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

Connecting FastCo (Catalog)

Connecting FastCo (Catalog)

1. Open your Shopify store 2. Open the “Slingshot Automotive” app 3. Click “Settings” 4. Click “Catalogs” 5. Scroll down to “FastCo Catalog” and click
Barry Alt (left), Dan Ziegler (center), Jay Funnell (right) - Year, Make, Model, Money! Podcast

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

Turn 14 Distribution’s longstanding partnership with Data Here-to-There has helped countless ecommerce businesses integrate their inventory into Shopify and BigCommerce: “Jay reached out to us back in 2018, and we worked through the integration process. By the middle of the pandemic, we had launched the first Shopify app. It was the first time a company had approached us saying, ‘We want to build an app on a platform,’ and now it’s one of the most heavily used integration options available”, explains Dan.
Select your currency