Author Topic: Invoicing order numbers  (Read 3789 times)

W Chenery

  • Beginner
  • *
  • Posts: 7
    • Adult Toy Party Plan
Invoicing order numbers
« on: April 04, 2009, 00:46:51 am »
can some one tell me if there is a way in plain terms so even i understand if there is a way to set the order number to start at 1000 instead of 001

as being a new site it becomes off putting to customers as they not sure to trust your site as it has low orders???

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28224
  • Always on vacation
    • Jenkin Hill Internet
Re: Invoicing order numbers
« Reply #1 on: April 05, 2009, 15:18:26 pm »
Open your database in phpMyAdmin, locate the jos_vm_orders table and open the table for browsing, usually by clicking on the browse icon in the first column after the table name (jos_vm_orders).

Then open the last order in the list for editing by clicking on the pencil icon on that row. The top field shown in order_id and you need to edit number shown in the Value box to a number one below the value you want to see on your next invoice.

Then save this by hitting the Go button at the bottom of the page with save selected in the action option box (usually save is there by default).

Then place a new order and you should find that you now have a better looking order/invoice number.

The problem with precise instructions is that you may have a different version of phpMyAdmin on your server, but the principle is the same.

If you are not used to editing databases then a good idea is to save a backup copy first. Use the export option to do this.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VirtueMart 3.8.9.10473 on Joomla 3.9.28 PHP 7.4.14

W Chenery

  • Beginner
  • *
  • Posts: 7
    • Adult Toy Party Plan
Re: Invoicing order numbers
« Reply #2 on: April 08, 2009, 04:52:47 am »
thank you for your help  it worked ty again