Code

Ninebot Command Generator V2

Ninebot Command Generator V2

February 11th, 2024

Using the ScooterHacking.org command API, I’ve created a GUI below to create commands. Fill out the form below to get [More…]

Shopify Liquid Get Video URL From Section Video Input

Shopify Liquid Get Video URL From Section Video Input

October 18th, 2023

As with all things Shopify, the video input on a section settings schema is not as straightforward as it probably [More…]

CSS Interactive Pulse Animation/Effect

CSS Interactive Pulse Animation/Effect

August 22nd, 2023

While working on a “tap to interact” overlay, I needed a pulsing tap animation and ended up with this quick [More…]
Shopify Fix Missing field “priceValidUntil” (in “offers”)

Shopify Fix Missing field “priceValidUntil” (in “offers”)

July 18th, 2023

Shopify’s dawn theme will cause a warning in Google Search Console. Missing field “priceValidUntil” (in “offers”) While this warning does [More…]
SQL: Update/Set Table Field To All Lowercase

SQL: Update/Set Table Field To All Lowercase

July 10th, 2023

Here’s a short snippet that I recently used to remove some camel case records and make them lowercase. UPDATE `table` [More…]
NetSuite PHP Toolkit – Get Internal ID from SKU

NetSuite PHP Toolkit – Get Internal ID from SKU

June 15th, 2023

I’ve been working a lot with NetSuite’s PHP Toolkit. While NetSuite works with “internal ids”, most merchants likely work with [More…]
SQL: Replace All HTTP Links/URLs with HTTPS

SQL: Replace All HTTP Links/URLs with HTTPS

May 6th, 2023

Here’s a short snippet that I recently used to replace a bunch of old HTTP links with the now-supported HTTPS. [More…]
SQL: Remove/Strip Newline Characters From Field

SQL: Remove/Strip Newline Characters From Field

April 12th, 2023

On MacOS, Sequel Ace imports CSV’s with newlines at the end. This snippet updates the data to remvoe those lines: [More…]
Shopify Translate & Adapt: Which section settings/input types are translatable?

Shopify Translate & Adapt: Which section settings/input types are translatable?

March 22nd, 2023

Shopify recently released the Translate & Adapt app to allow store owners to easily translate content for different markets. In [More…]
NetSuite PHP Toolkit: Get Item By Internal ID

NetSuite PHP Toolkit: Get Item By Internal ID

March 20th, 2023

The NetSuite PHP Toolkit is surprisingly fully featured but not very well documented. This will be the first of several [More…]
Shopify Access Metaobjects With Liquid

Shopify Access Metaobjects With Liquid

February 15th, 2023

Shopify recently released their Shopify Editions 2023, highlighting new features and updates to the platform. One of these new features [More…]
PDO/PHP Batch Inserting Records to Improve Speed

PDO/PHP Batch Inserting Records to Improve Speed

January 25th, 2023

While making a remittance checker I was running into issues with the huge amount of records coming in that needed [More…]