"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

                                  • Zoho Flow + QuickBooks Estimates – Line items not created from CRM subform

                                    Hi everyone, I’m trying to create QuickBooks Estimates from Zoho CRM Quotes using Zoho Flow. I’m aware that Zoho Flow’s native “Create Estimate” action does not support multiple line items, so I followed the community guidance for Invoices using a custom
                                  • SAP S/4 HANA Integration via ZOHO Flow

                                    Hi How do I change the SAP Client ID while creating a new connection ? MY client ID is 421. I believe the client id should be an input field for length 3 numbers rather then a drop down to select from a fixed set of values. Thanks
                                  • VLOOKUP FUNCTION PROBLEM

                                       Hello, i have a problem with the VLOOKUP  function in my sheet http://public.sheet.zoho.com/public/tonimoreno/indicemasacorporal2 in cell D2. This function doesn't work correctly and always returns the last content of the range. Can you help me?
                                  • Zoho Flow Completely Broken?

                                    Since December 13th, 100% of our flows have stopped working completely. Nothing is working or triggering??? I called support & sat on the line with them for 2 HOURS until they finally concluded it was a back-end problem on their end?? Now i'm calling
                                  • Print / Export full Dashboard page

                                    Hello Zoho team, It is currently only possible to print/export one component of a dashboard at a time. Requesting the option to print/export a full dashboard page with all components to a pdf or picture. Doing through the browser doesn't give good results.
                                  • emails duplicated in my outlook client

                                    Hello I am just new here and I have a litle problem that I do not find how to solve. I sumarise here after. Your help would be very appreciated. I have just recently contracted this zoho mail servicesservices as an initial evaluation yesterday night. I then:   - opened a free account  - created 1 initial email address ..........@domain.com  - created a second email address ..........@domain.com - proceeded with the config instructions (checking the ownership of my domain, changing MX etc... ) as
                                  • How to check task starting time in zoho mobile app?

                                    I am using the Zoho mobile app on my iPhone, and I am not able to see the task's starting and finishing times. When opening the Task information / Details, I can only see the Task start date and due date, but not the time. Is there any way to check a
                                  • Creating an extension in Sigma: Zoho CRM isn't selectable as a service

                                    I have 2 Zoho accounts which are part of 2 different workplaces. One workplace is able to select 'Zoho CRM' as a service option when creating a new extension, the other one is not. I'm not sure what the exact differences are between them. What do I need
                                  • List of packaged components and if they are upgradable

                                    Hello, In reference to the article Components and Packaging in Zoho Vertical Studio, can you provide an overview of what these are. Can you also please provide a list of of components that are considered Packaged and also whether they are Upgradable?
                                  • Cliq iOS can't see shared screen

                                    Hello, I had this morning a video call with a colleague. She is using Cliq Desktop MacOS and wanted to share her screen with me. I'm on iPad. I noticed, while she shared her screen, I could only see her video, but not the shared screen... Does Cliq iOS is able to display shared screen, or is it somewhere else to be found ? Regards
                                  • Knowledgebase SEO

                                    We have a custom-domain mapped help center that is not restricted via login. I have some questions: a) will a robots.txt file still allow us to control indexing? b) do we have the ability to edit the sitemap? c) do category URLs get indexed by search
                                  • RouteIQ for Zoho FSM

                                    Beste, Zou wel top zijn dat we een RouteIQ hebben voor FSM aangezien we constant moeten zien wat de beste route is voor onze monteurs. Nu moeten we een speciale aparte programma hebben om de beste route te berrekenen voor onze monteurs aangezien de planning
                                  • Export Tickets from the Help Center

                                    Hello everyone! We are now allowing end users to export tickets directly from the help center. The ticket export allows users to: Filter tickets by Department, Priority, and Account before exporting. Download files from Export History (Setup > Data administration
                                  • Super Admin Logging in as another User

                                    How can a Super Admin login as another user. For example, I have a sales rep that is having issues with their Accounts and I want to view their Zoho Account with out having to do a GTM and sharing screens. Moderation Update (8th Aug 2025): We are working
                                  • Is it possible to remove filtering options?

                                    My CRM has a lot of custom fields that should not be used in filters or views. Fields that are automated and exist only to store temporary values that get used in functions. These create a lot of noise in the list of fields to filter. Isn't there any
                                  • Function #18: Associate invoice templates automatically based on customer language

                                    For businesses dealing with a diverse linguistic clientele, it becomes crucial to send out invoices in the customer's preferred language to ensure effective communication. This requirement can be handled in Zoho Books by creating invoice templates in
                                  • Changing field types

                                    Question im a Zoho CRM user and curious, if I change a flied type from single or multi line text to a URL field type will i lose the data in the field or will it be converted to website link automatically. Thanks
                                  • Quote PDF – Header image stopped rendering suddenly

                                    Hello Zoho Support Team, We are facing an issue with Quote PDF templates in Zoho Books. Previously, images added inside the Quote header HTML were rendering correctly. However, recently the header image is no longer appearing, while header text still
                                  • Changing Default PDF Name

                                    Is it possible to change the default name of a PDF? As of right now, all of my quotes are named 'QT_$QuoteNumber' (i,e: 'QT_19803471298374) - would it be possible to change this to: '$CompanyName - $AccountName - $QuoteNumber' for instance?
                                  • Tip 2: Recursive functions in Deluge: How to dynamically run a function for a specified number of times.

                                    Hi folks, As part of the Zoho Creator - Tips and Tricks series every fortnight, we are back today with a new tip on Recursive functions.  Let us first quickly understand what Recursive functions are: A function that calls itself one or more times is known as a Recursive function. That is, you can execute a function to perform a particular action a specific number of times. And, at the end of each iteration, a new output is generated. Recursive functions are commonly used by programmers as it enables
                                  • Function #48: Manage fixed installment payments using Zoho Books

                                    Hello everyone, and welcome back to our series! Businesses offer installment payment options to their customers, particularly for expensive purchases, to ease the financial burden on them. By breaking down the total cost into smaller, more manageable
                                  • Function #1: Convert an accepted Estimate to Sales Order automatically in Zoho Books

                                    As you’re aware, Zoho Books provides a default option to have the estimates automatically converted to invoices once your customer accepts them. Many of you wanted a similar option for sales orders, so here’s a workflow that converts accepted estimates
                                  • Spotlight series #6: The Show app for Android TV has a new look!

                                    Hello everyone! We are delighted to introduce our revamped and redesigned Show app for Android TV.  Smart TVs are exploding in popularity. Android TV alone has over 110 million active monthly devices. Zoho Show, as part of a constant effort to improve
                                  • Employee Appraisal Applicability - Why is Date of Joining Hard-Coded?

                                    In the new (to me, at least) Performance Appraisal Cycle wizard, it's possible to set criteria to determine for whom the appraisal process should apply. This makes sense on its face. However, one MUST use the Date of Joining criterion as a filter. Why
                                  • Zoho Books integration sync from Zoho CRM does not work

                                    Hi Zoho Community & Zoho Support We just tried to get a sync some products into Zoho Books from CRM using the native sync and we're getting an error: "It looks like some mandatory fields you're trying to map are empty. Please provide valid field names
                                  • Appraisals - Order of Previous Reviews Should Be Newest to Oldest

                                    The new Zoho People layout generally does a decent job at providing the necessary information for performing appraisals of employee performance. One example of this is the Previous Reviews section: This information is helpful when conducting a review.
                                  • auto close automated alert tickets which are similar

                                    Hello ZOHO Community, we are using ZOHO Desk to process automated monitoring alerts. Scenario: Our monitoring system creates a ticket when a threshold is exceeded, e.g. Subject: Computer 1 – CPU usage 100% – Error A few minutes later, once the issue resolves
                                  • Paging through API results. a major gap in your documentation.

                                    There is no way for me. to get all of my data through a single API call. Typically REST APis have mechanisms for paging through API results. But the documentation for the API I am using: https://desk.zoho.com/DeskAPIDocument#Introduction Has no mention
                                  • Recurring invoices were generated with old template...

                                    I have recurring invoices setup. Ones generated on 10.20.2025 used the modified template I had used. But for some reason, on the ones created on 11/20/2025, it seems the invoices created reverted to the previous version of the invoice template. Notably,
                                  • Write-Off multiple invoices and tax calculation

                                    Good evening, I have many invoices which are long overdue and I do not expect them to be paid. I believe I should write them off. I did some tests and I have some questions:  - I cannot find a way to write off several invoices together. How can I do that,
                                  • Leave Report Emailed Weekly

                                    I am wondering if someone knows how to have a report generated either weekly or monthly or both for department heads and ownership of upcoming employee leave. For instance, it would be nice to get an emailed report on Friday for the upcoming week of who
                                  • Zoho desk desktop application

                                    does zoho desk has a destop applicaion?
                                  • Tip #54- Exploring the Files Icon in Zoho Assist- 'Insider Insights'

                                    As we’re already in mid-December, it’s a good time to take a closer look at one of the most useful options in the Zoho Assist remote support dashboard—the Files icon. To get started, log in to Zoho Assist using your credentials. Once you’re in, navigate
                                  • Tip#47: Estimation planner

                                    Sprint planning becomes easier, smoother, more collaborative and more accurate with the Estimation Planner extension. Most work items involve multiple users, and each user's role and effort vary. To provide an unbiased and fair estimation point to the
                                  • Painfully Slow Zoho mail

                                    Since yesterday Zoho Mail seems to have starting functioning very slowly and having a few bugs. It's slow to open mails, slow to send, slow to change between email accounts. Sometimes clicking on a particular folder (eg Sent folder) stops working and
                                  • Upcoming update to Google Drive integration in Zoho Creator

                                    Hello everyone, We're writing to inform you about an upcoming update to how Zoho Creator integrates with Google Drive. In Zoho Creator, during actions like importing files to create an app or attaching files to fields, you can choose files directly from
                                  • Time Tracking on Iphone doesn't stop

                                    When I start a time tracking session the timer starts as expected. However when I hit stop, the timer remains on that project. The only buttons available are discard and start. Start runs the timer more and discard says it will throw away the data from
                                  • Zoho Sign - Zoho CRM extension upgrade

                                    Hi everyone, We've updated Zoho Sign extension for Zoho CRM with significant internal changes. Impact on existing Zoho Sign extension users Users using the extension without customization If you are using the integration without implementing Zoho Sign's
                                  • Zoho Books blocks invoicing without VeriFactu even though it is not mandatory until 2027

                                    I would like to highlight a very serious issue in Zoho Books for Spain. 1. The Spanish government has postponed the mandatory start of VeriFactu to January 1st, 2027. This means that during all of 2026 businesses are NOT required to transmit invoices
                                  • Group by Owner/ Owner Kanban /Group by Custom Field

                                    Hi, We are missing the option of viewing Tasks grouped by their owner, as it is an essential function for us to manage our employees' working tasks. We find it hard to inspect what are the tasks that our employees are working on.  We are seeking an option
                                  • Next Page