UI Feature to export all products from a catalog/collection

Avatar

Avatar

mikewebguy

Employee

Avatar

mikewebguy

Employee

mikewebguy
Employee

28-05-2019

It would be so nice if there was an easy way to export all products form a Catalog or Collection. BrendanJaffary

2 Comments (2 New)
2 Comments

Avatar

Avatar

BrendanJaffary

Avatar

BrendanJaffary

BrendanJaffary

04-06-2019

This being a UI feature to export all products from a catalog/collection to an Excel file.

Avatar

Avatar

BrendanJaffary

Avatar

BrendanJaffary

BrendanJaffary

28-08-2019

I'm bumping this idea.

Summary

We need to have a feature that can mass delete entities based on a filter. I manage a catalog of over 400,000 entities so running a full catalog deletion is a huge impact to the business.  There is no real solution to manage your catalog as the comma delimited string for singular deletion requires the user to have a list of entityIDs to delete which they are not able to export from the catalog.

In the documentation, it states that the more entities in your catalog, the longer your criteria’s will take to process.  I’ve also noticed that the larger my catalog is, the less accurate the recommendations are.

Temporary Solution

Through a recommendation of a forum user... once you filter your catalog to whatever your deletion needs are, you can override the API call in the network tab of developer tools to expand the pagesize of the call.  Just simply adjust the pagesize in this network call : "target/products/productSearch.halosearch.at.json?pageSize=10". Once you have the data, you can parse through it to get all of the entityIDs, concat them into a comma delimited string and send the request off.

This is a poor solution as both the query and the delete command can't handle more than 10,000 entities at a time and requires additional development work.  I tried to write an application to manage this locally but ran into CORS issues with the API.  I'm sure that these APIs arent intended to handle this amount of data either.

Ideal Solution

The most ideal solution would be:

  • Filter the catalog by “lastModifiedDate”  **Currently not an available filter but data is available in catalog**
  • Add any additional filters
  • Export the data to an Excel file for further analysis on the data as the Catalog UI lacks sorting functionality
  • Batch delete all of the entities within the filtered selection

Being able to filter by “lastModifiedDate” is essential as it will identify entities that haven’t been viewed by users in a long period of time, often indicating that the entity isn’t available anymore.