Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming orders is required, the following 28 results were found.

  1. Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    this is just one way that we used that worked for 90% of the invoices. There are invoices that may be associated to sales orders changed after being confirmed or missing associated purchase orders altogether. I had to break this down into several...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

    An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this function too often either for debugging/monitoring purposes but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho Deluge: Get All Orders from eBayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

    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 of Zoho Inventory. In this task, we are simply getting a CSV...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a supplier, sent to another supplier for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    as option in advanced search: FUNCTIONALITY \components\com_search\views\search\view.html.php: // built select lists $orders = array(); $orders[] = JHtml::_('select.option', 'newest', JText::_('COM_SEARCH_NEWEST_FIRST')); $orders[] =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. ZohoCRM GetRelatedRecords INVALID_DATAhttps://joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

    Deals - Cancel Related Records Trigger: Standalone Purpose: For any deal which is cancelled, cancel its related sales orders. Inputs: - Outputs: - Date Created: 2025-01-30 (Joel Lipman) - Initial release Date Modified: ??? ??? More Information: Custom...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    description, tags and inventory details. This means the app needs to be able to sync all of its products, customers, and orders with Shopify as a 2-way integration as the Zoho app needs information from additional apps installed on the Shopify store....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

    invokeUrl. Why? Because my designers keep including custom fields in their transactional modules line items (quotes, sales orders, invoices, purchase orders). The only way to update these are by using the API and deluge function invokeURL rather than...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    to attach it to a CRM record. This works in the scenario where you have disabled the transaction modules in CRM (so Sales Orders, Invoices, Purchase Orders) and integrated your Zoho CRM with your Zoho Books. Why? Because then Zoho Books will create 3...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

    in r_ShopifyWebhooks.get("webhooks") { if(m_ThisWebhook.get("id") != null) { // // my app is the only one using the orders/updated webhook topic/trigger if(m_ThisWebhook.get("topic").equalsIgnoreCase("orders/updated")) { b_RestoreOrderUpdateWebhook =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho CRM & Zoho Books: Get SalesPersonshttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-salespersons.html

    = Map(); v_SalesPersonID = ""; // // eval v_BooksOrgID = 12345678901; r_SoDetails = zoho.crm.getRecordById("Sales_Orders",p_SoID); // // check if owner and get matching salesperson ID if(!isnull(r_SoDetails.get("Owner"))) { v_OwnerID =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho CRM: Standard Setup for Tax Rateshttps://joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

    users to be able to use these. Done, sorta To have this selectable for users in their transactional modules (quotes, sales orders, invoices, purchase orders), you need to modify each product record (can be done with "Mass Update") to give them the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

    to attach these files to. So for example, if you have a mix of files 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):...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. ZohoDeluge: Check Shipment Status via DHL APIhttps://joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

    purposes v_Date = zoho.currentdate.subDay(v_Index).toString("yyyy-MM-dd"); info v_Date; // // set criteria of what shipment orders to retrieve m_Criteria = Map(); m_Criteria.put("date",v_Date); // // retrieve all shipment orders for that day from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho CRM: Remove Duplicate Product Recordshttps://joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

    also try to delete the duplicate but if the duplicate is the one used in a transactional module record (eg. quotes, sales orders, invoices, purchase orders), then it will delete the older one (referred to as keep ID). Another point is that this is using...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Zoho Deluge: Connect to Shopifyhttps://joellipman.com/articles/crm/zoho/zoho-deluge-connect-to-shopify.html

    by Zoho) // where p_OrderID is the shopify order ID v_Endpoint = v_ShopifyURL + "/admin/api/" + v_ShopifyApiVersion + "/orders/" + p_OrderID + ".json"; r_GetOrder = invokeurl [ url :v_Endpoint type :GET headers:m_Header ]; info r_GetOrder; Now...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

    and its associates reserve the right to refuse service, terminate accounts, remove or edit content, or cancel orders in their sole discretion. Reviews, Comments, Emails, and Other Content Visitors may post reviews, comments, and other content and submit...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  18. Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

    this could get complicated if you had two dropdowns reading off the same list but needed to list elements in different orders. If you haven't made a dropdown list yet There's other instructions out there on the web but I thought I'd put what I did so...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  19. Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    to access that bit of information Zoho is reluctantly letting you have (such as comment information for estimates/sales orders/invoices). There are some quietly documented scopes granting absolute access: ZohoBooks.fullaccess.all...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. Why? At time of print, Zoho had recently introduced the ability to have custom fields in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 1 - 20 of 28

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.