Virtuemart and automatic import of a file in my database

Question

I would like to convert a text file to excel and then modify certain data inside the excel file and then import this new excel file to a database using PHP.

The contents of the excel file, for example, will be products and their prices and the modification will be on the prices. So the update of the products in the database and on the website will be automatic. I am planning to use Joomla with Virtuemart.

My question is this: will Virtuemart allow me to do this?

Answer 1

Natively, VM does not support excel importing, though there may be tools available at the JED. I've done a lot of it using phpExcel which gives me the flexibility to consider the format of the spreadsheet, as well as however I may happen to be using the VM products and custom fields.

I just found this link on the VM Forums that might help. It's for earlier version of VM, I think, but it might provide a foundation to get started with.