Upload Newsletter Subscribers to Shipping Easy

Create CSV import files of customers from OpenCart who are active, subscribed to the newsletter, and do not have an order marked Shipped within the last 120 days. Long-term subscribers with older shipped orders (after June 2016) but no recent activity are included. Each store cohort receives a dated tag filename for upload to Shipping Easy Marketing Contacts.

After generating the files, upload the CSV from your computer to Shipping Easy:

1. Login to Shipping Easy.
2. Near the bottom of the left menu — click on Marketing, then click on Contacts.
3. Near the top of the main window click on the button "+ Add Contacts", then click on "Upload Contacts (.csv)" in the pop-open menu.
4. Click on the gray "Browse" button in the Upload Contacts box to find the generated CSV on your computer.
5. Click on the file name to select it.
6. Click the "Open" button to add it to the Shipping Easy upload window.
7. In the Shipping Easy "Upload Contacts" window click on the "Upload" button to send the file from your computer to Shipping Easy.
8. In the table below the "Upload Contacts" window, you will see the file you just uploaded — click the "MAP FIELDS" button next to it.
9. There are 4 fields in the drop-down boxes on the left under "CSV Column" that need to be mapped to fields on the right under "Contact column".
10. Skip the first drop-down menu and click the second drop-down menu, then click on "Firstname".
11. Click on the third drop-down menu and click on "LastName".
12. Click on the fourth drop-down menu and click on "Email".
13. Click on the last drop-down menu and click on "Tags".
14. Skip all other drop-down menus.
15. Click on the button "Continue". Wait for the Status to change from "PROCESSING" to "READY".
16. Click on the button "READY". The list will be displayed.
17. Click on the button "Complete Upload".
18. Near the top left of the main window, click on the link "Lists".
19. Click on the button "Create New List".
20. Enter the "Tag" that you used when you created the list in the box "Name new list".
21. Enter any optional description you desire to help identify this list in the "Description (optional)" box or leave the "Description" box blank.
22. Click on the button "Create List".
23. Click on the button "+ Add Contacts", then click on "Add from Existing contacts" in the drop-down menu.
24. On the left, enter the Tag in the "Tags" box.
25. Click on the blue button "Add #### Contacts".
26. You are finished! The new list will now appear in all Shipping Easy list menus.
27. When you send the next email campaign, be sure to select the new list you just created.