If you’re a fan of Printify but currently selling through a sales channel that Printify doesn't integrate with yet - such as Squarespace, 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. CSV order import can also be of use if you are creating custom designs for each order.
Please note: All-over printed (AOP) clothing is not currently supported by the CSV Order Import feature.
How to import orders using CSV
1. Go to your "Orders" tab and click CSV order import.
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 items of the order.
* 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 express 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.
At least one print area is mandatory for each product. Under your chosen "Print Area" column, you should enter a direct image URL to your design, for example, https://mydesignfiles.com/123/mydesign.jpg;
Currently, .jpeg, .jpg, and .png formats are supported.
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 should have some imported orders as well as automatically created products that are associated with those orders.
Since it is not possible to ensure a precise design placement using the CSV order import, go to your "My Store" section, click on the brush icon, and adjust the designs as needed (if the same product has been ordered in multiple orders, you will need to adjust it for each order).
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!