How to Create a Shareable JSON Feed From a Google Sheets Spreadsheet Using Google Apps Script

Google Sheets supports exporting data to a bunch of formats such as CSV, Excel, and PDF.  However, it doesn't support exporting data to JSON.

While the most popular and widely used data export format is CSV, there are some platforms that don't support it.

This use case actually came up from a customer of our Shopify data export app, EZ Exporter, where they wanted to export a custom product catalog of their Shopify product data to use with Klaviyo …

Read more

EZ Exporter Update: Events (Timeline) Fields Now Available in Shopify Order Exports

EZ Exporter now supports order "Events" fields when exporting Shopify order data.  These "Events" are the entries displayed in the Order Timeline section of the Shopify Admin's order detail page:

In our app, the following fields can now be selected when creating an order export template:

events.action  Order Events Actions (type: text). A comma-separated list of actions that occurred.
events.app_title  Order Events App Titles (type: text). A comma-separated list of app names that created the events. …
Read more

EZ Exporter Update: New "Unlisted" Status in Shopify Product Exports

Shopify recently added an "Unlisted" status for products, which "hides products from store search and recommendations (including collections), all sales channels, internet searches and Shopify Catalog, while still allowing access via a direct URL"

EZ Exporter also now supports this new product status.  When you create a Data Settings for Product export, you should now see an option for "Unlisted" under Filters > Status:

If you need to filter based on a combination of different status values, use the  …

Read more

Automate Shopify Analytics Reports Export with EZ Exporter

EZ Exporter now supports a new Data Settings for "Analytics" data, which is available in the app's Premium Plan.

This new data type allows you to use the same ShopifyQL query in the Shopify Admin > Analytics > Reports to pull the same data.  Please note, however, that our app can only export a flat table (without the charts).

With this addition, you can now use EZ Exporter to automate export of your Shopify Analytics Reports and have the data …

Read more

EZ Inventory Update: Additional Info on the Activity Log Details Page

We've pushed an update to EZ Inventory's "Activity Log Details" page to show a summary count of items by update status (e.g. success, failure, skipped, removed).

You can also find a link on this page that allows you to quickly download a list of items that exist in the source data/inventory feed, but weren't found in Shopify.

In most cases, a supplier feed will contain a lot more items that the merchants carry in their store, so the merchants …

Read more