Jump to content
Sign in to follow this  
craigglawson

Order Numbers

Recommended Posts

When OSC assigns orders a number, its always 1, 2, or 3.

 

I want to be able to have order numbers that start with 8 zero's, and the order numbers increment from there, or for the order ref's to be alphabetical.

 

Any help?

 

Craig


... Too close for missiles, I'm switching to guns ...

Share this post


Link to post
Share on other sites

I have the same need.

 

The answer is at http://www.oscommerce.info/kb/osCommerce/Tips_and_Tricks/31

 

But, I have no idea how to executed an SQL query with MySQL. I am on a shared hosting server. Everything is well except for making this change.

 

Can someone give me (us) some kind of step by step instructions on how to perform this operation?

 

Thanks so much,

Steve

Share this post


Link to post
Share on other sites

the customers do not see the order number until after the order is processed, so it is kind of a moot point, only one which you know and the customer sees after the order is gone.

to change the order # you have to change the order_id in the orders table to whatever number you want.


John Oligario

 

Knowledge Base Contributions

Share this post


Link to post
Share on other sites

You can run your SQL statement on your database in several ways:

 

1) Use a tool which has a web interface that you can install on your website: e.g. PhpMyAdmin (www.phpmyadmin.net)

 

2) Create a simple php script yourself with the command in it, upload it to your website, and run it.

 

3) This is probably the easiest. If your host allows it, you can connect via Telnet (or the more secure SSL) and run the MySQL command directly on your host server in a "DOS" like command window. A good free SSL client is PuTTY. Ask your host are SSL connections supported.

 

I use a combination of all 3, but if you can get it working, PhpMyAdmin is indispensable in working with OsCommerce

 

Darren

Share this post


Link to post
Share on other sites

I downloaded and installed phpMyAdmin, and used that to change the numbers. Whoa, look at all that database info...now we're cookin'... glad I looked into that. You're right, phpMyAdmin will be indispensable in working with OsCommerce. Thanks for the other info too.

 

Steve

Share this post


Link to post
Share on other sites

Hi everyone,

 

I am new to oscommerce and just began building my shopping cart few weeks ago.

 

Currently, i am trying to generate random order numbers with alpahabets in front...like LZ0001. I tried the Robust Random Order Number contributed by Author: Richard Bentley. However, whenever i go to admin orders, i can't edit the orders or view the invoice/packing list as the product qty will always be zero.

 

Can someone pls advise me on what to do? :)

 

BTW, Thank you very much for everyone's contribution to Oscommerce! Its really been a great help to me! :D

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×