Product Media
Pacemaker Import Pro provides the command import:products:media command for the product Media import.
- The individual parts of the file name must match the pattern as followed:
product-media-import_20190608-114344_01.csv<IMPORT-DIRECTORY>/<PREFIX>_<FILENAME>_<COUNTER>.<SUFFIX>- <IMPORT-DIRECTORY>:
-
is by default the location of your working directory
<ROOT-DIRECTORY>/var/pacemaker/import/-
The
var/pacemaker/importdirectory is not created after the installation by default
-
- PREFIX:
-
The
<PREFIX>of the import filename represents theproduct-media-importarea. - 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-media-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>.csvas default for the import files.
|
.OK file:
Bunch import:
|
Your CSV file var/pacemaker/import/product-media-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 |
|---|---|---|---|
|
|
Product SKU to import the tier price |
|
|
|
Store(s) view-specific attribute translations
|
|
|
|
Comma ( |
|
|
|
Product Type |
|
|
|
Base Image path |
|
|
|
Base image label |
|
|
|
Base image position see the WARNINGS below |
|
|
|
Small image label |
|
|
|
Small image position |
|
|
|
thumbnail image path |
|
|
|
Thumbnail image label |
|
|
|
Thumbnail image position |
|
|
`` |
swatch image path |
|
|
`` |
swatch image position |
|
|
|
Comma ( |
|
|
|
additional image labels |
|
|
|
Comma ( |
|
Product Media support more data see file below |
|
Product Media images have a position to define the order of the images. Please note that if you want to have the images in a specific order, you must add the position for all stores, as the default value does not exist at the store level. The position must also always be defined for all store for the additional images. As otherwise the images will be displayed incorrectly in the frontend. |
|
The column for the positioning of the main image(base_image) should be better filled with its own position column. If no entry is defined and no data is available in the database for image_positions, these will be populated with the value 0. However, if an entry already exists in the database but is not defined in the CSV, no changes will be made and the existing values will remain unchanged. |
sku,store_view_code,attribute_set_code,product_type,base_image,base_image_label,base_image_position,small_image,small_image_label,small_image_position,thumbnail_image,thumbnail_image_label,thumbnail_image_position,swatch_image,swatch_image_label,swatch_image_position,additional_images,additional_image_labels,additional_image_positions,hide_from_product_page,disabled_images,base_video,base_video_title,base_video_description,base_video_provider,base_video_metadata,small_video,small_video_title,small_video_description,small_video_provider,small_video_metadata,swatch_video,swatch_video_title,swatch_video_description,swatch_video_provider,swatch_video_metadata,thumbnail_video,thumbnail_video_title,thumbnail_video_description,thumbnail_video_provider,thumbnail_video_metadata,additional_videos,additional_video_titles,additional_video_descriptions,additional_video_providers,additional_video_metadata
24-MB01,,Default,simple,/m/b/mb01-blue-0.jpg,,3,/m/b/mb01-blue-0.jpg,,3,/m/b/mb01-blue-0.jpg,,3,,,,"/a/z/AzXrs1c92RY.jpg,/m/b/mb03-black-0_alt1.jpg","My Video,24MB-03 Alt","1,2",,,,,,,,,,,,,,,,,,,,,,,https://youtu.be/AzXrs1c92RY,M2IF Product Import,This video shows a simple M2IF product import in a Magento 2 shop instance.,YouTube,M2IF