Products export only exports maximum 5000 rows/products. A big problem if you have tens of thousands of products requiring bulk updates
We have over 30,000 products within C&D and the quantity grows almost every week as new products come in. We have been using C&D for quite a few years now and over the years some of the data within C&D has become corrupted. For example, we have found that over the years, the original and correct item weights stored within C&D can often get overwritten by mistake with completely wrong values. These wrong values then get carried forward continuously leading to a number of surcharges in the form of "Admin Charge for underdeclared or mis-declared " packages. These surcharges have now built up into significantly large amounts over the course of each billing period! Therefore we wanted to clean all our data within C&D and make certain that all products had the corrects weights etc again.
So we thought that we would download a report from C&D containing all our products within C&D so that we could simply correct the weights etc wherever necessary within Excel and then reupload/update the corrected data back into C&D. However we noticed that C&D only exports 5000 rows/products of data (even when there are no filters etc active on the Products grid). We have already been through these 5000 products and corrected/uploaded the data to C&D where necessary. However, every time we do a Products export from C&D it gives us roughly the very same 5000 products in the excel file. There might be a few hundred new products in each report we download but by and large every report contains pretty much the same 5000 products.
This means we are now stuck and cannot check through the 25,000 or so other products and make any corrections in bulk via excel etc which would be the easiest way to complete this task. The only way we can update the other products seems to be manually and one by one within C&D directly which is obviously completely infeasible for 25,000 products!
Please remove the 5000 row restriction from the Products Export (when there are no filters etc active on the Products grid) so that the Export function then does actually export all our products as we would expect and we can then easily correct and update any data where necessary. Thank you.