CSV Import/Export Add-On

Bulk import and export category prices via CSV (customer-based and group-based category prices).

Package

• Composer package: mageb2b/pricesystem-categoryprice-importexport
• Magento module: MageB2B_PricesystemCategorypriceImportExport

Installation

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

Admin Import/Export (Magento ImportExport)

Use Magento's importer:

1. Go to System >Data Transfer > Import
2. Entity type:
   • Pricesystem Categoryprice (customer-specific category prices)
   • Pricesystem Categoryprice Customergroup (group category prices)

Tip: Export first and use the exported CSV as your template.

CSV Columns (High Level)

Customer category prices typically include:

• customer_id (required): customer ID (in some setups also customer email)
• category_id (required)
• price (required)
• qty, from_date, to_date, website_id (optional)
• price_application_type (optional): fixed, surcharge_nominal, surcharge_percent, discount_nominal, discount_percent
• price_attribute_id (optional)

Group category prices typically include:

• group_id (required)
• category_id (required)
• price (required)
• qty, from_date, to_date, website_id (optional)

CLI Commands

php bin/magento pricesystem:import-categoryprice /path/to/categoryprice.csv php bin/magento pricesystem:export-categoryprice php bin/magento pricesystem:import-categoryprice-customergroup /path/to/categoryprice_customergroup.csv php bin/magento pricesystem:export-categoryprice-customergroup

Related

• Price Selection
• Pricesystem CSV Import/Export