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:

Example: product-import-inventory-msi_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-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:

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-inventory-msi_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

Inventory Msi Example

Column Name Type Example Description

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

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

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 ( `\|` )

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 ( | )

MSI

Columns

Additional MSI Columns for the product import

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