Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

XML data feed to import pricing and stock levels


flourishgate

Recommended Posts

Posted

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.

Posted

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...?

Posted

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.

Posted

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?

Posted

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...?

  • 2 weeks later...
Posted

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 :)

Posted

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...?

  • 3 weeks later...
Posted

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!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...