ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? I'm storing this here as a reference and taking the bits that I...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 [ url : v_PriceBookEndpoint type :GET parameters: m_Params connection:"zbooks" ]; // // tests show this only returns the 1 relevant item from a pricebook of many more items l_PriceBookItems = ifnull(r_ThisPriceBook.get("items"),{}); for each...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 already but we don't expect staff to go to another app to check on this and would rather see it directly in ZohoCRM on the relevant record. So the more observant among you will have noted that I'm recording the module name and module record ID on the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

SQL: Use CASE for Relevance columnhttps://www.joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

03 August 2013 and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *