Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Can I change the Order Number ?!


Guest

Recommended Posts

Can I change the Order Number ?!

 

I hope the order number is started at 5 numbers

e.g.: 00001...00002.....01568.....05565

 

 

How to do it?!

 

Thanks~

Link to comment
Share on other sites

the database contains the order numbers, in order table, u can also use the contribution random order generator

But the random order generator will be generate the unknow number,

can it generate in sequence ?!

 

thx~

Link to comment
Share on other sites

no, just change the order # to a a few numbers below what you want it to start with, then place a test order or two

oh...ok~

let me try, thanks~

 

:lol:

Link to comment
Share on other sites

/////////////////      RAMDOMIZING SCRIPRT BY PATRIC VEVERKA      \\\\\\\\\\\\\\\\\\

 

$t1 = date("mdy");

srand ((float) microtime() * 10000000);

$input = array ("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z");

$rand_keys = array_rand ($input, 2);

$l1 = $input[$rand_keys[0]];

$l2 = $input[$rand_keys[1]];

$r1 = rand(0,9);

 

$ordernum = $l1.$l2.$t1.$r1;

 

/////////////////    End of Randomizing Script  \\\\\\\\\\\\\\\\\\\

 

 

I see this script, where can I define the order numer that I like ?!

 

 

 

that's all. This produces the random order number like KY1002025

 

It say the random order number like KY1002025,

but I need to use standard order number,

how can I do?!

 

Thanks~

Link to comment
Share on other sites

no, just change the order # to a a few numbers below what you want it to start with, then place a test order or two

oh...ok~

let me try, thanks~

 

:lol:

Do that

9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard)

 

Replace that and you're fine...

Link to comment
Share on other sites

no, just change the order # to a a few numbers below what you want it to start with, then place a test order or two

change which code ?!

 

can you briefy describe ?!??!

 

 

Thank You!!

Link to comment
Share on other sites

no, just change the order # to a a few numbers below what you want it to start with, then place a test order or two

oh...ok~

let me try, thanks~

 

:lol:

Do that

But I don't know how to do it?

Link to comment
Share on other sites

  • 3 years later...
OK~ I got it :P

 

I edit the data in " Order " Table of Mysql database.

Thanks~

 

where in the database did you find the order numbers, i dont see the last order number so i have no reference??

 

thanks.

Link to comment
Share on other sites

  • 1 year later...
where in the database did you find the order numbers, i dont see the last order number so i have no reference??

 

thanks.

 

don't bother to find the order numbers, just run the following query at mysql if you want your number to start from 1000.

 

alter table orders auto_increment = 1000;

 

Jason

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...