Beginner - How to Preserve Opt Out Status When Importing Contacts?

Beginner - How to Preserve Opt Out Status When Importing Contacts?

Greetings.

Please forgive the elementary question. We’re struggling to get started in Campaigns.

We have 2,500 customers in Lightspeed Retail POS. In the Lightspeed interface, some are marked as opting in to email marketing and some as opting out.

Our goal is simple: use Campaigns to send a message once a month to those marked as opting in.

We think the first step is to export the customers from Lightspeed to a CSV file. The only option in Lightspeed is to export them all. In the CSV file, Lightspeed includes a column headed "do_not_email." The data in this column will be either 0 (for those opting in) or 1 (for those opting out).

We can successfully import the file into Campaigns. But we do not see how to ensure that Campaigns does not send messages to those with do_not_email=1 in the CSV file. It seems that we must assign the same subscription type to all the contacts during import to Campaigns.

Many thanks for any pointers.



      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • Sticky Posts

          • Tip of the week 03 - Sending emails in batches

            Today's marketers not only want their email marketing to be efficient, but also smart. For an email campaign, you may think you have all the essential elements for lead conversion—a big mailing list, an attractive template design, and the most-engaging message content, but after hitting the ‘send’ button, you may not get the expected conversions. Wondering why? Here’s one of the major reasons. Many marketers miss out on sending the email campaign the right way. Did you know that you should not be
          • Tip of the week 04 - Know about your recipients' 'prime open time.'

            In today's market, the importance of customer behavior is astounding, with a vast amount of research and resources going into finding how customers make decisions. The process of persuading your customers to open your email and click on your call-to-action becomes easy when you understand the psychology behind their behavioral traits. Time to turn into a psychologist! Let's get to the basics—you want your emails to resonate well with your recipients. So, what's the primary thing involved here? It's
          • Zoho Campaigns Expert Diaries on SoundCloud, Spotify, Apple Podcasts, and YouTube

            Hi email champs,  As email marketers, we find great lessons in each other's works—be it the subject lines that worked good, the design that was received well, or the CTA that had the maximum clicks. Email marketing encompasses a wide variety of topics spanning everything from creation and design to development and deliverability.  Here's when we from the Zoho Campaigns team found the need to build an email marketing community comprising of seasoned marketers and email geeks who can help each other
          • Email Deliverability Tip #3: Seal the deal with the preheader

            In the last post, we learned about the subject line. Today we'll be learning about the preheader. A preheader is the short text that follows the subject line in an email. The preheader is designed to hint at what your email message is all about. A good preheader should act as a second subject line and convince your contacts to open the email. Now, let's learn the best way to craft a preheader. Your subject line and preheader should work together and accurately convey the gist of your email. Keep
          • Tip of the week 15 - Add subscription-preferences option. Drive more engagement.

            If crafting content for emails, getting creatives done, and running email campaigns is your love, then unsubscribes are the heartbreakers.  You can save your emails from being unsubscribed/trashed by adding a proper subscription-preferences option in your emails (works best at the time of signup). Giving subscribers the option to choose what they want to receive from you and decide how often (frequency of the emails) your emails should hit their inboxes will increase the reach of your campaigns manifolds. 

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ






                                ご検討中の方

                                  • Recent Topics

                                  • スマホでキャンペンメールを見ると正しく表示されない

                                    キャンペーンのメール(HTML)を作成しましたが、スマホ表示に切り替えると正しく表示されません(添付参照)過去に作成したキャンペーンでは特に意識してませんでしたが、問題なく表示されていたようです。うまく表示される場合とされない場合の違いは何でしょうか?
                                  • 136.143.188.51 blocked by spamcop

                                    Zoho mailserver seems to be blocked by spamcop. Cant send mail to my customer. Not sure what to do.
                                  • Zoho Calendar Integrated Into CRM?

                                    I've searched around the forums but couldn't find anything addressing this . . .  Is there a plan to integrate Zoho's stand alone calendar solution into Zoho CRM?  The CRM calendar does an OK job but is very basic and the Zoho calendar is great, but I've only figured out to subscribe to my CRM calendar within ZCalendar - there is no 2-way sync. My preferred solution would be for ZCal to become the default calendar/event solution within Z CRM. Is this on the roadmap? Thanks
                                  • Can I Create Different Page Layouts Based on a Specified Module Pick List Field

                                    I am trying to work out how to create different page layouts based on a specified module pick list field value, like the Salesforce feature where you can define multiple record types and then create custom page layouts for each record type. This is a super important feature as for almost all the modules we are using (Leads, Potentials, Accounts) we need to be able only show fields relevant to the record type. E.g. We need a very different page layout for a consumer lead Vs a commercial lead, same
                                  • Scheduling Tasks in Relation to Project End Date

                                    I use Zoho project  to help manage tasks that relate to a number of specific business events that take place.  I would like to be able to have my project end date be the date of the event and then work "back" from that date to say...   Add a task 2 weeks before the project end date to remind me to XYZ.  Does anyone know if there is a way to base task timings back from a project due date rather than a project start date?
                                  • What formula to use in computing total hrs and decimal hrss

                                    So , my data includes log im column , 2 breaks with 2 columns that says back and lunch and 1 column that says back and logged out. What formula should i use to be able to automatically have my total hours as I input time in each column? Thankyou
                                  • Notes of Tasks in Zoho CRM

                                    Hello, Is there a way to filter the Notes that appear on a Task to only show the notes related to that specific Task and not display all the Notes of the objects related to that Task (Accounts, Contacts, Deal, etc). In essence, our team struggles to understand
                                  • Passing the CRM

                                    Hi, I am hoping someone can help. I have a zoho form that has a CRM lookup field. I was hoping to send this to my publicly to clients via a text message and the form then attaches the signed form back to the custom module. This work absolutely fine when
                                  • How to next stage blueprint in Zoho Creator

                                    Hello, I have question, its possible to next stage blueprint? in case, Start - (first stage) Leader 1 (with condition 1) - (second stage) Leader 2 (with condition 2) - (third stage) Leader 3 (with condition 3) - (fourth stage) After first stage, i want
                                  • Feature Request: Email Follow-Up Sequences Similar to Zoho CRM

                                    I’m wondering if Zoho Recruit is planning to introduce a feature similar to the Email Automation – Follow-Up Sequences that is available in Zoho CRM. In CRM, this allows users to send a series of timed follow-up emails triggered by specific actions (for
                                  • Currency limitation when integrating Zoho CRM & Zoho Books

                                    Brief Video of Problem: https://www.loom.com/share/d61d1d07d0904e149d80c1901a22418e. Background ·       Our business is based in Australia and we have to have Zoho Books in AUD to comply with tax and reporting regulations in Australia. ·       We sell
                                  • Multi-select Lookup does not have Advanced filter options in CRM

                                    With much fanfare Zoho announced the advanced filter options for CRM lookup fields which was a nice addition. This feature is not available for Multi-Select lookup fields. Will it be rolled out in the next 3-6 months, considering the standard lookup filter
                                  • Experience effortless record management in CRM For Everyone with the all-new Grid View!

                                    Hello Everyone, Hope you are well! As part of our ongoing series of feature announcements for Zoho CRM For Everyone, we’re excited to bring you another type of module view : Grid View. In addition to Kanban view, List view, Canvas view, Chart view and
                                  • Unable to copy into a new document

                                    Whe I create a new Writer doc and attemp to copy and past I get this message. The only way to copy into a document is I duplicate an existing document, erase the text and save it under a different name and then paste the information. Not ideal. Can you
                                  • Kaizen #157: Flyouts in Client Script

                                    Hello everyone! Welcome back to another exciting edition of our Kaizen series, where we explore fresh insights and innovative ideas to help you discover more and expand your knowledge!In this post, we'll walk through how to display Flyouts in Client Script
                                  • Customize User Invites with Invitation Templates

                                    Invitation Templates help streamline the invitation process by allowing users to create customized email formats instead of sending a one-size-fits-all email. Different invitation templates can be created for portal users and client users to align with
                                  • Admin Control Over Profile Picture Visibility in Zoho One

                                    Hello Zoho Team, We hope you are doing well. Currently, as per Zoho’s design, each user can manage the visibility of their profile picture from their own Zoho Accounts page: accounts.zoho.com → Personal Information → Profile Picture → Profile Picture
                                  • Published Course Not Reflecting In Hub

                                    Hi! I am trying to create micro-learning courses for our team to be available for self-guided learning. I have published the courses with enrollment settings open to all users of the hub, but they don't appear to be available for enrollment. Am I missing
                                  • Unlock Locked Users via Zoho One Mobile App

                                    Hello Zoho One Team, We have noticed that in the Zoho One web admin panel, we can unlock a locked user when needed. However, when using the Zoho One mobile app, there is no indication that a user is locked, nor is there an unlock button similar to what
                                  • Account in Quick View Filter

                                    I have a report that I often run against a specific Account. Every time, I have to go into the edit menu and change the Advanced Filter. I would prefer to use the Quick View Filter, but it does not allow me to use the one and only field that makes any
                                  • Tip #47- Stay Ahead with Automated Scheduled Reports in Zoho Assist- 'Insider Insights'

                                    We’ve made it easier for you to stay informed, even when you’re busy managing remote sessions! With Scheduled Reports in Zoho Assist, you can now automatically receive detailed insights about your remote support and unattended access activities directly
                                  • Colour Coded Flags in Tasks Module List View

                                    I really like the colour coded flags indicating the status of the tasks assigned to a Contact/Deal in the module list view. It would be a great addition to have this feature available in the list view of activities/tasks. I understand you have the Due
                                  • Uploading data to S3

                                    Has anyone successfully uploaded data from Creator to S3 using the InvokeURL command or any other method in Deluge? (keywords: S3, AWS, Amazon, bucket)
                                  • UPS Label size when generated via Zoho

                                    We've integrated UPS with Zoho inventory. When creating and downloading the shipping labels they are created in a larger paper size. I'd like them to be generated to print on a 4x6 printer. Zoho have told me I need to do this within our UPS portal. UPS
                                  • Credit Management: #4 Credits on Unused Period

                                    Recall a familiar situation. You sign up for a monthly gym membership. You pay the subscription fee upfront, get motivated, and show up consistently for the first week. Then, suddenly, you get caught up in work deadlines, travel plans, or a dip in motivation.
                                  • Empowered Custom Views: Cross-Module Criteria Now Supported in Zoho CRM

                                    Hello everyone, We’re excited to introduce cross-module criteria support in custom views! Custom views provide personalized perspectives on your data and that you can save for future use. You can share these views with all users or specific individuals
                                  • Zoho Analytics Automatically Deletes Queries and Reports When a Synced CRM Field Is Removed

                                    We’ve encountered a serious and recurring issue that poses a massive data integrity risk for any Zoho Analytics customer using Zoho CRM integration. When a field is deleted in Zoho CRM — even an unused one — Zoho Analytics automatically deletes every
                                  • Prevent new Record Association

                                    Hello all, We have a small sales organization therefore, it's helpful for everyone on the sales team to be able to view the full list of accounts to assist in preventing duplicate accounts from being created. However we want to prevent people from creating
                                  • Tip of the Week #73– Automate workflow with Make integration.

                                    Make is a no-code workflow automation platform designed to connect your favorite apps and automate repetitive tasks across services. By integrating Make with Zoho TeamInbox, you can streamline everyday inbox management and save valuable time. With this
                                  • Viewing attachments

                                    I'm using a Web Form integrated in my web site to collect Leads several info, including a image upload. In order to to approve each lead, we have to view the image uploaded. Unfortunately, in the Leads view, the Attachments can only be downloaded, not
                                  • Kaizen #89 - Color Coding using Client Script

                                    Hello everyone! Welcome back to another exciting Kaizen post. Today let us see how you can apply color codes to the List and Detail Pages of Zoho CRM using Client Script. Need for color code in Zoho CRM When you mark things with different colors as a
                                  • Instant Sync of Zoho CRM Data?

                                    With how valuable Zoho Analytics is to actually creating data driven dashboards/reports, we are surprised that there is no instant or near instant sync between Zoho CRM and Zoho Analytics. Waiting 3 hours is okay for most of our reports, but there are
                                  • Is it possibly to directly set the tax amount on order instead of indirectly via tax rates?

                                    We own an eCommerce application and want to funnel submitted orders from that system into Zoho. We're already calculating tax in our application and just need a way to set it in Zoho. We tried to use Zoho's tax objects for tax by setting the rates to
                                  • Zoho account sign in with passkey

                                    Hello, I am trying to sign in using passkey, but the option doesn't show up in the web and is disabled in Oneauth on mobile, saying the admin has restricted the use. On the Admin page in Security MFA I can find no option for passkey. Help would be greatly
                                  • Nouveauté dans Zoho Writer - Création de documents et de modèles assistée par l'IA

                                    Zia, l’assistant IA de Zoho Writer, soutient les utilisateurs dans l’amélioration de leur écriture et la création de contenus : correction orthographique et grammaticale en temps réel, suggestions adaptées au contexte, détection du plagiat, révisions
                                  • Rescheduled US meetups: Zoho Desk user meetups are coming to seven U.S. cities in October and November, 2025

                                    Hello to our Zoho Desk users in the United States, We're excited to share the revised dates for the upcoming Zoho User Groups happening across the US this summer. Our product experts are heading to seven cities throughout the country, and for the first
                                  • Checklists as templates

                                    Is it possible to save checklists as templates to reuse them in other tasks? Example: I have a web project. I maintain individual web URLs as tasks. Within the tasks the same checklist should be used again and again: - Page created in CMS - Properties
                                  • Send mass email using my secondary email

                                    Hello, When I send an email to just one person from Zoho CRM, a complete email editor appears, where I can choose which of my email addresses I want to use in the From field. When I send a mass email, there is not such option. I can only select the email
                                  • Add the same FROM email to multiple department

                                    Hi, We have several agents who work with multiple departments and we'd like to be able to select their names on the FROM field (sender), but apparently it's not possible to add a FROM address to multiple departments. Is there any way around this? Thanks.
                                  • ZOHO TEAM INBOX Calendar Integration

                                    The Problem: Clients send meeting invitations to our TeamInbox address. TeamInbox receives these invites, but we cannot accept them. We do not use individual inboxes for transparency purposes. Ideal Solution: A way to accept calendar invites sent to our
                                  • Next Page