How to change order_id for Invoice number

[yiyinlah]

go to you phpmyadmin, click SQL (located on the top) then paste this on the text area:

Code: Select all

ALTER TABLE `order`  AUTO_INCREMENT =10000

Click the Go button on the right side.

Hi!

THank you, but it doesn't exist.

I tried & this is what it prompt me,
"#1146 - Table 'username_opcart.order' doesn't exist"

I don't know what to do anymore.
What had happened? Do it really not exist?
Please help me!

Thank you very much!
`
`
`

[yiyinlah]

Hi!

Thank you all!

I solved it!

I had forgotten about those prefixes.
I had changed & successfully made it worked!

Thank you so much!!!
`

[JasonC]

Execute this simple sql in your phpmyadmin

Code: Select all

ALTER TABLE `order`  AUTO_INCREMENT =10000

(prepend a prefix if needed (i.e. `xxx_order`)


Now it will start at 10000

What is the correct syntax to add the prefix?
thanks

[Blackbet]

Hi,

Sorry to bother. But the SQL script is not working for me. I'm receiving this message: "#1046 - No database selected"
I need to change order id to 10113.

OpenCart V1.4.9.1

Any help will be greatly appreciated.

Thanks

[cerami2]

I use one pay pal for a few websites i would like the order number to show what website the order came from
were do you change this in opencart i want to put a prefix for the order number

(prepend a prefix if needed (i.e. `xxx_order`) were do i fine this or were do i put it in at the website
Regards
cerami2

[Joxe]

HI,
Is this working for 1.5.x?

Thanks.

[iamskyemedia]

The command works for order id only. How do you get it to work for the invoice number? I'd like the order id and invoice # to match. I'm working with a numbering system only, not alphas. Please help. Thanks!

Execute this simple sql in your phpmyadmin

Code: Select all

ALTER TABLE `order`  AUTO_INCREMENT =10000

(prepend a prefix if needed (i.e. `xxx_order`)


Now it will start at 10000

What is the correct syntax to add the prefix?
thanks

[HorseMagic]

tried the sql thingy that everyone was talking about but it didn't work for me either


You do this at your own risk!

It worked for me but hey I don't know what I am doing, I have no technical skills whatsever but I do try to remember exact what I am doing so i can go back to original way if required.

So if there is problems down the track don't complain to me I have no knowledge of problems......

that should read... No problems yet

I will post back here if I find any.

Logged into cpanel,
I went to phpmyadmin,
tried the sql thingy that everyone was talking about but it didn't work for me either,
so went to oc_database,
scrolled down to orders,
clicked on that file,
went to last order
edit
changed the order number
and clicked on Go,
I have put through a couple of orders with no problems
Note: It would only accept changing the number, could not add letters before the number.

Like I said at the beginning, I know NOT what I am doing so its at your own risk and if anyone knows why I can't do it let me know, I am happy to learn

[storm-cloud]

The command works for order id only. How do you get it to work for the invoice number? I'd like the order id and invoice # to match. I'm working with a numbering system only, not alphas. Please help. Thanks!]

Did you end up finding out an answer to this? If not, would anyone know how?

We have a previous eCommerce solution and when we do the live switch I would like the order numbers to seamlessly continue. Yes, it would be great if order numbers and invoice numbers matched.

Also, by using executing the SQL command, this didn't make each order go by up by 10,000 did it?

[NikkiC]

This worked perfect for me too! Hope it doesn't mess anything up
But it seems to be working!

tried the sql thingy that everyone was talking about but it didn't work for me either


You do this at your own risk!

It worked for me but hey I don't know what I am doing, I have no technical skills whatsever but I do try to remember exact what I am doing so i can go back to original way if required.

So if there is problems down the track don't complain to me I have no knowledge of problems......

that should read... No problems yet

I will post back here if I find any.

Logged into cpanel,
I went to phpmyadmin,
tried the sql thingy that everyone was talking about but it didn't work for me either,
so went to oc_database,
scrolled down to orders,
clicked on that file,
went to last order
edit
changed the order number
and clicked on Go,
I have put through a couple of orders with no problems
Note: It would only accept changing the number, could not add letters before the number.

Like I said at the beginning, I know NOT what I am doing so its at your own risk and if anyone knows why I can't do it let me know, I am happy to learn

[aresn]

if you know what you are doing , then you can use some combination of this script http://www.tonymarston.net/php-mysql/encryption.html and your own to create a unique order id to present to user. check http://stackoverflow.com/questions/5387 ... l-order-id

hope this helped

[H2O]

go to you phpmyadmin, click SQL (located on the top) then paste this on the text area:

Code: Select all

ALTER TABLE `order`  AUTO_INCREMENT =10000

Click the Go button on the right side.

It appears this changed for the newer version of Opencart, the correct code that worked for me on version 1.5.2.1 is:

Code: Select all

ALTER TABLE `oc_order`  AUTO_INCREMENT =10000

[NikkiC]

Perfect! Thanks for letting us know the update :-)