IngGross_de

ITIB Mass Import Product Relations, Upsell and Cross-Sell

  • Popularity Score 2143 Popularity Score

    Popularity ScoreReferrals to Site/Downloads

    0 0 1+ 1+ 250+ 250+ 1000+ 1000+ 10000+ 10000+

This module can be used to mass import product relations (also upsell and cross-sell) from a csv file.

In Oct 2011 I dropped the further developement, as I found an open source tool, which is much better than my attempt. So I suggest, that you also switch to the best Mass Importer I can recommend:

MAGMI - on https://sourceforge.net/projects/magmi/ - with wiki, forum and free downloads.
Compatible with:
This extension is currently unavailable on Magento Connect. Please contact the developer.

You will be re-directed to the developer's website to complete your purchase.

You must be registered and logged in to get extension key.
In order to get this extension, you must be logged in to the Magento Community. Click here to login or register.
In order to get this extension, you must have active Magento Go Store. Click here to create Go store.
You must choose from Magento Connect Version 1.5.1.0 or 2.0.
Learn more

Magento Connect 1.0 change

FREE
Previous Next
Overview

ITIB Mass Import Product Relations, Upsell and Cross-Sell

This Extension makes use of product link API's to assign/update/remove and list product relation/links.

Product relation importer reads the data from properly formatted CSV to create, update or remove links or relations between products. This ITIB_MassImportProductRelations module can be used to perform following operations by reading data from a CSV file.

Valid Operations :

  1. assign is used to create a new relation between 2 products
  2. remove can be used to remove an existing relation between 2 products
  3. update can be used to update relation/link attributes between 2 products
  4. list is used to show products that are related to a particular product.

Relations: Following are the three valid relation types:

  1. related
  2. up_sell
  3. cross_sell

In order to run this properly, the CSV file should contain 4 columns and first row must be header row. Syntax for First row of CSV:

link function, sku 1, sku 2, link type, [attribute1], [attribute2]

where [attribute1] and [attribute2] are link attributes like “position” which can be used to manage the position of product in the related products listing. Example:

link function, sku 1, sku 2, link type, position

the above column names should remain same, however the sequence of columns may change. Other rows should have the following syntax:

assign,sku1,sku2,up_sell,[position_val]

where

  • assign is a operation that needs to be performed
  • sku1 is sku of first product
  • sku2 is sku of second product
  • up_sell is the relation between 2 products
  • [position_val] is a number, giving the position of product (sku2) in related product listing box of sku1

you can also use product ids instead of sku's in such a case, the header row should have the following syntax:

link function,product id 1,product id 2,link type

If you use product ids in case other rows should have the following syntax: i.e.

assign,521,633,up_sell

where

  • assign is a operation that needs to be performed
  • productid1 is id of first product
  • productid2 is id of second product
  • up_sell is the relation between 2 products

Following are the syntax for different functions:

  • assign,sku1,sku2,up_sell
  • update,sku1,sku2,related
  • remove,sku1,sku2,related
  • list,sku1,,related

Note:

Please note in the above examples, in case of list function we need to pass empty value in sku2, because list function does not require sku2.

Steps to import data:

  1. login to magento admin panel
  2. Upload your csv file with the data about relations with FTP to /public_html/var/import/product_relations.csv (or other means).
  3. select System-Import/Export-Advanced Profiles menu item
  4. Create once a new advanced profile by entering following information in various fields:
  • A) Profile Name: ITIB ProductRelationsImport (for example)
  • B) Actions XML: Copy and paste the xml contents which you can find here under the register "Documentation".
  • C) Save this entry and start profile

5. This will upload your csv and execute all the rows of csv, if it is properly formatted as described above.

6. After execution, it will display a summary on the rows that are executed successfully and also the rows that are skipped along with the reason why they are skipped. For more details, you can use the sample csv-file, which you also can find under the register "Documentation".

In Oct 2011 I dropped the further developement, as I found an open source tool, which is much better than my attempt. So I suggest, that you also switch to the best Mass Importer I can recommend:

MAGMI - on https://sourceforge.net/projects/magmi/ - with wiki, forum and free downloads.
Release Notes

This module can be used to assign/update/remove product links by reading data from csv file.

2012-02-05 17:05:35
  • Version number: 1.0
  • Stability: Stable
  • Compatibility: 1.3, 1.4, 1.4.1.1, 1.4.2, 1.5
You must be registered and logged in to get extension key.
You must choose from Magento Connect Version 1.5.1.0 or 2.0.
Learn more

Magento Connect 1.0 change

This module makes use of product link API's to assign/update/remove product links by reading data from csv file.
Reviews

About the Developer

This extension was developed by and is supported by IngGross_de

ITIB Mass Import Product Relations, Upsell and Cross-Sell 4 5 6 6
Working on Magento Enterprise ver. 1.12.0.2 It took me time to build the correct csv but after creating it, It worked like charm... June 19, 2013
nice nice module.. code to put in backend... <action type="dataflow/convert_adapter_io" method="load"> <var name="type">file</var> <var name="path">var/import</var> <var name="filename"><![CDATA[product_relations.csv]]></var> <var name="format"><![CDATA[csv]]></var> </action> <action type="dataflow/convert_parser_csv" method="parse"> <var name="delimiter"><![CDATA[,]]></var> <var name="enclose"><![CDATA["]]></var> <var name="fieldnames">true</var> <var name="store"><![CDATA[0]]></var> <var name="number_of_records">1</var> <var name="decimal_separator"><![CDATA[.]]></var> <var name="adapter">Itib_MassImportProductRelations/Convert_Adapter_Productimport</var> <var name="method">parse</var> </action> Hope anyone need this... :) April 10, 2013
Great Module! Works under 1.7.0.2 Thanks. January 6, 2013
Thank you for be so gracious enough to share the Magmi link here! It is wonderful!!!! I've tried everything from Store Manager For Magento (which crashes on Windows 7 and corrupts the magento database) to Capacity WebSolutions ImportProduct (which has some serious limitations). Magmi is by far the most superior solution -- and its FREE!!!! Thank You! Thank You! Thank You! MAGMI - on https://sourceforge.net/projects/magmi/ - with wiki, forum and free downloads. April 16, 2012
Great Module! Installed on 1.5.0.1 and it works like a charm! Defiantly going to save me at least a couple days in productivity by using this! Thanks so much and keep up the great work! July 28, 2011
works great - thanks April 30, 2011
1-6 of 6
Q&A
(1 Question : 0 Answers)

Product Q&A

Ask your questions. Share your answers.

 
 
« Back
 
 
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_27109096
Customer avatar
thanks!
by
dannyalfonzo
-
6 months ago
0points
0out of 0found this question helpful.
Was this helpful?Yes0No0
1 of 1
1 of 1
Get Help

Support for This Extension

The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.

Magento Platform Support

If you need support for a Magento platform, there are different options for support depending on which Magento platform you are using. Below are links for specific platforms.

In order to upload extension, you must be logged in to the Magento Community. Click here to login or register.

Close

Register

* Required Fields

Close window

Forgot Your Password?

Please enter your email below and we'll send you a new password.

* Required Fields

Close window

Login

To upload extension you must be logged in.

* Required Fields

Close window

You are using an outdated browser

We built Magento Connect using the latest techniques and technologies.
This makes Magento Connect faster and easier to use.
Unfortunately, your browser doesn't support those technologies.
Use the links below to download a new browser or upgrade your existing browser.