Need advice for product/item search functionality when adding invoices.

Need advice for product/item search functionality when adding invoices.

My client uses "Catalog or Vendor" name and Product code to search for his items. But Zoho only allow to search by product name and SKU when adding items to Invoices/Estimates.

Clients product codes are not unique as they may overlap from different catalogs/vendors. Often the vendor name is a link to webpage. Best solution I have came up is to create SKU codes that look like "(CATALOG/VENDOR)-PRODUCT_CODE", but because often VENDOR value is some web page and product code may be some free text - it will generate some extremely weird SKU codes. For example "(https://greatcups.com?name=coffee)Green master set".

Is there any solution for this problem, Ideally I would like to search by Item custom fields. I know I can search for item custom fields with API, so the functionality is available somewhere under the hood. We can develop zoho functions/webhooks or anything else that could help.

Thank you for the advice!

      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 コンテンツ






                                ご検討中の方