Export product_id + category

[hitstore]

Hi,

I need an SQL query to export product_id with category_name. I'm start to study sql, but it too early to solve. Can anyone help me ?

 

There's a way to export also secondary category ?

 

thank you.

[paulandw]

Something like this?

SELECT cp.id_product, cl.name
FROM p_category_product as cp LEFT join p_category_lang as cl on cp.id_category = cl.id_category;

[hitstore]

Ok, it's working !

But, for example, its possible to export in separated field id, default_category and secondary category ? I guess if I re-import a csv with an id with two categories in succession like this :

 

id_product;name         

10;PC Brand

10;All-in-One

 

in this case, the second row overwrite the first.

 

Can someone help me to obtain this sintax ?

 

10;PC Brand, All-in-One

 

? 

 

Thanks

Edited March 4, 2014 by hitstore (see edit history)

[paulandw]

Ok, it's working !

But, for example, its possible to export in separated field id, default_category and secondary category ? I guess if I re-import a csv with an id with two categories in succession like this :

 

id_product;name         

10;PC Brand

10;All-in-One

 

in this case, the second row overwrite the first.

 

Can someone help me to obtain this sintax ?

 

10;PC Brand, All-in-One

 

? 

 

Thanks

 

What are you trying to accomplish?

We are about to move to PrestaShop, so we don't really know the solution that well yet.

But why don't you simply import directly to p_category_product?

Things can be listed after each other, but it will break the normalization rules.

What if some of the products have 4 or 5 categories?

[hitstore]

I need to include category field in my csv for the import updates of price and quantity. Some product has more than default category. es.: an headset con be on "multimedia" and "gamers accessories"...

 

When I update a product without include category field, prestashop set category of each to "home page" again... so I lost all category information of all products.

 

I think it's a problem of import routine, but nobody has tryed to solve my problem.