Remove duplicate products with the Unique Rows Filter

Remove duplicate products with the Unique Rows Filter in Productsup.

If you need to remove duplicate rows from the Productsup Platform completely, then you can do so using the unique rows filter service. You can define which attribute should be checked for uniqueness.

You may also consider skipping unique values directly in an export feed.

Note

Make sure you have set a product identifier to use this service.

Add the Unique Rows Filter

In order to add the Unique Rows Filter, you should:

  1. Navigate to your site

  2. Navigate to Data Services on the left-hand tab

  3. Click add service

  4. Add the Unique Rows Filter service

  5. Give the service a name (if desired)

  6. Define a custom column prefix (if desired)

  7. Click add

  8. Select the column where you wish to filter for uniqueness under the uniqueness column drop-down menu

  9. If a product is not unique based on this column, select whether you wish to keep the first or last occurrence of this product

  10. Click save

unique.png

For example, you may use the Unique Rows Filter to achieve the following scenario. You only wish to import the first occurrence of every id and remove all duplicates.

Before

id

title

stock

1

Amazing Shoes

4

1

Amazing Shoes in blue

4

2

Great Jeans

1

3

Wonderful T-Shirt

5

3

Wonderful T-Shirt in green

4

Using the above configuration, (uniqueness column is title, occurrence is first) our result would be:

After

id

title

stock

1

Amazing Shoes

4

2

Great Jeans

1

3

Wonderful T-Shirt

5

Edit an existing Unique Rows Filter

In order to edit settings for your Unique Rows Filter, you should:

  1. Navigate to your site

  2. Navigate to Data Services on the left-hand tab

  3. Click on the settings wheel

Delete an existing Unique Rows Filter

In order to delete your Unique Rows Filter, you should:

  1. Navigate to your site

  2. Navigate to Data Services on the left-hand tab

  3. Click on the settings wheel

  4. Scroll to the bottom of the page and click remove this service