First Order ID modifed
 

Enter this SQL query into Patch/Upgrade SQL Queries box and your next new order # will be 15001.

Happy X-Carting! ;)

Re: First Order ID modifed
 

Are you sure about that ? Isnt it the orderid field that needs to be altered directly, not a global attribute ?

Im not an expert, but I thought fields could be altered, or attributes, but not directly affect an attributes numbering. If so, let me know, could be handy for other CMS's

It Works
 

Works like a champ!

Thanks Boomer.

Thanks Boomer!



*search works for me.* :D

Yep works for me as well on 3.5.6!

Thanks Boomer

Excellent! Worked like a charm for me as well (v3.5.10). Thanks Boomer!

Works great! Thanks for your input.

A step further...
 

Great fix! Now, taking all this a step further, I hava client who wishes to have the date included in his order number. On top of that, he wants the order numbers to restart daily. Example, the second order placed on 9-4-04 would appear as: 9-4-04-02... Any suggestions on how the query code could be written to accomplish any or all of this greatly appreciated.

X-Cart version 4.0.2
PHP 4.3.4 Details
MySQL server 4.0.18
MySQL client 3.23.49
Web server Apache/1.3.27 (Unix)

Thaks again Boomer. 8)

Can I include alpha ?
 

Hey Boomer,
I am not an expert, but need to ask you please... is it possible to include ALPHA on this ? Let's say, start the order as ABC1000 then ABC1001 and let only the numbers increase ?

Thanks a lot !!
Alex

Re: Can I include alpha ?
 

Hi, The order id only accepts numbers im afraid. you could always add the extra letters before where it prints on your order etc

Nice one, going to run this on 4.0.7 now, hope it still works...

Does anyone know if an Invoice number mod exists for X-Cart?
So an invoice number is created only when the order has succesfully had the payment taken?

So for instance, an invoice number is created only when the order is set to Processed, then it is displayed at the top of the printed invoice...

In the UK the taxman will want to see consecutive invoices, but you wont have that if a customer has cancelled their order, so you cant do this with Order Numbers, it has to be fully consecutive invoice numbers...

Anyway, anyone know about something like this in existance?

Thanks.

The mod worked for me. Thanks.

CC - I would not use the order number in substitute of the invoice number that you should be keeping record of separately.

How do you mean?

I think you are saying the same as me... :?

I have to have in place to separate number references:

1) Order Number
2) Invoice Number <--- Which must be consecutive for the Tax Man.

Would this "Order ID" mod work for the newest version of X-cart, 4.0.10 ?

Thanks
-Tuan

yep, works on any table you want
eg.

ALTER TABLE xcart_orders AUTO_INCREMENT = 0;

ALTER TABLE xcart_categories AUTO_INCREMENT = 0;

ALTER TABLE xcart_products AUTO_INCREMENT = 0;

ALTER TABLE xcart_manufacturers AUTO_INCREMENT = 0;

ALTER TABLE xcart_extra_fields AUTO_INCREMENT = 0;

etc.

Thank you, I appreciate your help. :D

Re: First Order ID modifed
 

[quote="B00MER"]
Enter this SQL query into Patch/Upgrade SQL Queries box and your next new order # will be 15001.

Question: I can't find Patch/Upgrade - I'm accessing the db using phpMyAdmin. So, would I enter this in the "Run SQL query/queries on database xcart " entry box on the xcart_orders SQL tab?

Thx
Sue

Yes.

But patch/upgrade is in your admin of XC, should be simple to find.

:oops:

Yes, you are correct, I was making it too difficult, looking in the dir structure - Thanks!

yes it does.

Alternative
 

Hi there

My first post here, so please dont kill me :)

Here is an alternative to increasing the order id.

Make a fake order and keep in mind the order id of this order (let it be '6').

Execute the MySQL patch thru the 'APPLY MYSQL PATCH' SECTION of the 'Upgrade/Patch' part of the 'Adminiatration' menu in admin area:

1. Scroll down the "Patch/Upgrade center" page and find the "Apply SQL patch" section.
2. Enter the patch text:

into "Query(ies):" text area and push the "Apply" button.

So, the next order will be numbered as order #801220

Hope this is useful.

Re: First Order ID modifed
 

Boomer,

Sorry for asking...Do I do this through the MYsqldatabase or apply patch?

thanks

Re: First Order ID modifed
 

Look in the quote you had highlighted, that is the answer.

Admin:patch: enter data...

Re: First Order ID modifed
 

Duh...thanks, got that implemented, it's great! :lol:

Works on 4.0.14
 

This is a great tip.. I just did it on my verison 4.0.14 site.

Nick

yes

How about taking this one further, and figuring out a way to increase the order by x number of orders for each order? That way if a store was doing just a few sales a day, the returning customer wouldnt think he/she was the only customer.. something to think about for the people out there who are just starting out as we all have done

If you are running MySQL 5.0 or above, they introduced a new varaible with that called auto_increment_increment that does just what you want. The MySQL command to change it is:
(Or whatever other value besides 10 you might want.

Anyone happen to know if this will still work in version 4.1.2 release?

Thanks
-Tuan

Anyone happen to know if this will still work in version 4.1.2 release?

Thanks
-Tuan

As long as the field in the database is still the same it'll work. This is independent of X-Cart and has more to do with MySQL.

I tried this and it does work on 4.1.2

Yup! Well put, Order ID's are simply MySQL auto increment keys. :wink:

Thanks guys. Cheers

-Tuan