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');

Db::getInstance()->Execute('truncate '._DB_PREFIX_.'category_group');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'product');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'product_lang');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'category_product');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'image');
Db::getInstance()->Execute('truncate '._DB_PREFIX_.'image_lang');
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');
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")');
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');