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!