Search - Joel Lipman .Com

1. Static Items: / Category /; Created on 05 March 2020
2. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; What? A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? ...; Created on 03 February 2022
3. 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
4. Zoho Deluge - Modify the product line items in an invoice module: / Zoho /; ... record: v_Index = 0; m_Update = Map(); l_ProductItems = List(); r_InvoiceDetails = Map(); r_InvoiceDetails = zoho.crm.getRecordById("Invoices",p_InvoiceID); for each r_ProductLineItem in r_InvoiceDetails.get("Product_Details") { ...; Created on 22 August 2019
5. Ordered List of over 1000 Items: / Cascading Stylesheets /; What? So many people asking this when the solution is a bit of aesthetic styling. ol -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item ...; Created on 08 February 2013
6. K2 Items disappear: / Joomla /; Basically you've woken up this morning, visited your website, and all your K2 articles are gone !!!! If you login to your Joomla! administration panel (back-end) and look under k2 items, you should ...; Created on 27 August 2010
7. 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
8. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... adding label because -3 often displays "Net 56" instead. m_InvoiceDetails.put("payment_terms_label","Due end of next month"); // // loop through line items and populate for each m_SOLineItem in l_SalesOrderLineItems { ...; Created on 06 July 2023
9. 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
10. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... Marked Items as inclusive of VAT so VAT reports in Books will be accurate (eg. £499.95 is correctly £416.62) Date Modified: 2023-02-23 (Joel Lipman) - Check if ebay Order ID already exists on ...; Created on 27 April 2023
11. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
12. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... that asked, in this case Zoho Inventory. So for this, I've set up a nightly schedule which checks on all the shipments from a certain date and updates the shipment status for items that have been delivered: ...; Created on 21 March 2023
13. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
14. 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
15. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... of each item purchased; including shipping and tax. The second is to associate these to the invoiced items and work out the profit. The third is to group by the sales person, date, and customer so as ...; Created on 03 November 2022
16. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... the line items from a package slip taken from Zoho Inventory. I'd prefer if it was included in the list view or a Zoho Creator report. How? We would think it similar to a picklist/dropdown where ...; Created on 18 August 2022
17. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... set the data type r_DownloadedPhoto.setParamName("image"); // // build up request to Zoho m_Params = Map(); m_Params.put("image",r_DownloadedPhoto); // // generate endpoint v_Url = "https://books.zoho.eu/api/v3/items/" ...; Created on 21 June 2022
18. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... the scope(s) ZohoInventory.items.READ (add some more if you're unsure...) Give it a connection name and note down the connection link name. I'm calling mine joel_zoho Authorize it, etc. Make a ...; Created on 31 March 2022
19. 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
20. 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