Welcome!

[brad_langdon]

I have a client who wants an ecommerce site. No problem there, there are many free or cheap cart applications that are easy to customise.

Is it possible though to upload a file each month to update the prices of existing items or add new products rather than entering them one by one? He will have quite a large database of products so doing it one by one would be a nightmare.

Can anyone recommend the best software to use to allow him to update his products in this way?

[divisionbyzero]

Of course it depends on the e-commerce package you use, and what format the data is available in.

Magento supports a rather nice way of importing products, but you have to enter them in the correct format, and they still have to be manually entered into a spreadsheet.

If the format of your client's product DB export is tricky or you don't want to do anything manually I'd recommend uploading a CSV file and having a PHP script on a CRON job process it. I did something similar where a script runs every hour and updates the DB based on a supplier XML feed.

Hope that helps.