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)
You can set the Invoice number via you Admin.
Or change your Order number via the phpMyAdmin:
Where 10000 is your own order ID.
Or change your Order number via the phpMyAdmin:
Code: Select all
ALTER TABLE `order` AUTO_INCREMENT =10000Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
thanks a lot..
Bean Bags Online Shopping | Bean Bags | Bean Bags Refill
Bean Bag Shop Online India | Bean Bag Chairs Online
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?
This is not possible with this code, how to solve?
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.
Naar welk nummer wil je toe?sniffertje wrote:That's not working, I can't go back to a number that is lower then 2014.....?
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.
Dat zei ik toch, een tabel kan niet met een 0 (nul) beginnen.sniffertje wrote:aangezien 000001 blijkbaar niet lukt naar 1000001
-- 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.
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.
Iemand een oplossing.
Who is online
Users browsing this forum: No registered users and 189 guests
