Automatically associate product name to store and sort shopping list

What I’m trying to do

Hi,

I’m trying to manage my shopping list with obsidian. I buy different products in different stores. What I’d like is be able to write the name of the product I need to buy in my shopping list (a task list for example) and for the system to automatically find in which store I have to buy it and either write the name of the store next to the product name or in the next column if using a table setup. Each store would have its separate note containing the names of the products I buy there for Obsidian to establish the association. Or any other systems that you think might work to automatically make those associations and sort my shopping list of the day by store without having to remember where I need to find everything.

Things I have tried

I’ve looked at the base plugin but I’m not sure it’s what I’m looking for although I’m quite unfamiliar with it.

Thank you for your help.

How about something like this using Bases?

Make a note for each shopping item and include properties like this:

---
purchased: false
stores:
  - "[[store 1]]"
  - "[[store 2]]"
---

Make a base called “shopping.base”.

  • Name the view “shopping list”, give it the filter file.hasProperty("purchased"), and display the properties stores and purchased.
  • Add a view called “cart” with the filter stores.contains(this).

Make a note for each store and embed the base view like this:

![[shopping.base#cart]]

That’s all you need to make the store lists and the overall shopping list.

You can embellish with properties like aisle for grouping while you’re in the store, recipes for searching, emojis for spotting items at a glance, etc.