Import XML Products to Drupal on an ongoing basis

• Project ID:

  785439

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

I got a lead today from a lady who wants a site with an e-commerce system. No big deal, but she threw me a curve ball which I haven't dealt with before. One of her suppliers has an XML data feed of their inventory. They have over 5000 products in their database, and any time one changes stock count, it needs to be reflected on her site, so she doesn't sell something which is out of stock.

I was thinking of a plugin to ubercart which could to this, but my searching (I found this http://www.ubercart.org/forum/ideas_and_suggestions/13200/importing_prod...) didn't return any results.

I will pay for help setting this up so her Drupal installation constantly (a few times a day maybe?) monitors this xml file and makes the needed changes to her product nodes, can anyone help me with this?

I would love a live site as an example of your work. Project will not start for 3 weeks. I will put money in escrow after choosing the winning bidder.

Additional Project Description:

09/05/2010 at 23:58 EDT:
***********PLEASE READ THIS EDIT*****************

It turns out the feed is a CSV feed, not XML, and there are 4 separate files:
Total Product Inventory
Discontinued
Out of stock
In Stock

You must monitor all of these csv files when cron is run, and make any necessary changes to the products on Drupal. I will not hire anyone unless they explain to me how they can accomplish this and that they understand what I need.

If you have screen shots or live links of a similar set up, I'd love to see it, it would help you win the job.


09/06/2010 at 0:38 EDT:
Sorry, one more edit.
The CSV Feed includes an image link, and a image thumbnail link. It would be easy to output this as a thumbnail and using lightbox enlarge the image.

ALSO the price needs to be able to marked up using math. I want the option to mark it up from a multiplier, so for example if the CSV says the price is $10 dollars, I want to be able to multiply that by 3 and display the price at $30

Skills required:

Drupal, eCommerce, MySQL, PHP