I don’t see any data on my columns

WP Sheet Editor shows all columns based on the fields it finds on the database. There are rare cases where you open the spreadsheet, and you can’t see any data on the columns, e.g you know the orders have the field “billing address” filled in, and you don’t see any value on the column “Billing Address”.

Solution to columns not showing data

The most common way to solve this issue, is to go to the Spreadsheet > Settings > Advanced Settings > Solution to weird errors > Deactivate the Data Prefetch

data prefetch

Note: This issue doesn’t occur on all sites, it just happens on some specific server settings. Deactivating the data prefetch is not going to affect the plugin performance and it won’t affect any functionality.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.