"Invalid value passed for Product ID" Error in Zoho Flow "Create Sales Order" Node

"Invalid value passed for Product ID" Error in Zoho Flow "Create Sales Order" Node

Hello Zoho Community,

I’m facing an issue with Zoho Flow while trying to create a sales order in Zoho Inventory using the "Create Sales Order" node. Here’s a detailed explanation of my setup and the problem:

What I’m Trying to Achieve

I’m building an automation in Zoho Flow to create sales orders in Zoho Inventory based on orders received from an external platform. The process involves:

  1. Fetching items from Zoho Inventory using their SKU.
  2. Creating a sales order in Zoho Inventory with the fetched items.

My Setup

  • I have a custom function (fetchItems) that fetches items from Zoho Inventory using the SKU via the Zoho Inventory API (/items endpoint). This function works perfectly and returns a list of items in the following format:
    json

    [ { "item_id": "XXXX", "quantity": 2, "rate": 151.56, "ean": "YYYY" } ]
    The item_id is fetched as a string from the API response and converted to a number using toLong() in some attempts (I’ve tried both string and number formats).
  • I then use a decision node to check if the fetchItems output is not empty (fetchItems_1.itemsList.size() > 0), which passes successfully.
  • Finally, I use the "Create Sales Order" node in Zoho Flow to create a sales order in Zoho Inventory. The node is configured as follows:
    • Organization: Correct organization ID (verified).
    • Connection: A Zoho Inventory connection with ZohoInventory.items.READ and ZohoInventory.salesorders.CREATE scopes.
    • Customer ID, Sales Order Number, and Sales Order Date: Populated from the trigger.
    • Items: I map the fetchItems_1.itemsList directly to the "Items" field using the "Insert Variable" option.

The Issue

The "Create Sales Order" node consistently fails with the error:

"Zoho Inventory says 'Invalid value passed for Product ID'"

What I’ve Tried

  1. Item ID Format:
    • Initially, I kept the item_id as a string (as returned by the /items API).
    • I also tried converting the item_id to a number using toLong() in the fetchItems function, but the error persists in both cases.
  2. Organization ID:
    • I verified that the organization ID used in the fetchItems function (for fetching items) and the "Create Sales Order" node is the same.
  3. Connection:
    • The connection used in the "Create Sales Order" node has the required scopes (ZohoInventory.items.READ and ZohoInventory.salesorders.CREATE).
    • I re-authenticated the connection to ensure it’s up to date.
  4. Item Status:
    • I checked the item in Zoho Inventory (via the UI) and confirmed that the item_id exists, the item is active, and it’s a sales item with available stock.
  5. Direct API Call:
    • As a workaround, I tried creating the sales order directly via the Zoho Inventory API (/salesorders endpoint) using a POST request in a custom function. However, I’d prefer to use the "Create Sales Order" node for simplicity.

Questions

  1. Why is the "Create Sales Order" node rejecting the item_id even though it’s valid and exists in Zoho Inventory?
  2. Does the "Create Sales Order" node expect the item_id in a specific format (string or number)?
  3. Could there be an issue with the connection or scopes that I might have overlooked?
  4. Are there any specific item settings in Zoho Inventory that could prevent an item from being added to a sales order?

Any help or suggestions would be greatly appreciated! I can provide more details about my setup if needed (without sharing sensitive data).

Thank you,


      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          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

                                  • Remove the “One Migration Per User” Limitation in Zoho WorkDrive

                                    Hi Zoho WorkDrive Team, Hope you are doing well. We would like to raise a critical feature request regarding the Google Drive → Zoho WorkDrive migration process. Current Limitation: Zoho WorkDrive currently enforces a hard limitation: A Zoho WorkDrive
                                  • Important Update: Google Ads & YouTube Ads API Migration

                                    To maintain platform performance and align with Google's newest requirements, we are updating the Google Ads and YouTube Ads integrations by migrating from API v19 to the newer v22, before the official deprecation of v19 on February 11, 2026. Reference:
                                  • Kaizen #228 - Process Large-Scale Migrated Data Using Catalyst Solutions

                                    Howdy, tech wizards! This week’s Kaizen explores how Catalyst Solutions in the Zoho CRM Developer Hub help import large volumes of data into Zoho CRM while improving data quality and simplifying the migration process. Why Catalyst Solutions? Catalyst
                                  • Zoho Expense Import Reports Won't Work Because Default Accounts Already Exist

                                    Im trying to import reports from another Zoho expense account to mine and im getting errors that won't allow the import to happen The account name that you've entered 'Ground Transportation' already exists. Enter another name for the account and try again.z
                                  • Inactive License for free account.

                                    I recently upgraded my Cliq subscription not my team (on the free version), are unable to login to their accounts. The error message received is Inactive License Looks like you have not been covered under the current free plan of users. Please contact
                                  • 2026 Product Roadmap and Upcoming Features

                                    This is your guide to what is coming in Zoho Vertical Studio throughout 2026. We’ll update this post throughout the year as items move from development to release, and as and when new initiatives are added. Once a feature is released, it will be reflected
                                  • Please, make writer into a content creation tool

                                    I'm tired of relying on Google Docs. I'm actually considering moving to ClickUp, but if Writer were a good content creation tool instead of just a word processor, I would finally be able to move all my development within the Zoho ecosystem, rather than
                                  • Syncing zoho books into zoho crm

                                    I was wondering how I can use zoho books in crm as I have been using them separately and would like to sync the two. Is this possible and if so, how? Thanks
                                  • Release Notes | January 2026

                                    We have rolled out a set of powerful new enhancements across Zoho Vertical Studio that bring several long-awaited capabilities to your applications. These updates focus on deeper customization, smarter automation, better reporting, and improved usability
                                  • Live Chat for user

                                    Hi everyone, I’m new to Zoho Creator and wanted to ask if it’s possible to add a live chat option for all logged-in portal users so they can chat internally. I’m trying to create a customer portal similar to a service desk, but for vehicle breakdowns,
                                  • Power up your Kiosk Studio with Real-Time Data Capture, Client Scripts & More!

                                    Hello Everyone, We’re thrilled to announce a powerful set of enhancements to Kiosk Studio in Zoho CRM. These new updates give you more flexibility, faster record handling, and real-time data capture, making your Kiosk flows smarter and more efficient
                                  • Announcing new features in Trident for Mac (1.34.0)

                                    Hello everyone! We’re excited to introduce the latest updates to Trident, which are designed to take workplace communication to the next level. Let’s take a quick look at what’s new. Connect with customers using Zoho Voice integration. You can now easily
                                  • Massive Zoho Books failure

                                    We have not received any communication or notification from Zoho, but we have detected that Zoho Books is not working for all our users. We cannot access or use Zoho Books. This is critical. We are trying to contact Zoho on the Spain telephone number,
                                  • The Social Wall: January 2026

                                    Hello everyone, We’re back with the first edition of The Social Wall of 2026. There’s a lot planned for the year ahead, and we’re starting with a few useful features and improvements released in January to help you get started. Create a GBP in Social
                                  • How to block whole domain?

                                    I am getting at least 50-75sometimes over 100 spams emails a day. I see a lot of the spam is coming from .eu domains. I would like to block /reject all email coming for the .eu domain. I do not have any need for email from .EU domains. Why won't the BlackList
                                  • How Zoho Contracts Makes Negotiations Clear, Secure, and Transparent

                                    Negotiation is one of the most critical—and often most chaotic—stages of the contract lifecycle. Multiple stakeholders review the same document, propose changes, debate terms, and exchange feedback. Without the right tools, this collaborative process
                                  • Error: Invalid Element tax_override_preference

                                    In both Books and Inventory, we're getting the following error whenever we try to enter any Bill: I think this is a bug. Even cloning an old bill (that obviously was entered just fine), this error occurs.
                                  • Assign Income to Project Without Invoice

                                    Hello, Fairly new user here so apologies if there is a really obvious solution here that I am just missing... I have hundreds of small deposits into a bank account that I want to assign to a project but do not want to have to create an invoice every time
                                  • How 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 Andrew
                                  • our customers have difficult to understand the Statements

                                    our costumers have big problems to understand Zohos Statements. we need a text box after the payment number to explain what the payments are for. Is it possible to develop a version of the Statement with that kind of box and if so whu can do it
                                  • How to track a list of ALL the items that ONE customer bought?

                                    Hello, I am interested in getting a list of all the items that only ONE of my customers bought, and the invoices are what show up instead. It's very tedious to go through every single invoice when we sell a lot of items to this customer. Surely there
                                  • Exchange Rate Updates

                                    Hi, It would be great that when you work with multiple currencies, the exchange rate updates automagically every day (as seen on Zoho Books) or at least that when you create/update an opportunity the exchange rate could be manually updated, or maybe both!
                                  • Locked Out of Super Admin Account

                                    I'm locked out of my Super Admin account and the external e-mail is no longer associated with it. There seems to be a problem during set up, the system ought to ask to assign a new password instead of using Google accounts. Please help me get back access.
                                  • Emails are going to notification folder and not in inbox

                                    emails are going to notification folder and not into inbox
                                  • 550 5.4.6 Unusual sending activity detected. Please try after sometime

                                    Hi, I am receiving this error message when trying to send my emails. The only reason I can think why this is happening is my previous two emails were bounced back to me due to a non working mailbox error. I have followed the online links for unblocking
                                  • Projects Home Customization

                                    Hello! We've been in Zoho One since July of last year, and my team has started providing feedback on what they'd like to do. Their latest wish is that they could have more control over the Projects Home content. For example, they want a card that shows
                                  • IMAP search support

                                    Does Zoho Mail support IMAP search? https://www.rfc-editor.org/rfc/rfc9051.html#name-search-command TEXT <string> Messages that contain the specified string in the header (including MIME header fields) or body of the message. Servers are allowed to implement
                                  • Performance is degrading

                                    We have used Mail and Cliq for about three years now. I used to use both on the browser. Both have, over the past 6 months, had a severe degradation in performance. I switched to desktop email, which appeared to improve things somewhat, although initial
                                  • Cannot reorder fields in Page Layout in Expenses and Purchase Requests

                                    It is very inconvenient that the custom fields in Page Layout cannot be re-ordered. The only way is to remove the fields and re-create them; however, it is impractical. This would affect the reports and dashboards we are having. Not able to re-order the
                                  • bouncing emails

                                    My recurring invoices have bounced back
                                  • Probable Scam / Phising attempt from email pretending to be Zoho

                                    I think this is a scam email right? It says "zohCworkplace.com". I'm on the Mail Free plan The link in the CTA button seems to go to a redirect. Just wanted to bring it up to the security team.
                                  • Email Address Search in "To" Field Search is broken, Zoho refuses to fix it

                                    Typing a part of the email address string other than the beginning of the string does NOT work, I kindly urge Zoho to fix this. Let's say you remember writing an email so someone called "smith" from company "corp.com", but can't remember their first name,
                                  • Emails not being received by @hotmail.com, @outlook.com and a few others

                                    When I try to send emails from zoho mail to people with email addresses ending @outlook.com and @hotmail.com (and a few others), I get a 'delayed' automatic email and then a few hours later, an 'undelivered' automatic email. This has started a few months
                                  • scroll bar for far left of screen

                                    I am unable to even see the scroll bar to the right of "inbox" etc on the left; it is stuck at "streams" and I can't get to inbox or anything else. It would help if it could be made a lighter color as the black or dark grey can't bee seen.
                                  • OUt of office every friday

                                    Hi, I tryed to configure my out of office, because i'm not working or emailing on fridays. But when i select only friday as unavailable day, the out of office still sets for the whole week. What am I doing wrong?
                                  • Signature line

                                    How do I set signature line in email
                                  • Zoho email

                                    I cannot send email to mail.ru
                                  • 【参加無料】東京 Zoho ユーザ交流会 NEXUS ー CRMで始めるマーケティング事例 / AI活用法(Zia Agents)

                                    ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 3月27日(金)に東京、新橋で東京 Zoho ユーザー交流会 NEXUS を開催します! 昨年度までより、さらにパワーアップして戻ってきました! ユーザー活用事例は、2人のユーザーさんからお話しいただきます。Zoho サービスの活用の幅を広げたい方や、他のユーザーの利用法を気軽に知りたい方など、多くの方にとって学びのあるセッションになること間違いなしです✨ また今年は、これまで以上に、AI機能にも焦点を当てて行く予定です。 初回として、Zoho社員からZoho
                                  • Issue Exporting Data – CSRF Token Invalid Error

                                    Dear Zoho Team, We are experiencing an issue when exporting data from our Analytics workspace. Whenever we attempt to export data from our analytical pool, the system displays the following alert message: Alert Message: The CSRF token is invalid. It could
                                  • Zoho Mail 505 error I can not send email

                                    Hi, I’m having issues sending emails from my custom domain email address. When I send emails to Outlook addresses, I receive an “Undeliverable 505” error. However, emails send and receive correctly when I use Gmail. This is important for my business,
                                  • Next Page