In order to help get you started, EZ Importer has a set of predefined templates for merchants not migrating from another platform or Shopify store.  Previously, when importing orders using these templates, the orders would always be marked fulfilled.  We've recently updated the templates to work with Fulfilled and unfulfilled orders, or you can map your fulfillment status.

Selecting Your Fulfillment Status

Our predefined templates do the data mapping for you and allow you to download the CSV file with the mapped …

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 …