Code Archives - joeybabcock.me

Shopify Liquid Array Code Snippets

April 11th, 2024

Shopify’s native support of arrays is… Iffy at best, completely inadequate at worst. There are workarounds for most standard operations, [More…]

Shopify Dawn – Add Search Bar as a Theme Section

March 26th, 2024

For some reason, there is no section to add a search bar to the Dawn theme so I repurposed the [More…]

Shopify Section “Validation failed: Liquid syntax error: Unknown tag ‘schema'” solution

March 12th, 2024

While starting a new theme I got the error message “Validation failed: Liquid syntax error (line 336): Unknown tag ‘schema’” [More…]

Ninebot Command Generator V2

February 11th, 2024

I’ve created a GUI below to create custom commands based on my older version.

Amazon MCF getFulfillmentPreview ‘Value NotEligibleForExport for parameter Item is invalid.’

January 12th, 2024

While attempting to submit an MCF order, I started encountering the following response from the SP-API: Value NotEligibleForExport for parameter [More…]

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

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”)

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

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

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

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

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…]