Synch stock levels with Virtuemart

[YZF]

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.

[GJC Web Design]

at the very least if you wanted some help surely you should mention your -> product/accounting software ?

[Matt_Ginn]

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.

[YZF]

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.

[GJC Web Design]

If the data is exportable as a csv then csvi is a simple way to import the data
http://www.csvimproved.com/en/

[YZF]

Thanks GJC. I think that is the solution we're looking for.