Import customers from a CSV file
Bring in your customer list from Square, Shopify or a spreadsheet. Nothing is sent unless you choose to invite them.
Open Customers and select More → Import. Use a CSV file with column names in the first row and one customer per row: up to 5,000 customers and 5 MB per file. In Square, Shopify or your spreadsheet app, export or save the list as CSV.
- Choose CSV file.
- Match columns. Common column names from Square, Shopify and spreadsheets are matched for you. Check each detail and change any column, or choose Don't import. Each customer needs a name and an email or phone number. Phone numbers without a country code are read as numbers in your store's country. For birthdays, only the month and day are kept; they are saved as a Birthday custom date. The table shows the first rows as they will be imported.
- Review. Nothing is saved yet. You see how many customers are new, how many existing customers have details to add, which are already up to date and which rows can't be imported, with the reason.
- Select Import (the button shows how many customers) and wait for it to finish, then review the summary. You can then invite them to subscribe (see below).
Existing customers are matched by email, then phone number. An import only fills in details that are blank on their record. It never changes their name, saved details or email and text preferences. Rows with the same email or phone number as an earlier row in the file are skipped. Importing the same file again doesn't create duplicates. If an import stops part-way, the customers before that row are saved and you can import the same file again.
Rows not imported: select Download rows not imported for a CSV of those rows with an Import problem column. Fix them and import that file.
Marketing permission
Imported customers aren't subscribed to email or text marketing, and the import sends them nothing. Anyone who unsubscribed from your emails stays unsubscribed. Marketing permission columns in the file (for example Accepts Email Marketing) aren't imported.
If everyone in the file with an email already asked to hear from you, for example by joining your mailing list or ticking a marketing box when they ordered, you can tick These contacts already agreed to receive email marketing from my business on the review step. A past purchase alone doesn't count, and neither does a list you bought or got from someone else. Keep a record of how they signed up in case you're asked. It applies to the customers in the file who have an email and aren't subscribed yet, new or existing, is recorded with the date, and never covers text messages. For an existing customer, the row must give the email on their record (or they have none): a row matched only by phone number never subscribes their stored email. Their status then reads Subscribed on the import date, with Imported (you confirmed they agreed) underneath. Customers subscribe to texts themselves at checkout or on your store.
Invite them to subscribe
After the import, the summary shows how many of the customers in the file can be sent an invitation to subscribe: the same email as Send Invite on a customer's page, which asks them to confirm and changes nothing unless they do. Select Send with the number of invitations to send them. An invitation is itself a marketing email, so it goes only to customers who ordered from you on Bakebug in the last 2 years, never to anyone who unsubscribed, is already subscribed or was already invited. Canadian and US stores need a Business Mailing Address on Business first. Invite everyone else with your Sign-Up QR link, in person or on social media.
Still need help?
Email support@bakebug.com with your store name and order number (if it's about an order), or ask other bakers in the Bakebug Community.