Search - Joel Lipman .Com

1. 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
2. Prices get rounded up in Virtuemart: / Virtuemart /; This happened to a m8s website in VirtueMart 1.1.3. The issue here was that although all the prices lost their float/decimal and were rounded up to the nearest integer... At first we thought this was ...; Created on 27 September 2009
3. Zoho CRM: Updating a CRM record Custom Line Items using API v7: / Zoho /; ... apply changes to any of the line items l_NewLineItems = List(); if(!isNull(m_RecordData.get("id"))) { for each m_LineItem in m_RecordData.get("Quoted_Items") { m_NewLineItem = Map(); m_NewLineItem.put("id",m_LineItem.get("id")); m_NewLineItem.put("Description",m_LineItem.get("Description")); m_NewLineItem.put("Discount",m_LineItem.get("Discount")); m_NewLineItem.put("CUSTOM_FIELD_1",m_LineItem.get("CUSTOM_FIELD_1")); m_NewLineItem.put("CUSTOM_FIELD_2",m_LineItem.get("CUSTOM_FIELD_2")); m_NewLineItem.put("Product_Name",m_LineItem.get("Product_Name")); m_NewLineItem.put("Quantity",m_LineItem.get("Quantity")); m_NewLineItem.put("List_Price",m_LineItem.get("List_Price")); l_NewLineItems.add(m_NewLineItem); } } } // // ...; Created on 18 December 2024
4. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... em Price (BCY)" AS "PO Item Price", poi."Graded Score" AS "PO Item Grade", poi."Quantity" AS "PO Item Qty", poi."Quantity Billed" AS "PO Item Qty Billed", poi."Quantity Received" AS "PO Item Qty Rcved", ...; Created on 09 July 2024
5. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... Description Quantity Unit Price Unit Discount 0) { v_LineItemTotal = 0.00; v_ThisQuantity = ifnull(c_Quote.Quantity,1).toLong(); v_TotalQuantity = v_TotalQuantity ...; Created on 07 May 2024
6. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... record, they will get a validation error on the decimal field even if that's not the field that is being changed: Decimal places for the Unit Price field should be less than or equal to 6. How? ...; Created on 13 December 2023
7. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... each r_Result2 in r_SearchResults2.get("items") { if(r_Result2.get("item_name") == v_CrmProductName) { m_BooksLineItem.put("item_id",r_Result2.get("item_id").toLong()); m_BooksLineItem.put("name",v_CrmProductName); m_BooksLineItem.put("description",r_CrmLineItem.get("Description")); m_BooksLineItem.put("quantity",r_CrmLineItem.get("Quantity")); m_BooksLineItem.put("rate",r_CrmLineItem.get("List_Price").toDecimal().round(2)); m_BooksLineItem.put("discount",ifnull(r_CrmLineItem.get("Discount_Percent"),0 ...; Created on 18 September 2023
8. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... build the update or create request m_CreateBooksItem = Map(); m_CreateBooksItem.put("name",v_ItemTitle); m_CreateBooksItem.put("sku",v_ItemSKU); m_CreateBooksItem.put("rate",v_ItemPrice.toDecimal()); // // ...; Created on 04 May 2023
9. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? 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? ...; Created on 27 April 2023
10. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonProducts = List(); // // start preparing CSV file to email for export v_ReportCSV = "ItemID,ItemName,Price,CurrencyCode,QuantityAvailable,SKU,DateCreated"; l_CsvFileRows ...; Created on 01 March 2023
11. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... above within the same function to return a map. Note that this is for fixedpriceitems only. For auction ones, you would need to adjust the parsing code below to capture auction details. This includes ...; Created on 28 February 2023
12. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... and Zoho is the data to be overwritten, ensuring that Product IDs, Variant IDs, Inventory IDs, Current Selling Price, Inventory Level, and Barcode all match. Our problem is that sometimes more than ...; Created on 20 February 2023
13. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... ID" AS "PO Product ID", poi."Item ID" AS "PO Item ID", poi."Item Name" AS "PO Item Name", poi."Item Price (BCY)" AS "PO Item Price", poi."FCY Tax Amount" / if(poi."Quantity" = 0, 1, poi."Quantity ...; Created on 03 November 2022
14. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... all monitors are now connected to my home PC. The way to do this might be different for you depending on the components of your PC. So here's a list of what I used: TypeComponentQuantityPrice (GBP) Reused ...; Created on 12 March 2022
15. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... like: { "data": { "productVariants": { "edges": [ { "node": { "id": "gid://shopify/ProductVariant/123456789012345", "price": "450.95", ...; Created on 14 February 2022
16. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... include fixed price items m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage); m_Params.put("Pagination",m_Pagination); //m_ActiveList.put("Sort","ItemID"); m_Params.put("ItemID",p_ItemID); // // ...; Created on 22 January 2022
17. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
18. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; What? An article to save time where a customer wants to click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has ...; Created on 21 October 2021
19. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... / build up variant list under this product l_Variants = List(); m_Variant = Map(); m_Variant.put("weight",0.0); m_Variant.put("title",input.Listing_Title); m_Variant.put("sku",input.Product_SKU); m_Variant.put("price",input.Shopify_Unit_Sell_Price); m_Variant.put("taxable",input.Taxable); m_Variant.put("inventory_quantity",input.Quantity.round(0) ...; Created on 17 October 2021
20. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... a list of all the listed active products in a fixed price item listing. The example below is a function which, if given the page number and the number of entries per page, returns these in JSON as a Zoho ...; Created on 13 October 2021