Import and Export Pricing Matrix as CSV
Managing your pricing matrix manually can be time-consuming. YoPrint simplifies the process by allowing you to import and export your pricing matrices using CSV files. This article walks you through the steps.
CSV format
It’s easiest to explain the required format using an example. Below is a pricing matrix with quantity breaks and color-based pricing.
Qty Break |
1 Color |
2 Color |
10-24 |
20.00 |
30.00 |
25-50 |
15.00 |
25.00 |
51+ |
10.00 |
10.00 |
To match this in CSV format for YoPrint, structure your file like this:
qty/type |
1 Color |
2 Color |
1 |
1000.00 |
1000.00 |
10 |
20.00 |
30.00 |
25 |
15.00 |
25.00 |
51 |
10.00 |
10.00 |
Minimum order quantity workaround
YoPrint currently requires the first quantity break to begin at 1. If you want to enforce a minimum order quantity, you can use a pricing “deterrent” for lower quantities (e.g., set 1 to 1000.00). This serves as a flag that an order doesn’t meet your minimum.
Native support for minimum order quantities is planned for a future update.
Uploading the CSV
Before uploading, create a placeholder service with a simple pricing matrix.
- Go to YoPrint Service Page
- Click the three dots on your service > View
- In the dialog box, click Upload CSV
- Select your CSV file and confirm upload
- Once complete, you’ll see a confirmation prompt
What if the columns don’t match?
YoPrint will replace the existing pricing matrix entirely with what’s in your CSV, including columns and values.
Exporting the Pricing Matrix
To download your pricing matrix:
- Visit YoPrint Service Page
- Click the three-dot button on your desired service and choose Export as CSV
The file will download automatically.
Pro Tip
- For large-scale changes, we recommend using the CSV export/import method mentioned above for speed and accuracy.
- For quick edits or minor updates, use the UI directly.