Tier price importer

From Magmi Wiki
Jump to navigation Jump to 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