... and restore them.
The Code Snippets: The Shopify Order Update notification
First create a CRM function called Shopify - Webhook - Order Notification. It's a standalone function but you'll need to ...
... + "/wp-json/wc/v3/products/categories";
l_PaginationParams = List();
l_PaginationParams.add("page=1");
l_PaginationParams.add("per_page=100");
l_PaginationParams.add("order_by=id");
//
// we have no ...
... (aka the Quote Builder) will need to post a new quote to the system as well as show previous orders.
How?
We're going to use the Zoho Extension SDK. You should refer to my previous linked article ...
... you can lock it down to just the scopes you need.
void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID)
{
v_OrderID = ifnull(input.p_OrderID,0).toLong();
/* *******************************************************************************
Function: ...
... has the scopes as specified in the function header. Also note, that this Zoho instance is in the EU datacenter (zoho.eu) rather than the US datacenter. The most important tweak in order for the below ...
... but in the United Kingdom, the week generally starts on a Monday. So let's say there's a schedule that has to be run weekly and include all the orders of a specific week...
Just to confuse everyone ...
... 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
{
...
... key here to enable inventory tracking
m_CreateBooksItem.put("item_type","inventory");
//
// other less important values to include re purchase information
m_CreateBooksItem.put("product_type","goods");
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());
m_CreateBooksItem.put("inventory_account_id",m_Accounts.get("Inventor ...
... "id": "123456789000000123456789",
"type": "custom"
}
}
Tidied Up
Want that in a practical format for use in ZohoCreator? Preferably not in the Zoho order, but that of the normal wee ...
What?
A quick note here on how to connect to the DHL API and check on a package given a tracking number.
Why?
In our megafunction to generate a customer, a product/item, a sales order, an invoice, ...
... build up COQL query
v_CoqlQuery = "select Content, Role from GPT_Chats where Owner='" + v_LoggedInUserID + "' order by Created_Time asc";
//
// build up parameters
m_Params = Map();
m_Params.put("select_query",v_CoqlQuery);
//
// ...
... ", ",").toList();
for each index v_Increment in l_AddPages
{
l_Pages.add(v_StartingPageIndex + v_Increment);
}
v_TotalNumberOfPages = l_Pages.size();
//
// declare variables to store order details ...
... to be by order of cursor alphabetically; but we were happy with the results the above code did anyway so I haven't tried this.
Source(s):
Shopify Dev - Paginating results with GraphQL
...
... = (v_Page - 1) * v_PerPage;
v_ToIndex = v_FromIndex + v_PerPage - 1;
//
// note that ordering here seemed to do nothing... it's in an order, not sure what order. Let's loop through every page anyway.
l_Candidates ...
... that will be attached to Contact records and Sales Orders, you will need to include at this step the "Contacts_001.csv" and "Sales Orders_001.csv" (preferably taken from a backup):
Watch the spinning ...
... for future use. The use-case is the client has their own delivery drivers and want them to mark a sales order & package as shipped and delivered.
How?
Here's a code snippet that works for me. It ...
What?
Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page.
Why?
Cos
How?
The below is a template ...
... form to download the attachments and upload them to the Creator "Document" form:
//
// get attachments
v_NoteAttachments = "";
m_SortCriteria = Map();
m_SortCriteria.put("sort_by","Created_Time");
m_SortCriteria.put("sort_order","desc");
l_Attachments ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.