Jump to content
Sign in to follow this  
eulamae

modify customer and order numbers

Recommended Posts

I would like to start the order and customer number at something other than "1" and have it auto increment from my starting point. How do I do that?

Share this post


Link to post
Share on other sites

Place an order then edit via phpMyAdmin all the orders tables and change the value of orders_id to the one you want to use.

Share this post


Link to post
Share on other sites

Ok... I'll ask... :oops: Where are the customer & order numbers? I'm testing checkout and I don't see either... upon checkout or in the order admin.

 

Where are they and does the cutomer receive this info?

 

-shaun

Share this post


Link to post
Share on other sites

Not sure if you are referring to being broken or how to change the current order number ...

 

Fixing Broken Orders:

 

If you cannot see any orders after adding them ... check via phpMyAdmin and see if your orders_status table is empty or if it has Pending, Processing and Delivered. There should be a set for each language.

 

 

How to Change Current Order Number:

 

To be safe ...

 

Go shop at your store and checkout ...

 

Go into phpMyAdmin ...

 

Go to your MySQL table ...

 

On all tables that start with orders (except orders_status) edit the orders_id to the new number you want it to be.

Share this post


Link to post
Share on other sites

Hey there, Linda -

 

Sorry for not being more clear. Yes, it's assigning numbers to the orders but the only place I physically see the number is in a VERY small [x] format on the right when checking orders. I was very surprised not to see it more prominent. And to top that, when an order is viewed, I don't see the order number anywhere on the screen. Am I missing it?

 

As for the customer number, I don't see that anywhere at all?

 

Should these be present on the screen in the admin areas?

 

Thanks!

 

-shaun

Share this post


Link to post
Share on other sites

Hi Linda

 

thank you for the idea to change the order number ,

i would like to make the order numbers start with letters like RQ as an example , do i need to change the order _id from int to var and keep it increament ?

 

Pls let me know if i am on the right track or if it require a different solution

 

Thanks

 

I>O

Share this post


Link to post
Share on other sites
Hey there, Linda -

 

Sorry for not being more clear.  Yes, it's assigning numbers to the orders but the only place I physically see the number is in a VERY small [x] format on the right when checking orders.  I was very surprised not to see it more prominent.  And to top that, when an order is viewed, I don't see the order number anywhere on the screen.  Am I missing it?

 

As for the customer number, I don't see that anywhere at all?

 

Should these be present on the screen in the admin areas?

 

I agree with you shaun. I have the order id showing on the list as well as inside the order, invoice and packing slip.

Share this post


Link to post
Share on other sites

I was wondering if there is a way of creating a random number that can be used as a unique reference number for bank deposits? This should also be linked to the order number to speedup picking and delivery?

 

I hope this makes sense.

Share this post


Link to post
Share on other sites

I have successfully get the 42 orders on my store. I want to start the next orders from the 1000 number. Is it possible to do it without disturbing the first order numbers.

Share this post


Link to post
Share on other sites
Place an order then edit via phpMyAdmin all the orders tables and change the value of orders_id to the one you want to use.

Can you please explain more details on how to change the value of orders_id? I have my PhpAdmin screenshot attached. I really have no idea where I can change the values. Thank you very much!

php.gif

Edited by iecwillow

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  

×