techdivision/import-product

M2IF library providing basic Magento 2 product import functionality

1.0.0-beta41 2017-09-20 16:04 UTC

README

Latest Stable Version Total Downloads License Build Status Scrutinizer Code Quality Code Coverage

Missing Index

As the M2IF functionality differs from the Magento 2 standard, for performance reasons, it is necessary to manually add a missing index.

To do that, open a MySQL command line and enter the following SQL statement

$ ALTER TABLE `eav_attribute_option_value` ADD INDEX `EAV_ATTRIBUTE_OPTION_VALUE_VALUE` (`value` ASC);
$ ALTER TABLE `catalog_product_entity_int` ADD INDEX `CATALOG_PRODUCT_ENTITY_INT_VALUE` (`value` ASC);
$ ALTER TABLE `catalog_product_entity_varchar` ADD INDEX `CATALOG_PRODUCT_ENTITY_VARCHAR_VALUE` (`value` ASC);
$ ALTER TABLE `catalog_product_entity_decimal` ADD INDEX `CATALOG_PRODUCT_ENTITY_DECIMAL_VALUE` (`value` ASC);
$ ALTER TABLE `catalog_product_entity_datetime` ADD INDEX `CATALOG_PRODUCT_ENTITY_DATETIME_VALUE` (`value` ASC);
$ ALTER TABLE `url_rewrite` ADD INDEX `URL_REWRITE_ENTITY_ID` (`entity_id` ASC);
$ ALTER TABLE `url_rewrite` ADD INDEX `URL_REWRIRE_ENTITY_TYPE_ENTITY_ID` (`entity_id` ASC, `entity_type` ASC);

This also improves performance of the Magento 2 standard import functionality, but not at same level as for M2IF.