You can easily use your store's existing export function to create a CSV file of your customers records and upload it to your iContact account.
If you do not have an iContact account, please first sign up with their service before proceeding with the following.
Generating your Customer Record CSV File.
From your 3dcart Online Store Manager:
- Go to Customers ->Customer List
- Once there, look to the top right of the page and click on the "Export/Import" button.
- On the left hand side of the Export/Import page, click on the +Icon for "Customers"
- Followed by the "Export Data" link.
You can also use the export interface to download your customer records by specific groups or alphabetical sections.
(A-H, I-Q, R-Z)
- Save the file to your desktop
Editing the CSV File
The customer record CSV contains a large amount of customer information that iContact will not utilize. Therefore, your next step will be to edit the CSV file to remove these unneccessary columns.
The Customer Record export contains a very important column titled "mailist" which denotes whether the customer has subscribed to your mailing list or not. This column will contain either a 1 or a 0 for the individual customer records.
- If the column contains a 1, it means the customer has subscribed.
- However if the column contains a 0 the customer has either not requested a subscription or has unsubscribed.
Before proceeding with any of the following edits, please be sure to remove all unsubscribed customers before uploading your CSV file to iContact. Again, these will be the ones listed with a 0.
- Open the CSV file in a spreadsheet program like Microsoft Excel
- Edit the file to remove all of the columns except for the following:
iContact will use this as their "fname"field.
iContact will use this as their "lname"field.
iContact will use this as their "address1"field.
iContact will use this as their "address2"field.
iContact will use this as their "city"field.
iContact will use this as their "state"field.
iContact will use this as their "zip"field.
iContact will use this as their "business"field.
iContact will use this as their "phone"field.
iContact will use this as their "email"field.
- additional_field(1 through 4)
iContact can use this as their "fax"field if you have a customized registration form that requests this information.
- Save your CSV file after making your changes
Your advanced CSV file is now ready to import to iContact. During the import process on your iContact account, you will match these fields with their respective equivalents on iContact.
Uploading the CSV file to iContact
You will now upload your CSV file to iContact. During the upload process, you will be prompted to match your CSV columns with their iContact field names.
- Log into your iContact account
- Click on "Add Contacts"
- Next, click on the "Upload from File" button.
- Browse to your saved CSV file and select it.
- Click "Upload Contacts"
- You will now match the remaining columns from your 3dcart CSV file to their iContact counterparts.
The following list should help you match the fields to each other.
3dcart Column Name
- billing_zip zip
iContact Field Name
- (if applicable) fax
- Click "Next" when you've completed matching the fields.
- Complete iContact's Spam-Free certification process and mark the checkbox labeled "Subscribe these Contacts."
Your mailing list is now imported into iContact