Pacemaker Community Edition (CE) provides a product import and the appropriate command import:products therefore.

You can find more information about how to invoke the command in the usage section.

  • The filename for the dedicated MSI import must match the pattern <PREFIX>_<FILENAME>_<COUNTER>.csv.

  • The default <PREFIX> is product-import, the <FILENAME> is a combination of date and time like 20190608-114344, and the <COUNTER> is a incremental number with two digits starting with 01.

  • The results in a filename like product-import_20190608-114344_01.csv.

  • Additionally, the appropriate .ok file is needed.

  • There is a fixed structure for the bunch import, which must be followed.

  • The three parts to be specified are each separated by an underscore ( _ ) and result in a filename like <PREFIX>_<FILENAME>_<COUNTER>.csv.

  • The name structure follows a predefined filename structure that is mandatory for the Bunch import.

Unique identifier

  • The unique identifier for the product import is the SKU.

  • The SKU is a mandatory field that has to be available in the column sku on every row of the CSV file.

Compatibility & extensions

The structure for the Product import is nearly 100 % compatible with the Magento 2 CSV structure.

Please check out the Magento 2 documentation for a more detailed description of the CSV file structure.

Especially for the product import, Magento extends the default CSV format for some individual cases called complex data, which provides some data serialization to extend the default CSV format.

Magento describes this on a dedicated page on their website. Besides the topics related to that page by Magento itself, there is a column with additional attributes that also uses a sophisticated data format like provided additional attributes.

In addition to the Magento 2 CSV structure, it is possible to add additional columns to allow tier prices and MSI stock data to be part of the product import.

Both columns contain serialized data like the provided additional attributes column does.

During the product import, Pacemaker Community Edition (CE) extracts the data from the columns and creates separate CSV files.

These CSV files are 1:1 the format described for MSI and Tier Prices import in the corresponding sections.

After the products are imported, Pacemaker Community Edition (CE) imports the tier prices as well as the MSI data.