What?
This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway).
My Data:
Account ...
What?
A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters.
Why?
I use MS Excel for organizing data and then converting to MySQL commands. ...
... contents background (white) shows.
When I visit a very long page on the site, the contents background disappears and reveals the overall background (blue) making the text very hard to read.
Why? ...
... > Functions: then hover your mouse over the function and select "REST API". Enable the API Key option and copy the long URL to your clipboard for use in the above function:
Set up a schedule
If ...
... product count as products can belong to multiple categories. Consider just using the WooCommerce interface to check the total number of products (wp-admin > Products > All Products).
Source(s):
WooCommerce ...
... HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers):
//
// Generate a CSV of a ...
... 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: ...
... Functions"
Click on the Plus icon alongside this, scroll down to "Custom Functions" and click on "New"
I give it the function name fn_Tickets_OnCreateEdit
I click on "Edit Arguments" and give it th ...
... to be unable to handle a lot of code or long URLs such as a base64 source URL for an image.
The Plan
Get company phone and website from Organization Details in ZohoCRM.
Upload and get publicly-accessible ...
... you have sent the code to either create or update the estimate in ZohoBooks. You will need the returned estimate ID and I'm not 100% sure the attention/phone number goes along as my client didn't include ...
What?
A quick article on getting the payment terms in Zoho Books along with their IDs.
Why?
I often need to send through an automatic payment term on the creation of an invoice but lots of my ...
What?
A super quick article on resolving this issue if it ever appears again.
Why?
At time of print, this error was happening to schedules in Zoho Books, Zoho Inventory, and Zoho Subscriptions. ...
What?
One of these articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory:
Why?
Who uses ZohoInventory ...
What?
A quick article on the SPF & DKIM setup to improve email deliverability from a ZohoApp and methods to check.
Why?
Not sure how I came across it as most of our customers don't use ZohoMail, ...
What?
This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records...
Why? ...
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 ...
... ChatGPT Plus possibly exposing email addresses that belong to random users] 2023-03-20
Like my previous article, this needs to be fed contextual data to continue a conversation Done 2023-03-11
...
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 ...
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.