Magento

now THAT, btbc, would be very very useful if it can be implemented in magento

Any body have successed?  Please share your code and process.

Thank you very much.

success with what?

i changed the order number from 000000001 to 148560001 by using phpmyadmin and changing the information in eav_entity_store, increment_last_id field

Changed padding to 0 (below) but still getting padding of 8. Also cleared all EAV cache. Why does that not work?

update `eav_entity_type` set `increment_pad_length`=0 where `entity_type_code`=’order’;

Update. Was able to get it to work by doing the following ...

Go to app/code/core/Mage/Eav/Model/Entity/Increment/abstract.php it appears that the if(empty($padLength) ) is evaluating to true. When I change $padLength to 0 it works even though it should have been picking up 0 padding which I set in the eav_entity_type table.

$padLength = $this->getData(’pad_length’);
if (empty($padLength)) {
$padLength = 0; // this was 8

Hi there,

I tried to code an extension for European shops with consecutive numbering, but I am not able to get it done. This is my config.xml:

this is /app/code/local/Pulpmedia/ConsecutiveNumbering/Entity/Increment/Numeric.php (for testing with a random number):

... and this is my /app/code/local/Pulpmedia/ConsecutiveNumbering/Model/ConsecutiveNumbering.php

I tried to place an order an do not get a random number between 1000 and 100000. Could anyone help me here please?

J.

Click thumbnail to see full-size image

Hi,

first, in your config.xml this should be

There should be also a file Pulpmedia_ConsecutiveNumbering.xml in app/etc/modules which contains

Go to the shopbackend System->Configuration->Advanced and take a look your module is loaded or not.

Cheers

Stefan

anybody got a good idea to sync the invoice/order number of multiple stores? should order number and invoice number always be the same? or do you think it is better to have a different one?

we have three stores (= six store views) and we think about having different order numbers and consecutive numbering of all stores for invoice.

does anybody have a good idea how to code this (in general)? i would post an extension here immediately, if someone’s got a good idea for this…

I personally feel that this *needs* to be part of the cart itself.

I would not make any core changes in fear of future upgrades… but that is just me.

our client wants consecutive ordernumbers for all stores in the system and the SAME number for the invoice. how can I handle this?

I did it. Consecutive order numbers AND invoice numbers.

The trick:

In eav_entity_store I added two entries:

for orders:

for invoices:

additionally I changed the values of “increment_per_store” from 1 to 0 for entity_type_code 11 and 16 (order and invoice) in eav_entity_type.

hth,
j.

@scree

if you do it this way will it cause any problems on updates?

I want to have my order number similar to amazon.

i want to use the 9 numbers. start it from 465784268 or what ever....ether increment in 9 for every order or just have it random. (wold be nice to have an extra 3 digit number for each order, like a store code)

can you help please.

@nafna1000: I don’t think so. --- I have a full working demoshop (copy of liveshop) and will try updating to 1.1.5 here. will post my results here, if it works without problems.

Thanks,

Please let us know, I want to go live as this is one of a few loos ends that i still have to complete.

Hi!

When I try to insert as suggested, I am getting the following error:

#1452 - Cannot add or update a child row: a foreign key constraint fails (`db123456789/eav_entity_store`, CONSTRAINT `FK_eav_entity_store_entity_type` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_id`) ON DELETE CASCADE ON UPDATE CASCADE)

Any clues anyone?

I am running 1.1.6 and just have one store with one storeview…

Thanks,
rrochelle