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.

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

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:

Issue	Solution
print_ready_file image address is not public	Ensure your image address is full and public. The URL should end with the file type (i.e .jpg, .png etc)
shipping_country is not set to the country code (i.e “United Kingdom”)	The shipping_country field should be the 2 digital country ICO code (i.e “GB”)
Missing print_ready_file image – Warning	You can upload your CSV with image URLs missing – you will need to add the images from your Artwork Library but Viewing the order and assigning artwork to each item
Incorrect print area name. You must match the print_area_name to the name on Papello for your item. For example a greetings card may have 2 print area names “Front/Back” and “Inside” – If the name doesn’t match it will show an error.	Use the “”Auto Correct names” button to correctly update the print_area_names to the SKU. Alternately, update your CSV with the correct name and re-upload

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.