KornitX Platform Imports & Exports - Pricing Tier Groups | Variants
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.
Numerical Value For Import
Shipping Cost Price
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.
Currency (using the currency code - “GBP”, “USD”, etc)
Seller (The seller cost, only works with retail or RRP cost by using company ref ID)
Buyer (The buyer cost which is set on everything but retail or RRP by using company ref ID)
Quantity Break (quantity per price type)
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.
- Product ID
- Product Name
- Product Supplier SKU
- Product Retail SKU
- Supplier Company Name And ID
- Tier Group Price Type
- Tier Group Seller Company Name and ID
- Tier Group Buyer Company Name and ID
- Variant SKU
- Variant Aspect Option 1 Name
- Variant Price Size Description
- Variant ID
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”