How to find a specific sku in the filter report

The filter report provides some useful insight into why products are not loaded into your store.  Are they missing images?  Require LTL shipping but LTL is disabled?  The report will show you each part number that is rejected and why.

Start by downloading your filter report in the Turn14 app.

Once downloaded, we highly recommend viewing this report in google sheets, as it handles larger spreadsheets a bit better and the following function is much easier to use.

Upload the file to your google drive, and right click, “Open with”, then Google sheets.

Data Here-to-There Inc. | How to find a specific sku in the filter report

If you are looking for a specific SKU, just open the file up directly and use Ctrl+F to open the find window, enter the SKU and hit enter, and you should see the reason that SKU was filtered out.

Data Here-to-There Inc. | How to find a specific sku in the filter report

Here, we see our example SKU was filtered out due to having no images.

Data Here-to-There Inc. | How to find a specific sku in the filter report

Here is a video that goes further in depth.

Share:

More Scribes

multi location inventory

Multi Location Inventory

Previously we had all skus showing a single location called the “Slingshot App”, however we received a lot of requests

Add your Comment

Stay Connected

More Updates

Barry Alt (left), Dan Ziegler (center), Jay Funnell (right) - Year, Make, Model, Money! Podcast

The Year, Make, Model, Money! Podcast, Episode 2, Part 3

In this third part of our conversation with Dan Ziegler, we dig into what truly makes the Turn 14 Distribution app the game-changer for automotive dealers. With candid dealer feedback, behind-the-scenes design debates, and powerful automation at its core, Part 3 pulls back the curtain on what it really takes to build tech that works in the real world. If you’ve ever lost hours to spreadsheets or had a MAP violation nearly jeopardize a vendor relationship, this one’s for you.
Select your currency