CSV Information and Troubleshooting

Downloading the CSV Template

If you are having trouble downloading the CSV Template, here are a few steps to try:

• Clear your browser’s cache and cookies 
• Try using a different browser, Google Chrome is the preferred option 
• Log in using incognito mode to avoid conflicts with browser extensions 
• Ensure that pop-up blockers are not activated, as they can interfere with the downloading process 

See attached PDF at the bottom of this article for help with any of the previously mentioned steps

If you are still unable to download the CSV template, reach out to partnersupport@ouraring.com.

How to use the CSV Template

1. Add all required items to your cart
2. Toggle to the multiple address tab
3. Select upload addresses via CSV and download the template
   1. the template is generated with selected items in your cart. If new items are added, you must download a newly populated CSV template

Order Numbers need to match exactly from the CSV template to Order Hub's order summary display. 

4. Enter each recipient's shipping information on the line correlating to their order. Ex: TEMP1224_09 in Order Hub must match that exact line on the CSV

5. Once all information has been entered, export the file as a CSV file, not an Excel file (.xlsx or .xls),  and then drag and drop or select file to be uploaded into Order Hub

6. Addresses will be populated into your order summary where you can edit, if necessary, using the pencil icon. You must select shipping speed for each item in your order. For items shipping together, Order Hub will default the shipping speed you’ve selected for the address

Troubleshooting CSV Upload Errors

Incorrect Addresses or Errors

• Carefully review all address data in your CSV file. Check for any spelling errors and make sure each zip code has five digits
• Each cell has a 40 character limit. Abbreviate titles or names, when applicable 
• Enter apartment or suite information in the Address 2 field
• Use country code “US” for United States 

Zip Codes Starting with Zero 

• If a zip code begins with a zero, add an apostrophe before the zero (‘0)  for it to be properly displayed. For example, ‘01234
• When entered correctly, the cell in the CSV file will display a green triangle in the top-left corner 

Missing Mandatory Fields: 

• Carefully scan your CSV file for any rows that are missing information within the mandatory fields. Input the missing information in the appropriate cells. Accuracy is crucial for processing orders correctly