Hi I need to create a set of sub categories for each top level category like this.
Category 1 - Sub Category 1 - 250, 500, 750, 1250, 2500, 5000, 10000
Category 1 - Sub Category 1 - 250, 500, 750, 1250, 2500, 5000, 10000
Category 1 - Sub Category 1 - 250, 500, 750, 1250, 2500, 5000, 10000
Category 1 - Sub Category 1 - 250, 500, 750, 1250, 2500, 5000, 10000
Category 1 - Sub Category 2 - 250, 500, 750, 1250, 2500, 5000, 10000
Category 1 - Sub Category 2 - 250, 500, 750, 1250, 2500, 5000, 10000
Category 1 - Sub Category 2 - 250, 500, 750, 1250, 2500, 5000, 10000
Category 1 - Sub Category 2 - 250, 500, 750, 1250, 2500, 5000, 10000
etc
I have quite alot of categories so ideally I would like to create these sub categories easily inside the database to save me alot of time.
Also I have products inside Sub Category 1 and Sub Category 2. 250, 500, 750, 1250, 2500, 5000, 10000 are category names that refer to the quantities of the products previously in Sub Category 1 and Sub Category 2.
So I need to move products from Sub Category 1 and Sub Category 2 inside the quantity categories as I realise you cannot have categories and products together inside the same category.
So I need to move products from Sub Category 1 inside the 250 category and duplicate those products across all quantity categories.
After that I need to update each individual products quantity.
So ideally I need a way to do this inside the database quickly and easily.
Also I would like to know if there's a way that I could easily add the quantity to my product name across all products. Each product already has a name so I just need to add the quantity inside the names. The above is more important though for now.
Thanks
Nick
Bookmarks