Search - Joel Lipman .Com

1. Products: / Category /; Created on 05 March 2020
2. Product Documentation: / Category /; Created on 05 March 2020
3. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; What? A quick article on retrieving all the products from a WooCommerce instance on a client's Wordpress website. Why? A client of ours wants the information entered against products in their WooCommerce ...; Created on 15 April 2024
4. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; What? An article to resolve my frustration in being able to ONLY retrieve the first 100 products using GraphQL, so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most ...; Created on 20 February 2023
5. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
6. Zoho Creator / Shopify: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's Shopify. Why? The use-case was that I wanted to search ...; Created on 12 October 2021
7. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... photo to CRM: // init v_AppOwner = "joel_the_awesomest"; v_AppName = "joels_app"; v_ReportName = "My_Report"; // specify your CRM record ID for this product v_CrmProductID = 1234567890123456789; // ...; Created on 27 September 2021
8. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; What? This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. ...; Created on 17 May 2021
9. Zoho Deluge - Modify the product line items in an invoice module: / Zoho /; What? This is a reminder on how to swap out a product in an invoice. Why? A client wanted one of their products to be swapped out with another as they had a 3rd-party feed that kept creating a ...; Created on 22 August 2019
10. VBScript to retrieve Windows Product Key: / Windows OS /; What? A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as ...; Created on 23 September 2015
11. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024
12. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... product photo c_Product = Products[ID == c_Quote.Product]; if(c_Product.count() > 0) { v_ProductPhotoFile = c_Model.Product.getSuffix("http").getPrefix("\"").getSuffix("/image/"); v_ProductPhotoURL ...; Created on 07 May 2024
13. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... notification Note that this one is not the "Inventory Item Update" as I get the two muddled up very often and they don't do the same thing. We want this triggered whenever the stock level of a product ...; Created on 22 April 2024
14. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... Report in ZohoCreator l_CsvLines = List(); l_ApplicableProducts = Products[Display_in_Widget=="Yes"] sort by Product_Name; for each c_Product in l_ApplicableProducts { l_CsvRow = List(); l_CsvRow.add(c_Product.Photo); l_CsvRow.add(c_Product.Product_Name.replaceAll(",", ...; Created on 25 March 2024
15. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... photos of the faulty products. These display fine in a Zoho Creator report and even show up on the preview when exporting to PDF. But when you download the PDF and view this outside of the Zoho instances, ...; Created on 26 January 2024
16. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; What? This is an article detailing the client script to fix any fields which exceed their decimal places limit in ZohoCRM. Why? So we have a customer that has some decimal fields on the products ...; Created on 13 December 2023
17. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... to ZohoAnalytics using the API. The use-case here is that a client wants customers to submit ZohoDesk tickets and upload photos of the problematic product to the ticket. They then want an Analytics ...; Created on 05 December 2023
18. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... examples I use in production systems: Pre-amble: I'm applying to a Zoho Instance on the US Datacenter (.COM) These examples are using CRM REST API v5 but you can use these as far back as CRM REST ...; Created on 14 November 2023
19. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... ---------------------- QUOTE LINE ITEMS ---------------------- // line items get via api v2.1 or greater l_BooksLineItems = List(); r_CrmProductLineItems = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes/ ...; Created on 18 September 2023
20. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... and that's only half of the production system's contacts. I needed a quick bit of code to find any duplicates, all within the Zoho Creator app using Zoho Deluge and avoiding the use of any third-party APIs. ...; Created on 12 July 2023