Order Number combined with Customer ID

[time111]

Hello,

Like to know is there any possibility where we can combine the order number generated by zencart with customer ID as final order number visible to customer.

Ex:
Order Number: 3256, Customer ID: 199
Combined Visible Order Number: 3256000199 or 1990003256

Any help appreciated.

~Time

[mc12345678]

Hello,

Like to know is there any possibility where we can combine the order number generated by zencart with customer ID as final order number visible to customer.

Ex:
Order Number: 3256, Customer ID: 199
Combined Visible Order Number: 3256000199 or 1990003256

Any help appreciated.

~Time

I really should know the answer to this, but haven't looked at that page enough to know. Are both of those pieces of informmation that are currently displayed on that page, but separated? Is this value going to be stored somewhere? Won't it be difficult to identify who is who as the number of customers increases and the number of orders also increases? (Ie, how many zeros are going to prefix the customer id to make this work?

[time111]

Still nobody? is this wrong category I posted?

[badarac]

The customer id and order id are auto incremented values in the database tables. While you could concatenate them in any html or emails, to actually use the combined value to reference order information would require a substantial rewrite of the cart code.

[time111]

The customer id and order id are auto incremented values in the database tables. While you could concatenate them in any html or emails, to actually use the combined value to reference order information would require a substantial rewrite of the cart code.

Hi,

This idea also look fine, can anybody tell how to call customer ID from database to places where order ID is visible like My Account, Order Status Emails etc....

~Time

[mc12345678]

Hi,

This idea also look fine, can anybody tell how to call customer ID from database to places where order ID is visible like My Account, Order Status Emails etc....

~Time

Should be a session value with no database lookup necessary unless using something like COWOA where there is no "login" per se, I think. Not sure that when one returns to the site to look up a past order if a SESSION variable is initiated to capture the details of the user or not. Otherwise it is a SQL query to the database or a simple display of information to be added or already gathered in the header_php.php, main_template_vars.php of the page's pages directory, or similar. (Ie. includes/modules/pages/PAGENAME/)

[swguy]

Re-read @badarac's answer, which is correct. This idea isn't practical.
If you want to make your store look like it has processed more orders, bump the order id using Tools->Store Manager.

[time111]

it is nothing to do with more or less orders, by adding customer ID we can use that in logistics/admin to know customer just by ID. only order number will need update of database every time for offline usage.

I only want both order ID and customer ID should be visible together, do not need to fiddle with auto incremental of anything.

~Time