Hi, I have a list of my products in an excel file together with it's price, quantity, description etc. I want all that data to be imported in my joomla site. Can this be possible? I want my data to be updated once my excel files update/save. example: Product 1 --- $20.00 --- 5 pcs --- description of product 1 here Product 2 --- $40.00 --- 2 pcs --- description of product 2 here Once I change my product 1 price it also updates my joomla database. can this be possible with some extension? I need some guides what to do. Thanks!
You using a shopping cart application? Virtuemart for Joomla has a csv import if im not mistaken.. Maybe start here - http://extensions.joomla.org/extensions/extension-specific/virtuemart-extensions/4973/details ?
Alternately you could use some db to html software. I like db to html express but I forget the website. You simply export csv data into tables via a simple template. You can then copy and past this into Joomla as a table I guess.
no I'm not using virtuemart. I want my excel file to be connected in my joomla database so whenever a new item or value was entered in my excel file it will also update my joomla database. I don't know if its possible. Thanks for all of your reply!
I don think is possible to connect an excel file to a database updating the db automatically, could be dangerous. Maybe there is some way to do it using the API for google spreadsheets: http://code.google.com/apis/spreadsheets/overview.html