KornitX Platform Imports & Exports - Pricing Tier Groups | Variants

KornitX Platform Imports & Exports - Pricing Tier Groups | Variants

Introduction

The following article details the pricing tier group import and export which is one of our most advanced imports to date. This specific article details the purpose built variant version which will only list variant pricing lines,The below image shows how the option will appear within the platform. 

This version of the export produces a CSV document of all set pricing for any 'selected' or filtered Products in Product Manager; this allows you to target a specific Category or Fulfiller. 
Please note when running imports for new or existing pricing every field of the CSV must be included, importing just the values you need may lead to inaccurate data.
The same import can be used regardless of the pricing export used, simply save the file as a CSV with UTF-8 and quoting all text cells and import!

What Pricing Types Can Be Set?

There are multiple prices that can be set including Cost (Ex Tax), Trade (Ex Tax), Carriage Cost (Ex Tax), RRP (Inc Tax) and Retail (Inc Tax). Below is a break down of the numerical value associated to each pricing type.
Pricing Type
Numerical Value For Import
Cost Price
0
Trade Price
1
RRP Price
2
Retail Price
3
Shipping Cost Price
4
The only element pricing that can be exported is variants (ID 1).

Additional Entries For Pricing Import

The below lists additional entries that can be set for your pricing import including a breakdown on what each option means. 
  1. Currency (using the currency code - “GBP”, “USD”, etc)
  2. Seller (The seller cost, only works with retail or RRP cost by using company ref ID)
  3. Buyer (The buyer cost which is set on everything but retail or RRP by using company ref ID)
  4. Quantity Break (quantity per price type)
  5. Price (the actual price, unlike legacy import this is unique for every price type 

Data Available With The Variants Pricing Export

The following data will be shown when running the Variants version of this export including the below. 
  1. Product ID
  2. Product Name
  3. Product Supplier SKU
  4. Product Retail SKU
  5. Supplier Company Name And ID
  6. Tier Group Price Type
  7. Tier Group Seller Company Name and ID
  8. Tier Group Buyer Company Name and ID
  9. Currency
  10. Variant SKU
  11. Variant Aspect Option 1 Name
  12. Variant Price Size Description
  13. Variant ID
  14. Quantity
  15. Price
The import can also be used to now delete pricing in mass, this is via the following 2 fields which need a positive “1”value if the idea is to delete and pricing - “tier_group._delete” and “tier_price.delete”