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!