Compatibility & extensions
The structure for the Product import is almost 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.
-
Magento extends in exceptional cases (complex data), especially for the standard CSV format, the product import, and offers advanced data serialization to enhance the standard CSV format.
-
Magento describes this on a dedicated own website page. In addition to the topics covered by Magento itself, an additional attributes column also uses a refined data format like the extra attributes provided.
-
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.
-
As well as the column with the additional attributes, both columns also contain serialized data.
-
During the product import, Pacemaker Import Community extracts the data from the columns and creates separate CSV files.
-
These CSV files use 1:1 the format also described for MSI and Tier Prices described, and import them to the associated sections.
-
After the product imports are complete, Pacemaker Import Community imports the tier prices and the MSI data.
Attribute Is Online
In Magento 2, the is_online value for products and categories is used to determine whether a product or category is active and visible on the frontend of the store.
Product is_online
For products, the is_online value typically refers to whether the product is enabled and in stock, making it available for purchase on the website. This is influenced by several factors:
-
Status: The product must be enabled (status should be set to "Enabled").
-
Stock Availability: The product must be in stock or have a quantity greater than zero, depending on the inventory settings.
-
Visibility: The product must be set to be visible on the store (visibility should be set to values like "Catalog", "Search", or "Catalog, Search"). To check if a product is online, Magento combines these factors to determine its visibility on the frontend.
The product status values are saved in the catalog_product_entity_int table and relate to the status attribute. Here are the values:
-
Enabled: 1
-
Disabled: 2