Tier price importer

From Magmi Wiki
Jump to: navigation, search

What it does

This plugin is able to associate tier prices to products and customer groups. price importer plugin supports the following features:

  • price per customer group
  • price per quantity
  • relative price assignment from base price

Syntax for price per customer group

Just declare a column per customer group with name “tier_price:name of customer group if you have say group1 & group2 as customer groups & want to set group1 price to 10 & group2 price to 12

 "sku","tier_price:group1","tier_price:group2"
 "SKU001","10.00","12.00"

Syntax for price per quantity (can be assigned to each customer group or to all)

Declare a column per customer group as above or declare just one column for all like this : "tier_price:_all_". The syntax for quantities is : "qty_threshold1:price1;qty_threshold2:price2;qty_threshold3:price3"


For example:

 "sku","tier_price:group1","tier_price:group2"
 "SKU001","25:10.00;50:9.00;100:8.00","25:11.00;50:10.00;100:9.00"

or

 "sku","tier_price:_all_"
 "SKU001","25:10.00;50:9.00;100:8.00"

To clear a tier price, just put a blank information in the column for the corresponding tier price.

Syntax for relative price assignment

Tier price importer supports relative price assignment, using negative % value or positive % value instead of fixed tier price.

IMPORTANT:to use relative price assignment,price column MUST be present in input data.

negative % relative price example

 "sku","price","tier_price:group1","tier_price:group2"
 "SKU001","50","25:-15%;50:-25%;100:-40%","25:-10%;50:-22.5%;100:-37.5%"

positive % relative price example

 "sku","price","tier_price:group1","tier_price:group2"
 "SKU001","50","25:85%;50:75%;100:60%","25:90%;50:77.5%;100:63.5%"

Multiple websites

From version 0.0.7 of the plugin,different tier prices can be assigned to different websites

  • Just fill the websites column with the website(s) code(s) (comma separated if several) to set the websites for which the tier prices have to be set
  • All syntaxes above supported (relative price,multiple customer groups)

In the samples below, say we have 2 websites with respective codes ws1 & ws2

multiple websites, all customer groups tier price example

 "websites","sku","tier_price:_all_"
 "ws1,ws2","SKU001","25:10.00;50:9.00;100:8.00"

multiple websites, multiple customer groups tier price example with % discount

 "websites","sku","price","tier_price:group1","tier_price:group2"
 "ws1,ws2","SKU001","50","25:-15%;50:-25%;100:-40%","25:-10%;50:-22.5%;100:-37.5%"



Back to Product Import Related Plugins