I have a Joomla website that indicates you the amount of stock of products on the website, I use virtuemart as my E Commerce Component which I invoice through.
The problem that I have is that I don't only sell the products online, I also have a physical shop and I invoice using another system called Legend POS running through Microsoft Access.
What I need is a solution to keep the stock updated between the 2 systems.
I want this done through a automated time clock of 10 minutes intervals.
The stock must be updated according to Stock Codes, the Virtuemart field names is product_sku and product_in_stock and the Microsoft Access fields is product_code and stock_on_hand
If there is another innovative solution please advise.