How To

How to Identify and Remove Duplicate eBay Listings: A Step by Step Guide

With the implementation of eBay's duplicate listing policy it is very important to manage your fixed price eBay listings and make sure that you are not posting duplicate listings. Below are steps that can be taken to easily identify and remove your ebay duplicate listings. You will need to create the four filters and then sort the data in Excel.

 

Prerequisites 


You should be familiar with the following topics before continuing:

 

Tasks to Complete


By creating a series of advanced filters within your ChannelAdvisor account you will be able to easily locate all of your duplicate eBay listings and remove them. Follow these steps to create all of the necessary filters for this process.

  1. Filter 1: Identify Duplicates To create a filter in the inventory view entitled Identify Duplicate
  2. Filter 2: Flagged
  3. Filter 3: Duplicates to Withdraw
  4. Sorting for Duplicates in Excel
  5. Block Additional Duplicate Listings

 

Filter 1: Identify Duplicates To create a filter in the inventory view entitled Identify Duplicates

  1. Navigate to your Inventory > All Products view.
  2. Click on Create next to the advanced filter and enter the following:

Running this filter will bring up all items that have more than 1 ad, but they are not necessarily duplicates. The resutls from this filter will include both Auction and Fixed Price Ads in the count. You will then need to complete the following steps:

  1. Increase the page size to 500, to get the maximum results per page.
  2. Click the Select column header to check the select box for all items on that page.
  3. Click the Flag button.
  4. Select a flag.
  5. Enter Duplicate as your description.
  6. Repeat this process for any additional pages, 500 at a time.

 

Filter 2: Flagged

To create a filter in the ads view entitled Flagged.

  1. Navigate to Marketplaces > eBay > Product Mapping > Ads view.
  2. Click on Create next to the advanced filter and enter the following:

 

Note: Please note that if you are listing on eBay Motors, the second field in the filter will need to be "eBay Motors Fixed Price US" instead of "eBay Fixed Price".

Running this filter will bring up the ads for all of the SKUs you flagged in the inventory view. The actual flags themselves are not going to be visible, but the results will be filtered accordingly. You will then need to complete the following steps:

  1. Increase the page size to 500.
  2. Click on the column header SKU to sort the results by SKU name. Your duplicates will now appear together and will be easier to spot.
  3. Go down the list and check for any SKUs that have more than one ad. Decide on which ad to keep if there are multiples for the same SKU, mark the others.
  4. Click the Remove Schedule button. This will remove the schedule from those duplicates so that they won't automatically relist.
  5. Repeat this process for any additional pages, 500 at a time.

Please note:

  • If you have a large number of results in the Ads view, and prefer to sort them in Excel, please see the Sort for Duplicates in Excel section below.
  • You can also repeat the steps above for Auction listings, but use Auction instead of Fixed Price in the applicable filters in the Ads view.

 

Filter 3: Duplicates to Withdraw

To create an additional filter in the ads view entitled Duplicates to Withdraw

  1. Navigate to Marketplaces > eBay > Product Mapping > Ads view.
  2. Click on Create next to the advanced filter and enter the following:

  1. Click the Select column header to check the select box for all items on that page.
  2. Click the Withdraw Listings button.

Once the listings have closed, you may wish to delete these ads from your account.

 

Sorting for Duplicates in Excel

If you have a large number of listings in the Ads view you may want to sort these ads using excel instead of manually scrolling through the results in the Ads view. After creating and running the Filter 2 above entitled Flagged follow these steps:

  1. Click the Export button to export the results to Excel.
  2. Open the spreadsheet in Excel.
  3. in Excel do the following:
    • Use a conditional formatting rule to identify duplicate values. The target column should be the one containing your sku names. You can actually do this in a number of ways. But if you choose to highlight duplicates, you can then sort by cell color. (Choose a conditional formatting rule and sorting method that works best for you). Once you have sorted your results by duplicates, you will still need to select the ones you want to remove. You should plan to keep one ad for any particular sku, and mark the additional ads for that sku as duplicates.
    • In the Ad Schedule Column, enter the text _DELETE_ (include underscores).
    • The only columns you will need are the Ad ID and the Ad Schedule columns. Delet all the other columns.
    • Save as a Text (Tab delimited) file.
  4. In ChannelAdvisor's Ads view do the following:
    • Upload this newly saved file in Ads view, using the Bulk Upload Ads link. (When you do this, the assigned ad schedules will be deleted from those Ad IDs).
    • Amend your previous filter or create a new one with the following options:
  5. Resume the steps outlined in the previous section, following the image for filter 3 entitled Duplicates to Withdraw.

 

Block Additional Duplicate Listings

Once you have identified your duplicate ads, you will also want to stop duplicate listings from being submitted to eBay. The Duplicate Listing Block can be used to stop these listings from going live, even if they are accidentally created and scheduled to go live.

With the implementation of eBay's duplicate listing policy it is very important to manage your fixed price eBay listings and make sure that you are not posting duplicate listings. Below are steps that can be taken to easily identify and remove your ebay duplicate listings. You will need to create the four filters and then sort the data in Excel.

 

Prerequisites 


You should be familiar with the following topics before continuing:

 

Tasks to Complete


By creating a series of advanced filters within your ChannelAdvisor account you will be able to easily locate all of your duplicate eBay listings and remove them. Follow these steps to create all of the necessary filters for this process.

  1. Filter 1: Identify Duplicates To create a filter in the inventory view entitled Identify Duplicate
  2. Filter 2: Flagged
  3. Filter 3: Duplicates to Withdraw
  4. Sorting for Duplicates in Excel
  5. Block Additional Duplicate Listings

 

Filter 1: Identify Duplicates To create a filter in the inventory view entitled Identify Duplicates

  1. Navigate to your Inventory > All Products view.
  2. Click on Create next to the advanced filter and enter the following:

Running this filter will bring up all items that have more than 1 ad, but they are not necessarily duplicates. The resutls from this filter will include both Auction and Fixed Price Ads in the count. You will then need to complete the following steps:

  1. Increase the page size to 500, to get the maximum results per page.
  2. Click the Select column header to check the select box for all items on that page.
  3. Click the Flag button.
  4. Select a flag.
  5. Enter Duplicate as your description.
  6. Repeat this process for any additional pages, 500 at a time.

 

Filter 2: Flagged

To create a filter in the ads view entitled Flagged.

  1. Navigate to Marketplaces > eBay > Product Mapping > Ads view.
  2. Click on Create next to the advanced filter and enter the following:

 

Note: Please note that if you are listing on eBay Motors, the second field in the filter will need to be "eBay Motors Fixed Price US" instead of "eBay Fixed Price".

Running this filter will bring up the ads for all of the SKUs you flagged in the inventory view. The actual flags themselves are not going to be visible, but the results will be filtered accordingly. You will then need to complete the following steps:

  1. Increase the page size to 500.
  2. Click on the column header SKU to sort the results by SKU name. Your duplicates will now appear together and will be easier to spot.
  3. Go down the list and check for any SKUs that have more than one ad. Decide on which ad to keep if there are multiples for the same SKU, mark the others.
  4. Click the Remove Schedule button. This will remove the schedule from those duplicates so that they won't automatically relist.
  5. Repeat this process for any additional pages, 500 at a time.

Please note:

  • If you have a large number of results in the Ads view, and prefer to sort them in Excel, please see the Sort for Duplicates in Excel section below.
  • You can also repeat the steps above for Auction listings, but use Auction instead of Fixed Price in the applicable filters in the Ads view.

 

Filter 3: Duplicates to Withdraw

To create an additional filter in the ads view entitled Duplicates to Withdraw

  1. Navigate to Marketplaces > eBay > Product Mapping > Ads view.
  2. Click on Create next to the advanced filter and enter the following:

  1. Click the Select column header to check the select box for all items on that page.
  2. Click the Withdraw Listings button.

Once the listings have closed, you may wish to delete these ads from your account.

 

Sorting for Duplicates in Excel

If you have a large number of listings in the Ads view you may want to sort these ads using excel instead of manually scrolling through the results in the Ads view. After creating and running the Filter 2 above entitled Flagged follow these steps:

  1. Click the Export button to export the results to Excel.
  2. Open the spreadsheet in Excel.
  3. in Excel do the following:
    • Use a conditional formatting rule to identify duplicate values. The target column should be the one containing your sku names. You can actually do this in a number of ways. But if you choose to highlight duplicates, you can then sort by cell color. (Choose a conditional formatting rule and sorting method that works best for you). Once you have sorted your results by duplicates, you will still need to select the ones you want to remove. You should plan to keep one ad for any particular sku, and mark the additional ads for that sku as duplicates.
    • In the Ad Schedule Column, enter the text _DELETE_ (include underscores).
    • The only columns you will need are the Ad ID and the Ad Schedule columns. Delet all the other columns.
    • Save as a Text (Tab delimited) file.
  4. In ChannelAdvisor's Ads view do the following:
    • Upload this newly saved file in Ads view, using the Bulk Upload Ads link. (When you do this, the assigned ad schedules will be deleted from those Ad IDs).
    • Amend your previous filter or create a new one with the following options:
  5. Resume the steps outlined in the previous section, following the image for filter 3 entitled Duplicates to Withdraw.

 

Block Additional Duplicate Listings

Once you have identified your duplicate ads, you will also want to stop duplicate listings from being submitted to eBay. The Duplicate Listing Block can be used to stop these listings from going live, even if they are accidentally created and scheduled to go live.

0
Your rating: None Average: 4.5 (2 votes)
0
Your rating: None Average: 4.5 (2 votes)