[SOLVED] Add all products to a category SQL

[nzrobert]

Hi,

I have created another category in the back office, and would like to put all products in to that category.
Is there a fast was of implementing this through SQL command?

Cheers
Robert

[rocky]

Try the following SQL query:

INSERT INTO `ps_category_product` SELECT 8, `id_product`, 0 FROM `ps_product`

Change ps_ to your database prefix and change 8 to the ID of the category you want to copy all the products to.

[nzrobert]

Hi,

Thanks heaps for your reply!
I got this error:

#1046 - No database selected.

[rocky]

That's not something caused by the query. Are you executing the query using phpMyAdmin or with code? If you are using phpMyAdmin, make sure that you have clicked on a database before trying to execute the query. If you are using code, you should write:

Db::getInstance()->execute('INSERT INTO `'. _DB_PREFIX_.'category_product` SELECT 8, `id_product`, 0 FROM `'._DB_PREFIX_.'ps_product`);

[nzrobert]

Hi Rocky,

It worked! thanks man..

[nzrobert]

I have just come across something probably a little more difficult i think.

I need to copy all products from a particular category to another category.

Any ideas?

[rocky]

Try the following:

Db::getInstance()->execute('INSERT INTO `'. _DB_PREFIX_.'category_product` SELECT 8, `id_product`, 0 FROM `'._DB_PREFIX_.'category_product` WHERE `id_category` = 7');

This should copy all the products from category 7 to category 8.

[nzrobert]

Im getting a Unknown column 'id_category' in 'where clause' error, would we be looking at the wrong table for clause?

[rocky]

You are right. I wrote ps_product when I should've written ps_category_product. I've updated the query above.

[nzrobert]

works perfect, nice one mate

[zapmore]

Is this still valid in version 1.5.4.1? if not, how do I add products from one category to another using SQL in this new version of prestashop?

[marc.pochet]

Thank you very much for sharing