I need a modification done to Virtuemart done where each product we have sold has its own unique number assigned to it. For example, order numbers are assigned for each order automatically, but I need a product number, which I can have start from a certain number, and then increase incrementally with each product sold.
So if one customer purchase say Product A B & C, the order information would show:
Product A #0000001
Product B #0000002
Product C #0000003
The numbers would appear automatically in the order and in the order history.
If a search is done for a particular product number from the admin area, then we should be able to find the associated customer who purchased it.
In virtuemart forums someone made this comment that might help get this done:
You can use order_item_id in #__vm_order_item table. It is automatically incremented for every item sold. If you don't like the simple number, you can elaborate in some way, filling with zeroes and so on.
This needs to be completed within the next 3-4 days.
I will also need details on where the modifications were made so that when future upgrades of vituemart come out I can easily retain the modification.