How to import CSV imports for fulfilment

You can import orders from a CSV file directly into the Papello Dashboard.

Your CSV must match the template to ensure order details are correctly mapped to Papello’s order submission.

Download CSV Template here

CSV Format Requirements

• File must be in CSV format with comma-separated values

• First row must contain the exact column headers shown in the template

• All required fields must be provided for each order

• The print file must be public, not requiring any authorisation.

• File size limit: 10MB

• For multi-print area products, use print_area_1, print_area_2, etc. columns

• To include inserts, set up API Orders Inserts in Brand settings

1. Click on “Import Orders” from the dashboard sidebar

2. Click “+ Import Orders”

3. Drag and drop or Select the CSV file from your computer

Any errors in your CSV will be highlighted before you can import the order, you will need to make changes and fix your CSV to match the template.

Warning such as “Missing Artwork” will be displayed if not present in the CSV. You can continue to import these orders, however you will need to add the artwork from your artwork library for each one missing.

4. Click – “Upload and Import” to import orders into the Papello Dashboard

Once imported you can fetch Quotes for each order – this is the total cost of the order that will be charged to your saved payment method.

Once you’re ready, click “Submit” and your order will be submitted for fulfilment!

You will see the status of the order change from “Pending” to “Submitted” if the order was submitted successfully.

Common Errors

Common when importing orders from a CSV include:

Once submitted – you can see your orders progression from the Orders page.

Required CSV Columns

Order Information

• merchant_reference – Your internal order reference (required)

• amount_paid – Total order value for customs (optional)

• currency – Currency code, defaults to GBP (optional)

Currency defaults to GBP if amount_paid is provided but currency is not specified.

Shipping Information

• shipping_first_name – First name

• shipping_last_name – Last name

• shipping_address1 – Address line 1

• shipping_address2 – Address line 2 (optional)

• shipping_city – City

• shipping_state – State/Province/Region

• shipping_postcode – Postal code/Zip code

• shipping_country – Country code (e.g., GB, US)

• shipping_method – Standard/Express/Budget

Item Information

• item_sku – Papello product SKU

• item_quantity – Quantity to order

Product names and prices are fetched from SKU when quotes are generated.

Artwork Files

• print_ready_file – Single print area file URL (required for single print area products)

• print_area_1 – First print area URL (required for multi-print area products)

• print_area_1_name – First print area name (required when using print_area_1)

• print_area_2 – Second print area URL (optional)

• print_area_2_name – Second print area name (required when using print_area_2)

• print_area_3 – Third print area URL (optional)

• print_area_3_name – Third print area name (required when using print_area_3)

Important: Print area names are required for order submission. Use either print_ready_file OR print_area_1+ columns, not both.