How can I import orders using a CSV file?
If you’re a fan of Printify but currently selling through a sales channel that Printify doesn’t integrate with yet, such as Big Cartel or Ecwid, CSV order import could save you a lot of time. The feature allows you to upload your order information – customer details, product information, and design files – to Printify in bulk.
How to import orders using a CSV file
1. Go to your Orders tab and click CSV Import / Export, then select Import CSV file.
2. Download (as a .csv file) or create a copy of the CSV template form, get familiar with the Print provider and product information that will help you fill in the cells of your CSV file.
3. Fill in the order information in your CSV sheet.
-
Enter the information starting from the second row (first row has to contain column names).
-
If the same order contains multiple products, please assign the same External ID and Label to all products in that order. All line items belonging to the same order should be placed consecutively, next to each other in the sheet.
- External ID*: For your reference only, a unique identifier of the external order.
- Label*: For your reference only, a unique identifier of the order on Printify.
- Shipping*: input 1 for regular shipping, and 2 for priority shipping.
- First name*: Customer’s first name for the shipping address.
- Last name*: Customer’s last name for the shipping address.
- Email*: Customer’s e-mail address. If one isn’t provided, you can use your own.
- Phone*: Customer’s phone number. If one isn’t provided, you can use your own.
- Country*: An Alpha-2 country code for the shipping address (e.g., use “US” instead of “United States”).
- Region*: Region name for the customer’s shipping address. Can be the full name of the state (e.g., “Wyoming”, instead of “WY”).
- Address line 1*: Customer’s shipping address.
- Address line 2: An additional shipping address line (optional).
- City*: The full city name for the customer’s shipping address.
- Zip*: ZIP code for the customer’s shipping address.
- Quantity*: Quantity of the particular line item.
- Print Provider ID*: Please refer to Print Provider and Product Information.
- Blueprint ID*: Please refer to Print Provider and Product Information.
- Variant ID*: Please refer to Print Provider and Product Information.
* Mandatory fields.
Print areas
-
At least one print area is mandatory for each product.
-
Currently, .jpeg, .jpg, and .png formats are supported.
-
You will need a direct image URL to your design. You can use any image hosting website to host your files, such as Imgur, Dropbox, Google Drive, or another.
-
Right-click on the image and select “Copy image address” to get a direct image URL.
-
Paste the direct image URL under your chosen “Print Area” column. It should look similar to this: https://website.com/123/mydesign.jpg.
4. Upload the CSV file that you just created to Printify. Make sure it’s .csv format.
In case the import fails, double-check that the information you’ve entered in the file matches the requirements (as described above) and that all mandatory fields are filled.
5. Once uploaded, check the imported information to make sure everything seems correct. If all looks good, click Submit orders.
Don’t worry – the orders won’t be immediately sent to production.
6. Now you’ll see your imported orders along with the automatically created products for those orders.
Make sure this step is carried out before sending the orders to production!
7. Once the design placement is good to go, you can either wait for the imported orders to be sent to production in accordance with your order approval settings, or speed the process up by clicking Submit order straight away.