How to change order number (ID)?

[Gleaf]

Switching from another cart to AbanteCart, is there a way to change the default starting order ID so I can follow the last order number from my old store?  Thanks!

[abolabo]

you need to set new autoincrement value for order table.
for ex your last order_id is 100

run this on your mysql
ALTER TABLE `orders` AUTO_INCREMENT = 101;

[Gleaf]

Thanks for prompt reply. That's something new for me.   I'll try to learn.

It might be useful if we can setup the starting order ID in contorl panel like the cart I used before. We may need some numbers as prefix, for example, use 100xxxx for one store, 200xxxx for another store, or simply we don't want the order number start from a 2-digit number.
Hope to see this feature in a later version.

[abolabo]

Thanks for prompt reply. That's something new for me.   I'll try to learn.

It might be useful if we can setup the starting order ID in contorl panel like the cart I used before. We may need some numbers as prefix, for example, use 100xxxx for one store, 200xxxx for another store, or simply we don't want the order number start from a 2-digit number.
Hope to see this feature in a later version.

you mean "stores" as different hosts or 2 stores on the same engine and same host(multistore)? For multistore described feature not needed because every order have store_id. You can separate orders easy.

[Nimitz1061]

you mean "stores" as different hosts or 2 stores on the same engine and same host(multistore)? For multistore described feature not needed because every order have store_id. You can separate orders easy.

I like this consistent approach better than offering alternative labels, as it makes for more consistent path management when working sales support and fulfillment.  There always seems to be some expectation that the selected label will also work in a URL - and when it doesn't, then you waste time....

David

[Gleaf]

... For multistore described feature not needed because every order have store_id. You can separate orders easy.

I didn't know that. Thanks.  For me, just wanted to follow the order number from my old store, so I can manage documents easy. Another reason, even for a complete new business, when I setup my old store 4 years ago, I didn't start from order#1, instead, I used a random 3-digit number with preifx 10, simply I don't want my customer think he(she) is my first, second... customer. Meanwhile I created a page named Check Order Status showing all order numbers and status as a log. This may psychologically  affect customer confidence. The fact is, I have many visitors for this page, and I believe they're not my customer at the time they see this page, because I have good communication with customers and they don't need to check their status on the page.

Happy New Year!
My new store start working anyway.

[Qhalifh]

This is how I change it Manually.

Firtsly login to cpanel, then click PHPMyAdmin.

Then, click ab_orders from droplist. (See attachement)
After that click 'Operations' Tab. Then, change value of 'AUTO_INCREMENT'   (your order id start) at Table Options tab. (See attachement).

Finally clik 'GO'.

Thats all. Hope this help for whoever looking for this solutions.

[Basara]

Thank You

[flyn]

Thanks a lot for this. I was able to make a change for our new site I am working on.

Is it possible to have alphanumeric? I tried it but it id not take.