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 5 days 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 and second columns - CustomOrderId and CustomShipmentId - are optional. These fields can be filled in with anything you'd like. 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. Then add an email address to the OrderConfirmationEmailAddress and ShipmentConfirmationEmailAddress fields. 

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 Order Confirmation and Shipment Confirmation email addresses.


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?