KornitX Platform Imports & Exports - Pricing Tier Groups | All Current Pricing

KornitX Platform Imports & Exports - Pricing Tier Groups | All Current Pricing

Introduction

The following article details the pricing tier group import and export which is one of our most advanced imports to date. This import allows users to set multiple different pricing and element types which allows for comprehensive pricing detail to be set against your products. 

This version of the article is based on the "All Current Pricing" version which will use the below image 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

What Element Pricing Can I Set?

On top of these options we can also set pricing for “Elements” within a product to ensure we can import to enable additional pricing for the following options.  
  1. “Base” - base cost of the entire product. 
  2. "Variant" - variant pricing specific to a chosen variant.
  3. "Attribute" - attribute Pricing, specific to a chosen attribute.
  4. "Attribute Value Quantity" - quantity of an attribute value working with Production>Inventory to manage stock. 
  5. “Text Area” - text Area pricing, to add a charge if a text area selected.
  6. “Image Area” - image Area pricing, to add a charge if a image area selected.
  7. “Print Area” - print Area pricing, to add a charge if a print area is used. 
  8. “Stitch Count (1000s)” - stitch count, in relation to embroidery products. 
  9. "Setup" - setup cost in relation to embroidery products.
  10. “Colour Count”  - colour count, in relation to embroidery products.
Below are the numerical values you must use to associate with these elements. 
Element Type
Numerical Value
Base
0
Variant
1
Attribute
2
Text Area
3
Image Area
4
Print Area`
5
Stitch Count (1000s)
6
Setup
7
Colour Count
8
Attribute Value Quantity
9

The import can use the either the name or ID of the elements to set such as the variants, this makes the information easier to collate

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 All Current Pricing Export

The following data will be shown when running the All Current Pricing version of this export including the below. 
  1. Product ID
  2. Product Name
  3. Product Supplier SKU
  4. Product Retail SKU
  5. Supplier Company ID & Name
  6. Tier Group Price Type
  7. Tier Price Element Type
  8. Tier Group Seller Company Name and ID
  9. Tier Group Buyer Company Name and ID 
  10. Currency
  11. Attribute ID and Name
  12. Text Area ID and Name
  13. Image Area ID and Name
  14. Variant ID and Name
  15. Quantity
  16. 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”.

    • Related Articles

    • KornitX Platform Imports & Exports - Pricing Tier Groups

      Introduction The following article details the pricing tier group import and export which is one of our most advanced imports to date. This import allows users to set multiple different pricing and element types which allows for comprehensive pricing ...

    • KornitX Platform Imports & Exports - How To Set Shopify Pricing Beta

      This article will be cover the options available to add pricing information to products so that they work within the Shopify app. Pricing can be set manually or via a dedicated CSV data Import. Everyone who wishes to load their products within ...

    • KornitX Platform Imports & Exports - ECommerce Data

      What Is eCommerce Data? Within the Kornit X Platform, your products can be set up with eCommerce data which can be downloaded within an export, updated with our import and generated in a feed to get products added to retailer sites and for many of ...

    • 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 ...

    • KornitX Platform Imports & Exports - Pricing Tier Groups | Print Areas

      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 Print Areas version which will only list Print Area pricing ...