How to change order_id for Invoice number

dramony wrote: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.

Qphoria wrote: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

JasonC wrote:

Qphoria wrote: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

iamskyemedia wrote: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!]

HorseMagic wrote: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

dramony wrote: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.

ALTER TABLE `oc_order`  AUTO_INCREMENT =10000

Counting Pounds wrote:I've run the myPHP command and that works well for numeric orderID's.

I'm not sure what /how to get Alpha-numeric's for an order ID, not just integers. For example, if I wanted OC-1000 and counting.

I'm planning to copy the order ID into the invoice field (don't need these to be different, but want/need to have some static letters in the invoice#. I need the entire set of characters including the two letters to be in the data stored so we can print etc / simply adding these non-varying letters as prefixes to document template info is no use as there are too many places to edit this.