Post by aquaplanning » Mon Nov 05, 2012 5:16 pm

OpenCart 1.5.4. 1
Clean Install, two languages.

I was able to start my order and invoicenumbers at 2000, to avoid the dreaded 1, 2, 3 invoice and ordernumbers.

But I did not realize that my order and invoicenumbers are now very similar which is confusing.
I am trying to change my ordernumbers to 1000, which is lower than the booking numbers I have now but that does not seem te work.

What I did:
- Search in PHP my admin for the highest order number, and changed it to 1000.
(five tables: order, order-history, order_option, order_product, order_total (2x))
I then looked for the highest number + 1 and did a search but found nothing.
But when I made a test booking, the original ordernumber is used again. (+1 ofcourse)

What am I missing?

(It is not an option to change the invoicenumber or prefix, since the taxe rules require me to have a continuous range of invoice numbers)
Last edited by aquaplanning on Mon Nov 05, 2012 7:45 pm, edited 1 time in total.

Newbie

Posts

Joined
Sun Oct 14, 2012 2:23 am

Post by i2Paq » Mon Nov 05, 2012 7:34 pm

You can set the Invoice number via you Admin.

Or change your Order number via the phpMyAdmin:

Code: Select all

ALTER TABLE `order`  AUTO_INCREMENT =10000
Where 10000 is your own order ID.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by aquaplanning » Mon Nov 05, 2012 7:46 pm

Worked like a charm, thanks.

(Or better: in Dutch: hartelijk bedankt!)

Newbie

Posts

Joined
Sun Oct 14, 2012 2:23 am

New member

Posts

Joined
Sun Apr 28, 2013 2:45 pm
Location - Pune, Maharastra

Post by sniffertje » Sat Jan 04, 2014 8:45 pm

I'm using number 2014000000 now , but want to go starting with a new range 000000000001

This is not possible with this code, how to solve?

New member

Posts

Joined
Fri Jan 08, 2010 10:42 pm

Post by i2Paq » Sat Jan 04, 2014 9:06 pm

sniffertje wrote:I'm using number 2014000000 now , but want to go starting with a new range 000000000001

This is not possible with this code, how to solve?

You cannot start with a 0.

So instead of 000000000001 you can only use 1.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by sniffertje » Sun Jan 05, 2014 3:55 am

That's not working, I can't go back to a number that is lower then 2014.....????

New member

Posts

Joined
Fri Jan 08, 2010 10:42 pm

Post by i2Paq » Sun Jan 05, 2014 6:12 am

sniffertje wrote:That's not working, I can't go back to a number that is lower then 2014.....????
Naar welk nummer wil je toe?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by sniffertje » Sun Jan 05, 2014 6:26 am

aangezien 000001 blijkbaar niet lukt naar 1000001

New member

Posts

Joined
Fri Jan 08, 2010 10:42 pm

Post by i2Paq » Sun Jan 05, 2014 9:43 pm

sniffertje wrote:aangezien 000001 blijkbaar niet lukt naar 1000001
Dat zei ik toch, een tabel kan niet met een 0 (nul) beginnen.

-- A table cannot start wit 0 (zero). --

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by sniffertje » Mon Jan 06, 2014 4:29 am

maar ook naar 100001 kan ik niet, omdat het nummer lager is wat er nu wordt gebruikt. momenteel zit ik op 20140000003 en wil naar een lager nummer , maar dat kan blijkbaar ook niet.

Iemand een oplossing.???

New member

Posts

Joined
Fri Jan 08, 2010 10:42 pm
Who is online

Users browsing this forum: No registered users and 41 guests