TOPIC: [SOLVED] Reset order and PDF invoice order issue

I'm unsuccessfully trying to reset order and invoice number to put store online.
I have deleted order from virtuemart, deleted invoices from db table "jictm_virtuemart_invoices, deleted order history from db table "jictm_virtuemart_order_histories" and set auto increment value to 1 for tables: "jictm_virtuemart_order_histories", " jictm_virtuemart_orders ", "jictm_virtuemart_invoices", but as you can see by attachment pdf invoice number is related to the total amount of test orders done today, also for order number.
All I need is to start from 1 with order and invoice number, than re-start from 1 for both when year changes (01-01-2015)

VM 2.0.26
Joomla 2.5.19

My Order number plugin configuration is:
Format of the order numbers: Ordine # [day]-[month]-[year]
Format of the invoice numbers: # [day]-[month]-[year]
for other settings see image by attachment.

Best Regards
Daniele Comello

Dear Daniele,
If you use "separate counter per format value", then the counter will start at 1 whenever any of the variables used in the format changes its value. In your case, this maeans that the counter will be per-day.
You can switch to a global counter, which will never be reset. Unfortunately, your wish to have the counter reset at the beginning of each year is currently not possible. If you include any other value than the year, then a yearly reset is not possible.

Best regards,
Reinhold

Thanks for your answer Reinhold,
I've disabled "Customize invoice numbers" after installing "Artio INVOICE", so if I have understood, the right way to have ordering number starting from 1 each new year is to check "Separate counter per format value" with this format: [day]-[month]-[year] #

Best regards
Daniele

Actually, no. With your format there is no way to reset the counter each year. For a description of how the plugin works in detail, see www.open-tools.net/forum/ordernumber-plu...er-format-value.html

Best regards, Reinhold

Hi Reinhold,
could you please help me with another post:
www.open-tools.net/forum/ordernumber-plu...ation-by-length.html

I need help to calculate shipping rate for product sells by lenght (iron cable).

Best regards
Daniele

Problem solved.

I have now released version 1.12 of the ordernumber plugin, which allows the admin to configure in more detail when the counter is "reset" (internally, it is not really reset, but a new counter with a new name is started). In your case, the proper number format to have the counter reset yearly would be:
Of course, you'll have to enable "Separate counter per format value". (Notice, however, that if you already have orders, the counter would start from 1 again).

So, you probably have your shop set up now and don't want to change this. However, I'm posting this example in case someone else with a similar issue reads through our support forum and reads this thread.

Best regards,
Reinhold

Thanks for your answer Reinhold,
this means that if I will upgrade to 1.12 version, when new year will starts, new invoice will be 0001-day-month-2015?

Best regards,
Daniele

Yes and no. If you upgrade, nothing will change unless you change the configuration of the plugin. You'll need to change the invoice number format and set the counter to format-specific (NOT global).

The proper format for your desired invoice numbers would be:
However, if you change the plugin configuration now, the counter will start at 1 again.

To let the counter continue from your current number, you'll have to manually adjust the database, see open-tools.net/documentation/41-vm2-ordernumber-plugin-faq.html

In your case, the easiest approach is to change the database entry where number_type=1 from number_format="" to number_format="#-2014". You need to do this at roughly the same time as you change the plugin configuration. In particular, if any order comes in between the change of the configuration and the change in the database, that order will have a wrong invoice number...

Best regards,
Reinhold

Ok, so if I will do this change as you described on 31-12-2014, the first order/invoice of 2015 will starts from 01-month-2015?

Best Regards

Yes, the format string that I gave makes the order or invoice numbers start from "1-01-01-2015" with the first number being the counter within the year.

Best regards,
Reinhold