Price Comparison Website

Posted by sarath.verve on December 2, 2011 at 4:36am

Hi All,

I am working on a price comparison project and we planned to do this in drupal. But please help me to solve my issues..

I will brief my requirements.

Feed collection and processing:

- receive XML feeds from various product vendors(Amazon, yahooshopping etc) in predefined formats, clean/transform, then load into a catalog DB.

Catalog:
– display listings of the products in various ways: by category, title, price range, most popular, etc.
Price Comparison Table:
–generate a price comparison table of all suppliers of that product.
Tracking:
– tracking #views/#clicks per product, category, and supplier (Need to track users every actions in our site.)
Search:
– simple keyword search resulting in a list of matching products.

My main problem is with the first point. I need feeds from almost 10 product vendors. How can I get all those api? How can I load into my website? Is there any module for this? Or any idea to customize this..

Please help me to solve this issues.. :(

Comments

Vendor catalogs

Posted by bunthorne on December 2, 2011 at 4:59am

I can't help you with the Drupal part, but I can tell you something of the current business practices.

Many vendors already provide catalogs to ERP and Procurement systems for shopping, often using a CSV template with common fields that apply to all products and services, or customized for particular industries or product types. Ariba has done a lot to standardize electronic catalogs, and the use of the UNSPSC category coding scheme has become commonplace enough to be able to expect it of vendors. You might be able to get CSV files from vendors that come pre-coded to a common category scheme.

Ted Spencer
Addison Spencer Consulting LLC

Use the feeds and the

Posted by gordon on December 2, 2011 at 5:09am

Use the feeds and the feeds_xpathparser modules which will allow you to bring in content to allow which will allow you to do the price comparisons.

The feeds module will most likely import everything, except I found that the http fetcher only loads to memory so some of these files you may need to import using a cron job and then get feeds to process it using the file fetcher.

Gordon.

--
Gordon Heydon

Thanks Gordon and

Posted by sarath.verve on December 2, 2011 at 5:22am

Thanks Gordon and Bunthorne,

Is it possible to control vendor's product in our site if we are using feeds module? I want to control (Need to disable some products and need to track all actions) vendor's product in my site. Also I want to create my own products in my site. Is it possible to bring all this together ?

Thanks for all your help...!

Once they are brought in they

Posted by gordon on December 2, 2011 at 5:36am

Once they are brought in they will be standard nodes (if you choose to do that) and then you can edit, or add your own products as needed.

--
Gordon Heydon

item key

Posted by bunthorne on December 2, 2011 at 5:45am

If you need an item key, use the Supplier/Vendor ID, Suppler Part ID, and the Supplier Auxiliary Part ID (if used), and keep track of item updates (versions) with a timestamp.

Ted Spencer
Addison Spencer Consulting LLC

Thanks guys...! I am confused

Posted by sarath.verve on December 2, 2011 at 7:10am

Thanks guys...!

I am confused with feeds and how to bring it to my site :( ... I will try out this and get back to you soon... Thanks for all your help..

How to get Merchant details from the xml?

Posted by sarath.verve on December 3, 2011 at 10:31am

Hi Gordon,

I have created products using the xml. Thanks for your help... Can you please tell me how can I import the merchants details from the feed? I don find any tags related to merchants in my xml. How can I get the merchants details?

This is what I was searching

Posted by thamizhchelvan on December 6, 2011 at 12:25pm

This is what I was searching a very long back, later we built our own modules to do this.