I was trying to export a customer list to a CSV file in Magento 2 (2.2.7).
But every time I try it comes up with a 500 error regardless of how many customers are included in the export.
Exporting sales works fine so it's not an error with exporting generally.
I've checked the developer console and it comes up with a js error.
Looking in the logs I also found the following error message:
GET
/myadmin/mui/export/gridToCsv/key/a07f4aed6c1179773233c13c4e984264d2309de49d34d35fe8580a8c42ca54cb/?filters%5Bplaceholder%5D=true&filters%5Bcreated_at%5D%5Bfrom%5D=02%2F01%2F2019&filters%5Bcreated_at%5D%5Bto%5D=02%2F07%2F2019&search=&namespace=customer_listing&selected=false
HTTP/1.0
I'm not very experienced with Magento so I'm not sure what is causing this error. I'd appreciate some help to resolve this situation please.
Best Answer
There must be some custom extension in your magento that has created custom customer attribute through setup script of that module and included column in customer_listing.xml file.
For example i had a module which has added a column mobile number in customer_listing.xml which caused this issue for me.
Kindly check.
If not sure, then try to disable all custom extension and check.