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!