EZ Inventory: Using Formulas for Mapping Product Variants in Shopify

EZ Inventory has supported using formulas for inventory quantity updates for quite some time now.  This allowed our users to use conditional logic and other data manipulation against their supplier feed's data when updating the quantity in Shopify.

We've just pushed an update to extend this functionality for mapping items from their supplier's feed to product variants in their Shopify store.  This option is now available in the Data Feed settings:

Since most merchants don't have the option to modify or customize …

Read more

Google Sheets Tip: Compare Two Columns and Extract Missing Values

You may run into a situation where you  need to compare two spreadsheets and figure out which values exist in one but not the other.

For example, if you run an ecommerce store where your supplier provides you a spreadsheet of their inventory that's constantly changing, you may need to figure out which new products exist in the data feed that you currently don't have published in your store.

One way to figure this out is to export the current product data …

Read more

How to Manage Inventory Across Multiple Sites

It almost goes without saying that one of the main goals of running an e-commerce site is to increase sales and be successful. In this day and age, though, it can be a little difficult to manage such a feat. With the need to maintain visibility, be alluring, and increase profits, among other things, it may seem like you're working with the cards stacked against you. Chances are, you know the deal and you want to give yourself as many …

Read more

3 Ways to Better Manage Back Orders

There is no way around it. As often as many store owners try to avoid it, back orders can happen to the best of them. It's unavoidable when a particular product may be extremely popular. While this may seem like a good thing for your profits, it can also spell bad news for you as a store owner. Most consumers don't want to wait for anything and hardly anyone subscribe to delayed gratification. That doesn't mean that an instance of …

Read more

5 Profitable Channels to Sell Your Overstock

As an e-commerce store owner, you're thinking of all of the year-end things you need to do, I'm sure. One thing plaguing you is what to do with all of this excess inventory you possess. You may have a few items left over from a time earlier in the year that didn't sell too well to being with. Or perhaps you simply ordered too many of them and the supply was greater than the demand. Maybe you're just making room …

Read more