CODEWITHSUNDEEP
mysqlsqlprestashopprestashop-1.5
Miguel Borges
Miguel Borges

Reputation: 7659

How to put products in a category by query

I need to put products (IDs 10233 to 10247) in a home category (id=2) automatically, in my prestashop (v1.5) shop.

maybe, by sql is easier, no?

Tables:

Upvotes: 0

Views: 177

Answers (1)

micbobo
micbobo

Reputation: 872

INSERT INTO ps_category_product (id_category,id_product)
SELECT 2, ps_product_shop.id_product 
FROM ps_product_shop 
WHERE ps_product_shop.id_product > 10232 AND ps_product_shop.id_product < 10248

I think something like this could be what you want

Upvotes: 1

Related Questions