techdivision/import-category

Pacemaker library providing basic Magento 2 category import functionality

21.0.3 2023-10-11 15:56 UTC

Requires

• php: >=7.3.0
• techdivision/import: ^17.0.0

Requires (Dev)

• consolidation/robo: ~1.0
• doctrine/dbal: 2.5.*
• mikey179/vfsstream: ~1.0
• pdepend/pdepend: 2.5.2
• phpmd/phpmd: @stable
• phpunit/phpunit: ^6.5.0|^8.0.0|~9.5.0
• sebastian/phpcpd: ~3.0|~4.0|~5.0|~6.0
• squizlabs/php_codesniffer: ~3.4.0|~3.6.0
• symfony/http-kernel: ~2.0|~3.0|~4.0

MIT

• Tim Wagner

README

Please visit the Pacemaker website or our documentation for additional information

Multistore URL Rewrite Import

• Importer supports multistore url_key, just note that if the file contains only default store row for a new category, only one entry for defualt store is stored in the catalog_product_entity_varchar table and a key is stored in the url_rewrite table for all stores.
• When updating this category with a new key for this category, it will be changed for all stores.
• To avoid this problem, the default line can be omitted and only the specific store imported.

Special case

In some cases the default row must be included in the product file, in which case, if there are no entries in the varchar for the stores already, the url_rewrite for all stores is updated based on what is in the default column.

Possible solution

• To solve the problem only the default store and the specific store should be imported and so the category will only be imported for the store and the specific store.
• import should always include all stores in a new category, so each store has an entry in the catalog_product_entity_varchar table for the url_key attribute.
• If the category is only to be updated in a store, the default row must be supplied with the specific store, then the url_rewrtie and url_key are updated in the Varchar table.