I'm wondering if anyone has managed to set up a shopping cart in Drupal that utilizes an external product database. I'm trying to set up an online cart that sells products from a vendor that uses XML based Web Services to feed data to our site.
By this, I mean that I can take user input and look up a product in an external database (via an HTTP request) and receive a response from our vendor via XML. I would like to feed that XML response to our shopping cart. I don't want to set up a copy of all that product data in MySQL.
I can handle the programming involved in parsing the XML from our vendor. I just can't find a shopping cart that will take product info from anything but a local database.
I've been looking through Drupal's forums and search results, as well as Google's and I've come up empty. I hope it's because my search terms are off. Surely somebody, somewhere has had to set up a store where they use a vendor's data for their shopping cart.
I'd be happy to use any of the popular carts for this purpose, but all my searching tells me that I need to cram the data into a locally hosted database. That doesn't make any sense, since the vendor is willing to provide that data (3million products or so...) without my having to copy it locally.
I don't want to just import the Vendor's data into a database. They have a gazillion items and updates occur daily. I want to make 'realtime' requests against THEIR data -- which they allow via http/SOAP requests.
Aren't there any carts out there that will allow for the data to be fed from an outside source? Help!
Thanks.
-dave.
Comments
=-=
This may be a question for the ecomerce development forums or the ubercart community. I don't know how often either get to the drupal.org forums.
Wow. That's a quick
Wow. That's a quick response. Thanks, VM.
I'm working on posting this same question to the UberCart site (trying to make sure I'm not cross-posting).
I'll also look at the ecommerce forum here within drupal.
That said, if anyone has some further advice please pass it along.
-dave.
You might also check with
You might also check with the folks in the e-commerce group at http://groups.drupal.org/ecommerce
The login there is separate to the one here (or was when I signed up a while back).
Wondering if you've found a
Wondering if you've found a solution. I have a similar issue, we're using Drupal to manage all of our news, articles, and other info, our ecommerce site is on a different server with a different database, I'd like to query the product database on the Drupal site using the Drupal search keywords and display them along side the Drupal search results. From that point if a user clicks on a product, they will be brought to the ecommerce site.
Thanks.
John
The parameters have shifted
John - The parameters have changed slightly... I have access to a flat file of all the distibutor's products, and I have built a database with that. My initial problem was that I didn't have access to all the data at once, only on a query-at-a-time basis.
I'm now struggling to learn the basics of the Drupal API in order to take that data and push it into the tables used by Drupal's Ubercart modules. If I can actually build the Product tables using that external data and the API, we can use Ubercart.
I found 2 helpful sites on the web with info on how to use the API:
www.stonemind.net
and there are 2 at this site (Unibia.com):
This one is 'How to Create Drupal Nodes with a Script'
This one is 'How to import products into Drupal Ubercart with a Script'
That 2nd one is a bit too specific for my needs but is a good example of getting in under the hood.
-dave.
Looking to do something similar
I would like to use various (about half a dozen stores) XML product feeds to monitor prices daily and provide a price comparison feature
What would be really cool is if I could use this incoming data to help maintain a product DB that could be referenced for various other nodes
e.g. Reviews
So...yeah...subscribing in case you guys find something of interest
Currently looking at starting a module from something like:
http://datafeedstudio.com OR http://code.google.com/p/saleinform/
Thanks
Current (Main) Project: http://www.takraw-association.org.uk
_
I would think this could be accomplished with the http://drupal.org/project/feedapi module.
_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.
A great starting point
Sure but it would be a Price Comparison module that depended on FeedAPI
Sadly I'm not sure my dev skills are up to it
Current (Main) Project: http://www.takraw-association.org.uk
hi were you able to find a
hi were you able to find a solution?