What this is
The bulk pricing import and export feature lets you work with pricing data in CSV or Excel format instead of entering prices one by one in the UI. Export your current pricing to modify it offline, then re-import the changes. For products with hundreds or thousands of price points — like menu boards with multiple formats, colours, and coatings — this is the only practical way to configure pricing at scale.
Who this is for
Partner Management team members setting up or updating pricing for customers with complex product assortments
Anyone managing pricing for products where manual entry would be prohibitively time-consuming (high-variant product lines)
Before you start
You need permission to edit pricing for the customer
For import: a CSV or Excel file with pricing data, typically an export from a previous configuration or a customer-provided pricing sheet
For export: navigate to the customer's pricing configuration page
How to export pricing
Navigate to the customer's pricing configuration page
Click Export CSV
The system generates a file in CSV format that includes all current prices and attribute mappings
Save the file to your computer
Use the exported file as a starting point for bulk updates: open it in Excel, modify the prices, and re-import.
How to import pricing
Navigate to the customer's pricing configuration page
Click Import CSV
Select your file — it will be validated for format and encoding
Review the import preview in the UI — the system shows which prices will be added or updated
Confirm the import — prices are applied immediately to the configuration
After import, review the updated prices in the editing page to confirm they match your expectations
File format
The import and export both use the same CSV format — column names, order, and structure are identical. This means:
You can export pricing, edit it in Excel, and re-import it directly
UTF-8 character encoding (not ISO-8859-1 or Windows-1252)
Standard CSV syntax compatible with Excel and Google Sheets
Tip. If you have pricing configured already and want to make a bulk update, export the existing pricing first, modify it in Excel, and re-import. This is faster and safer than manual editing for large configurations.
Performance and limits
Exports complete instantly, regardless of size
Imports of 1,000+ rows complete in less than 10 seconds
UTF-8 encoding is required — if your file uses a different encoding, convert it first
Error handling
If the import encounters invalid data or format issues, the system will report which rows failed and why. No prices are applied until all rows validate successfully.
Common questions
Can I export just some of my products, or is it all-or-nothing?
Export covers all pricing in the current configuration. To work with a subset, you can manually delete rows from the exported file before re-importing.
Does my exported file include tiered pricing?
Yes — tiered quantity breaks and their corresponding prices are included in the export.
What if my file uses a different encoding?
The import requires UTF-8. If your file uses a different encoding (ISO-8859-1, Windows-1252, etc.), open it in Excel or a text editor, save it as UTF-8, and try again. This is the most common cause of import failures.