[SOLVED] How To Increase The Starting Order Number to A Higher Value

[deepee]

Hi

I have converted an existing site to Prestashop.

When I place a test order, the order number count starts at "order #1:"

Is there a way to increase the starting order number to somewhere in the thousands, so it doesn't look like I just started a new business?

Thanks
Deepee

[rocky]

Go to Orders > Invoices to change the next invoice number and Orders > Delivery slips to change the next delivery slip number.

[deepee]

Thanks for your reply, Rocky.

I currently have the invoice generator turned off as we generate these separately from our accounting package but I changed the invoice number to a highervalue anyway.
I also changed the delivery slips.

When I try to place another test order I got the confirmation email with :-
"Order details
Order: #000001 placed on 2009-10-23 14:05:39
Payment: Direct Deposit"

Placed another order as a different "customer" and got:-
"Order: #000002 placed on 2009-10-23 14:18:03
Payment: Direct Deposit"

Is there anything else I need to change?

Thanks
Deepee

[rocky]

I'm surprised that doesn't work. The only other thing I can think of is that it is using auto-increment to generate the order numbers. If it is, you could execute the following query on your database to set the next order number to 1000:

ALTER TABLE `ps_orders` AUTO_INCREMENT = 1000

[deepee]

Hi Rocky

It worked!

Thanks very much
Deepee

[Alex75]

I'm surprised that doesn't work. The only other thing I can think of is that it is using auto-increment to generate the order numbers. If it is, you could execute the following query on your database to set the next order number to 1000:

ALTER TABLE `ps_orders` AUTO_INCREMENT = 1000

Rocky, could you please explain how to execute this query? What file should I look for?
Thank you very much!

[rocky]

You must go to your cPanel, then select phpMyAdmin, then click the SQL button at the top-left, then enter the above query and click Go.

[Alex75]

You must go to your cPanel, then select phpMyAdmin, then click the SQL button at the top-left, then enter the above query and click Go.

Rocky, thank you SO much! It worked.
I really appreciate your help.
All the best,
Alex

[sgtbash]

Thanks for the post - quite easily one of the most useful 'hacks' around.

Nothing worse than firing up a new ecommerce site and your customers receiving the first, second, third orders - looks SUPER lame!

Thanks

Dan

[Degsey]

I coupled this with the hack of making the order# and invoice# the same and it looks good

[Eck!]

Ive made a plugin for the backend for this. To use it:

1. Copy the attached file into your admin/tabs folder
2. Go to Tools/Tabs/Add New
3. Enter "Order Options" as the name
4. Enter "AdminOrderOptions" as the class
5. Select "Orders" as the parent
6. Click Save
7. Go to Orders/Order Options
8. Enter the new number you want to start with
9. Click "Change Start number"

Done.

Let me know if there are any problems I'll try and post an update.

AdminOrderOptions.php

[sgtbash]

Cool, initially looks good, installed great although running live shop and don't want to change order number right now.

One thought, what happens if you change it to a number less than the number you are on currently? Will it throw an error, or allow 're ordering' on the same number?

Something worth testing I think although cant right now as running a live shop.

I can test it once home next week on a test environment.

Dan

[Eck!]

Good question - I may add a line to get the last order number and make sure its lower than the entered value. For new shops its fine though.

[update]: Just realised, it doesnt matter if you change the autoinc value to a value less than the highest order number - the system will still take the next number and ignore autoinc, so this should be perfectly safe.

I just tried setting 1000, placing an order - OK, then setting 800 and placing an order - I got order number 1001 so no problems.

[sgtbash]

Probably a good idea... I'm not sure how PS would handle reusing order numbers...

Dan

[Eck!]

Blimey youre quick - see update.

[jfriday]

Thanks so much to whoever posted this. I switched hosts for my shop and really wanted to keep the order numbers in sequence. Thanks again

[121man]

What is the default value, just incase ?

Thanks

[Rigs]

That's awesome!! Thanks for putting this up - so much better than invoice #1!!!

[Konabella]

I'm surprised that doesn't work. The only other thing I can think of is that it is using auto-increment to generate the order numbers. If it is, you could execute the following query on your database to set the next order number to 1000:

ALTER TABLE `ps_orders` AUTO_INCREMENT = 1000

Help please!!!
I use hostgator as my hosting company and followed these steps and got this error.

#1046 - No database selected
ALTER TABLE `ps_orders` AUTO_INCREMENT =2092

Please help.
Thanks in advance.

[rocky]

Try:

ALTER TABLE `database_name`.`ps_orders` AUTO_INCREMENT = 2092

Change database_name to the name of your database.

[Dimaer]

Guys for accounting purposes I want to reset number of orders and make them start from 1. Is it possible as I have some completed orders in already and also many test orders. Apparently I have customers with loyalty points which are based on order number.
What is best solution?
Thanks.

[Grek]

Hi
For some reason it doesn't work for me using 1.4.0.17
I can see the command successfully executed but no impact on my orders... Still 122, 123, etc instead of 1000, 1001, etc
Any idea?

[rcplus]

Same as Grek. Not changing.. any idea?

[kkshop]

same question guys! nothing new how to increase order number?

[jaimeweb]

Do we have a solution for 1.4?

[jaimeweb]

Anyone help please? I need to do this...

thanks

[jaimeweb]

Can no body give me a solution for 1.4 on this matter?

[ghassan]

Hi,

i'm trying to add the address of the supplier on the customer's delivery slip in order for the customer to know the location of the supplier in case of any item exchange ( thats if the customer doesnt want to use the RMA option ).

can you please advise,

thanks

[vinventddp]

Ive made a plugin for the backend for this. To use it:<br/><br/>1. Copy the attached file into your admin/tabs folder<br/>2. Go to Tools/Tabs/Add New<br/>3. Enter "Order Options" as the name<br/>4. Enter "AdminOrderOptions" as the class<br/>5. Select "Orders" as the parent<br/>6. Click Save<br/>7. Go to Orders/Order Options<br/>8. Enter the new number you want to start with<br/>9. Click "Change Start number"<br/><br/>Done.<br/><br/>Let me know if there are any problems I'll try and post an update.

 

It works perfectly for 1.4.4. Thanks Eck!

[yabonga]

I can confirm that Ecks php-file works for 1.4.4.1. Thank you for that! By the way, what do I have to change to increase/edit the credit slip id?

[idoityourself]

Where is Tools/Tabs/Add New? I cant see Tabs under Tools had it changed?

thanks

[preerp10]

Where is Tools/Tabs/Add New? I cant see Tabs under Tools had it changed?

thanks

 

In case anybody else is wondering, "tabs" is now (v1.4.5.1) under "employees" not under "tools".

[preerp10]

I can confirm that Eck!'s plugin works in v 1.4.5.1

Eck!- Thanks for making it so bloomin' easy. In case nobody's told you this yet today, you rrrock.

[Pippo3000]

I use this http://prestashop-module.de/en/back-office-features-for-prestashop/80-noumerique-bestellungs-und-kundennummer-manager.html, numerique by silbersaiten

 

for free and works great. just increased customers and ordernumbers for 2012

[led-watches.co.uk]

For those who dont want to mess around with cpanel etc.. heres confirmation I have just tried and test Eck!'s plugin in v 1.4.6.2 and it works a treat.

 

Changed the order number to match the delivery and invoice number at last!!!

 

Good work!!

[rockmaster]

Ive made a plugin for the backend for this. To use it:

1. Copy the attached file into your admin/tabs folder

2. Go to Tools/Tabs/Add New

3. Enter "Order Options" as the name

4. Enter "AdminOrderOptions" as the class

5. Select "Orders" as the parent

6. Click Save

7. Go to Orders/Order Options

8. Enter the new number you want to start with

9. Click "Change Start number"

Done.

Let me know if there are any problems I'll try and post an update.

 

This one worked perfect for me!

Thnx!!!!

 

( installed on version 1.4.4.1 )

 

http://www.hippeboefjes.nl

[berta recchia]

Good stuff.

Rockmaster tool worked well, for 1.4.8.2 too.

 

Such small tools make a world of difference!

[Dan1]

Thank you Eck. Works in 1.4.8.2.

[zazza]

Yeah, remeber that tabs is now under "employees", and then it works

 

Thanks!!

[madxface]

I'm surprised that doesn't work. The only other thing I can think of is that it is using auto-increment to generate the order numbers. If it is, you could execute the following query on your database to set the next order number to 1000:

 

ALTER TABLE `ps_orders` AUTO_INCREMENT = 1000

 

WORKS! 1.4.8.2

[kitsuperstore]

version 1.4.9 the Eck! plugin does not work. anyone know how to get the invoice numbers to line up? i used the sql statement above to get my order numbers updated but the invoice number is now out of sync.

[madxface]

version 1.4.9 the Eck! plugin does not work. anyone know how to get the invoice numbers to line up? i used the sql statement above to get my order numbers updated but the invoice number is now out of sync.

 

run this query ALTER TABLE `ps_orders` AUTO_INCREMENT =1000

 

Your next ID order will be 1000

[kitsuperstore]

Thanks, yeah i did that already and my order numbers are higher, but now the invoice number on the pdf attached to the order is still IN000004. Do you know a sql I can run to match that up with the new higher order number? Thanks!

[madxface]

order number (which is now 1000) is completely different thing than invoice number (you can change it manually in BO/orders/invoices)

- probably it will never be a same number

[kitsuperstore]

Thanks, I tried setting invoice number there and it still generates the low number. I am on number 5 now .... I guess it is fine if they get out of sync later but I wanted the order number and invoice number to be higher so it doesn't project my company as being brand new and untrustworthy. Thanks!

[oaten101]

Ive made a plugin for the backend for this. To use it:

 

1. Copy the attached file into your admin/tabs folder

2. Go to Tools/Tabs/Add New

3. Enter "Order Options" as the name

4. Enter "AdminOrderOptions" as the class

5. Select "Orders" as the parent

6. Click Save

7. Go to Orders/Order Options

8. Enter the new number you want to start with

9. Click "Change Start number"

 

Done.

 

Let me know if there are any problems I'll try and post an update.

 

Spot on!

[maximus33]

Ive made a plugin for the backend for this. To use it:

 

1. Copy the attached file into your admin/tabs folder

2. Go to Tools/Tabs/Add New

3. Enter "Order Options" as the name

4. Enter "AdminOrderOptions" as the class

5. Select "Orders" as the parent

6. Click Save

7. Go to Orders/Order Options

8. Enter the new number you want to start with

9. Click "Change Start number"

 

Done.

 

Let me know if there are any problems I'll try and post an update.

 

Hi Guys, I've done the above on 1.4.8.2 and when I go to order options in orders it says 'tab file not found' anyone know where i might be going wrong. I've definitely uploaded the file too. (admin/tabs)

[Joe Retail]

This module is GREAT.  It's simple, free and works with 1.5.5.   The site is in German, so select your language and download this free module.  My wording is in English.

 

Thanks developer silbersaiten.

 

 

I use this http://prestashop-module.de/en/back-office-features-for-prestashop/80-noumerique-bestellungs-und-kundennummer-manager.html, numerique by silbersaiten

for free and works great. just increased customers and ordernumbers for 2012

[ssekazinga]

Awsome  - been looking for this, had made a fresh install the best option than upgrading from 1.4 to 1.56.

thank guys.

[MrBraco]

Priceless information right there.

[10210ken]

I use this http://prestashop-module.de/en/back-office-features-for-prestashop/80-noumerique-bestellungs-und-kundennummer-manager.html, numerique by silbersaiten

 

for free and works great. just increased customers and ordernumbers for 2012

 

Great module. Should be included in Prestashop as standard

[nikmagnus]

Try:

 

ALTER TABLE `database_name`.`ps_orders` AUTO_INCREMENT = 2092

Change database_name to the name of your database.

 

Thanks the Auto-Increment works well for me in PS 1.5.6.2

Nik

[mir-aus]

Hi,

My last id numbr is  93404
 

 

Still I have to run 

ALTER TABLE `database_name`.`ps_orders` AUTO_INCREMENT = 1000 
or

ALTER TABLE `database_name`.`ps_orders` AUTO_INCREMENT = 93404

 

 

[mir-aus]

any one can help me in this matter please