TOPIC:

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 :)

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:

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 :)

Works perfect :)
Thank you Reinhold!

Problem solved.