When applying templates to active listings in bulk you may find it easiest to filter the list based on certain values. However, because the listing data doesn’t contain the same fields as the products screen, this can be difficult.
Fortunately, there is a method around this, by filtering via SKU separated by commas (SKU1, SKU2, SKU3, etc). You can generate your list of SKU’s by using the export wizard, and modify the file to copy and paste into the filter.
The below example shows you how to select listing with variations, however you can use any filters available in the export wizard.
From the Neto Dashboard navigate to Setup & Tools > Export Data.
Select Perform Complex Export and choose Start Data Export Wizard.
Name your file and Continue To Next Step.
Choose the fields you want to filter by clicking Add New Field To File, and selecting them from the drop down box. You also need to include SKU. When complete, Continue To Next Step.
Filter the products you want exported. In this example we’re getting a list of parent products, so the filter used is Has Child Product. When ready, select Continue To Next Step.
Set the Send Export File To drop down box to Local URL. This will save your file to your site, and give you a web address to download it from.
Check the box to save the export configuration if you wish, and click Export Now.
After 5 - 10 minutes the export will be completed and you can click the link to download and open your file. If you’re using Microsoft Excel, right click on the column header next to the SKU, and select Insert.
You’ll now have an empty column next to the SKU. Enter a comma (,) into each row, per SKU. Highlight all the SKU’s and commas, and copy it to your clipboard.
In the Neto Dashboard navigate to eBay > Active Listings.
Expand the filters and Paste the data from Excel into the SKU field, and select Apply Advanced Filter.
You’ll now only see active listings, where the linked product is a variation parent.
Tip: By sorting the Excel file (e.g. weight smallest to largest) you can also filter listings by values that aren’t in the export filters.