Istruzioni (ad esempio da inserire in un modulo oppure da inviare direttamente da mysql)
per il reset del catalogo in caso di troppi tentativi di import:
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'product');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'product_lang');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'category_product');
/* >=1.6 */
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'product_shop');
/* IMMAGINI */
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'image');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'image_lang');
/* VARI */
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'tag');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'product_tag');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'manufacturer');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'manufacturer_lang');
/* ATTRIBUTI */
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'product_attribute');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'product_attribute_combination');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'attribute_group');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'attribute_group_lang');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'attribute');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'attribute_lang');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'attribute_impact');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'product_attribute_image');
/* >=1.6 */
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'product_attribute_shop');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'product_attribute_group_shop');
/* CATEGORIE */
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'category_group');
Db::getInstance()->Execute('delete from '._DB_PREFIX_.'category where id_category !=1');
Db::getInstance()->Execute('ALTER TABLE '._DB_PREFIX_.'category AUTO_INCREMENT = 2');
Db::getInstance()->Execute('delete from '._DB_PREFIX_.'category_lang where id_category !=1');
Db::getInstance()->Execute('ALTER TABLE '._DB_PREFIX_.'category_lang AUTO_INCREMENT = 2');
Db::getInstance()->Execute('INSERT INTO '._DB_PREFIX_.'category_group (`id_category`, `id_group`) VALUES ("1", "1")');
/* >=1.6 */
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'category_shop');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'category_group_shop');