Um in Magento die Bestellnummer / Kundennummer / Rechnungsnummer oder Sendungsnummer zu ändern ist es bis zur Version 1.6 nötig, dies direkt in der Datenbank zutun. Ab der Version 1.6.0 kann man diese Nummern direkt im Admin Bereich ändern.
Anleitung:
Es kann hier die Länge der Nummer und auch der Startwert geändert werden. Gehen Sie hierzu in phpmyadmin und führen Sie unter dem Punkt SQL folgenden Befehl aus:
– Kundennummer – Länge definieren
UPDATE `eav_entity_type` SET `increment_pad_length` = ’5′ WHERE `entity_type_code`=’customer’ AND `entity_model`=’customer/customer’;
– Bestellnummer – Länge definieren
UPDATE `eav_entity_type` SET `increment_pad_length` = ’5′ WHERE `entity_type_code`=’order’ AND `entity_model`=’sales/order’;
– Rechnungsnummer – Länge definieren
UPDATE `eav_entity_type` SET `increment_pad_length` = ’5′ WHERE `entity_type_code`=’invoice’ AND `entity_model`=’sales/order_invoice’;
– Sendungsnummer – Länge definieren
UPDATE `eav_entity_type` SET `increment_pad_length` = ’6′ WHERE `entity_type_code`=’shipment’ AND `entity_model`=’sales/order_shipment’;
– Kundennummer – Startwert definieren
UPDATE `eav_entity_store`,`eav_entity_type` SET `increment_last_id` = ’65000′,`increment_prefix`=” WHERE `eav_entity_store`.`entity_type_id`=`eav_entity_type`.`entity_type_id` AND `entity_type_code`=’customer’ AND `entity_model`=’customer/customer’;
– Bestellnummer – Startwert definieren
UPDATE `eav_entity_store`,`eav_entity_type` SET `increment_last_id` = ’65000′,`increment_prefix`=” WHERE `eav_entity_store`.`entity_type_id`=`eav_entity_type`.`entity_type_id` AND `entity_type_code`=’order’ AND `entity_model`=’sales/order’;
– Rechnungsnummer – Startwert definieren
UPDATE `eav_entity_store`,`eav_entity_type` SET `increment_last_id` = ’65000′,`increment_prefix`=” WHERE `eav_entity_store`.`entity_type_id`=`eav_entity_type`.`entity_type_id` AND `entity_type_code`=’invoice’ AND `entity_model`=’sales/order_invoice’;
– Sendungsnummer – Startwert definieren
UPDATE `eav_entity_store`,`eav_entity_type` SET `increment_last_id` = ’65000′,`increment_prefix`=” WHERE `eav_entity_store`.`entity_type_id`=`eav_entity_type`.`entity_type_id` AND `entity_type_code`=’shipment’ AND `entity_model`=’sales/order_shipment’;
UPDATE `eav_entity_type` SET `increment_pad_length` = ’5′ WHERE `entity_type_code`=’customer’ AND `entity_model`=’customer/customer’;
– Bestellnummer – Länge definieren
UPDATE `eav_entity_type` SET `increment_pad_length` = ’5′ WHERE `entity_type_code`=’order’ AND `entity_model`=’sales/order’;
– Rechnungsnummer – Länge definieren
UPDATE `eav_entity_type` SET `increment_pad_length` = ’5′ WHERE `entity_type_code`=’invoice’ AND `entity_model`=’sales/order_invoice’;
– Sendungsnummer – Länge definieren
UPDATE `eav_entity_type` SET `increment_pad_length` = ’6′ WHERE `entity_type_code`=’shipment’ AND `entity_model`=’sales/order_shipment’;
– Kundennummer – Startwert definieren
UPDATE `eav_entity_store`,`eav_entity_type` SET `increment_last_id` = ’65000′,`increment_prefix`=” WHERE `eav_entity_store`.`entity_type_id`=`eav_entity_type`.`entity_type_id` AND `entity_type_code`=’customer’ AND `entity_model`=’customer/customer’;
– Bestellnummer – Startwert definieren
UPDATE `eav_entity_store`,`eav_entity_type` SET `increment_last_id` = ’65000′,`increment_prefix`=” WHERE `eav_entity_store`.`entity_type_id`=`eav_entity_type`.`entity_type_id` AND `entity_type_code`=’order’ AND `entity_model`=’sales/order’;
– Rechnungsnummer – Startwert definieren
UPDATE `eav_entity_store`,`eav_entity_type` SET `increment_last_id` = ’65000′,`increment_prefix`=” WHERE `eav_entity_store`.`entity_type_id`=`eav_entity_type`.`entity_type_id` AND `entity_type_code`=’invoice’ AND `entity_model`=’sales/order_invoice’;
– Sendungsnummer – Startwert definieren
UPDATE `eav_entity_store`,`eav_entity_type` SET `increment_last_id` = ’65000′,`increment_prefix`=” WHERE `eav_entity_store`.`entity_type_id`=`eav_entity_type`.`entity_type_id` AND `entity_type_code`=’shipment’ AND `entity_model`=’sales/order_shipment’;
Code als Download:
magento-bestellnummer.sql (1,8 KiB, 448 hits)
