Cannot add variants for an existing product through import?

Cannot add variants for an existing product through import?

Argh!! Seriously?  (As Bryan is pulling his hair out.)

As anyone might guess after reading other forum posts of mine, I'm usually very pro-Zoho, I'm a huge fan of Zoho, I think it's a good company with good people and have a good product.

But I really have to rant about this.  And not just this specific issue, but in a more general sense... The fact isthat there are a range of artificial limitations imposed on doing any sort of bulk editing... and it virtually makes my head explode.  Among them are things like...

You can't upload over 1MB at a time in Commerce.  (Why make it take five times as long for me to do something that I have to do?)
You can't overwrite any field with a null value - so you can never clear a value through an import.  Seriously.  You can't.  There are so many reasons you'd want to do this, but you can't.
There are a variety of other gems that also result in imports being virtually useless for performing inventory updates.
And so now you can't add variants for an existing product through an import?

Nearly every time I need to do an import to make corrections, I can't because of an artificially imposed restriction.  Nearly every time.  And I can't be alone in this regard.

There is no need for this.  And it's the case in Commerce, Books, and Inventory - so it's seemingly a systemic policy driven issue that I don't experience with other SaaS providers.  This is unique to Zoho.

If the concern is that someone who doesn't know what they're doing will wipe out their Inventory with the wrong import, I get that.  But we're all adults here.  And for those who know how to manage inventory imports, exports, and updates, there needs to be a range of unrestricted tools that allows more experienced users to not feel like they're being forced to drive 20MPH on a 65MPH road.

But these aren't things limited to the needs of advanced users.  You don't need to be doing anything out of the norm for this to be an issue.  In fact is that the use cases are endless.

Suppose I'm a shoe store and I sell Converse shoes (only the best and most timeless shoe in history) and Converse decides to add a 12th color to their 11 color line of High Top Chuck Taylors... each one being available in no less that 73 different sizes between an infant 1C and an adult Mens 18.  (Perhaps there's some overlap between the Big Kids and Adult sizes, but I digress).  My point is that it becomes a very unnecessarily time-consuming and ends up being a multi-hour project to expand pre-existing product with new variants.  Suppose you wanted to change the name of a color.  Show me a way to do that quickly.  Why is it that the only available option in cases like these is to manually enter new SKUs manually one by one.

And it would be one thing if Commerce was held back by a technical reason for these things... but let's be real here.  There's no technical reason that should inhibit make bulk edits in the system.  These restrictions are, for whatever reason, policy driven. 

Similar to the one megabyte import limitation restriction (which still is just as unfathomable to me as to why that should exists) I'd love to know what logic would dictate that it would be a good idea to put an absolutely unnecessary limitation like this  into Commerce?  There is simply no reason for this to exist, other than to drag out something much longer that any other system would allow you to accomplish in second.  Amazon, Shopify, etc... simply import your data.  They just do.  

Why the unnecessary roadblocks that only serve to slow you down when the system should be designed in every way to optimize save me time, rather than making every inventory update into a project.  

Please please please fix this so that inventory imports can be a useful part of Commerce.  Please.  Manual editing in Commerce has sucked countless hours from my life because of this.  I'm not kidding.  Please fix this so we can actually work with our store inventory efficiently and in a manner that's accommodate by virtually every other available ecommerce solution. 

-Bryan



        • Recent Topics

        • Introducing Dark Mode / Light Mode : A New Look For Your CRM

          Hello Users, We are excited to announce a highly anticipated feature - the launch of Day, Night and Auto Mode implementation in Zoho CRM's NextGen user interface! This feature is designed to provide a visually appealing and comfortable experience for
        • Object required error

          Hi, I am getting an 'Object required' error on the line Call HideColumnsOutsideRange(ws, startOfWeek, endOfWeek) when I run the ShowCurrentWeek macro but not when I run the ShowCurrentMonth macro. Any ideas? Regards, GW Option Explicit Sub HideColumnsOutsideRange(ws
        • Zoho CRM - Rename "Estimates" in CRM Finance Suite Integration to "Quotes"

          I'm not sure if it's been 2 or 3 years now since Zoho Books renamed Estimates to Quotes. I still see "Estimates" in the Zoho CRM integration. Could this be added to Translation settings so that some customisation could be made on an account by account
        • Its 2022, can our customers log into CRM on their mobiles? Zoho Response: Maybe Later

          I am a long time Zoho CRM user. I have just started using the client portal feature. On the plus side I have found it very fast and very easy (for someone used to the CRM config) to set up a subset of module views that make a potentially extremely useful
        • All new Address Field in Zoho CRM: maintain structured and accurate address inputs

          The address field will be available exclusively for IN DC users. We'll keep you updated on the DC-specific rollout soon. It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition. Latest update
        • New Series Announcement - Ecommerce Marketing Tips

          Running an online business is more than just having a website. It’s about getting the right customers to discover you, trust you, and keep coming back. To support your growth journey, we’re launching a weekly Marketing Tips series right here on Zoho Commerce
        • Marketing Tip #7: Add a blog to your online store

          A blog is more than content. It’s a magnet for new customers. Sharing product guides, styling tips, or industry insights through blog posts builds trust and helps you rank higher on search engines. Try this today: Write one blog post answering a common
        • Kanban view on Zoho CRM mobile app!

          What is Kanban? The name doesn't sound English, right? Yes, Kanban is a Japanese word which means 'Card you can see'. As per the meaning, Kanban in CRM is a type of list view in which the records will be displayed in cards and categorized under the given
        • Allow Regular Users to Directly Transfer Ownership of Files & Folders

          Hi Zoho WorkDrive Team, Hope you are doing well. We would like to request an important enhancement related to file and folder ownership management in Zoho WorkDrive. At the moment, a regular user cannot directly transfer ownership of their files or folders
        • Triggering rules on lead conversion

          There is no field on the Rule list for rule conversion to trigger an alert on liead conversion to a potential. I assigned a rule to file on any creation or update of a lead. The lead was changed a lead to a potential but no rule was fired. Rajesh Bhadra
        • Customised Funnel

          We are running the standard plan for our ZOHO CRM. I have been asked if there is a way to combine data from the Calls module, Deals module and Contact Module into 1 funnel, similar to the view you can get when viewing Deals By Stages, you can see the
        • Trigger Zapier on Deluge Insert Into Function?

          Hello, To get around the limitation of not being able to trigger a Zapier Zap on Record Update(this would be extremely useful to be able to do btw), I have created a Deluge script to copy the data from Form A to a Trigger Form B using the Insert Into expression from a Custom Action button on a Report from Form A.  This action does not trigger the Zapier Zap whereas manually adding a record or duplicating an existing record does trigger the Zap. Is Insert Into not the same as a manual Add in the context
        • Can you inject JS in an HML+CSS+Deluge Page?

          I have an HTML + CSS + Deluge page and need just a little vanilla JS functionality. However, it seems like Zoho Creator does not allow that. I'm required to create a JS widget. Is this correct? If so: 1. Won't this quickly consume my API limit if there
        • Display Client Name in Zoho Creator Client Portal Dashboard

          Hello Zoho Creator Team, We hope you are doing well. Zoho Creator recently introduced the option to set a client’s display name in the Client Portal settings, which is very helpful for providing a personalized portal experience. However, there is currently
        • Zoho unified inbox

          The new changes have definitely improved things for switching between accounts.  But zoho still desperately needs a unified inbox.  It sucks to have to enter filters and folders for each and every inbox.  This seems like such a simple thing, i wonder why Zoho hasn't done it?
        • Marketer’s Space - Multi-Channel Campaigns for the Biggest Shopping Week with Zoho Marketing Automation

          Hello marketers, Welcome back to another post in Marketers Space! The biggest shopping week of the year is almost here, and it’s your moment to shine without the stress. With Black Friday and Cyber Monday just around the corner, being present across email,
        • Is there a problem with sharing workdrive files with links since last night?

          As per title, we can't access folders/files through share links since last night. I created ticket but we need quick solution and didn't hear back from the support yet. The files are still accessible by the main account but all zoho files that we are
        • Enable Screen Recording in Zoho WorkDrive Mobile Apps (Android & iOS)

          Hi Zoho WorkDrive Team, How are you? We are enthusiastic Zoho One users and rely heavily on Zoho WorkDrive for internal collaboration and content sharing. The screen-recording feature in the WorkDrive web app (similar to Loom) is extremely useful- however,
        • Production Management Tool (MRP / BOM)

          Hi Guys, is there any recommended App available that works with zoho and covers the needed applications for a production? What we need is a system that covers the BOM (bill of materials), MRP (material ressources planning), MRP II (manufacturing ressources
        • Function #53: Transaction Level Profitability for Invoices

          Hello everyone, and welcome back to our series! We have previously provided custom functions for calculating the profitability of a quote and a sales order. There may be instances where the invoice may differ from its corresponding quote or sales order.
        • Bug in Zoho Cliq Signup Flow – "%s" Placeholder Visible Instead of Product Name

          Hi Zoho Team, I would like to report a UI bug in the Zoho Cliq signup/enable flow. During the step where Cliq asks to enable the product for the company, the following text appears: Great! Your company is already available in Zoho, so you just have to
        • Zoho Invoice Customer Login Portal

          Are there any plans for a customer portal to Zoho Invoice, ala Freshbooks?  I would like customers that I invoice to be able to login to review invoices and invoice history.  I have not switched from Freshbooks for this very reason.
        • Exporting tickets

          I went to Setup -> Organization -> Import/Export in order to export tickets but found 2 issues: 1. The email body never gets exported. 2. There are some large numbers (like 5.57E+16) under certain columns of the exported CSV file. I could not find any export options. Please can you help with this?
        • Editing the Ticket Properties column

          This is going to sound like a dumb question, but I cannot figure out how to configure/edit the sections (and their fields) in this column: For example, we have a custom "Resolution" field, which parked itself in the "Ticket Information" section of this
        • Copy field information to clipboard

          I need to be able to transfer some field information in to the clipboard, so that I can then paste it in to our helpdesk system. Is there a way I could add a button to a detail report that does this?
        • Issuing reconciling a bank statement

          HELP! I'm trying to reconcile a bank statement. The prior month reconciled perfectly. Beginning balance is correct yet I'm off by the same amount each time. Both myself and my office manager, separately and together, have tried to complete this reconciliation
        • Unknown table or alias 'A1'

          I would like to create a subquery but i am getting the following error: Unknown table or alias 'A1' used in select query. This is the sql statement:  SELECT A1.active_paying_customers, A1.active_trial_customers, A1.new_paying_signup, date(A1.date_active_customers), 
        • Detect and ignore bots in visitors

          The SalesIQ visitor numbers are basically useless to us because there is no bot detection. We get the same bots coming in from the same countries looking at the same pages every day. It can't be that difficult to tell the difference between an actual
        • Add Real-Time Microphone Audio-Level Indicator During Screen Recording

          Hi Zoho WorkDrive Team, Hope you are doing well. We would like to request an important enhancement to the Zoho WorkDrive screen-recording experience. Current Limitation: During a recording session, there is no visual indication that the microphone is
        • Zero Personalization of the File Sharing Experience

          By now (2025) this is the maximum level of personalization available for a Zoho sharing link. We gently asked Zoho if we could modify at least the background, and they replied that it cannot be customized. We're truly disappointed – and surprised every
        • External Share > Edit: Cannot Create Zoho Files

          Hi Zoho, When we create an external share link with Edit permission, our external users are unable to create a Zoho file (Zoho Writer, Zoho Sheet and Zoho Show). They can only upload files. They can edit the Zoho files if we create them internally and
        • Two factor authentication for helpdesk users

          The company i work for wants use the helpdesk site in Zoho desk, as a place for their distribution partners to ask question and look for information about our product. The things there is suppose to go up there is somewhat confidential between my company
        • Kiosk can't merge picklist or multiselect

          There is no ability to load a multiselect or picklikst field into a kiosk with the values that have been previously selected. So, I essentially have 3 unacceptable options: 1.)Load the value into a text string and include instructions like this: "Picklist
        • AGE field from DATE OF BIRTH Field.

          HI! I have a field called date of birth in my CRM (LEADS, CONTACT etc…)     How can I know the AGE today   I would like to create a field AGE. I now how to create a field but I don´t which calculation (CUSTOM FUCTION) to make ¿ANY HELP?
        • How to update/remove file in zoho creator widgets using javascript API

          Hi Team, I have developed a widget which allows inserting and updating records I have file upload field with multiple file upload. Now while doing insert form record, I am using uploadFile API to upload files for that record. I am using updateRecord API
        • Introducing Enhanced Storage Management

          We’re excited to roll out two new enhancements in Zoho Recruit, Subscription Information and Storage Management — designed to give admins complete visibility into subscription details, feature limits, and storage consumption — all from one place inside
        • Announcing new features in Trident for Windows (v.1.34.4.0)

          Hello Community! Trident for Windows just got better! With this update we have features that make your daily work easier and more efficient. We've added some features that are exclusive to our app and we're sure you'll find them useful. Let’s dive into
        • Report Hover Setting

          Would be great if we will able to show information to the user while hovering a record in a report.
        • Vertical images displayed as horizontal

          Some pictures that originally are in vertical position are displayed in horizontal after the upload. It seems that system rotates them by 90 degrees. How can I fix this issue?
        • Zoho Desk iOS app update: Saved filters and sort options

          Hello everyone! Saved filters created on the web(desk.zoho.com) for tickets are now accessible on the Zoho Desk iOS app. You can easily rename, delete, or clear filters on the go. We have also introduced Sort options on the ticket listing screen, allowing
        • Next Page