wsandwith Posted April 9, 2010 Share Posted April 9, 2010 I need some help to get XML data from my supplier posted into my website automatically. This is what is posted on their site: We have the following Web Services currently available for : Version 3.0 (XML and SOAP) * Price and Availability (PNA) * Create Order * Order History Inquiry * Order Details for a customer’s order * Product Specifications * Tracking Number for a customer’s order It allows me to send the orders directly to the supplier and have them drop ship. I also need to be able to include my markup before placing on my retail site. Does an add on exist that does this already or do I need to have this custom made? Any useful input will be greatly appreciated. Cheers! Wendell Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 9, 2010 Share Posted April 9, 2010 I get an xml file from one of my suppliers as well. I only use it to update price and quantities on hand. Not adding products (working on that one but running into walls...) It will have to be custom designed for you, but you are welcome to my file as a base for building one of your own. It uses SimpleXML so it will not do large feeds. (That is the wall I am up against with full product feeds. The file is 50+mb) PM me if you are interested. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
MrPhil Posted April 9, 2010 Share Posted April 9, 2010 It might be easiest to take the XML file and (with a custom-written processor) change it into a CSV file that something like EasyPopulate could use to update osC. It depends on what kind of data is in the file and what EP needs. Are you looking to replace all your product data with each update, or only change things that have changed? In the latter case, you'd have to compare the current and previous XML data and remove (ignore) unchanged items. Maybe the custom processor could read in both XML files, while preparing the CSV file, and ignore entries that haven't changed since last time. This could cut down the amount of data being sent to EP (and might tear down Mark's "wall", too). Just some random thoughts. When you say "Version 3.0" you're not talking about osC 3.0, are you? If so, you're in the wrong board. Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 9, 2010 Share Posted April 9, 2010 This could cut down the amount of data being sent to EP (and might tear down Mark's "wall", too). Just some random thoughts. I actually slew my dragon this morning with the assistance of the internet and Google... now proceeding to build the contribution... (which has no part of EP with it.) Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted April 9, 2010 Share Posted April 9, 2010 Price and availability XML is now available. See my profile for contributions. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...? Link to comment Share on other sites More sharing options...
wsandwith Posted April 9, 2010 Author Share Posted April 9, 2010 Price and availability XML is now available. See my profile for contributions. Wow! you work fast! :thumbsup: Thank you for your insite and knowledge you are providing so generously! I will take a look at this contribution, I am also trying to learn a bit about using xml so I can understand the way it works and how to call it from a webpage. Cheers! Wendell Link to comment Share on other sites More sharing options...
wsandwith Posted April 9, 2010 Author Share Posted April 9, 2010 It might be easiest to take the XML file and (with a custom-written processor) change it into a CSV file that something like EasyPopulate could use to update osC. It depends on what kind of data is in the file and what EP needs. Are you looking to replace all your product data with each update, or only change things that have changed? In the latter case, you'd have to compare the current and previous XML data and remove (ignore) unchanged items. Maybe the custom processor could read in both XML files, while preparing the CSV file, and ignore entries that haven't changed since last time. This could cut down the amount of data being sent to EP (and might tear down Mark's "wall", too). Just some random thoughts. When you say "Version 3.0" you're not talking about osC 3.0, are you? If so, you're in the wrong board. Thank you for your reply MrPhil, I am cureently experimenting with EP and was looking to change fields that have been changed. The supplier has many other intgration options available that would be really cool to figure out, such as the ability to have the customers order go directly to the supplier and then dropped shipped not to mention I could make an XML call to have the shipping tracking number displayed for the customer. The version3 reference is to the XML development version used by the supplier. Cheers! Wendell Link to comment Share on other sites More sharing options...
sonictrip.net Posted September 24, 2010 Share Posted September 24, 2010 Thank you for your reply MrPhil, I am cureently experimenting with EP and was looking to change fields that have been changed. The supplier has many other intgration options available that would be really cool to figure out, such as the ability to have the customers order go directly to the supplier and then dropped shipped not to mention I could make an XML call to have the shipping tracking number displayed for the customer. The version3 reference is to the XML development version used by the supplier. Cheers! Wendell This sounds like the mod ive been waiting for the last few months! :) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.