If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / how to set order id backwards,a smaller one?

how to set order id backwards,a smaller one?

Started by win8win on 9 Aug 2012, 8:06 AM · Views: 731

Results 1 to 6 of 6
9 Aug 2012, 8:06 AM
#1
win8win avatar

win8win

Zen Follower

Join Date:
Apr 2012
Location:
beijing
Posts:
258
Plugin Contributions:
1

how to set order id backwards,a smaller one?

how to set order id backwards,a smaller one?
at backend ,only can set forwards,a bigger one,
if need to set a smaller one,
what should i do?:blink:

focus on the open source for online shoping website.
my site: best shop 24h.com

9 Aug 2012, 8:16 AM
#2
win8win avatar

win8win

Zen Follower

Join Date:
Apr 2012
Location:
beijing
Posts:
258
Plugin Contributions:
1

Re: how to set order id backwards,a smaller one?

figured out,
by phpadmin
update the follow five tables's field named orders_id to the smaller one you like where orders id's value is the bigger one you set by backend:

orders
orders_products
orders_products
orders_products_attributes
orders_status_history

focus on the open source for online shoping website.
my site: best shop 24h.com

9 Aug 2012, 9:05 AM
#3
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: how to set order id backwards,a smaller one?

win8win:

figured out,
by phpadmin
update the follow five tables's field named orders_id to the smaller one you like where orders id's value is the bigger one you set by backend:

orders
orders_products
orders_products
orders_products_attributes
orders_status_historyAnd what happens when these "lower" order numbers run into the existing higher order numbers?

10 Aug 2012, 5:28 AM
#4
win8win avatar

win8win

Zen Follower

Join Date:
Apr 2012
Location:
beijing
Posts:
258
Plugin Contributions:
1

Re: how to set order id backwards,a smaller one?

yes,it would be a bug ,maybe need to delete other bigger order ids

focus on the open source for online shoping website.
my site: best shop 24h.com

10 Aug 2012, 5:36 AM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: how to set order id backwards,a smaller one?

A more important question is WHY are you even wanting this? What brought you to a position where you need to ask this question? What business problem are you trying to "solve"?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

12 Aug 2012, 6:28 AM
#6
win8win avatar

win8win

Zen Follower

Join Date:
Apr 2012
Location:
beijing
Posts:
258
Plugin Contributions:
1

Re: how to set order id backwards,a smaller one?

just because of making a wrong orderid setting by mistake,would like to restore

focus on the open source for online shoping website.
my site: best shop 24h.com