ImportPrestashop

Pubblicità

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_.'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('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');

 

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

 

 


HOMEHOME

Nuovi Prodotti

Al momento non ci sono nuovi prodotti

Carrello  

(vuoto)

Prodotti in Offerta

Al momento non ci sono prodotti in offerta

now on facebook!

All trademarks are the property of their respective owners - PLANETE-I sarl - TVAFR49497941138  - tel: +39 02 40707921 - +33 (0)3 73 27 06 13 - ticket