Products
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>
isproduct-import
, the<FILENAME>
is a combination of date and time like20190608-114344
, and the<COUNTER>
is a incremental number with two digits starting with01
. -
The results in a filename like
product-import_20190608-114344_01.csv
. -
Additionally, the appropriate
.ok
file is needed.
|
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.