A newer version of this documentation is available: View the Latest Version

Product FPT

Pacemaker Import Pro provides the command import:products:fpt command for the Fixed product tax import.

The individual parts of the file name must match the pattern as followed:
<IMPORT-DIRECTORY>/<PREFIX>_<FILENAME>_<COUNTER>.<SUFFIX>
<IMPORT-DIRECTORY>:

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

PREFIX:

The <PREFIX> of the import filename represents the fixed-product-tax-import 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 fixed-product-tax-import_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 Pro uses the <SUFFIX> .csv as default for the import files.

.OK file:
Bunch import:
  • The Bunch import requires the same predefined filename structure as described.

Your CSV file var/pacemaker/import/fixed-product-tax-import_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
Column Name Type Example Description

sku

varchar

24-MB01

Product SKU to import the fixed tax

website_code

varchar

admin

Website code from product

attribute_code

varchar

fpt

FixedProductTax attribute code

country_code

varchar

AT

ISO2 country code

region_code

varchar

TI

Region code of the respective country or empty

value

double

20.00

the new tax value

  • Product Tax fixed rewrites get imported with the entire product import as default.

  • The Product must exist in the case

website_code,sku,attribute_code,country_code,region_code,value
admin,24-WB01,fpt_tax,AT,TI,20.00
admin,24-WB01,fpt_tax,DE,,19.99