ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.http://mail.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 30, "salesperson_id": "345678901234567890", "line_items": [ { "item_id": "456789012345678901", "discount": 0, "quantity": 1, "description": "A test product description" } ], "shipping_address": { "address": "Test Street", "street2": "Test Street 2",...

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

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

17 October 2021 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 // use inventory_levels m_Variant.put("inventory_policy","deny");...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)http://mail.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 instead of: query: "sku:ABC 123" send query: "sku:'ABC 123'" The final graphQL for product id, variant id, inventory id, quantity, price barcode and handle? // // graphql v_SearchSKU = ifnull(v_SKU,""); v_GraphQl = "{ productVariants(first: 1, query:...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 productVariants(first: 10, query: "updated_at:>'2023-02-20T00:00:00+0000'") { edges { node { id price sku barcode inventoryQuantity inventoryItem { id } product { id title handle status createdAt publishedAt updatedAt } updatedAt } cursor } pageInfo {...

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

Zoho Creator: Disable/Hide the add and delete subform row buttonshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

28 February 2023 with a list of services. The client does not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero) alongside each serviceable item. How? So at time of print, this is the only way I know: add a note...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 payment. Date Modified: 2023-03-21 (Joel Lipman) - Added if conditions to not adjust stock level if item has enough quantity then that purchased - Adds tracking number and carrier to shipment record on either creation or modification. - Only creates...

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

Zoho Inventory: Enable Tracking using the APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 m_CreateBooksItem.put("reorder_level",0); m_CreateBooksItem.put("available_stock",v_QuantityAvailable.toLong()); m_CreateBooksItem.put("initial_stock",v_Quantity.toLong()); m_CreateBooksItem.put("initial_stock_rate",v_ItemPrice.toDecimal());...

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