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

How does MAP-MSRP-Margin Work

How does MAP-MSRP-Margin Work?

The MAP-MSRP-Margin option will check for MAP first.  If MAP is available, that will be the product price.  If MAP is not available the system
How do I Become a Distributor for Turn 14?

How do I Become a Distributor for Turn 14?

Turn 14 lists all of their application information on their website here:  http://turn14.com/become_customer The main things are: The application and all instructions and who to contact
Select your currency