YetiDev

Troubleshooting

Solutions to common issues

I can't see YetiExport in the menu

  • Check WooCommerce is installed and active - YetiExport sits under the WooCommerce menu
  • Check your user role. Only Administrators and Shop Managers (users with manage_woocommerce) can see it

A customer is missing from the export

  • Check the date range - customers only appear if they have an order inside it
  • Check the order statuses - by default only Processing and Completed orders count
  • Check the customer type and minimum spend filters
  • Registered customers with no orders only appear if Include registered customers with no matching orders is ticked, and only if they have the Customer role
  • Guest orders with no billing email are skipped

A guest shows as "Registered"

That's intentional. If a guest checkout used the same email as a registered account, those orders are merged into the account so the customer appears once with their full spend.

Some values start with an apostrophe (')

Any value starting with =, +, - or @ is prefixed with an apostrophe. This stops spreadsheet programs treating customer-entered text as a formula (known as CSV injection), which could otherwise be used to run malicious formulas on your computer.

You'll most often see this on international phone numbers, e.g. '+447700900123. If you need to remove it, use Find & Replace in your spreadsheet to replace '+ with + in the Phone column.

Accented characters look wrong

The CSV is saved as UTF-8 with a marker that Excel recognises, so names like Zoë or José display correctly when you double-click the file. If they still look wrong, open Excel first and use Data > From Text/CSV, choosing UTF-8 as the file origin.

The export takes a long time or times out

  • YetiExport removes the PHP time limit and works in batches, but very large stores can still take a while. Leave the tab open until the download starts
  • Narrow the export with a date range or a minimum spend
  • Some hosts enforce their own hard limit on request time. If the download never starts, ask your host to raise it, or export in smaller date ranges

The export runs out of memory

Orders are read in batches, but YetiExport keeps a running total for every customer in the export and loads your account email list once, so memory use grows with the number of customers. If a very large export fails with a memory error:

  • Split it using a date range, a customer type or a minimum spend
  • Untick columns you don't need
  • Ask your host to raise the PHP memory limit (WP_MAX_MEMORY_LIMIT)

Total Spent doesn't match WooCommerce Analytics

YetiExport adds up order totals (including shipping and tax) minus refunds, for the statuses you ticked. WooCommerce Analytics may use different statuses, exclude shipping or tax, or not have finished importing historical data. Make sure you're comparing the same date range and statuses.

Need Help?

If you have questions or need assistance, check out our Troubleshooting Guide or FAQ.

YetiExport

Export every WooCommerce customer to a clean CSV

About this plugin