"Spreadsheet Mode" for Fast Bulk Edits

"Spreadsheet Mode" for Fast Bulk Edits

One of the challenges with using Zoho Inventory is when bulk edits need to be done via the UI, and each value that needs to be changed is different.

A very common use case here is price changes. Often, a price increase will need to be implemented, and the new prices aren't all the same, nor are they algorithmically related (e.g., not every price is exactly 10% higher than previous).

There are likely dozens of other use cases, as well. The one I'm running into at the moment is setting min/max quantities for each of 100+ Composite Items.

The only logical way to do this at the moment is to open each Composite Item individually, edit the fields, save, and move onto the next. This is tedious and time consuming.

What would make this type of bulk updating far easier for users would be if there were a "spreadsheet mode" for the View of items and other entities that allowed for editing of the individual cells on the view, similar to how a Spreadsheet Report works in Zoho Creator.

I know the knee-jerk reaction of Zoho is to suggest workarounds, so I'll briefly address those here.

Export --> Edit in Spreadsheet --> Import: While this theoretically works, there is a pretty good risk of permanently corrupting live data if done incorrectly. I'm a pretty solid user of Zoho products, and I don't think it's worth the risk to do this myself. I couldn't ever recommend this to a non-power user.

Bulk Edit Button: This works okay if all of the values to be changed are the same. However, that is not the use cases I'm addressing here. Also, not all fields are exposed to the bulk edits button, so this isn't always an option.
      • Recent Topics

      • Change 'default' project dashboard

        Is it possible to change the default project dashboard for all projects? Both in layout and in what widgets are shown? We have a lot of (short-running) projects and I want to quickly see the tasks and milestones when I open a Project, but I don't want to change the layout for all my projects manually. Thanks, Menno
      • Multiple subscription plan line items in Zoho Billing quotes

        I run an IT company and sell a lot of licences. A client might have multiple subscription plans including software licences in different categories. A client might have Microsoft licences, antivirus licences, web hosting and maintenance package services.
      • [ZohoDesk] Improve Status View with a new editeble kanban view

        A kanban view with more information about the ticket and the contact who created the ticket would be valueble. I would like to edit the fields with the ones i like to see at one glance. Like in CRM where you can edit the canvas view, i would like to edit
      • Live connection to DS files in Zoho Creator / ChatGPT

        As an idea, we are using ChatGPT to build with Zoho Creator (outside of Zia), which is works brilliantly to assist write deluge, provide test suggesitons etc. Currently we are uploading the DS files which are very point in time, it would be great to have
      • Unable to integrate Whatsapp Messaging into Zoho CRM - Business Messaging

        Hello, I want to set up Business Messaging in our Zoho CRM and am struggling to set it up. I have logged into the account and our facebook business page, our business shows in the dropdown for WhatsApp Business Account but does not for WhatsApp Business
      • Files in Teamspaces: keep your team's documents where the work happens

        Release Note: This feature is available for all accounts across all DCs Hello Everyone, A Teamspace is built around a specific team and a shared objective, and it holds the modules and projects that team works with every day. The document that team depends
      • Script to access a CBPX file from zoho crm

        Hello everyone, I'm planning to write a script in Python or Java in Zoho CRM functions, to access a CBPX file. Is it possible to write this script in the dev console of Zoho? What are the best practices to do this ? Would you have references in the Zoho
      • Calculate hours

        Is there any chance that the the "formula" will have the ability to do calculation using the "time" field in the future? Our company has a form set up for tracking hours worked and we use 2 time fields currently. One for the clock-in time, and one for the clock-out time. It's great for keeping that record, but if there were a way to calculate the hours to show on the report would be awesome. Previously we had used JotForm and their calculator had that ability, but it seems that Zoho doesn't accept
      • Introducing parent-child ticketing in Zoho Desk [Early access]

        Hello Zoho Desk users! We have introduced the parent-child ticketing system to help customer service teams ensure efficient resolution of issues involving multiple, related tickets. You can now combine repetitive and interconnected tickets into parent-child
      • Zoho Books | Product Updates | November 2026

        Hello users, As the year winds down, we've introduced several enhancements to make compliance, inventory management, and everyday bookkeeping easier in Zoho Books. This month's updates include an improved TDS experience, a new way to exchange transactions
      • Zoho Writer workflows now support custom stages, parallel reviews, and external approvers

        Hello everyone, Zoho Writer now lets you build your own approval chains. The pre-built workflows also get new review modes, completion criteria, and external approver support. What’s new Custom workflows: Design review and approval processes from scratch,
      • Expanding sales, marketing, and support capabilities in Zoho CRM Plus 3.0

        Hey everyone, It's been more than 10 years since we launched Zoho CRM Plus back in 2014. This is quite a milestone, and we've come a long way in empowering you with everything you need to offer an exceptional customer experience. On that note, we expanded
      • Erase function in Zoho PDF editor does not truly redact

        Using the "erase" function in the Zoho PDF editor online does not redact the text underneath when opening the file in Adobe. When I used the erase function to whiteout the areas I didn't want to be seen, I opened the supposed redacted files in Adobe.
      • Error creating an XML file

        I am creating an xml as string in the function Employee.generatePartA_XML_String, and then I want to save it as a file to the field "Part_A_XML", but I get the response: {"code":3700,"message":"Unable to upload a file. Please check and try again."} How
      • Thunderbird cannot authenticate Zoho on android

        I keep getting a message from Thunderbird on Android that it could not authenticate for my account, dadashton@zoho.com., and to update my server settings. Now the settings are exactly the same for my other devices (1 Windows, 1 Mac and 2 Linux) Can anybody
      • Mailchimp Integration

        Hello, I am needing some help. Does anybody have a recommended source for information on the Zoho-Mailchimp integration. We are working on a system to import large amounts of records into Zoho that will sync into Mailchimp for us to run a mail campaign out of. Let me explain what the process we are trying to implement - any information or advice is appreciated. Import record data base into Zoho Leads module --> use Lead source to ID records that are part of this mail campaign Zoho Leads (specific
      • [Free webinar] Zoho Creator meets AI with MCP | Creator Tech Connect (November 2026)

        Hello everyone, We are excited to invite you to another edition of the Creator Tech Connect webinar. About Creator Tech Connect The Creator Tech Connect series is a free monthly webinar consisting of purely technical sessions, where we dive deep into
      • Invalid Client - Client ID passed does not exist

        I tried connecting the Zoho campaign with the "Uncanny Automator". It shows an error " Invalid Client - Client ID passed does not exist". There is no option to add manual API. URL: https://accounts.zoho.eu/oauth/v2/auth?response_type=code&client_id=1000.MSFIUOA1G8YBK7IFRL9Z0NINM6DW9C&scope=ZohoCampaigns.contact.ALL&redirect_uri=https%3A%2F%2Fapi.automatorplugin.com%2Fv2%2Fzoho-campaigns&prompt=consent&access_type=offline
      • Field of Lookup - 5 Field Association Limit.

        This query relates to the post at: https://help.zoho.com/portal/en/community/topic/introducing-the-field-of-lookup-in-crm-public-early-access-2023 My simple (and common) scenario: I select an account / customer lookup and want their address pulled into
      • Task status - completed - other options

        I have a dumb question I know i can make custom statuses for the tasks - but is there anyway to make additional "completed" statuses like for instance if i have a task "call back customer" and i leave a vm for them to call back marking it "completed -
      • #20 I've Sent It and It's Wrong

        Meera spots a mistake in an invoice just four minutes after sending it. She has billed a photoshoot at the half-day rate instead of the full-day rate. Her first thought is to delete the invoice and start again. But is deleting the right thing to do? It
      • Zoho Forms API

        Is there any way to get all form entry list using API? Looking forward to hear from you
      • BNZ Bank Feeds No Longer Available

        The BNZ (New Zealand) bank feeds are still failing and it's been months since they last worked! Uploading bank statements (CSV's) mean waiting to the end of the month when they become available. It is unacceptable to keep my clients waiting for payment
      • MCP is now easier to access and configure in Bigin

        Greetings! We hope you're all doing well. We've previously introduced Zoho MCP for Bigin, which lets you connect Bigin with AI tools and interact with your Bigin data using natural language. Now we're making MCP easier to access and configure directly
      • Launch agents from more custom button locations and attach files in Ask Zia

        Hello all, Your agents now meet your team where the work happens. You can add agents to custom buttons in list views, create and edit pages, and related lists, so users launch them without leaving the page they’re on. What’s new Agents in more custom
      • Phone system to integrate with Zoho CRM

        I am looking for phone software that would allow my agency to do the following within Zoho CRM: Make calls from zoho Track calls and notes Leave pre-recorded messages after reaching voicemail of lead Only 2 members, so need company who will allow just
      • Introducing PRM: Build, manage, and scale your partner ecosystem

        Growing a partner ecosystem is a good problem to have. What starts as a handful of partners can quickly turn into a maze of spreadsheets, emails, and disconnected processes. More partners mean more opportunities, greater reach, and new ways to grow
      • Zoho Projects connector with Zoho CRM (Related List module) features

        Hi community, I use Zoho Projects connected to Zoho CRM, where we associate Projects with Deals, clients, etc.. I am looking to change/edit the fields that are available in the integration. Currently it shows Project Status, Project Completion, Milestones,
      • Feature Request: Render Markdown (.md) files in Zoho Cliq

        Hi, We regularly share Markdown (.md) files in Zoho Cliq. However, when we open these files in Cliq, the content does not render as Markdown—it displays as plain text. This forces us to copy/paste the content into an external Markdown viewer to read it
      • Free webinar: Zoho Sign for Microsoft apps

        Hello, Did you know Zoho Sign works right inside the Microsoft apps you already use? A signature request shouldn't mean leaving Teams for another tab, or downloading an Outlook attachment just to sign it. Zoho Sign integrates with Microsoft 365, Teams,
      • Users can now notify the contact while adding a 'Resolution' to the ticket.

        Hello, In the latest version of the Desk iOS mobile app (v2.6.4), users can now notify the contact while adding a 'Resolution' to the ticket. Also, the 'Resolution' UI has been tweaked to support edit and delete option.   Please update the app either
      • Better Time Tracking

        We need better time tracking customization for IT MSPs. We also need reporting that is built in, rather than having to try and fumble with creating custom reports. We also need to be able to mark whether a ticket has been billed or not, I don't think
      • Introducing Custom Fonts for Career Sites

        Your Careers page is often the first place candidates interact with your organization. From exploring job opportunities to submitting applications, a consistent visual experience helps candidates recognize and connect with your brand. To give you more
      • Need help with importing expenses

        I'm using the template downloaded from the application. When I try to import my expenses, I get the message: Duplicate entry in the Expense Date column. Ensure it contains unique values. None of the rows will import. There are duplicate dates, but they
      • time tracking on zoho crm cases

        Is there a time tracking feature in zoho crm cases? I need calculate time spent in calls, tasks and events Thanks in Advance  
      • Integrate with Power BI

        Hi, How to connect Zoho CRM dashboards & reports with POWER BI ?
      • Unbundle feature for composite items

        We receive composite items from our vendors and sell them either individually or create other composite items out of them. So, there is a lot of bundling and unbundling involved with our composite items. Previously, this feature was supported in form
      • Zoho Recruit: Time to Step Up Your AI Game!

        I've been using Zoho Recruit for many years and I love it. But let's be honest, it's starting to feel a bit like a relic from the pre-ai era. I recently tried out new systems that have ai resume screening and ai interviewing capabilities, these systems
      • Zoho mail app throwing network error

        Zoho mail app is throwing network error and I do not know how to fix the issue.
      • Cannot unblock account

        Hi, I have recently been travelling for work and now my mail account has been locked due to suspicious activity (I guess login attempts from different countries) however when I go into my admin panel it won’t let me unblock and asks me to contact support.
      • Next Page