CSV Import and Export
CSV Import/Export is installed per pricing product. It adds Magento Import/Export entities and matching command-line tools for bulk maintenance.
This add-on is different from the customer-facing CSV links on My Prices. Those links are part of the base pricing products.
Packages and entities
| Pricing product | Package | Magento import entity |
|---|---|---|
| Customer Price | mageb2b/pricesystem-customerprice-importexport |
pricesystem_customerprice |
| Price Lists | mageb2b/pricesystem-pricelist-importexport |
pricesystem_pricelist |
| Category Price | mageb2b/pricesystem-categoryprice-importexport |
pricesystem_categoryprice and pricesystem_categoryprice_customergroup |
| Product-Customer Matrix | mageb2b/pricesystem-productcustomermatrix-importexport |
pricesystem_product_customer_matrix |
Use System > Data Transfer > Export first and use that file as the template for import. This is safer than composing column names from memory and preserves the identifiers expected by the installed packages.
Command-line tools
php bin/magento pricesystem:export-customerprice
php bin/magento pricesystem:import-customerprice path/to/file.csv
php bin/magento pricesystem:export-pricelist
php bin/magento pricesystem:import-pricelist path/to/file.csv
php bin/magento pricesystem:export-categoryprice
php bin/magento pricesystem:import-categoryprice path/to/file.csv
php bin/magento pricesystem:export-categoryprice-customergroup
php bin/magento pricesystem:import-categoryprice-customergroup path/to/file.csv
php bin/magento pricesystem:export-productcustomermatrix
php bin/magento pricesystem:import-productcustomermatrix path/to/file.csv
Run php bin/magento help COMMAND for the options supported by a particular importer or exporter.
Safe import routine
- Export the current records.
- Keep a recoverable backup outside Magento's import directory.
- Test the modified file in a staging environment.
- Use Magento's validation step before import.
- Import a small batch and verify calculated storefront prices.
- Clean the Price System cache after the final batch.
The dedicated product guides explain their customer, SKU and other aliases.