Customer Order Ids

19 Mar 2008, 19:59

#1

New Zenner

Join Date:: Mar 2008
Posts:: 2
Plugin Contributions:: 0

Customer Order Ids

I would like to create custom order ids with alphanumeric data, e.g. CR4004.

I looked through modules/classes/order.php and I can't seem to find how it's setting the order id.

Any suggestions?

19 Mar 2008, 20:07

#2

steven300

Totally Zenned

Join Date:: Jan 2008
Posts:: 1,564
Plugin Contributions:: 0

Re: Customer Order Ids

I've seen a few requests for this in the past. Sadly there is no option in admin to do what you want. As far as I'm aware, there's no contribution available either. I think you might have to make do with the current approach which is to increment the ID by 1 each time. You can always change the ID to start at a higher number, e.g. 60548. This can be done in admin>tools>store manager.

19 Mar 2008, 22:34

#3

sanguisdesign

Inactive

Join Date:: May 2005
Posts:: 588
Plugin Contributions:: 1

Re: Customer Order Ids

please explain the algorithm that you want to use for order ID's, so we may see if it is possible.

26 Mar 2008, 12:57

#4

winzippy

New Zenner

Join Date:: Mar 2008
Posts:: 2
Plugin Contributions:: 0

Re: Customer Order Ids

I want the order id's to be something like CR999999. Just need to append "CR" to the order id really.

26 Mar 2008, 14:04

#5

sanguisdesign

Inactive

Join Date:: May 2005
Posts:: 588
Plugin Contributions:: 1

Re: Customer Order Ids

there are 2 ways of going about this., (that I can think of at the moment).
the easier i think would be to modify the code to display the added cr to the id number every where you want the cr to be displayed.
This way you will not have to mess w/ the database.
The other thing to do is to add a customer_number to the customers table on the database, and to have it be a varchar(64) and have your customer creations script do something like $customer_number = 'cr'. $customers_id; that way you dont have to think of messing w/ the auto incrementing that that the database already does for you.
both methods will will require you to change the loging script to match the customer_number w/ the database instead of the email address.

05 Apr 2008, 13:18

#6

paddy100

New Zenner

Join Date:: Feb 2007
Posts:: 52
Plugin Contributions:: 1

Re: Customer Order Ids

If you just want to add the CR to the order number there is alot easier way to do this, as I have done it to mine, I will dig out the files needed and come up with a short tutorial:smile:

05 Apr 2008, 13:22

#7

steven300

Totally Zenned

Join Date:: Jan 2008
Posts:: 1,564
Plugin Contributions:: 0

Re: Customer Order Ids

Thanks Paddy, that will help a lot of people.

05 Apr 2008, 13:26

#8

paddy100

New Zenner

Join Date:: Feb 2007
Posts:: 52
Plugin Contributions:: 1

Re: Customer Order Ids

OK Dead simple,

In the developers tool kit (admin>tools>Developers tool kit) do a search in the bottom search field for "Order #" then change the text in the files you wish to whatever you want to see in fromt of the order number.

EG. if you want it to read Order # CRXXXX

Just add 'CR' after the hash symbol

12 May 2008, 21:36

#9

d1rage5

Zen Follower

Join Date:: Jan 2008
Posts:: 144
Plugin Contributions:: 0

Re: Customer Order Ids

i know this is an older post but hope people are watching it.

is this option gone in 1.3.8?

When i search for order # it can not find anything looks like it is only searching the files and not the database for order number....

28 May 2008, 09:46

#10

oavs

Totally Zenned

Join Date:: Jan 2006
Posts:: 921
Plugin Contributions:: 0

Re: Customer Order Ids

Its all there.

Here is a even simpler solution:

Just add CR after the 'Order Number: CR'

on following page and lines.

/admin/includes/languages/english/orders.php

Line #152 : define('EMAIL_TEXT_ORDER_NUMBER', 'Order Number:');

/includes/languages/english/account_history.php

Line #28 : define('TEXT_ORDER_NUMBER', 'Order Number: ');

/includes/languages/english/checkout_process.php
Line #54 : define('EMAIL_TEXT_ORDER_NUMBER', 'Order Number:');

Yippieeee!

29 May 2008, 05:59

#11

d1rage5

Zen Follower

Join Date:: Jan 2008
Posts:: 144
Plugin Contributions:: 0

Re: Customer Order Ids

Does this place this in the database?
the reason for the question is: i am using quickbooks and when i download the invoices from three different sites and nothing is noted in the database then all the order id numbers will be the same.

09 Aug 2009, 14:36

#12

shane78

Banned

Join Date:: Oct 2008
Posts:: 876
Plugin Contributions:: 0

Re: Customer Order Ids

Hi D1rage5

did you ever come to a solution to your problem with adding a prefix to order numbers?

I too am looking for that solution...

Please help if you can!

09 Aug 2009, 15:36

#13

d1rage5

Zen Follower

Join Date:: Jan 2008
Posts:: 144
Plugin Contributions:: 0

Re: Customer Order Ids

No not a thing. nothing worked like i needed.

Sorry for that news.

09 Aug 2009, 20:02

#14

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Customer Order Ids

d1rage5:
Does this place this in the database?
the reason for the question is: i am using quickbooks and when i download the invoices from three different sites and nothing is noted in the database then all the order id numbers will be the same.

Why not make some customizations to the quickbooks export tool you're using to have it insert a prefix into the order number when it generates the exported data?

09 Aug 2009, 20:45

#15

d1rage5

Zen Follower

Join Date:: Jan 2008
Posts:: 144
Plugin Contributions:: 0

Re: Customer Order Ids

My Issues is that i have one quickbooks file and three different companyies.

09 Aug 2009, 20:54

#16

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Customer Order Ids

3 different stores you're exporting from?

It's simple: simply edit the QB Exporter code in each store to insert a prefix or some sort of identifier for each company, so that your exported file that you take into QB has differentiated numbers in it already.

23 Aug 2009, 23:05

#17

nima

New Zenner

Join Date:: Apr 2008
Posts:: 67
Plugin Contributions:: 0

Re: Customer Order Ids

I too would really like a mod that can do this

I also run more than one website that i want to seperate with some letters in front of the order number.

24 Aug 2009, 00:54

#18

d1rage5

Zen Follower

Join Date:: Jan 2008
Posts:: 144
Plugin Contributions:: 0

Re: Customer Order Ids

doen'nt work or no one is making one.
This has been on the plate for a long long time. It may be in the next version.

The add an before or after only works in a way that if you add this to some type of quick books add on and then its only in QB and not in zen cart so get audited and try to explain this to the irs (i have just gone through this and they dont care if the first part and the second part with the Prefix match) its your money with the accountant that have to fuse about. so if zencart and quickbooks and almost the same numbers your screwed.....

three different books have to be setup until some builds a correct numbering scem between zencart and quickbooks.

15 Sep 2009, 22:08

#19

shane78

Banned

Join Date:: Oct 2008
Posts:: 876
Plugin Contributions:: 0

Re: Customer Order Ids

i have been looking.. and while i have little knowledge of MySQL....

is there not some setting or easy way to prefix orders_products_id in the database to have some letters before the incremented order ID? I.E via PHPmyAdmin and not touching ZC at all?

just thinking allowed...

15 Sep 2009, 22:27

#20

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Customer Order Ids

mcshane78:
i have been looking.. and while i have little knowledge of MySQL....

is there not some setting or easy way to prefix orders_products_id in the database to have some letters before the incremented order ID? I.E via PHPmyAdmin and not touching ZC at all?

just thinking allowed...

No. Those fields in the database are numeric, and incremental numbering managed by the database. You can't add other numbers or letters to them.