Product relater

From Magmi Wiki
Jump to: navigation, search

What it does

This plugins adds support for importing related products

Usage

This plugins handles 2 extra columns :

  • re_skus for skus to link with current item (directional link from current sku to matching re_skus)
  • xre_skus for cross skus to cross link with current item (bidirectional link from/to current sku to matching re_skus)

For each of these columns, the plugins support multiple values & sku regexp matching.

Import mode influence

Create mode

In create mode, no special thing to say apart plugin limitations , association removal is a no op since no associations exist yet as the product does not exist !!!!

Update mode

In update mode, the related matching skus WILL BE ADDED to current related skus UNLESS EXPLICIT REMOVAL IS ASKED

to remove existing relation, just prefix the sku matching (regex or exact) with a -

Samples

Sample 1, add related, exact matching

....,sku,re_skus,.....
....,"00000","",.....
....,"00001","",.....
....,"00002","00001,00000",..... < here 00000 & 00001 will be added to related products of sku 00002

Sample 2, add cross relate , exact matching

....,sku,xre_skus.....
....,"00000","",.....
....,"00001","",.....  
....,"00002","00001,00000","",.....  < here 00000 & 00001 will be related to 00002  and 00002 will be related to 00001 & 00000

Sample 3, add related & cross relate , regexp matching

....,sku,re_skus,xre_skus,.....
....,"00000","",.....
....,"00001","","re::0000.*",.....  < here 00000 will be related to 00001 & 00001 to 00000 (see limitations, only 00000 exists at the time the sku regexp matching is made)
....,"00002","re::0000.*","",.....  < here 00000 & 00001 will be related to sku 00002 (since 00000 & 00001 exist, the sku regexp matching will get those 2)

Sample 4, add related & cross relate , exact+regexp matching

....,sku,re_skus,xre_skus,.....
....,"00000","",.....
....,"00001","","re::0000.*",.....   < here 00000 will be related to 00001 & 00001 to 00000 (see limitations, only 00000 exists at the time the sku regexp matching is made)
....,"00002","re::0000.*","",.....  < here 00000 & 00001 will be related to sku 00002 (since 00000 & 00001 exist, the sku regexp matching will get those 2)
....,"10000","","",..... 
....,"10001","","",..... 
....,"10002","re::1000.*","00002",.....  < here 10000,10001 (regexp match) will be added to related products of sku 10002 , while 00002 & 10002 will be cross related


Sample 5, add & remove upsell & cross sell , exact+regexp matching , remove old association

given a call in "update" mode , and sample 4 has be ran before .

....,sku,re_skus,xre_skus,.....
....,"00002","re::1000.*","00001",.....  < here sku 00002 will be removed all relations with skus beginning with 1000  (but preceding 1000.* will still have 00002 as related), and will be cross related with sku 00001 
                                            (all existing since we assume sample 4 has be ran before)

Limitations & workarounds

As the above samples let you figure out,You cannot associate an non existing sku to a product.

the better usage of this plugin is to create a profile to use in "update" mode after first product creation. (like Sample 5 being ran after Sample 4)

While exact matching will issue warnings, regexp matching just cannot issue any warning .

Limitation example (relate)

say you have a file with skus 00000,00001,00002 , all non existing in magento db

....,sku,re_skus,....
....,00000,00001,.... < will issue a warning, 00001 does not exist yet
....,00001,00000,.... < this is OK, 00000 has been created by the line before
....,00002,re::0000.*,.... < will be ok too, will relate all existing skus beginning with 0000 with 0002 (even those not in the file however)

Back to Product Import Related Plugins