How to Change Invoice Number to YYYYMMDDxxxx?

[kuroi]

When clients bring me this sort of request, my first question is usually "how many more sales will you get from this?"

There's no obvious reason why this shouldn't work, but it's also not clear that there's business benefit that warrants spending more than a couple of minutes on it.

[racinjason]

Try to just have the date in the invoice number 201201150000001
Copy and pasted the code in the first thread......not working

<td class="main"><b><?php echo ENTRY_ORDER_ID . $oID . '-' . date(Y,strtotime($order->info['date_purchased'])) ; ?></b></td>

What is wrong?

I don't want it to say date purchased if that is what is going to happen too.

[gjh42]

What exactly do you mean by "not working"? Does it do anything? The code as posted will give some custom text and the order number followed by date. What you want would take something like this

<td class="main"><b><?php echo date('Ymd',strtotime($order->info['date_purchased'])) . $oID; ?></b></td>

Also, as mentioned, this will not affect the actual order number at all, or its display in any other location. If you really want the order number itself to work as described, you could schedule a cron job to run at midnight every day and reset the next order number to the date as shown plus whatever quantity of zeros.

[gjh42]

I don't know if it's compatible with ZC admin control of the db, but this article may be useful to someone wanting to actually identify order numbers by time period: Working with MySQL Events

I reset order numbers each year, so this year's orders start like 120001. Sites with higher order frequency may want different criteria.
See Admin->Tools->Store Manager to reset order numbers.

[kuroi]

Try to just have the date in the invoice number 201201150000001
Copy and pasted the code in the first thread......not working

<td class="main"><b><?php echo ENTRY_ORDER_ID . $oID . '-' . date(Y,strtotime($order->info['date_purchased'])) ; ?></b></td>

What is wrong?

I don't want it to say date purchased if that is what is going to happen too.

The code as posted won't work because the the first parameter in the date function needs to be in quotes.

This would be easier to diagnose if you explained where you'd put the code, and specifically what symptoms, results or lack of them lead you to conclude that it's "not working".

[mqeprez]

Have been reading the post here and have a question..
What if all we wanted was to put a prefix to the order number i.e. "w1000" ? How would that be done? thru the database or code?
Thanks!