Search - Joel Lipman .Com

1. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; 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? ...; Created on 27 April 2023
2. Zoho Deluge: Get All Orders from eBay: / Zoho /; 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 ...; Created on 29 March 2023
3. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? 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 ...; Created on 28 February 2023
4. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... in Zoho Analytics as we can't control the out-of-the-box PNL report that comes with Zoho Books. We needed a dataset that took into account "Delivery" as a separate line item on the purchase order. I' ...; Created on 03 November 2022
5. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
6. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; What? I probably won't forget this but just in case I do, this is an article to explain how I got the shipping address from a sales order in Zoho Books into the template of the Package Slips. Why? ...; Created on 07 October 2021
7. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... API... Why? A follow on from my article Zoho Creator: Push to eBay Listings. I have a Creator app that needs to receive the orders from an eBay account as soon as the order or transaction is made ...; Created on 20 September 2021
8. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; What? This is an article to document how to use Zoho Deluge to download a file that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books. Why? Because it ...; Created on 15 May 2020
9. Zoho Deluge: Associate/Link an Invoice to a Sales Order: / Zoho /; What? This is an article because there was no documentation that I could find that describes how to do this. When an invoice is created, not by clicking on the "convert sales order to invoice" button, ...; Created on 10 March 2020
10. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... application which lists all the Google Chrome Profiles on your Windows 10 workstation in alphabetical order. Why? This program will be redundant if Google ever update their Chrome browser to list ...; Created on 07 January 2020
11. CSS Ordered List 1, 1.1...1.10 Formatting and Alignment: / Cascading Stylesheets /; What? A quick article to remind me on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to ...; Created on 10 July 2019
12. SSRS Border Problem: / SQL Server Reporting Services /; What? A very quick note on why borders may be misbehaving in SSRS. This note corrects the situation at Design time. This is where you are trying to select a cell to have an outline border but then ...; Created on 20 January 2014
13. Oracle: order by subquery missing right parenthesis: / Oracle PL/SQL /; ... the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue. I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g ...; Created on 05 December 2013
14. Reorder Columns in a Table: / Databases /; What? Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns ...; Created on 22 July 2013
15. Ordered List of over 1000 Items: / Cascading Stylesheets /; What? So many people asking this when the solution is a bit of aesthetic styling. ol -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item ...; Created on 08 February 2013
16. Excel PivotTable Filter List Ordering: / Excel /; ... dropdown appears with all available values listed. The Problem The values are listed in alphabetical order at first. If any new values come along then they get added to the bottom of the list... ...; Created on 05 September 2011
17. Sort order a dropdown list in MS InfoPath without programming: / Infopath /; ... put elements in the order that I entered them in the datasheet. Googling this led me to browse MSDN for an hour before I realised all those experts were using programming solutions that seemed a ...; Created on 21 July 2011
18. Border settings not saving in SSRS: / SQL Server Reporting Services /; This may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells ...; Created on 24 March 2011
19. Frontpage Item Ordering: / Joomla /; Having trouble ordering your frontpage articles? After re-ordering articles wondering where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick ...; Created on 16 September 2010
20. Change default order of weblinks: / Joomla /; It took a few google searches until I could find out how to change the default weblinks order. A lot of websites showed how to do this via the admin back-end panel in the advanced configuration... I ...; Created on 15 November 2009