Bug reports Found a bug? Post it here please.
Version 5.x > Bug reports > Reconnecting deleted products View modes: 
User avatar
Member
Member
spectro-jarlen - 9/29/2011 9:16:14 PM
   
Reconnecting deleted products
Hi,

One of the users on my site recently had deleted all the products in one category (removed history as well) by accident. The products are still appearing within the e-commerce area of CMS Desk -> Tools -> e-commerce. Is there any way to link these back to pages on the site? I recreated the category, so ultimately want to link the products that still exist to new pages within the new category.

Thanks for your help!

User avatar
Kentico Support
Kentico Support
kentico_zdenekc - 10/4/2011 5:22:33 AM
   
RE:Reconnecting deleted products
Hi,

The description suggests that the products (defined in Tools - > Ecommerce) were not deleted, only the product documents were.
The product documents are linked with the Ecommerce product by NodeSKUID column in the database record for the documents (more exactly TreeNodes from CMS_Tree table).

So, what you need to ensure setting the proper NodeSKUID of those documents to the existing products (SKU) SKUID values.
This can be done in the database, but that's not recommended if it's not the very last option.

Easiest way would therefore be (in the CMS Desk) to select the product document that is not linked with a product and in the Product tab, choose Mark document as product option and Select an existing product. You can see the closer description in context help (pointing to ~/CMSHelp/index.html?cms_content_product.htm)

Regards,
Zdenek C.

User avatar
Member
Member
spectro-jarlen - 10/4/2011 2:52:42 PM
   
RE:Reconnecting deleted products
Thanks Zdenek. I did a bit of research and found that to be the easiest option. While not ideal, I think it is the best way. Thanks for confirming my research! :)

User avatar
Kentico Support
Kentico Support
kentico_zdenekc - 10/5/2011 2:27:11 AM
   
RE:Reconnecting deleted products
Hello,

You're welcome :).
Should you need any additional details, please feel free to ask.

Regards,
Zdenek C.