Magento : Réinitialiser les numéros de commande, facture, …

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