CSV import and export
The Import/Export package adds two entities to Magento's data transfer tools:
| Entity | Format |
|---|---|
pricesystem_pricelist (Pricesystem Pricelist) |
Normalized — one row per customer assignment, customer-group assignment or product row. The identifier columns for products, customers and groups are configurable. |
pricesystem_pricelist_legacy (Pricesystem Pricelist (Legacy)) |
The previous packed format: customer and group assignments travel in packed user_ids and group_ids columns on the list header row. |
Prefer the normalized entity for new integrations and keep the legacy entity for files produced by older package versions. Either export can contain list headers, product rows, customer assignments and customer-group assignments.
composer require mageb2b/pricesystem-pricelist-importexport:*
php bin/magento setup:upgrade
php bin/magento cache:flush
Export a small list from System > Data Transfer > Export and use it as the template. The default aliases make products readable as SKUs and customers readable as email addresses. The Export mass action on the price-list grid produces the same normalized format, so a grid export also works as an import template.
When importing:
- Keep each list's identifying fields consistent across its rows.
- Confirm product SKUs, customer emails and group IDs in the target store.
- Test a small file with one product and assignment.
- Review validation errors before importing the full set.
- Check the list in the Admin and storefront after import.
The package also provides CLI import and export commands:
php bin/magento pricesystem:import-pricelist /path/to/pricelist.csv
php bin/magento pricesystem:export-pricelist
Run --help on either command for the arguments supported by the installed package.