There may be cases where your supplier uses a different SKU or barcode from what you use in your Shopify store.  Using Shopify Variant Metafields is a good way to track these. With this EZ Inventory update, you now have the option to map product variants in your Shopify store to products in your suppliers' feeds based on a custom variant metafield's value.

In the Data Feed settings, you can find this option under Field Mapping > Shopify Variant Field.  Select the …

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 …