I can see the product in the DB but not in the shop

[4GLte.eu]

As in the subject I can see many invisible products in db. Why are they not displayed in the shop?

[Daniel Patilea]

As in the subject I can see many invisible products in db. Why are they not displayed in the shop?

Did you do any import recently? Check the ps_product_shop table to see if products are assigned to your shop

[4GLte.eu]

Hi there,

 

Yes you right I have a mixture of shop_Id 1 and 2

 

Two mire questions: 

 

1. Some records I can change manually without any problems but other gives me an error:

 

Error

SQL query: Edit Edit

 

UPDATE  `DB_presta`.`ps_product_shop` SET `id_shop` =  '2' WHERE `ps_product_shop`.`id_product` =5 AND `ps_product_shop`.`id_shop` =1

 

MySQL said: Documentation

 

#1062 - Repeated occurrence of '5-2' for key 'PRIMARY'

 

2. How can I move all products to shop_id 2  ? (we dont use shop_id 1 anymore)

Edited July 15, 2016 by 4GLte.eu (see edit history)

[musicmaster]

#1062 - Repeated occurrence of '5-2' for key 'PRIMARY'

 

2. How can I move all products to shop_id 2  ? (we dont use shop_id 1 anymore)

 

Looks like there was already a product 5 defined for shop2. Did you check that?

 

Also note that you would need to change shop id's in the ps_product_lang table too. Not to mention that you will face even more trouble if you use optional features like combinations and discounts.

[4GLte.eu]

Thank you. It resolved the problem!