Tier prices

Tier price import only

Pacemaker Import Community provides the command import:products:price:tier command for the dedicated tier price import.

The individual parts of the file name must match the pattern as followed:

Example: product-import-tier-price_20190608-114344_01.csv

<IMPORT-DIRECTORY>/<PREFIX>_<FILENAME>_<COUNTER>.<SUFFIX>

<IMPORT-DIRECTORY>:

is by default the loation of your working directory <ROOT-DIRECTORY>/var/pacemaker/import/

The var/pacemaker/import directory is not created after the installation by default
- see described instruction how to create the import directory

PREFIX:

The <PREFIX> of the import filename represents the product-import-tier-price area.

DELIMITER ( _ ):

The mandatory Delimiter ( _ ) for the import filename between <PREFIX> and <FILENAME> is a underscore ( _ ).

FILENAME:

The filename is a autogenerated combination of date and time.

As a result, the filename look like product-import-tier-price_20190608-114344_01.csv.

DELIMITER ( _ ):

The mandatory Delimiter ( _ ) for the structured filename between <FILENAME> and <COUNTER> is underscore ( _ ).

COUNTER:

is a incremental number with two digits starting with 01.

SUFFIX (filename extension):

The Pacemaker Import Community uses the <SUFFIX> .csv as default for the import files.

.OK file:

In addition, the appropriate .ok file is needed (see cli import commands).

Bunch import:

The Bunch import requires the same predefined filename structure as described.

Your CSV file var/pacemaker/import/product-import-tier-price_20190608-114344_01.csv is now ready for import.

Columns

The CSV file with the attributes for Magento 2 CE/EE consists of the following columns

Tier Price Example

Column Name Type Example Description

Column Name	Type	Example	Description
sku	`varchar`	`24-MB01`	Product SKU to import the tier price for the required product
tier_price_website	`varchar`	`All Websites`	website code to import the tier price for `All Websites` as default for all websites or the `<website_code>`
tier_price_customer_group	`varchar`	`ALL GROUPS`	The customer group associated tiered-price or `ALL GROUPS` for all customer groups gets imported
tier_price_qty	`decimal`	`20.0`	The quantity the tier price is valid from
tier_price	`decimal`	`98.0`	The tier price itself
tier_price_value_type	`varchar`	`Fixed`	Choose between the listed value types `Fixed` `Discount`

sku

varchar

24-MB01

Product SKU to import the tier price for the required product

tier_price_website

varchar

All Websites

website code to import the tier price for

All Websites as default for all websites
or the <website_code>

tier_price_customer_group

varchar

ALL GROUPS

The customer group associated tiered-price or ALL GROUPS for all customer groups gets imported

tier_price_qty

decimal

20.0

The quantity the tier price is valid from

tier_price

decimal

98.0

The tier price itself

tier_price_value_type

varchar

Fixed

Choose between the listed value types

Fixed
Discount

Tier prices

Tier price import only

Columns

WIR HÄTTEN IHNEN DIESE MELDUNG AUCH GERNE ERSPART ...