Hello,
We are looking for a simple way to synch our stock levels between our product/accounting software and our Joomla/Virtuemart website. Can anyone tell us what is the best way to accomplish this?
Joomla - 3.3.6. Virtuemart - 3.02
Thank you for any assistance with this question.
at the very least if you wanted some help surely you should mention your -> product/accounting software ?
If your product/accounting software can output a .csv file containing the product SKU and the stock level, it's a fairly easy job to write a .php file that loops through it and writes to your VM database. You can then schedule it to run overnight (if that's what you want) with a shell script. I do something very similar where I automatically download a CSV from our product manufacturer at 1am every morning and update all the stock on our site:
http://www.mardens-trading.co.uk/portwest/
Although we are still using Joomla 2.5.28 and VM 2.6.16, I doubt it will be very different for your versions.
Quote from: GJC Web Design on April 08, 2015, 11:46:00 AM
at the very least if you wanted some help surely you should mention your -> product/accounting software ?
I didn't think that was necessary since we export the data fields we need and save it as a text file. However, we are using AccountEdge.
Thanks for your input Matt_Ginn. We will look into that.
If the data is exportable as a csv then csvi is a simple way to import the data
http://www.csvimproved.com/en/
Thanks GJC. I think that is the solution we're looking for.