How can I import orders using a CSV file?
If you’re currently selling through a sales channel that Printify doesn’t integrate with yet, such as Big Cartel or Ecwid, you can use the CSV Order Import feature to fulfill your orders with Printify. This feature allows you to upload your order information, including customer details, product information, and design files, to Printify in bulk.
Step 1: Download or create a copy of the CSV template form
Go to your Orders tab and click CSV Import / Export, then select Import CSV file. Next, download (as a .csv file) or make a copy of the CSV template form. Familiarize yourself with the Print provider and product information that will guide you in filling out the cells of your CSV file.
Step 2: Enter the order details into your CSV form
Start entering the information from the second row, as the first row must contain the 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 Standard Shipping, 2 for Priority Shipping, 3 for Express Delivery, or 4 for Economy Shipping. Visit this article to learn more about 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.
Step 3: Add an image URL to at least one print area for each product
In the same CSV form, you must include at least one image URL for each product.
- You’ll need a direct image URL to your design. You can use any image hosting website to store your files, such as Imgur, Dropbox, Google Drive, or another.
- To obtain a direct image URL, right-click on the image and select “Copy image address”. Paste this URL into the appropriate “Print Area” column. It should look similar to this: https://website.com/123/mydesign.jpg.
- Currently, .jpeg, .jpg, and .png formats are supported.
Step 4: Upload the file in .csv format
Next, export the file you just created in .csv format and upload it to Printify. If the import fails, double-check that the information in the file matches the requirements described above and that all mandatory fields are filled.
Step 5: Double-check the imported order information
If the import was successful, review the imported information to ensure everything is correct. If everything looks good, click Submit orders. Don’t worry – the orders won’t be immediately sent to production.
Step 6: Adjust the design placement on each product
Once your imported orders and automatically created products appear, you can adjust the design placement. Navigate to your My products section, click on the paintbrush icon, and adjust the designs as necessary. If the same product has been ordered multiple times, you will need to adjust it for each order.
Step 7: Submit your orders for production
After ensuring the design placement is correct, you can either wait for the imported orders to proceed to production based on your order approval settings, or expedite the process by clicking Submit order immediately.