Import & Export Pricing Matrix as CSV

In this article

• CSV Format
• Uploading the CSV
• Exporting the Pricing Matrix

We know how tedious it can be to individually key in your pricing matrix. YoPrint makes it easy to create and manage your pricing matrices. In this article, we will cover how to import and export pricing matrix as CSV.

CSV Format

It's easier to explain the CSV format by using an actual example. Let's take the following table as an example.

Qty Break	1 Color	2 Color
10-24	20.00	30.00
25-50	15.00	25.00
51+	10.00	10.00

Here is the corresponding CSV file that YoPrint will accept

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 does not currently support minimum order quantity directly. All quantity breaks must start at 1, or the system will not function properly.

As a workaround, we recommend setting a high starting quantity, in this case, $1000 which clearly does not make sense. It will serve as a clear alert if an order does not meet your intended minimum quantity requirement.

Minimum order quantity support will be added in the future, eliminating the need for this workaround.

Uploading the CSV

For this to work, you must have an existing service set up. Simply create a one-column matrix as a placeholder—then use the CSV upload feature to override it.

1. Navigate to https://app.yoprint.com/product-service/service 

2. Click the three dots for the desired service, and click on View

3. A dialog box will appear, and you will see the Upload CSV button

   

4. Select the CSV file from your computer to upload

5. You will see this prompt once the upload is complete

   

What Happens if the Columns in YoPrint Don't Match Your CSV?

When you upload a CSV file, YoPrint will rebuild the pricing matrix based on the data in the file. This means that all previous values will be completely replaced with the new ones.

Short answer: The columns will be updated to match the CSV file.

Exporting the Pricing Matrix

You can also export your pricing matrix as CSV. This is useful if you prefer using spreadsheet software to update the pricing.

1. Navigate https://app.yoprint.com/product-service/service 

2. Click the action button on the desired row and click Export as CSV

   

3. Your CSV file will be automatically downloaded to your computer.

PRO TIP 

For significant updates to your pricing matrix, we recommend using CSV upload for efficiency. For minor or spot changes, the UI is the best option for quick adjustments.