• Resolved ukila

    (@ukila)


    Hello WooCommerce team,

    I’m experiencing an issue with the Analytics → Variations in WooCommerce version 10.4.3, and I wanted to share the details and get guidance. Here’s what I’ve observed:

    1. Small exports work fine
      • When the number of variations is small, the CSV downloads immediately in the browser and opens correctly in Excel.
    2. Large exports switch to email
      • For a full year (e.g., 2024 or 2025), the Analytics UI says the report will be sent by email.
      • In these cases, I receive the scheduled email (“Varianter nedlasting gjenstår”), but the CSV is empty.
      • There are no PHP errors or warnings logged.
      • Scheduled actions (in WooCommerce > Status > Scheduled Actions) show the export actions as Completed, so the task runs successfully.
    3. Tried reducing the number of CSV columns
      • I attempted to export a smaller CSV by reducing the columns that are included.
      • In this case, the email said “Download your Variations Report” (instead of “Download pending” – “Varianter nedlasting gjenstår” ), but the CSV still ended up empty.
      • Again, no errors are thrown.
    4. Observations
      • The export appears to run, and the CSV file is created, but the report data itself is missing.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    Hi there!

    Thanks for the detailed report that’s very helpful, and I understand how frustrating it is to see the export complete successfully but still receive an empty CSV.

    At this stage, the next step would be to gather a bit more information about your store environment so we can better understand what might be affecting large Analytics exports.

    Could you please share your System Status Report? You can find it here: WooCommerce → Status

    Once there, please copy the report and paste it into one of the following services:

    Then share the link to that paste in your reply. Once we have that information, we’ll be able to advise on the next steps more accurately.

    Thread Starter ukila

    (@ukila)

    Here’s my System Status Report:
    https://pastebin.com/6nEgSbuY

    Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    Hi there!

    Thank you for sharing the System Status Report. I’ve reviewed it, and everything appears to be fine. I also tried to replicate the issue on my end, but it’s working as expected for me.

    To troubleshoot this further, I’d recommend running a conflict test by deactivating all plugins except WooCommerce and switching to a default theme such as Storefront. Then check whether the issue still occurs.

    If the issue persists, could you please try following the solution mentioned in this other thread and let us know if it works for you?
    https://ww.wp.xz.cn/support/topic/typeerror-cannot-read-properties-of-undefined-reading-replace-2/#post-18761311

    Thread Starter ukila

    (@ukila)

    Thank you for your suggestion, however, I do not have the error described in that thread, nor does the line mentioned exist in my WooCommerce version. Applying that fix does not match my situation.

    Also, disabling all plugins and switching themes is not an option, since this issue occurs on a production site.

    To provide more context:

    • I am trying to export variations via WooCommerce Analytics.
    • In my case, there are approximately:
      • 160 variations
      • 10,000 items sold
      • 3,000 orders
    • With this dataset, the export does not work, the CSV is empty, even though scheduled actions complete successfully.
    • Smaller datasets export immediately without issue, so the problem seems to occur only with larger datasets.

    Could you clarify:

    1. Up to how many orders/variations does the built-in export officially support?
    2. Is there a recommended method for reliably exporting larger variation datasets in production?

    Hi @ukila,

    Thanks for the additional details, that helps clarify the situation.

    To answer your questions directly: There is no documented or guaranteed limit for the number of orders, variations, or rows that WooCommerce Analytics exports support. The Analytics export feature is designed primarily for reporting and review, not for reliably exporting very large datasets.

    In practice, large exports (especially variations tied to thousands of orders) are sensitive to server limits such as memory, execution time, and background processing constraints. When those limits are reached, the export task may still complete successfully at the scheduler level but produce an empty or incomplete CSV, which matches what you’re seeing.

    Since this is happening only with larger datasets and smaller exports work correctly, it’s unlikely to be a data integrity issue and more likely related to environment or scale limitations.

    For production sites and larger datasets, the recommended alternatives are:

    • Use a dedicated export tool or plugin designed for large WooCommerce datasets. These typically process data in batches and are more reliable at scale.
    • Export directly from the database (for example via a reporting tool or database client), if you have access and are comfortable doing so.
    • Export data in smaller date ranges as a workaround, if feasible. 

    At this time, WooCommerce core Analytics does not provide advanced controls for chunking or retrying large exports, and there isn’t a supported way to force large variation exports to complete reliably from the Analytics UI alone.

    If you believe this behavior should be improved in core, you may want to submit a feature request or feedback via the WooCommerce GitHub repository, where the Analytics team tracks scalability-related enhancements.

    Please let us know if you have any other questions or need clarification on alternative approaches.

    Plugin Support thelmachido a11n

    (@thelmachido)

    It’s been a while since we heard back from you for this reason we are closing this thread. 

    If WooCommerce has been useful for your store and you appreciate the support you’ve received, we’d truly appreciate it if you could leave us a quick review here: 

     https://ww.wp.xz.cn/support/plugin/woocommerce/reviews/#new-post

    Feel free to open a new forum topic if you run into any other problem. 

Viewing 6 replies - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.