Post by Nile » Mon Jan 23, 2012 10:05 pm

Hi All

I don't really want to look to my customers like we've just started trading.

So is it possible to change the first order number to say 0001045, then each order number after that goes up by 78. So the next order number would be 0001123, then 0001201 and so on.

Obviously the order number and invoice number for each order need to match.

Can anyone help?

Many thanks

Nile

Newbie

Posts

Joined
Wed Jan 11, 2012 12:41 am

Post by Klimskady » Mon Jan 23, 2012 11:19 pm

Surely if you are starting at 0001045 then increasing by 1 will be more than suitable?

Active Member

Posts

Joined
Tue Jun 07, 2011 7:57 am

Post by Nile » Tue Jan 24, 2012 7:30 pm

Yeah your right. Of course that would seem logical, but I'm going to be dealing with some big fish and don't want to look like a small fish in a big pond, so I need them to accumulate exponentially at first........Do you know how to do it???

Newbie

Posts

Joined
Wed Jan 11, 2012 12:41 am

Post by jty » Tue Jan 24, 2012 8:40 pm

Nile wrote:So is it possible to change the first order number to say 0001045,
change the auto increment in your database to start at 1044
or do 1044 test orders
then each order number after that goes up by 78. So the next order number would be 0001123, then 0001201 and so on.
I dunno cos the order number is an auto increment in the mysql database (I don't know about the other types of databases)
Obviously the order number and invoice number for each order need to match
I don't know how you're going to achieve this as orders get abandoned, cancelled so order numbers do not equal invoice numbers.

You can change the invoice increment (invoice not order) in model/sale/order.php
Find

Code: Select all

$invoice_no = $query->row['invoice_no'] + 1;
and change the +1 to +78 or whatever

jty
Active Member

Posts

Joined
Sat Aug 30, 2008 8:19 am

Post by Nile » Tue Jan 24, 2012 9:03 pm

Hi

Thanks for your help, worked great.

Regards

Nile

Newbie

Posts

Joined
Wed Jan 11, 2012 12:41 am
Who is online

Users browsing this forum: Bing [Bot] and 365 guests