Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 Here we need to loop through all the available pages, so including the above plus some calculation to work out how many times to loop should retrieve every thing: // // initialize l_AllProducts = List(); v_TotalCategories = 0; v_TotalProducts = 0;...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 time to store the record but that's it. Processing the record must be done at a later time or in a different process but sometimes it simply will not process it all and respond to Shopify within 1 second. How? So let's begin with the code snippets as...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 boolean to indicate deprecation notification.notificationId unique identifier of the notification notification.eventDate timestamp indicating when eBay user made the data deletion request notification.publishDate timestamp indicating when current...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 - Date Created: 2025-10-08 (Joel Lipman) - Initial release Date Modified: 2025-10-13 ( Joel Lipman) - Parsing Xero Dates and Times to include timezone of Xero instance for accurate time comparisons - Map Xero tax rates to Zoho tax rates (same names in...

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

ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 them into ZohoCRM Inputs: - Outputs: - Date Created: 2025-10-13 (Joel Lipman) - Initial release - Parsing Xero Dates and Times to include timezone of Xero instance for accurate time comparisons Date Modified: ??? - ??? More Information:...

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

ZohoBooks: Broken UK Banking Feedhttps://joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 I made along the way. When a Zoho Books bank feed stops syncing in the United Kingdom, there are a few possible causes. Sometimes the issue is with the bank or the Open Banking token, but other times the feed itself becomes stuck and cannot be refreshed...

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

Increment a column in MySQL using the UPDATE queryhttps://joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Change Regional Settings for your Reporthttps://joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 or the client machine. Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to UK format (dd/MM/yyyy). You can override this in the report by: Go to Design Select the View...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Reminder on SSRS row separatorhttps://joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 R2 (SSRS) What do I want? I have a report displaying room bookings. Each row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear between each day in the list, so I have: Monday...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Convert seconds to total time in PHPhttps://joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

31 January 2012 This is intended for activity/session durations and although I usually get MySQL to do the date/time calculations, there are times when we have to do with PHP. This is the shortest way I know to properly convert seconds into total hours, minutes and...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB