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

EZ Inventory: Option to Specify the Minute in Hourly Sync Schedules

We've just pushed out an update to EZ Inventory to allow our users to specify the "minute" portion of the hourly sync schedule.

In the past, all inventory update jobs scheduled to run hourly will start at the top of the hour. However, we've seen a case recently where a supplier's feed also gets updated/rebuilt hourly at the same minute, which sometimes causes the job to fail as the feed wasn't yet ready and had incomplete data.

With this update, …

Read more