Tips and Tricks #23: How to avoid errors while importing data in bulk or migrating from other systems to Zoho Subscriptions
To import your data successfully, you will need to ensure that the rows and columns in your import files match with our sample import files, which can be downloaded from any import screen in Zoho Subscriptions
However, even after doing this, you could still run into validation errors, which prevent your data from being imported. This could happen if Zoho Subscriptions has not been configured for the data in your import file.
Here are a few examples of validation errors:
- You try to import transactions with the transaction mode as "Check" but you haven't added "Check" as a mode of payment in Zoho Subscriptions.
- Your import file contains subscription details and plan codes for importing subscriptions but you haven't created a plan with that particular plan code in Zoho Subscriptions yet.
When it comes to importing data in bulk, especially from other systems, checking or validating each and every record in a huge import file can be time-consuming and tiresome.
This week's tip can help you breeze through the validation process with the click of a button.
This is article is part of a series of tips and tricks. Missed our previous post? Read up on localizing your product prices in Zoho Subscriptions.
This is article is part of a series of tips and tricks. Missed our previous post? Read up on localizing your product prices in Zoho Subscriptions.
How It Works
Simply import your data into Google Sheets and run our Google Apps Script (linked below). The script will communicate with Zoho Subscriptions via an API and check if the selected data in your import file exists in Zoho Subscriptions.
After making the necessary changes in Zoho Subscriptions, run the script again to double-check your import file. If you find that nothing has to be changed, go ahead and import the file into Zoho Subscriptions.
Setting It Up
- Import the data that you want to validate into Google Sheets.
- Click the Plus icon in the bottom left corner to create a second sheet.
We'll be using this second sheet to run our script on the data that needs to be validated, which is the payment mode, in our example. To do this, you'll need two columns on the new sheet, one with the data that needs to be validated (payment mode) and one with our script's response. Here's how to do it:
- Enter a column name for the data that needs to be validated in the cell A1 and a column name where our script will display it's response in the cell A2. We've named our columns "Payment Mode" for A1 and "Exists in Zoho Subscriptions?" for A2.
- Enter the following formula in the cell A2 to list out all the unique payment modes from our first sheet:
=UNIQUE(Sheet1!D2:D)
Note: This formula contains D2:D, since the values for the payment mode start on the cell D2 in our first sheet, so modify this if necessary.
- Go to Tools > Script Editor and paste our script, which is available on GitHub. Enter your Auth Token and Organization ID in this script, since it uses Zoho Subscriptions' APIs.
Now, all that's left to do is create a button which can run this script.
- Create a button by going to Insert > Drawing from the toolbar.
- Right click on the button and click the 3-dot menu.
- Select Assign a script.
- Enter the function name of our script, which is syncPaymentModes and click OK.
You're all set! Go ahead and click the button to validate your data.
Let us know if this helped your business! Also, feel free to write to us at support@zohosubscriptions.com or leave a comment below, if you have any questions regarding this tip.
Cheers,
Varun Steven
The Zoho Subscriptions Team
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Varun Steven
Bill
Sticky Posts
Tip #4 : Refer and Earn Workflow system for your Subscription Business
Hello everyone, We've been coming up with a tip every week to address specific business scenarios which can be implemented for your business. In continuation to the previous post, this week we will be seeing about how you can implement the Refer and Earn Workflow system to acquire more customers. Why are Referrals important? Customer Acquisition is crucial for any business to sustain itself in a constantly evolving market. It involves persuading new consumers to purchase your products. CustomersTip #2 - Cancellation of Offline Subscriptions based on the Expected Payment Date
Hello everyone, As you all know, we are coming up with a custom function workflow every week to address specific business scenarios. In continuation of this previous blog, this week we will be seeing about Cancellation of Offline Subscriptions based on the Expected Payment Date. Business Scenario: In general, for any business, the customers make payments via online as well as offline. In case of subscription where the automatic collection of charge is enabled (aka online subscription), the customer'sTip #3 : Send SMS Reminders for your Subscription Business
Hello everyone, As you all know, we are coming up with a tip every week to address specific business scenarios. In continuation to the previous blog, this week we will be seeing how you can use SMS reminders for your Subscription Business. Using SMS messages for your Subscription Business: While managing your subscription business, more often than not, you need to keep your customers informed about upcoming renewals, payment reminders and cancellations. By keeping them informed in advance, you canTips And Tricks - Announcement
Hello everyone, Every business is unique and each of them follows a specific workflow. While managing your customers' subscriptions with Zoho, you might have some needs unique to your business. Custom Functions helps you address such needs. This is a start to a series of posts, where we will be coming up with a custom function workflow every week that addresses specific business scenarios. Watch this space for further updates! Also, if you have any specific business scenario which needs to be addressed,Tip #6 : Accessing external URLs from Zoho Subscriptions
Hello everyone, We have been sharing a tip every week to address specific business scenarios which you can implement for your subscription business. Last week, we shared a tip about implementing the Approval Workflow system. This week, let's look at how you can access external URLs with the help of Custom Link. Business Scenario: Every business functions differently and has its unique requirements. At times, businesses might want to access other websites or applications by appending specific information
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Unable to connect Zoho Learn to other Zoho Tools
Hello Zoho, Can you work on Zoho Learn. I am unable to connect it with other Zoho tools like Zoho people or even Zoho SalesiQ. This is needed, especially if I am connect Ai to my systems. Please work on connecting your applications better, especiallyChatbot for Urdu language
Hello, I have successfully set up Zoho Desk and integrated it with Moodle using ASAP. I am now looking for a chatbot that supports the Urdu language to enhance student support. My goal is to enable the chatbot within ASAP so that students can ask questions,Multi Level Hierarchical Query
Hi guys I have a situation where i am trying to extract the descendants of a particular entry. So long story short, i have the Account table with Agency (A) id = 1, and that has child Agency (B) id = 2. This child agency (B) has a child agency (C) idAI-Powered Grouping and Tagging of Related Issues and Tasks in Zoho Projects
Dear Zoho Projects Team, Greetings, We would like to suggest a feature that would greatly enhance how we manage feature requests and bug reports submitted through the Zoho Desk to Zoho Projects integration. Use Case: Our support agents handle customerHow to change side bar from dark mode to light mode?
The side bar on the left side in workdrive doesn't appear to have a way to fix it from dark mode - is there a way to? I can't read in dark mode without excessive headaches, and I would really like to be able to see while I have workdrive open, as workdriveHow to see history on Bulk send of Customer Statements
Hi, We bulk send statements to customers every month via Books - every month we have customers emailing requesting a statement. Currently I have no visibility on if a customer was sent the statement or not and if our process is being followed or overlookedHow to add buttons elements in the Header
I am trying to add CTA (Call to Action) buttons in the right side of the main navigation menu. This is a common practice for sites but I can't seem to figure this out for Zoho Sites. Is there a custom workflow that could be shared with me?Automatic back up - Zoho Recruit, books, people,crm, analytics
Hello, Has anyone found a good way of automatically backing up Zoho (CRM, expense, recruit, people, books, analytics).? I have found with tool that does, but it doesn't include recruit or analytics It's a bit annoying and time consuming having to go todelete departments on zoho desk
I created test departments on zoho desk. how can i delete them now?Validation, checking if a file has been attached to the ticket
A very useful option would be to allow checking, under specific conditions, whether the user has attached a file to the application, e.g., a bug report. Some applications require files to be attached, and the system could enforce this after the systemAI & Zoho Recruit
Hello, I guess we all are using AI in our personal and professional lives. Now, let's imagine. Recruitment is just a succession of stages and steps. For which step would you like to see AI implemented into Zoho Recruit ? I'll start : - Automatic translationZoho Flow not handling Boolean properly
Hi, I have a checkbox in one system that I'm trying to sync with a checkbox in Zoho CRM. The value from the source system comes in as blank (unticked) or 1 (ticked). I've written the following custom function to convert the output to either boolean falseQuotes Module - import data
Hello Zoho, is it possible to import Quotes records? I was trying and i have no results. Raport shows no data imported. Could you help me please how to do it?Balance Sheet - Zoho Analytics
Hi Team, I’m looking to implement a feature that captures the conversion rate based on the filters applied. By default, it should fetch the most recent conversion rate, and when a filter (such as a timeline filter) is applied, it should return the conversionfiles sent will not open for recipient
work files (done in writer) which previously opened will not open for the recipientHow to Print the Data Model Zoho CRM
I have created the data model in Zoho CRM and I want the ability to Print this. How do we do this please? I want the diagram exported to a PDF. There doesnt appear to be an option to do this. Thanks AndrewCisco Webex Calling Intergration
Hi Guys, Our organisation is looking at a move from Salesforce to Zoho. We have found there is no support for Cisco Webex Calling however? Is there a way to enable this or are there any apps which can provide this? Thanks!Migration of Mails from Pipedrive
Hi, so far the migration from Pipedrive to ZOHO works pretty good. For full completeness of the migration we miss all the mails linked to Deals, Contacts, Customers, ... What possibilities do we have to have Pipedrive fully migrated to ZOHO? Best Regards,Published sheets don't work anymore
Hi, Published sheets don't work anymore. The display of values is very very slow and calculations are not displayed at all. Thanks!#1 Zoho Billing vs. Zoho Books: Which one should I choose?
Managing your business finances isn't just about sending invoices. It's about keeping everything organized, accurate, and moving towards your organization's goals. At Zoho, we understand the complexity, which is why we offer two powerful yet distinctIs Zoho tables still being developed?
Has this product been abandoned? I haven't seen any useful new features or stability improvements over the past six months or more. I think Tables is a great concept, filling a niche between spreadsheets and full database tools, but the current implementationHow to connect oracle ADW with Analytics
I want to add Oracle ADW as a data source in Zoho Analytics, but I couldn't find any relevant documentation. Can anyone suggest how to do it, or let me know if it's even possible? Thanks!!RAG (Retrieval Augmented Generation) Type Q+A Environment with Zoho Learn
Hi All, Given the ability of Zoho Learn to function as a knowledge base / document repository type solution and given the rapid advancements that Zoho is making with Zia LLM, agentic capabilities etc. (not to mention the rapid progress in the broaderadd attachments to automated emails?
Hi, I'm looking for a way to have documents saved under an account, be grabbed and sent to an email address once a specific status has been updated. For example we have a tab we've labeled as sales orders, when the status is changed to shipped, it emails the customer the tracking number and estimated delivery date. I'd like it to also grab pdf docs (COA, BOL, etc) from that order and send in that email. Currently we have to go into zoho change the status to shipped, then email all the docs to[Action Required] Zendesk - Zoho Analytics integration requires re-authentication
Dear Zendesk integration users, Zendesk is transitioning to a new OAuth model that uses refresh tokens for improved security and stability (read more). As a result, all Zendesk users in Zoho Analytics must re-authenticate their Zendesk connections onRerun Migration?
I migrated a mailbox a few days ago, but didn't do the cutover on the MX records until today. How can I rerun the migration to sync the mailboxes? The old account has had a fair amount of activity since the first migration. I am used to other systemsطلب حذف الدومين والمؤسسة من حساب zoho
السلام عليكم، أود طلب حذف الدومين التالي من حسابي في Zoho، حيث لا يظهر لي خيار الحذف في لوحة التحكم: اسم الدومين: hudajstore.com البريد المرتبط: [contact@hudajstore.com] علمًا بأنني المسؤول عن المؤسسة، ولا أستخدم الدومين حاليًا، وأرغب في إلغاء ربطه وحذفMicrosoft Outlook Add-in Update: Enhancing Efficiency for Recruiters
We've released an update to the Zoho Recruit Microsoft Outlook Add-in, which brings a host of features designed to streamline your recruiting process and boost productivity. Let's delve into the details: Associate Emails with records in Zoho Recruit YouNew integration: Zoho Books + Zoho Forms
Hello Zoho Forms community! We are thrilled to announce the addition of another integration that brings speed and efficiency to your financial workflows. Zoho Forms can now be integrated with Zoho Books! Here’s a quick rundown on Zoho Books! For anyoneWitness Sign - Automation with Zoho Creator
Hi there, I used to be able do automatically send a Zoho Sign document from Zoho Creator where each signer had one witness. The action code was as follows for each signer and witness: // CLIENT eachActionMap1 = Map(); eachActionMap1.put("signing_order","1");Announcing: custom color palette + free workshop
Hello everyone, We're excited to share new feature in Zoho Bookings—a color palette within booking page themes. You'll find this option under Manage Bookings > Workspaces > Booking Page Themes. You can customize the color of every element in your booking page and even alter the transparency of your background image. Please note that this is a paid feature included in the Basic and Premium plans. At the moment, it's available only under the Modern Web theme. This means you can create billions (7,Removing To or CC Addresses from Desk Ticket
I was hoping i could find a way to remove unnecessary email addresses from tickets submitted via email. For example, a customer may email the support address AND others who are in the helpdesk notification group, in either the TO or CC address. This resultsAbility to Export Field Dependency Structure in Zoho Desk
Hi Zoho Team, We’d like to request a feature enhancement in Zoho Desk that would greatly improve configuration management for organizations like ours: Requested Feature: The ability to export the full structure of Field Dependencies, especially for multi-level[URGENT] Allow reorder (drag&drop) of subform record
Very simple user case: a wedding planning app where you want to send your client a form to fill with information about their wedding. Form includes some field for general purpose information and a subform for event pacing/schedule. Clients are invited to create a new row (When? - What? - Where? - Who?) for each thing happening during their wedding chronologically. Ex: When What 10h Something TBD Speech After speech Yet another thing happeningDepartments in Zoho
I'm trying to set up a department. It looks like Departments have been removed from Zoho One. Is there another option? We have our main account setup, but want to set up a separate small department that can't see our tabs.Add Timer for Agent Status Duration in Zoho Desk Dashboard
Hello Zoho Desk Team, We hope you're doing well. We would like to submit a feature request to further enhance the agent status tracking functionality within the Zoho Desk Dashboard. 🎯 Current Functionality As it stands, Zoho Desk allows us to view the[Beta Feature] Parent-Child Ticketing
Hello there, a beta parent-child ticketing feature has recently been made available for some, read more here: https://help.zoho.com/portal/en/kb/desk/ticket-management/articles/understanding-parent-child-ticketing-system#Business_scenarios I would likeEnable Sorting by Ticket Count in Category Reports
Hi Zoho Desk Product Team, I hope you're doing well. We would like to submit a feature request to improve the reporting capabilities in Zoho Desk. 🎯 Feature Request: Sorting by Ticket Count in Category Reports Currently, category-based reports in ZohoReactivating a CRM user...
I'm a 1-man business primarily using CRM under my Zoho1 subscription (I have NO other employees or users). I wish to re-activate a prior user (my son, once more working with me) but when changing his status from inactive to active I receive this message:Zohoサポートにスコープ開放を依頼する
お世話になっております。 現在、弊社にてZoho DeskのナレッジベースをAPI経由で取得し、AIツール（NotebookLM等）に連携する仕組みの構築を検討しています。 つきましては、ZohoDesk.articles.READ スコープを使用したOAuth認証の許可をいただけますでしょうか。 API Console から Server-based アプリを作成済みですが、認可URLにアクセスすると「スコープが登録されていません」と表示されます。 お手数をおかけしますが、スコープの開放をごNext Page