Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 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)); // deprecated...

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

Zoho CRM Client Script: Map Quote to Invoicehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 = o_ThisLineItem._product_description; o_NewLineItem.Discount = o_ThisLineItem._Discount; o_NewLineItem.List_Price = o_ThisLineItem._list_price; o_NewLineItem.Quantity = o_ThisLineItem._quantity; o_NewLineItem.Tax = o_ThisLineItem._Tax; // going to...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 m_CrmProduct.put("Description",m_XeroLineItem.get("Description")); m_CrmProduct.put("Unit_Price",m_XeroLineItem.get("UnitAmount")); // // map over tax (even if it's zero) v_XeroLineItemTaxAmount = ifnull(m_XeroLineItem.get("TaxAmount"),0).toDecimal();...

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

ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 { m_CrmProduct.put("Description",m_XeroLineItem.get("Description")); } m_CrmProduct.put("Unit_Price",m_XeroLineItem.get("UnitAmount")); // // map over tax v_XeroLineItemTaxAmount = ifnull(m_XeroLineItem.get("TaxAmount"),0).toDecimal();...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

12 March 2022 might be different for you depending on the components of your PC. So here's a list of what I used: Type Component Quantity Price (GBP) Reused components Monitor Acer K242HL 2 ~@£100.00 (at time of purchase) Monitor Dell U2414Hb 3 ~@£250.00 (at time of...

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

Zoho CRM: Standard Setup for Tax Rateshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-standard-tax-rate-setup.html

02 September 2021 to a CRM product record (you can do mass edit on a listview of products but for demo purposes, we'll do just one) Under Price Information, edit the field "Tax" (multi-select) and select both tax rates Now go to a transactional module that has line items...

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

Zoho Creator: eBay: Get Item Transactionhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-item-transaction.html

22 January 2022 m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ItemReturnCategories"); // // include fixed price items m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page); m_Pagination.put("EntriesPerPage",v_PerPage);...

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

ZohoCRM: Get All eBay Active Listingshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-all-ebay-active-listings.html

01 March 2023 = Map(); l_JsonProducts = List(); // // start preparing CSV file to email for export v_ReportCSV = "ItemID,ItemName,Price,CurrencyCode,QuantityAvailable,SKU,DateCreated"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // get access token...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 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) + "%");...

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

Checklist for the local computer repairshttps://joellipman.com/component/content/article/checklist-for-the-local-computer-repairs.html?catid=116&Itemid=165

28 April 2011 Newsletter Business Cards Extra RAM (to charge for) Extra Cables (again to charge for) Service: Software installs at flat price Website development per hourly rate Computer repair per hourly rate "I always had work order forms in duplicate. Right above...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Free Translator API using Googlehttps://joellipman.com/component/content/article/free-translator-api-using-google.html?catid=61&Itemid=165

08 January 2013 added itself to the fray pretending to offer free services but in the small print, you will find they too charge the same price. How? The Google Translate API still actually exists. Just don't try to exceed your free quota: Visit...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Prices get rounded up in Virtuemarthttps://joellipman.com/articles/else/e-commerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

27 September 2009 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 due to installing a Virtuemart UK Credit Card...

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