Not all skus are returned on the product/sku specification spreadsheet
Catalog
•
ID: 649316
Fixed
Published on8/31/2022
•
Last updated on11/25/2022
1 min read
Summary
This behavior happens when a category has a lot of specifications and a lot of skus. That way, when exporting the spreadsheet eventually the excel limit is gonna be reached (around 65k).
When this happens, the spreadsheet won't return an error, it will only cut out the skus that are over this limit.
The result is that not all skus will be returned on this scenario.
Simulation
- Export a product/sku specification spreadsheet;
- Verify that is on the excel limit;
- Verify if the category has a large number of specifications and skus on it;
- Check that some skus are missing on the spreadsheet.
Workaround
A workaround would be to check if the specifications need to check if the specifications need to exist on a higher level of the category or just on a lower level. That way fewer skus and specifications would be returned and the limit would be harder to reach.