I need a feature developed for our Virtuemart site that enables us to run a process which imports from a CSV file into the sales order module in Virtuemart.
It can see if a sales order numbger match exists and if so update the order status in Virtuemart. If the order does not exist in Virtuemart it will need to create the order. This module does not need to email the order or accept any funds. These order will already have been paid for and created from the management system side. We want them visable to the customer so they can see all their orders and what is outstanding vs. supplied.
The csv file will contain the following columns;
- Customer Username
- Status (A for Outstanding, Z for Supplied)
- Product Code (SKU)
- Ordered Quantity
- Unit Price
- Total Ex Tax
- Total Tax
- Total Inc Tax
Look forward to your quote and questions if you have any.