How do I send in bulk via CSV upload?

Here's a guide on how to send via CSV through Sendoso. Attached at the bottom of this article are CSV templates with the preferred formatting. Using these templates may help to avoid any errors you may encounter.

Uploading a CSV for a Bulk Send

Overview: Whether you're sending a physical gift or an eGift, you can use the CSV upload function to send multiple sends at once. Here's an overview of the process, with the details below:

1. Select your Send on the Send page
2. Select Multiple Emails (eGifts) or To a Group of People (inventory or direct gift)
3. Fill out Address Confirmation settings (inventory or direct gifts)
4. Either upload your CSV or use the template provided
5. Map the relevant fields
6. Check for and address errors
7. Build a message
8. Preview Send
9. Send!

Process Details

1. Find the send on the Send page

2. Click on the "To a Group of People” option when asked how you’d like to send your gift.

3. For physical sends, select whether or not you’d like to have your recipient confirm their address or provide their address, as well as how long to wait for their response and what to do in the event that a recipient does not respond. Read more about Address Confirmation here. 

For physical sends, please keep the following in mind:

• If Address Confirmation is enabled, the email address field cannot be blank
• If you're sending to an international address, the phone number field cannot be blank.

For eGift sends, move to the next step.

4. Optional: Download the CSV template to see the preferred formatting. The templates are also attached to this article.

5. Double check the field mapping. Our system will do its best to map your fields, but you have the opportunity to make adjustments before the file is uploaded. You can map the relevant fields using the drop-down menu that appears after uploading the CSV that contains your recipients’ information. 

Important note for syncing to Salesforce: You will either need to map the recipient's Email Address or Salesforce Contact/Lead ID in order for Sendoso to push the activity over to the correct records in Salesforce.

Note: Large files may experience longer loading times. However, you'll have the option to be notified via email once the file is processed.

6. Once the file is processed, you'll see if any of the fields in your file have caused an error. You can address the error by editing the field directly on this page by clicking "View Details" at the bottom.

7. On the Details page, you'll be able to see which field(s) is/are causing the error (in red.) You can also filter the view to any row with an error if you have multiple in a large file. Click edit to fix the issues.

8. Next, you'll build your message using the available dynamic fields that were included in your CSV upload.

8. Lastly, you'll need to click “Preview Message” on the upper right-hand corner of the message text box to review the messages you plan to include before we execute your send.

Once you click Send, you’ll receive a summary of your successful sends in Sendoso and via email. If there were any invalid recipients, the list will be attached to the email notification so you can update the CSV and re-upload the file.

Troubleshooting

1. Special Characters within the CSV file name

This will cause the CSV not to upload successfully. Please rename the file not to include any special characters (%, &, $, commas, etc.)

2. Missing the leading 0 in your zipcodes

You may have some addresses with a zip code that starts with a 0, due to the nature of excel and csvs, the 0 could be lost when uploading the file. Here are some common ways to check and correct your file.

Example of how it is usually input and how to correct it:

You can always view the length of zip code with "=LEN("

3. Missing Headers or Columns must contain a name

You may run into an error where the CSV list is missing a header name, in this case, you need to check for any columns that may be missing a header name or delete any excess columns that don't have relevant information.

 4. "Your CSV Headers Are Not Supported" OR “Your CSV File Format Is Not Supported”

This error will pop up if you have not saved the file in the correct format or if special characters are not allowed in the file. You may run into other formatting issues but to see the exact error you can visit csvlint.io to troubleshoot.

 Tip: If you copy the data from your Excel file and re-upload it onto Google Sheets, then download the CSV, this will solve 90% of all issues, UTF-8 issues. You can visit sheet.new to easily open up a new google sheet.

Additional Resources

Want more training on CSV uploads? Check out these Sendoso University courses:

Create Personalized Sends in Bulk

CSV Bulk Uploads: Get to Know

• UpdatedCSVTemplateForAcDisabled.csv816 Bytes
• UpdatedCSVTemplateForAcEnabled.csv720 Bytes