| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
First Order ID modifed | ||||
|
|
Thread Tools | Search this Thread |
#11
|
|||||||||
|
|||||||||
Re: Can I include alpha ?
Quote:
Hi, The order id only accepts numbers im afraid. you could always add the extra letters before where it prints on your order etc
__________________
Looking for a reliable X-cart host ? You wont go wrong with either of these. EWD Hosting Hands On Hosting |
|||||||||
#12
|
|||||||||
|
|||||||||
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.
__________________
XC 4.2 inc (unofficial) patch release. |
|||||||||
#13
|
|||||||
|
|||||||
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.
__________________
X-Cart Gold 4.1.3 |
|||||||
#14
|
|||||||||
|
|||||||||
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.
__________________
XC 4.2 inc (unofficial) patch release. |
|||||||||
#15
|
|||||||
|
|||||||
Would this "Order ID" mod work for the newest version of X-cart, 4.0.10 ?
Thanks -Tuan
__________________
Win2003 IIS6, PHP 5.2.3, MySQL 5.0.45 and X-Cart 4.1.9 |
|||||||
#16
|
|||||||
|
|||||||
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.
__________________
xcartmods.co.uk |
|||||||
#17
|
|||||||
|
|||||||
Thank you, I appreciate your help.
__________________
Win2003 IIS6, PHP 5.2.3, MySQL 5.0.45 and X-Cart 4.1.9 |
|||||||
#18
|
|||||||
|
|||||||
Re: First Order ID modifed
[quote="B00MER"]
Code:
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 |
|||||||
#19
|
|||||||||
|
|||||||||
Yes.
But patch/upgrade is in your admin of XC, should be simple to find.
__________________
XC 4.2 inc (unofficial) patch release. |
|||||||||
#20
|
|||||||
|
|||||||
Yes, you are correct, I was making it too difficult, looking in the dir structure - Thanks! |
|||||||
|
|||
X-Cart forums © 2001-2020
|