duplicate product

[mipavluk]

Hi There

I found a product, duplicate in a category... same product id... just twice... take a look:

http://scrappingwhispers.com/store/i...index&cPath=53

This product:
SW - Baby Christmas - December Collab Kit
http://scrappingwhispers.com/store/i...oducts_id=3545

[Ajeh]

Check the following tables and see how many products_id match for:
3545

products (what is the master_categories_id)
products_descripton
products_to_categories (what categories_id come up)

Do you import your products?

[mipavluk]

in the master_categories_id 53
said I have 25 products.... but in the front door of the store... I have 26 because one is duplicated

in products_to_categories, in categories_id 53 said I have 25 products

nop, I do not import my products...

[Ajeh]

If you look at your database tables, how many records are in:
products
products_description
products_to_categories

It sounds like products or products_description has 1 more record than it should ...

If you search these two tables for products_id 3545 how many records come up in:
products
products_description
products_to_categories

[mipavluk]

If you look at your database tables, how many records are in:
products: 1,601
products_description: 1,601
products_to_categories: 6,377



If you search these two tables for products_id 3545 how many records come up in:
products: 1
products_description: 1
products_to_categories: 7 ---> 3 - 27 - 28 - 39 - 53 - 60 - 178

53 is the category where the product is added and is copied to the other 6 categories