Bonjour,
Cette mise à jour vers 1.8.1 m’a obligé de tester le bon fonctionnement du site !
Vous trouverez, ci-dessous, quelques requêtes SQL pour remettre à zéro les numéros de commandes, factures, … :
UPDATE eav_entity_store INNER JOIN eav_entity_type ON eav_entity_type.entity_type_id = eav_entity_store.entity_type_id SET eav_entity_store.increment_last_id = '100000001' WHERE eav_entity_type.entity_type_code = 'order' AND eav_entity_store.store_id = 1;
UPDATE eav_entity_store INNER JOIN eav_entity_type ON eav_entity_type.entity_type_id = eav_entity_store.entity_type_id SET eav_entity_store.increment_last_id = '100000001' WHERE eav_entity_type.entity_type_code = 'invoice' AND eav_entity_store.store_id = 1;
UPDATE eav_entity_store INNER JOIN eav_entity_type ON eav_entity_type.entity_type_id = eav_entity_store.entity_type_id SET eav_entity_store.increment_last_id = ‘100000000’ WHERE eav_entity_type.entity_type_code = 'shipment' AND eav_entity_store.store_id = 1;
UPDATE eav_entity_store INNER JOIN eav_entity_type ON eav_entity_type.entity_type_id = eav_entity_store.entity_type_id SET eav_entity_store.increment_last_id = '100000003' WHERE eav_entity_type.entity_type_code = 'creditmemo' AND eav_entity_store.store_id = 1;
Voila,
Nicolas Portais
Auteur Photographe