I have a long category list of drinks, foods and tobacco.
Can someone help me with a report where i can merge all the all list of category into the following:
All drinks(Alcohol/Non Alcohol) go under the category Beverages
All Foods(Starters/Main Course/Side dishes) go under the Category Food
All Tobacco(Cigarettes/Cigar/Shisha) go under the Category Tobacco.
Add a custom product tag in the program settings tab under product tags I think it calls the gold.
This will give you a new field on the edit product page fill this field using product tage editor for all products then split your reports using the product tag.