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
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
Sorry VirtueMart 3.0.10
Are you refering to a table in the database? Can you elaborate?
QuoteChange 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.
Thanks for that, I managed to make the changes and all is well.
Regards,
James
Great - thanks for the update