Google Sheets has an IMPORTRANGE function that allows you to import a range of cells from another spreadsheet and requires you to enter the spreadsheet's URL.

But what if you just want to reference data from another sheet within the same spreadsheet?

A simpler approach is to use the QUERY function instead.

A Quick Example

We can use this formula to pull the values from columns A and B of Sheet1:

=QUERY(Sheet1!A:B)

Here's the …

JSON data feed format is now supported in EZ Inventory!

This allows you to upload a JSON file or use a web feed/REST API endpoint that returns JSON data as a data source when updating the inventory quantity of products/variants in your Shopify store.

The JSON data just needs to have a list of products and you can specify the specific key that contains this data in the app. If the data structure has a variants subfield, …

We've recently pushed an update to our EZ Inventory Shopify app which allows our users to specify additional HTTP headers when pulling their product/inventory feeds.

A use case that came up was when one of our customer's supplier feed recently made a change to their website to require a 'User-Agent' header before the web request is accepted. So having this option took care of the issue.

There are other use cases where being able to specify a custom …

For a long time, Airtable has supported access to their API via a single API Key per account. The API Key gives full access to all the user's tables and bases.

The downside of this approach, of course, is security and key management. Some apps may just need read access, but there was no way to generate a read-only key previously. Also, if multiple apps are using the same API Key, revoking/renewing the key will affect all of them.

EZ Importer, our Shopify app that allows you to import orders from CSV files to Shopify, now allows you to add order Metafields to your orders. Adding Metafields to your order is a configuration option similar to the way you replace values in your file or if you want to add default fields.

Data Mapping Configuration

To add Metafields to your order, open the Metafields Configuration section of your data mapping and add the Metafield you want …