Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

First Order ID modifed

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #11  
Old 11-16-2004, 07:43 AM
  shan's Avatar 
shan shan is offline
 

X-Guru
  
Join Date: Sep 2002
Location: Birmingham, UK
Posts: 6,163
 

Default Re: Can I include alpha ?

Quote:
Originally Posted by aschek
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

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
Reply With Quote
  #12  
Old 11-24-2004, 07:26 AM
  CC's Avatar 
CC CC is offline
 

eXpert
  
Join Date: Jun 2004
Posts: 349
 

Default

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.
Reply With Quote
  #13  
Old 11-28-2004, 11:29 AM
 
clydefrog clydefrog is offline
 

Advanced Member
  
Join Date: Nov 2004
Posts: 61
 

Default

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
Reply With Quote
  #14  
Old 11-28-2004, 01:48 PM
  CC's Avatar 
CC CC is offline
 

eXpert
  
Join Date: Jun 2004
Posts: 349
 

Default

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.
Reply With Quote
  #15  
Old 01-18-2005, 12:03 PM
 
TL408 TL408 is offline
 

X-Adept
  
Join Date: Jan 2005
Posts: 549
 

Default

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
Reply With Quote
  #16  
Old 01-18-2005, 12:16 PM
 
PhilJ PhilJ is offline
 

X-Guru
  
Join Date: Nov 2002
Posts: 4,094
 

Default

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
Reply With Quote
  #17  
Old 01-18-2005, 01:44 PM
 
TL408 TL408 is offline
 

X-Adept
  
Join Date: Jan 2005
Posts: 549
 

Default

Thank you, I appreciate your help.
__________________
Win2003 IIS6, PHP 5.2.3, MySQL 5.0.45 and X-Cart 4.1.9
Reply With Quote
  #18  
Old 01-24-2005, 10:12 AM
 
smrtsu smrtsu is offline
 

Advanced Member
  
Join Date: Sep 2004
Posts: 34
 

Default Re: First Order ID modifed

[quote="B00MER"]
Code:
ALTER TABLE xcart_orders AUTO_INCREMENT = 15000;

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
__________________
smrtsu
xcart v4.0.17 http://www.ettasays.com
xcart v4.0.19 http://www.inspa.com
Reply With Quote
  #19  
Old 01-24-2005, 10:16 AM
  CC's Avatar 
CC CC is offline
 

eXpert
  
Join Date: Jun 2004
Posts: 349
 

Default

Yes.

But patch/upgrade is in your admin of XC, should be simple to find.
__________________
XC 4.2 inc (unofficial) patch release.
Reply With Quote
  #20  
Old 01-24-2005, 10:35 AM
 
smrtsu smrtsu is offline
 

Advanced Member
  
Join Date: Sep 2004
Posts: 34
 

Default



Yes, you are correct, I was making it too difficult, looking in the dir structure - Thanks!
__________________
smrtsu
xcart v4.0.17 http://www.ettasays.com
xcart v4.0.19 http://www.inspa.com
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 12:15 AM.

   

 
X-Cart forums © 2001-2020