Video
Walkthrough
If you have contact details, such as email address, first and last name, phone number, etc from other sources, you have the ability to import that list to the Contacts Manager of your Art Storefronts website. There are several import ways, depending on the number of contacts that range from a way to create a single contact, to generating several at a time, and in the end, you have the ability to upload a spreadsheet with as many contacts as you have.
Please Note: In order to upload a spreadsheet and import your contacts in a bulk that way, you must use the attached spreadsheet format to upload your contacts. If your spreadsheet is not in the correct format, contacts will not upload correctly. You can download the example spreadsheet file in .csv format from this link.
Additionally, ensure that the required fields, including First Name, Last Name, Email Address, and Opted_In, are filled out correctly. The "Opted_In" field must contain a valid date to mark contacts as subscribed.
Let's start by locating the Contacts section from the Jump To menu.
Log in to your Art Storefronts Site Manager, and in the Jump To Menu, select Contacts.
From here, your options branch out based on how you want to manage your list. You will see several buttons you can use to add a new contact or contacts to your site.
Starting from left to right, the first button, +ADD CONTACTS, will let you create an individual contact. This option is best for instances where you have one or two contacts to add.
The next option is ADD CONTACTS BY EMAIL. This lets you add multiple emails at once to your contacts list—very convenient when you have a fresh batch of emails from art shows or other events.
Once clicked, this field will display an entry box where you can input email addresses. To enter multiple emails at once, separate them with a comma (e.g., test@artstorefronts.com, test2@artstorefronts.com, test3@artstorefronts.com
Once done, click on IMPORT. You should see the emails you entered appear in the contacts list. Keep in mind that contacts added this way will only have email addresses; any additional information must be manually added for each contact.
Keep in mind that contacts added this way will only have email addresses, and any other info would need to be manually added for each contact.
The next option is DOWNLOAD CONTACTS. This allows you to download a list of contacts from your site in a
.csvspreadsheet format. There are several filters you can apply, such as filtering by a segment (great for downloading contacts who entered a specific promo or giveaway).
Once you specify the date range and any additional filters, click EXPORT. A spreadsheet with your contacts will be sent to your account email address.
Note:When exporting contacts by segment, make sure to consider the date the contact was created, not the date they were added to the segment. The easiest option is to select a date far enough in the past to ensure you capture all eligible contacts.
The next option is IMPORT CONTACTS. This allows you to import a bulk spreadsheet with an unlimited number of contacts. To use this method, you must use a specially formatted spreadsheet template that the site can read correctly. The form template can be downloaded HERE>>
Ensure that your
.csvfile adheres to the following guidelines to avoid errors during import:Wholesale Field: Use
TRUEorFALSEvalues for thecan_buy_wholesalecolumn. Avoid using values like"NO".Segments Column: Ensure there is only one
Segmentscolumn, typically located at column AC. Adding multipleSegmentscolumns will cause the import to fail.Duplicate Columns: Avoid duplicate column headers, such as having two
idcolumns.Downloading Issues: If you encounter issues downloading the CSV template (e.g., seeing raw text in your browser), right-click the download link and select Save Link As or Save As to save it as a
.csvfile.
When you have the
.csvfile, open it in any spreadsheet editor (we recommend Google Sheets for convenience) and enter your contact details.
Once your sheet is filled out and saved on your machine, return to the site, select Import Contacts, and choose the saved spreadsheet file from your computer/Mac.
Click Open.
You will receive a notification that your contacts are importing. An email confirmation will be sent to you once the process is complete.
After receiving the completion email, refresh the page to view your new contact(s).
Please Note: For your contacts to be Opted-In in Art Storefronts (which in turn marks your contact as Subscribed in Mailchimp), please ensure that your "Opted_In" column is filled with a valid Date. (In most cases, using the current date will be all you need)
Additionally, ensure that your CSV file does not contain duplicate columns or multiple Segments columns, and that all required fields are filled out correctly to avoid import errors.