Articles in this section

Import contacts from a CSV file into Carts Guru

Louise Blosfelds-Hayes
  • Updated
Follow

Importing the existing contacts in your CMS (Shopify, Prestashop, Magento, WooCommerce etc) into Carts Guru will expand the reach of your email and SMS marketing campaigns and increase your ROI. Here are the steps to follow.
First, you can export contacts from:

  • Your CMS (Shopify, Prestashop, Magento, WooCommerce, etc)
  • Your CRM or DMP (database)
  • Your mailing tools or providers

You should then have a CSV file that looks like this:image__6_.png

There are two key things to check and modify if needed:

  1. Contacts have to be opted in (subscribed to your communications)
  2. Phone numbers have to be in the international format. E.g: USA ‘14151234567’, France ‘336123456789’

Remove any opted-out contacts and correctly format phone numbers, then you can start to clean your CSV file by deleting unnecessary columns.

Your CSV file needs to include an Email Address column, but we also recommend First Name, Last Name, and Phone Number. You can get rid of the rest. If you don’t have time to delete columns now, no worries: you can come back to it later.

A properly cleaned CSV file will look like this:image__43_.png

Once your file is clean and saved in CSV format (which can be done in Excel or Google Sheets) you can import it to Carts Guru. To do so, just follow these steps (video below).

  1. Go to the left-sidebar and click Lists.
  2. Create a static list. Call it, for example, “import today’s date”.
  3. Go to the left-sidebar and click Contacts.
  4. Then, in the upper part of the screen, click the orange "Import" button.
  5. Choose whether you want to import your contacts or orders. In this case, click on "Contacts".
  6. Find and select the .csv file you want to import.
  7. After the file has been processed, select the relevant fields that you want to map. For example, George -> First Name, US -> Country, and so on. If a field doesn’t exist (in this case, it is the column Optin/Subscribed), select “Do not map that field”.
  8. After mapping all the fields, click Next.
  9. Finally, review whether your contacts have opted-in to email or SMS communications and choose whether you want to include these contacts in the static list you created before (Remember: all your contacts are automatically added to a dynamic "All contacts" list).
  10. Click "Import Now" and you're done!

Related articles