Preview email limit issue

  • Resolved Haja

    (@hajakutbudeen)


    6 months ago

    Hello there,

    We are currently utilizing your plugin. However, when attempting to search for old order numbers in the search field, no results are displayed; instead, it shows “No result found.” I suspect this issue may be due to a limitation restricting the display to only the last 50 orders. Could you please address this limitation? The search functionality should not be restricted by a limit of 50 orders or any other constraint.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author digamberpradhan

    (@digamberpradhan)

    Hi @hajakutbudeen

    There are no restriction on the search orders. My guess is that your old orders havne’t been migrated to Woocommerce’s new order table properly.
    I have updated the plugin to check wc_orders if wc_orders exists otherwise we search the post_type shop_order.

    I could theoretically search both tables but that would be slow. So i will do some more testing on this.
    Can you please if possible check if the order you are searching for is on wc_orders table or the wp_posts table.

    Thread Starter Haja

    (@hajakutbudeen)

    Hello @digamberpradhan

    Thank you for your response. We are using a multisite setup, and I noticed that the wc_orders table doesn’t contain any records. In your plugin, the ‘Search Orders’ feature isn’t working, and ‘Choose Order’ displays only a list of over 25 orders. This problem didn’t occur before, so I reverted to your previous versions. Everything works fine up to version 2.2.6. The issue appears starting from version 2.2.7 onwards.

    wenape

    (@wenape)

    We have the same issue. Also started appearing from 2.2.7.

    Thread Starter Haja

    (@hajakutbudeen)

    Hey?@digamberpradhan

    Just wanted to let you know—I’m the one who spotted this. It would be nice if you could thank me for bringing this to your attention: https://www.digamberpradhan.com/issues-with-woocommerce-order-table/

    Cheers! ??

    • This reply was modified 4 months, 3 weeks ago by Haja.
    • This reply was modified 4 months, 3 weeks ago by Haja.
    Plugin Author CodeManas

    (@codemanas)

    Hi @hajakutbudeen

    Thank you for bringing this to my attention.
    Your insight was very helpful to resolving this issue.

    Thread Starter Haja

    (@hajakutbudeen)

    Thanks for your kind words @codemanas

Viewing 6 replies - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.