If you have a spreadsheet that has a column with a comma-separated list of values (like URLs), you can easily combine them and create a separate row for each one in Google Sheets using a formula like this:

=TRANSPOSE(SPLIT(JOIN(",", Sheet1!B2:B), ","))

The formula above references column B of Sheet1, where each row's Column B is a comma-separated list of URLs for each product on a Shopify store.

Here's what the formula does:

1. JOIN(",", Sheet1!B2:B): This part of the formula combines all …

Today, we're excited to announce that EZ Fulfill now has built-in templates to make it easier to get started.  If you're familiar with EZ Exporter and EZ Importer, then you've had experience with our built-in template system and are probably familiar with how much time this feature could save you.

You can download the template file, which will be in CSV or Excel format (depending on the template you are using), or use the template to create a data feed.  …

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 data in Sheet1:

We'll enter the formula in …

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, our app can …

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 header could come …