Note Taking | How to Create a Shopping List in Notion

Let me explain how the shopping list shown in this blog is created in Notion. I will add some Notion tutorials as needed when some basic explanation is required. Feel free to leave your question in the comment below.

​Creating Databases
The first step is to create two essential databases for the shopping list: the Recipes and Products databases. I shared them with you so you can copy them first, and we will explain why we created them like this. 

The Recipes database has the following fields:

• Name 
• Meal 
• Type 
• Ingredient 
• Total Ingredient Number 
• Weekday ​

The Product database has the following fields: 

• Name
• Tags
• Lowest Price
• Link to Purchase

Understanding the Workflow
After the database is created, we can then discuss the basic workflow. 

• Shopping List: We must make a meal plan by selecting the recipes and assigning them to our weekdays. The "is_shopping" attribute is "yes" for all selected receipts. We can get the required product list for the references in these receipts. If the product is in stock (is_stock=yes), we will not add it to the shopping list. Otherwise, the shopping list is created. 
• Recipe Finder: We have to look at all the products in stock and then find out if all the products can satisfy any receipt requirement. If so, we will find the receipt that requires a minimum purchase and add the recipe recommendation. 

With this understanding, we will discuss the detailed implementation next... Please comment if you are interested in hearing more or have any questions.