IMPORTANT NOTES:
- You can use this tool to add data to existing customers or if you are mapping a new database of customers to Blastramp.
- It is recommended to test with one or two customers first before making any large-scale edits.
- Be sure to export your customer data to Excel and keep a backup copy.
- If you're trying to update data in the "Bill To" column and it is currently toggled, ensure you update all the fields in that column.
- Refer to the provided Excel screenshot for an example.
-
Important: You must have "Ship To Name," "Ship To Address," and "Ship To Postal/Zip Code" in the fields as a minimum, even if you are not changing them, so the tool can identify the account you are updating.
-
If you are unsure of what you are changing, please contact help@blastramp.com and include the Excel document of the customers you are updating with the data position fields filled out (see Step 8).
1. Click on Utilities
2. Click on Upload Customers via Copy and Paste from Excel
3. Paste selected text into text area - DO NOT INCLUDE HEADERS ONLY THE DATA THAT YOU ARE CHANGING
4. Click on DATA POSITIONING FIELD
6. Type "1" This position will be your first column from Excel (e.g. Ship To Name).