I need to create a set of sub categories for each top level category

[Nick1973]

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

[schoolboy]

To do this with a SQL query will not be easy. The "parent ID <-> Category ID" relationship is a complex one in zencart. (A "child" category (sub-category) becomes a "parent" category as well, when a sub-sub-category is added to it.)

Writing this to the two tables involved is not going to be easy - and moreso in your case where the sub-cats are identically named in a lot of instances.

It can be done... but will take some very detailed planning.