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