SOLVED: Bulk Create Product Category Rows

-- url of the page with the problem -- : not required
-- HikaShop version -- : 1.5.7
-- Joomla version -- : 1.7
-- PHP version -- : not required
-- Browser(s) name and version -- : not required
-- Error-message(debug-mod must be tuned on) -- : Error_message

Hello,

I wish to add many products (1000s) into a new category. That category will be applied to a discount code.

I have two options:

1) Spend a long time using the backend to update the relevant products with the new category.

2) Bulk change the database.

I wish to do the second of these.

Looking at the database, there are three tables:
- Category
- Product
- Product Category

It seems to me that Product Category is an m:n resolver between the other two tables.

My plan is to simply insert rows into Product Category combining the relevant Category IDs and Product IDs and allowing the primary key to auto increment.

This seems quite straight forward.

My question is... Are there any other tables involved? Will this work? Do you envisage any problems by doing this?

Many thanks,

Tony

Hi Tony,

Note that another solution can be to :
- Create some products manually
- Export them through the EXPORT button of the page "Hikashop->Products"
- Add your product through this exported CSV file
- Import it

Doing it through Hikashop SQL tables won't be that easy, for example regarding your product price you'll also have to add your price through the "hikashop_price" table.

Thank you for your post, but I don't think you have understood my question.

My Products exist.

My Category exists.

Let me phrase the question differently:

If I use the Hikashop backend to asign a Category to a Product, what database rows are created/updated?

Is it JUST Product_Category?

Tony

Yes, just this one.

Regards,

Thank you.