Login
Register

VirtueMart

WooCommerce

Others

Docs

Support

Blog

About

Advanced Ordernumbers for VirtueMart

IMPORTANT ANNOUNCEMENT: Plugin development ceased, all plugins made available freely (GPL)

With great sadness we have to announce that we are ceasing development of all our VirtueMart, WooCommerce and Joomla plugins. Effective immediately, all our plugins -- even those that were paid downloads -- are made available for free from our homepage (GPL license still applies), but we cannot and will not provide any support anymore.

It has been a great pleasure to be part of the thriving development communities of VirtueMart as well as WooCommerce. However, during the last year it became painstakingly clear that in addition to a full-time job, a young family and several other time-consuming hobbies at professional level (like being a professional singer) the plugin development and the support that it requires is not sustainable and is taking its toll. It has been an honor, but it is now time to say good bye!

×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

Start with a certain order number 29 Mar 2013 16:38 #1

  • media
  • media's Avatar Topic Author
Hello.
I want to start with the order number 1116. Therefore, i have # as global counter only whithin the plugin settings for the order numbers. Format of the nummber is "00001116".
Would you please point me to the exact place of the database table , where i have to enter the value of 1116(?).
Thank you :)

Start with a certain order number 29 Mar 2013 16:53 #2

I you have configured the counter to be a global counter (in your case you appear to have format "#" with a global counter an 8 minimum digits), then you need the following:

-) Table (prefix)_virtuemart_shopper_plg_ordernumber, where (prefix) is the table prefix used by your Joomla installation.

-) Find the entry with number_type = 0 and number_format = ''. There you can change the count column to 1116 (i.e. the last order had nr 1116, the next order will have order number 1117).


If you prefer SQL, here is the SQL command to set the order number to 1116 for the global counter:
UPDATE `j25_virtuemart_shopper_plg_ordernumber` SET `count` = '1116' WHERE `number_type` = 0 AND `number_format` = '';

Start with a certain order number 29 Mar 2013 17:23 #3

  • media
  • media's Avatar Topic Author

I you have configured the counter to be a global counter (in your case you appear to have format "#" with a global counter an 8 minimum digits)

Exactly!

f you prefer SQL...

Did it this way.

I will report after the next order.

Thank you for your kindly and professional Support :)

Start with a certain order number 30 Mar 2013 20:19 #4

  • media
  • media's Avatar Topic Author
Works perfect :)
Thank you Reinhold!

[SOLVED] Start with a certain order number 30 Mar 2013 23:09 #5

Problem solved.
  • Page:
  • 1