CSV Import/Export Add-On

Bulk import and export customer prices via CSV.

Package

Composer package: mageb2b/pricesystem-customerprice-importexport
Magento module: MageB2B_PricesystemCustomerpriceImportExport

Installation

composer config bearer.repo.softwaresilo.io composer config repositories.softwaresilo composer https://repo.softwaresilo.io/ composer require mageb2b/pricesystem-customerprice-importexport:* php bin/magento setup:upgrade php bin/magento cache:flush

Admin Import/Export (Magento ImportExport)

Use Magento's importer:

Go to System >Data Transfer > Import
Entity type: Pricesystem Customerprice

Tip: Export first and use the exported CSV as your template (column names vary by version/config).

CSV Columns (Customerprice)

Common columns:

customer_id (required): customer ID or customer email
product_id (required): product ID or SKU (depends on config pricesystem/customerprice_import/product_id_alias)
price (required): numeric value
qty (optional): quantity tier
website_id (optional): website scope
from_date, to_date (optional): date range
price_application_type (optional): fixed, surcharge_nominal, surcharge_percent, discount_nominal, discount_percent
price_attribute_id (optional): custom price attribute mapping (if used in your setup)

CLI Commands

php bin/magento pricesystem:import-customerprice /path/to/customerprice.csv php bin/magento pricesystem:export-customerprice

Useful flags (example):

php bin/magento pricesystem:import-customerprice /path/to/customerprice.csv --behavior=add_update php bin/magento pricesystem:export-customerprice --export_path=var/export/customerprice.csv