Order ID

[jimpett81]

Hi All,

I would like to set a specific start point for the order number in virtuemart. The problem is that I have some old orders with old order id's, when I pull in new orders some match the old ones and my database can't import them as they are duplicates. So what I need is a way to set a start point of the order numbers so that it is a high number and won't match any old ones. How can this be done? I was pointed to this file - administrator/components/com_virtuemart/helpers/config.php but could not find the variables mentioned within it?

Thanks,

James

[AH]

Version of Vm would help.

Are you talking about the order_number or order_id

order_number is not the primary key for the orders file and is not used for "matching"

To adjust the order_id to a start at a higher number change the database table #_virtuemart_orders

Set the "Auto increment:"  to a value required

[jimpett81]

Sorry VirtueMart 3.0.10

Are you refering to a table in the database? Can you elaborate?

[AH]

Change the database table #_virtuemart_orders

Yes it is the table above.

If you do not know how to set the  "Auto increment:"  to a value required - then I cannot be of any more help as it would not be wise for me to "guide" you through the process.

[jimpett81]

Thanks for that, I managed to make the changes and all is well.

Regards,

James

[AH]

Great - thanks for the update