Assuming price is required, the following 26 results were found.
-
"PO Ref", poi."Product 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") AS "PO Item Tax", poi."Quantity"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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 by going through forum posts from 7 years to 2 years ago. The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
(0)1234 567890 info@mycompany.com www.mycompany.com QUOTE Quote For: Quote Date: Quote By: Item Description Quantity Unit Price Unit Discount 0) { v_LineItemTotal = 0.00; v_ThisQuantity = ifnull(c_Quote.Quantity,1).toLong(); v_TotalQuantity =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= ifnull(p_SKU,""); v_GraphQl = "{ productVariants(first: 1, query: \"sku:'"+v_SearchSKU+"'\") { edges { node { id price sku title barcode inventoryItem { id } product { id } } } } }"; m_GraphQl = Map(); m_GraphQl.put("query", v_GraphQl); // // Send...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Calculating Percentagehttps://joellipman.com/articles/ecommerce/calculating-percentage.html
progress eg. ($8 / $10) * 100 = 80% ie. $8 of $10 is 80% To determine the percent (adjustment level) given the RRP and the price you're selling at: ((Agreed Price - Usual Price) * 100) / Usual Price = % eg. ($10 - $8) * 100 / $8 = +25% ie. selling an $8...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
of truth 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 100 products are modified in a day... We need...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
print, Zoho had recently introduced the ability to have custom fields in your line items, alongside the product name, list price, quantity, tax, etc. In the example below, we have added a column called "Group Name" in the CRM Quote module as per the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_NewLineItem.put("Quantity",m_LineItem.get("Quantity")); m_NewLineItem.put("List_Price",m_LineItem.get("List_Price")); l_NewLineItems.add(m_NewLineItem); } } } // // if there is reason to update it then let's update CRM API v7 style...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html
way by its authors. You can apply it to your programs, too. When we speak of free software, we are referring to freedom, not price. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
}, "data": { "member_id": "123456", "channel_name": "shopify", "item_name": "Joel's Awesome Life", "item_price": "priceless" } } What Zoho sends to the 3rd-party API: Sending a map request using the invokeUrl() function, the odd thing is that Zoho's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
po."Purchase Order Date" AS "PO Date", po."Purchase Order Status" AS "PO Status", poi."Item Name" AS "PO Item", poi."Item Price (BCY)" AS "PO Item Price", poi."Graded Score" AS "PO Item Grade", poi."Quantity" AS "PO Item Qty", poi."Quantity Billed" AS...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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? The workaround for staff is to round this up manually and then save the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
.sub-content{ margin-left: 14px; } Photo View List View Product Name #1 Product SKU #1 Product Description #1 Product Price #1 Product Name #2 Product SKU #2 Product Description #2 Product Price #2 Product Name #3 Product SKU #3 Product Description #3...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_LineItem_Name = r_QuoteDetails.Product_Name; v_LineItem_Desc = r_QuoteDetails.Product_Description; v_LineItem_Price = r_QuoteDetails.Product_List_Price; v_LineItem_Quantity = r_QuoteDetails.Product_Quantity; v_LineItem_TaxAmount =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is an article to document how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications API... Why? A follow on from my article Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
}, "quantity": 1, "Discount": 0, "total_after_discount": 0, "net_total": 0, "book": null, "Tax": 0, "list_price": 0, "unit_price": 0, "quantity_in_stock": 0, "total": 0, "id": "1642130000047106029", "product_description": null, "line_tax": [] } ],
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= Quotes.Line_Items(); r_Row.Product = m_LineItem.get("Product"); r_Row.Quantity = m_LineItem.get("Quantity"); r_Row.List_Price = m_LineItem.get("List_Price"); r_Row.Tax = m_LineItem.get("Tax"); r_Row.Discount = m_LineItem.get("Discount"); r_Row.Total =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a client's eBay store. Why? The use-case was that I wanted to retrieve 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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
- Language: *
-
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: *