How to Change Invoice Number to YYYYMMDDxxxx?

Hi,
Is it possible to change the invoice numbers to reflect the date the order was raised.. e.g the fifth invoice raised on 13 August 2011 would have the invoice number 201108130005?

I've searched the forum and found this post but i don't know how to change it. Can anybody help me?

Thanks

It's easy to modify the order number shown on the invoice so that it includes the year of the order.
For example, if you have order number xyz, ordered in 2008 and want to display it on the invoice as Invoice No. xyz-2008 you can edit the file admin/invoices.php...
find this line of code at about line 141:

    <td class="main"><b><?php echo ENTRY_ORDER_ID . $oID; ?></b></td>

and replace it with this:

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

Then all your invoice numbers will include the year of the order, without ever having to update anything manually.

What about that post wasn't clear ?

Its probably just that i cant read /dont understand php.
If i put that code in i get "Invoice No. xyz-2011"?

so I'm assuming...
$oID . gives me xyz
'-' gives me -
. date(Y,strtotime($order->info['date_purchased'])) gives me 2011?

What will give me yyyymmdd and is it just a matter of reversing it so i have yyymmddxyz?

is this a valid code?

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

Not quite. The dot before the semi-colon would give you a problem, and you will probably want to use "Ymd" rather than "Y" to give you the month and day too.

However, this won't restart the numerical part each day. If the last number today was 5, the first tomorrow will be 6.

thanks kuroi, i'll remove the dot in question and change the Y. the end bit not changing is close enough to what i wanted to do (now that i know how its going to work)

thanks again for your help

Hi, I've been looking at the above and cant get the below code to work. My invoice numbers are just continuing to role over as normal without the Year Month Date prefix!

The code I'm replacing is in the admin/invoice.php file and is shown below.

Am i doing something wrong?

Thanks
Tony

The YMD needs quotes around it. Single or double, either will do.

still not having it!

I dont have to change anything in the DB do I? field length etc??

You're missing a concatenation dot between ENTRY_ORDER_ID and the date function.

i.e. should read > ENTRY_ORDER_ID . date("YMD", etc

and this won't change your underlying order numbers, just prepend the date when displaying in this specific location.

thanks for the advice but its still not having it. I'll look at it again when I have more time.

thanks again.

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.

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.

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 ```php

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.

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

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!