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.

[Shane78]

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!

[d1rage5]

No not a thing. nothing worked like i needed.

Sorry for that news.

[DrByte]

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?

[d1rage5]

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

[DrByte]

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.

[Nima]

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.

[d1rage5]

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.

[Shane78]

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...

[DrByte]

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.