flourishgate Posted September 7, 2010 Posted September 7, 2010 My suppliers provide me with product feeds in XML format. This should allow me to update my websites automatically with their product categories, price, stock level and product description on a daily basis. I am expected to add mark up and shipping rate and this is applied to all the products automatically. I tried unsuccessfully to install XML Feed on my oscommerce. Please can you help.
♥mdtaylorlrim Posted September 7, 2010 Posted September 7, 2010 My suppliers provide me with product feeds in XML format. This should allow me to update my websites automatically with their product categories, price, stock level and product description on a daily basis. I am expected to add mark up and shipping rate and this is applied to all the products automatically. I tried unsuccessfully to install XML Feed on my oscommerce. Please can you help. Which one did you try and install. Keep in mind that all XML feeds are different and customized by the provider. A lot of changes to any script is going to be necessary to get it to work. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...?
flourishgate Posted September 7, 2010 Author Posted September 7, 2010 I tried multivendor Feed manager at the moment it is coming up with this comment: Parse error: syntax error, unexpected T_STRING in /homepages/12/d337254998/htdocs/oscommerce-stable version/catalog/admin/includes/functions/html_output.php on line 363 I have tried xml2.php in the past but did not succeed. Which one did you try and install. Keep in mind that all XML feeds are different and customized by the provider. A lot of changes to any script is going to be necessary to get it to work.
♥mdtaylorlrim Posted September 7, 2010 Posted September 7, 2010 I tried multivendor Feed manager at the moment it is coming up with this comment: I don't know that one. Is there any contact information for the author? Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...?
flourishgate Posted September 7, 2010 Author Posted September 7, 2010 Thanks, which one do you know. It might be better to use the one I can easily get help installing. I don't know that one. Is there any contact information for the author?
♥mdtaylorlrim Posted September 10, 2010 Posted September 10, 2010 I know my own code. It is easy to install but requires an ability to do some critical thinking to analyze the provided feed and make the changes to the code. You could try mine, and if you have problems understanding it I can likely get it to work for you if you provide the top 100 lines of your xml feed file. http://addons.oscommerce.com/info/7286 Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...?
k0ng Posted September 22, 2010 Posted September 22, 2010 I know my own code. It is easy to install but requires an ability to do some critical thinking to analyze the provided feed and make the changes to the code. You could try mine, and if you have problems understanding it I can likely get it to work for you if you provide the top 100 lines of your xml feed file. http://addons.oscommerce.com/info/7286 Hi, I have been looking for exactly this add-on, but i am new to coding. Will this work with multiple feeds? i am going to attempt to install on my test server to be safe :)
♥mdtaylorlrim Posted September 23, 2010 Posted September 23, 2010 Hi, I have been looking for exactly this add-on, but i am new to coding. Will this work with multiple feeds? i am going to attempt to install on my test server to be safe :) No, it will have to be heavily customized, and perhaps make a customized script for each feed. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...?
Terrakota Posted October 11, 2010 Posted October 11, 2010 Hi! I'm trying to install this contribution (thanks!), and I'm new to xml, so I'm trying to understand. Do the names of the common file on xml feed and in my database have to be the same, or can they be different, for example "id_ozon" in the mysql, and "id" on the xml feed. So, is this correct then: /* Set your common field For this to work your data feed must have a unique field (like products_id or products_model) that mataches one for one with a field in your database.in order to work properly. Some shops have installed custom fields. This is where you will define that field. */ define('PRODUCT_ID', 'id_ozon'); // default is 'products_model' Change to whatever your common field is AND // ************************************* This block needs to be edited to match your xml file. ONLY THE NAMES IN CAPS NEED TO BE CHANGED ************* // assign each value to specific variables if ($name == "id") $itemno = trim($value); // this may match your products_id or it may match your products_model or a custome field. if ($name == "price") $cost = trim($value); // if ($name == "QTYOH") $qty = trim($value); // if ($name == "MFGINO") $model = trim($value); // this may or may not be necessary. The others are necessary. Xml feed that I need to parse looks like this: <offer id="2251474" type="book" available="true"> <url>http://www.ozon.ru/context/detail/id/2251474/?from=partner</url> <price>624</price> <currencyId>RUR</currencyId> <categoryId>1090569</categoryId> <categoryId>1097156</categoryId> <year>2004</year> <ISBN>5-17-025119-X</ISBN> </offer> So, there is an "id_ozon" field in my database, that has the same value - 2251474 - as an "id" field in xml feed, and I need the price to be updated. Thanks!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.