The CSV Order Import Tool is a feature that lets you upload a spreadsheet to submit multiple orders to Printful at once. It’s especially useful if you're processing a high volume of orders manually or importing them from another platform. The guide below explains how to format your data file so the tool can read and process your orders correctly.
There are two ways to import bulk orders using a spreadsheet:
- Use Printful’s template – You’ll find it from your Printful Dashboard → Orders → Import orders.
- Use your own file – Make sure it includes the necessary order and product information.
File format and structure
- Accepted file types: CSV or XLS.
- Each row should represent a separate product variant.
- You can include up to 10,000 rows.
- Only synced products can be included in your file.
Required columns
To make sure your orders import correctly, your spreadsheet should include these columns:
- Order ID: A unique ID you choose (letters, numbers, or both). Use the same ID for multiple rows to group items into one order.
- Product ID: Found under the product name in the Stores section of your Dashboard or My products → Published.
- Variant ID: Found when you click on the product—all variants are listed there.
- Quantity: Number of units ordered for that variant.
- Full name: First and last name of the recipient.
- Company (optional).
- Address line 1: Street name and number.
- Address line 2 (optional): Apartment, suite, or other info.
- State/Province/Prefecture: Required for orders going to the USA, Canada, or Japan.
- City.
- Country: Two-letter country code (e.g., “US”).
- Postal/ZIP code.
- Phone number (optional): Helps with delivery updates.
Matching your column names
You can name your spreadsheet columns however you like. In Step 2 of the order import tool, you’ll match your column names with the corresponding fields in our system.
For example: If your column is named “Name”, you can select that it represents the Full name field during the import setup.
This helps the tool recognize your data correctly and map everything to the right order fields.
Still need help? Our Support Team is here for you—reach out anytime through our contact form or start a chat with us.