EZ Inventory: Feed Data Filtering Now Available

We were working with one of our EZ Inventory customers recently and ran into an issue where their inventory feed contains inventory data for all their warehouses.

This wouldn't have been an issue if their store is enabled for multi-location inventory, but Shopify hasn't released this feature yet to merchants. It's currently only available for test/development stores.

In their specific case, they basically wanted to sync the inventory only from one of those warehouses in their feed with their Shopify store. Adding an option in EZ Inventory to do the data filtering directly would solve this issue, so that's what we did. :)

When you create a Data Feed configuration in the app, you will now see an option called "Filter Source Data." This feature is actually very flexible, you can select from many filter conditions:

  • is equal to (e.g. 1 = 1)
  • is not equal to (e.g. 1 != 2)
  • is equal to any (use a comma-separated list of values, e.g. "US" is equal to any of: "US, MX, CA")
  • is not equal to any (use a comma-separated list of values, e.g. "US" is not equal to any of: "AU, GB, CA")
  • contains (e.g. "slippers, shoes, socks" contains "shoes")
  • does not contain (e.g. "slippers, shoes, socks" does not contain "pants")
  • starts with (e.g. "SKU12345" starts with "SKU")
  • ends with (e.g. "SKU12345" ends with "345")
  • is greater than (e.g. 2 > 1)
  • is less than (e.g. 1 < 2)

You can combine multiple filters as well and specify whether to match any one of the conditions or all of them.

In the case of our customer, they basically just needed to filter their data feed based on the value of one of the fields/columns in their CSV file, something like this:

  • Warehouse Location is equal to XYZ

With this set, our app will only process the rows where the value of "Warehouse Location" field/column equals "XYZ."

Here's what this option looks like in our app to give you a better idea of what's possible:

EZ Inventory Shopify App - Data Filters

If you've used our EZ Exporter app before, you can see this basically looks just like the filters we use there. :)

As you can see from the screenshot, there are many possible combinations you can do here to filter your inventory feed data. We really hope that providing this option helps you manage your Shopify inventory better and reduce all those manual, time-consuming work.

Tags: new features, shopify, ez inventory, inventory management