Cross/Upsell Importer

From Magmi Wiki
Jump to: navigation, search

What it does

This plugins adds support for importing cross sell and upsell related items

Usage

This plugins handles 2 extra columns :

  • us_skus for upsell skus to link with current item
  • cs_skus for cross sell skus to link with current item

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 associated upsell & cross sell matching skus WILL BE ADDED to current existing upsell & cross sell UNLESS EXPLICIT REMOVAL IS ASKED

to remove exising upsell/cross sell association, just prefix the sku matching (regex or exact) with a -

Samples

Sample 1, add upsell, exact matching

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

Sample 2, add upsell & cross sell , exact matching

....,sku,us_skus,cs_skus,.....
....,"00000","",.....
....,"00001","","00000",.....  < here 00000 will be added as cross sell products with sku 00001
....,"00002","00001,00000","",.....  < here 00000 & 00001 will be added to upsell products of sku 00002

Sample 3, add upsell & cross sell , regexp matching

....,sku,us_skus,cs_skus,.....
....,"00000","",.....
....,"00001","","re::0000.*",.....  < here 00000 will be added as cross sell products with sku 00001 (see limitations, only 00000 exists at the time the sku regexp matching is made)
....,"00002","re::0000.*","",.....  < here 00000 & 00001 will be added to upsell products of sku 00002 (since 00000 & 00001 exist, the sku regexp matching will get those 2)

Sample 4, add upsell & cross sell , exact+regexp matching

....,sku,us_skus,cs_skus,.....
....,"00000","",.....
....,"00001","","re::0000.*",.....  < here 00000 will be added as cross sell products with sku 00001 (see limitations, only 00000 exists at the time the sku regexp matching is made)
....,"00002","re::0000.*","",.....  < here 00000 & 00001 will be added to upsell products of 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) & 00002 (exact match) will be added to upsell products of sku 10002


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,us_skus,cs_skus,.....
....,"00002","-re::0000.*,10001","",.....  < here sku 00002 will be removed all upsell relations with skus beginning with 0000 , and will be associated with sku 10001 
                                            (it exists 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 (upsell)

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

....,sku,us_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 associate all existing skus beginning with 0000 (even those not in the file however)

Back to Product Import Related Plugins