Homepage → Bulk Orders → Creating a CSV File with Multiple Orders

Creating a CSV File with Multiple Orders

Collect order information for multiple recipients. Import these orders all at once.
PY
Written by Print Your Cause
Updated 4 weeks ago

First, you will need to create a spreadsheet with the following headers:

    • CustomOrderId
    • CustomShipmentId
    • CampaignProductId
    • ProductColor
    • ProductSize
    • Quantity
    • ShippingAddress_Name
    • ShippingAddress_AddressLine1
    • ShippingAddress_City
    • ShippingAddress_State
    • ShippingAddress_PostalCode
    • ShippingAddress_Country
    • CustomerEmailAddress
    • OrderConfirmationEmailAddress
    • ShipmentConfirmationEmailAddress
    • Priority
    • Quality

Or copy and past the following into your spreadsheet:

CustomOrderId CustomShipmentId CampaignProductId ProductColor ProductSize Quantity ShippingAddress_Name ShippingAddress_AddressLine1 ShippingAddress_City ShippingAddress_State ShippingAddress_PostalCode ShippingAddress_Country CustomerEmailAddress OrderConfirmationEmailAddress ShipmentConfirmationEmailAddress Priority Quality

Then, you will need to complete the spreadsheet. 

The first column, CustomOrderId, is required. Each order in the CSV must have a unique identifier, but can be anything you like.

Orders that will have more than 1 item will need to have the same CustomOrderId to be shipped together.

The second column, CustomShipmentId, is optional. This field can be filled in with a unique identifier. The system may generate these fields if left blank.

To find the CampaignProductId, go to the Products section of the management portal. 

Click the product name link that you want to add to your spreadsheet.

On the product page, click on the URL. Highlight the last section of the URL and copy and paste it into your spreadsheet.

The last section of the URL will appear after the word products and a forward slash: /products/. The CampaignProductId will contain a combination of letters and numbers. 

The ProductColor can be found on the product page on the right side of the page. Add your desired color name to the spreadsheet.

The ProductSize options can be found in our catalog. To find the desired product in the catalog, select the catalog product link located beneath the product name near the top of the page. This will bring you to the catalog listing and will show the available sizes for that product. Add your ProductSize to the spreadsheet.

Add your desired Quantity to the spreadsheet.

The next few columns will be for the address you want your order to be delivered to. You will add the shipping details as follows: ShippingAddress_Name, ShippingAddress_AddressLine1, ShippingAddress_City, ShippingAddress_State, ShippingAddress_PostalCode, ShippingAddress_Country. 

Next, add your email address to the CustomerEmailAddress field. The customer email address will only be used to contact the order recipient if there is an issue with the order (ie. incorrect shipping address or item out of stock).

Then add an email address to the OrderConfirmationEmailAddress and ShipmentConfirmationEmailAddress fields. These email addresses will receive automated notications regarding the order's progress in production. 

The email addresses don't have to match. If you're creating an order for someone else, you can add their email address as the Customer Email Address. 

To complete the spreadsheet, add your Priority and Quality. Priority will be 10 and Quality will be Superior. 

The last step is to export your file as a CSV or Comma Separated Values file. You can do this in most spreadsheet apps by going to File and selecting Export or Download. Select CSV as the file type and save the file.

Congratulations! Your CSV file is complete. For step by step directions on uploading your CSV file to your account, check out this article! 

Please note, products CANNOT be customized when imported through this process.
Did this answer your question?
close-image
full-image