MSI

Pacemaker Import Community provides the command import:products:inventory:msi command for the dedicated MSI 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 loation of your working directory <ROOT-DIRECTORY>/var/pacemaker/import/

PREFIX:

The <PREFIX> of the import filename represents the product-import-inventory-msi 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-inventory-msi_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:
Bunch import:
  • The Bunch import requires the same predefined filename structure as described.

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 inventory source item

source_code

varchar

default

Code for the source of the products

status

integer

1

Stock product status for this source

quantity

decimal

98.0

Product amount for this source

Additional MSI Columns for the product import

To add the full MSI inventory data to the product import, the additional field inventory_source_items must get specified in the following described format

Column Name Type Example Description

inventory_source_items

varchar

source_code=default,quantity=10.0,status=1|
source_code=inventory-01,quantity=5.0,status=1

Required column to be able to import also MSI inventory data with the product import

  • Every line is seperated by a pipe ( | )