Add "Category" to Item Properties and subdivide Items in Shopping List depending on their Category

[EarthlingX]

In first, thanks a lot for your great app! :-)

Would it be possible to add a category/branch property to each item?

For example:

• List type: Food list
• Item name: Milk
• Category: Dairy products
• Standard package size: 1000
• Unit: ml

I am happy to hear from you! :-)

[PawelSpoon]

yes, but what to do with that info ? just show ? filter ? are you.talking bout 2 add. properties or one ?

[PawelSpoon]

the main pain in ass is here the migration of db. and the translation ...

[EarthlingX]

Thanks for your reply! :-) I edited this posting because I had a further idea...

yes, but what to do with that info ? just show ? filter ? are you.talking bout 2 add. properties or one ?

I would love to just show the category names as subdividing sections between corresponding items. In the shopping list it could be displayed like that for example:

FOOD LIST Dairy products

• Cheese
• Milk
• Yogurt

Fruits & Salad

• Apples
• Avocados
• Salad

HOUSEHOLD LIST Cleaning products

• Floor cleaner
• Toilet cleaner
• Vinegar

Hygiene products

• Toothpaste
• Deodorant
• Shampoo

Once you are in the market, you can see at which area you have to buy the desired things. If fruits and salad is in the beginning of the market, but the salad will come up at "S", you have to walk back all the way to the entrance. :-) With the upper feature you could see what you need from the "Dairy products" area with one look.

The second property mentioned could be a small description (if necessary), for example;

• List type: Food list
• Item name: Milk
• Category: Dairy products
• Standard package size: 1000
• Unit: ml
• Description: Keep care of organic products

Actually, I think the second property is not really important. :-)

[PawelSpoon]

i think i could subdivide them similar as the date separation in sailkick, that could be rather simple.

the biggest obstacle is the management of categories themselves. i cant imagine that you would be happy with hardcoded categories and you would like to rename them afterwards. so pretty much of an effort.

[EarthlingX]

i cant imagine that you would be happy with hardcoded categories and you would like to rename them afterwards.

Why not? :-) I really like your idea and I guess this attempt would be the easiest and quickest solution to implement. Furthermore, supermarket area categories are standardized and the same all over the world...

What do we need?

• Fruits and salads (O+G = Obst und Gemüse)
• Dairy products (milk, cheese, etc.) (Mopro = Mokereiprodukte)
• Meat products (Fleisch)
• Frozen foods (convenient pizza etc.) (TK = Tiefkühlkost)
• Magazines
• Loose pastries (bread)
• Dry goods (TROSO = Trockensortiment)

And maybe for TROSO as sub-categories:

• Staple food (salt, sugar, flour, etc.) (Grundnahrungsmittel)
• Baking articles (baking powder, raisins, succade, etc.) (Backartikel)
• Breakfast articles (musli, etc.) (Frühstücksartikel)
• Beverages (mineral water, juices, etc.) (Getränke)
• Canned goods (pickles, jam, etc.) (Konserven)
• Coffee/tea
• Noodles/rice (Nudeln & Reis)
• Delicacies (Feinkost)
• Confectionery (chocolate, candies, etc.) (Süßwaren)

I guess the main categories will be enough for the beginning. Even more, they are already a big help when shopping. With separated categories in TROSO it would be too complicated. :-) What do you think?

[PawelSpoon]

Well a) it depends on the shops b) somebody might want to have rather shops like Lidl/Hofer, then categories my wife did once ask for it, i was able to convince her that it makes no sense ;-) c) i have technical stuff in my list, spare parts for moto bikes i.e. which again either leads to a) or b)

the more i think about it the more it leads to a complete redesign:

• no separation between house hold and food to save manu items
• manage page where the db items can be maintained including the categories ..
• ..

gives me head ache

however: i did start to work on it. it will be possible to define categories in an own list and to assign them to items.

[PawelSpoon]

you are lucky, i am bound to my bed. i have created a category management. this allows you to create / remove categories. no edit, cause then i would need to propagate that into the lists it is also possible to defined the category on items (food and household) the shopping list does not show the categories yet, but it sorts according to the categories if you want i can upload you somewhere a version. do not want to release it officially now.

the migration should work (new table plus new columns), but still it may make sense to export your db .. it might also be more feasible to start with an empty shopping list, but i did not discover any sideeffects on already existing items in the shopping list.

what is missing: recipe-items are not sorted according to their category: the lookup is missing shopping lis separators. update help page update demo db

i am not the fastest and the ide does not realy support you in finding bugs and my pc is slow, it is a 200 euro laptop, so each debug start takes 2 mins. so up to now it took me 10+ hrs

[EarthlingX]

i have created a category management.

Awesome work!!! Thank you very much! :-) If you want, you can upload the new version and send me the link. I will test if I can find any bugs during usage.

so up to now it took me 10+ hrs

I will send you a small obulus for that as well. :-)

[PawelSpoon]

thanks, i did not tell you the effort to get money

just to make it understandable why i might not make it perfect

the app has 20 users :-)

i have upload 1.51 to open repos. you can take it from there. it is now pretty complete.

[EarthlingX]

Awesome! Thank you so much! I already tested your pre-release version yesterday in the morning and it looked great. Fantastic job! :-)

[EarthlingX]

Ah, can I donate you a coffee/tea via PayPal?

[PawelSpoon]

Great that you liked it ! i have just uploaded 1.52 to open repos. it includes the a new help text that should answer your questions. the manage menu and manage application page are new, to have all the lists and category management at one place. editing of items is an old feature, but be aware that if you use the item already in a recipe, recipe wont get updated (yet). you would need to reselect the item in the recipe. that s exactly the same problem as would be with renaming the category and updating all items that are using it, which is currently not in.

i have a paypal me, the button should be visible in openrepos.