CSV import and export

The Import/Export package adds separate Magento data transfer entities for customer category prices and customer-group category prices.

composer require mageb2b/pricesystem-categoryprice-importexport:*
php bin/magento setup:upgrade
php bin/magento cache:flush

Export each entity from System > Data Transfer > Export and use the resulting file as its template. Customer rows identify a customer; group rows identify a customer group. Both include the category, quantity, value, application type, optional base price, website and dates.

The customer entity uses the columns customer_id, category_id, qty, price, price_application_type, price_attribute_id, website_id, from_date and to_date. The group entity uses group_id instead of customer_id with the same remaining columns.

Product and customer aliases can use human-readable identifiers such as SKU and email where the package configuration offers them.

Command line import and export

The package also registers console commands for automated transfers:

php bin/magento pricesystem:import-categoryprice <import_path>
php bin/magento pricesystem:export-categoryprice
php bin/magento pricesystem:import-categoryprice-customergroup <import_path>
php bin/magento pricesystem:export-categoryprice-customergroup

Imports accept a required file path plus --behavior, --field_separator, --field_multiple_value_separator, --fields_enclosure and --delete_file_after_import. Exports write to var/export/ by default and accept --export_path, --field_separator and --fields_enclosure.

Both admin grids additionally offer an Export mass action for selected rows.

Test one customer record and one group record before importing a full file. After import, verify a product in the selected category, the exact quantity threshold and a customer for whom both record types match.