Hello,
I'm an author of this contribution, but do not have much time for developing it lately.
I wrote this plugin for some new shop and simply not foresee using it for existed products. I see no simple solution for that. Some of you probably using various product's types in yours shops so it's almost impossible to change their type without broking something.
I've got something for those of you, who are using only typical "product" type or want to change only this type to "product_extra_description" .
Please be careful with that and remember about some database backup before.
1. Log in to the admin panel
2. Go to Tools -> Install SQL Patches
3. Paste this text into the form:
Code:
UPDATE products SET products.products_type =(SELECT type_id FROM product_types WHERE product_types.type_handler ='product_extra_description' LIMIT 0,1) WHERE products.products_type = (SELECT type_id FROM product_types WHERE product_types.type_handler ='product' LIMIT 0,1);
4. Click "SEND"
I hope it will help for some of you at least.
I'm warning - I have test this SQL code only on my database. It should be OK and safe for any database but NO WARRANTY - BACKUP FIRST ;) .
Bookmarks