nishandesilva
Forum Replies Created
Viewing 10 replies - 1 through 10 (of 10 total)
-
Forum: Plugins
In reply to: [WooCommerce] Thousands of items in Scheduled ActionsHi Zubair,
Thanks for the fast response. Here’s what I did.
- Investigated Code snippets plugin (Couldn’t find anything that might interact with orders)
- Investigated the “wc-admin_import_orders” hook (From the most recent records, I realized that for every order, there was an action. When I looked at the order number, it matched. Within 30 minutes or 1 hour, the scheduled actions matched the number of orders we received. Then I checked the Pending actions and realized they were all scheduled at a particular time. Here’s the screenshot – https://ibb.co/F6Z7vvF. I deleted all of them, and things seem to be fine for now.
Since then, there hasn’t been any abnormal actions.
I tried to apply reward points for past orders using WooCommerce Points and Rewards plugin. Maybe that has to do with the additional “wc-admin_import_orders”?
Also, is it normal for every order we get to have an “wc-admin_import_orders” action?
What are the common plugins that use “wc-admin_import_orders” hook?
Thanks
Forum: Plugins
In reply to: [WooCommerce] Thousands of items in Scheduled ActionsHi,
Thanks for the investigation. I think I found the culprit. It’s wc-admin_import_orders hook. Before reaching out to you, I deleted a bunch of them. But upon checking now, I see 8555 items out of 9182 are them.
Screenshot – https://ibb.co/Hqk64VG
What should I do? Just to clarify, we are not importing order related data from any external sources. How can I identify what’s causing this?
Thanks
- This reply was modified 1 year, 11 months ago by nishandesilva.
Forum: Plugins
In reply to: [WooCommerce] Thousands of items in Scheduled ActionsHi Rajesh,
Thanks for the response. I went through the guide you shared. Based on my understanding, WP Cron seems to be working fine. I am assuming that Action Scheduler is blocked. Below you will find the requested reports.
System Status Report
WordPress Environment<br><br>WordPress address (URL): http://jumpbooks.lk<br>Site address (URL): http://jumpbooks.lk<br>WC Version: 9.0.1<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ✔ 3.8.0<br>Log Directory Writable: ✔<br>WP Version: 6.5.4<br>WP Multisite: –<br>WP Memory Limit: 2 GB<br>WP Debug Mode: –<br>WP Cron: ✔<br>Language: en_US<br>External object cache: – Server Environment<br><br>Server Info: Apache/2.4.59 (Debian)<br>PHP Version: 8.2.19<br>PHP Post Max Size: 128 MB<br>PHP Time Limit: 800<br>PHP Max Input Vars: 3000<br>cURL Version: 7.64.0<br>OpenSSL/1.1.1n<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.4.34-MariaDB-1:10.4.34+maria~deb10-log<br>Max Upload Size: 128 MB<br>Default Timezone is UTC: ✔<br>fsockopen/cURL: ✔<br>SoapClient: ✔<br>DOMDocument: ✔<br>GZip: ✔<br>Multibyte String: ✔<br>Remote Post: ✔<br>Remote Get: ✔ Database<br><br>WC Database Version: 9.0.1<br>WC Database Prefix: wp_<br>Total Database Size: 7154.77MB<br>Database Data Size: 4559.31MB<br>Database Index Size: 2595.46MB<br>wp_woocommerce_sessions: Data: 46.09MB + Index: 2.33MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 6.52MB + Index: 2.52MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 60.59MB + Index: 37.14MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 774.98MB + Index: 574.63MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.25MB + Index: 0.14MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 2694.98MB + Index: 1534.97MB + Engine InnoDB<br>wp_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_atum_product_data: Data: 0.05MB + Index: 0.05MB + Engine InnoDB<br>wp_automatewoo_abandoned_carts: Data: 1.50MB + Index: 0.11MB + Engine InnoDB<br>wp_automatewoo_customers: Data: 2.52MB + Index: 3.36MB + Engine InnoDB<br>wp_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_automatewoo_guests: Data: 0.23MB + Index: 0.34MB + Engine InnoDB<br>wp_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_automatewoo_logs: Data: 2.52MB + Index: 4.55MB + Engine InnoDB<br>wp_automatewoo_log_meta: Data: 11.52MB + Index: 7.03MB + Engine InnoDB<br>wp_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_bv_ip_store: Data: 0.28MB + Index: 0.16MB + Engine InnoDB<br>wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 49.58MB + Index: 40.61MB + Engine InnoDB<br>wp_datalist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_dgwt_wcas_stats: Data: 0.45MB + Index: 0.00MB + Engine InnoDB<br>wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fc_campaigns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fc_campaign_emails: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_fc_campaign_url_metrics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fc_funnels: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_fc_funnel_metrics: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_fc_funnel_sequences: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_fc_funnel_subscribers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_fc_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fc_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_fc_sequence_tracker: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_fc_subscribers: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_fc_subscriber_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_fc_subscriber_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_fc_subscriber_pivot: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_fc_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fc_url_stores: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ff_scheduled_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_entry_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_form_analytics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fluentform_submission_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_fsmpt_email_logs: Data: 48.05MB + Index: 0.00MB + Engine InnoDB<br>wp_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_giftvouchers_activity: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_giftvouchers_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_giftvouchers_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_giftvouchers_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_budget_recommendations: Data: 0.19MB + Index: 0.11MB + Engine InnoDB<br>wp_gla_merchant_issues: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_grp_google_place: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_grp_google_review: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_jetpack_waf_blocklog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_automation_runs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_mailpoet_automation_run_subjects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_forms: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_log: Data: 9.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_newsletters: Data: 3.52MB + Index: 0.05MB + Engine InnoDB<br>wp_mailpoet_newsletter_links: Data: 2.52MB + Index: 2.03MB + Engine InnoDB<br>wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_newsletter_templates: Data: 10.52MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_scheduled_tasks: Data: 24.55MB + Index: 14.02MB + Engine InnoDB<br>wp_mailpoet_scheduled_task_subscribers: Data: 9.52MB + Index: 6.52MB + Engine InnoDB<br>wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailpoet_sending_queues: Data: 48.52MB + Index: 0.13MB + Engine InnoDB<br>wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_statistics_clicks: Data: 0.33MB + Index: 0.33MB + Engine InnoDB<br>wp_mailpoet_statistics_forms: Data: 0.14MB + Index: 0.08MB + Engine InnoDB<br>wp_mailpoet_statistics_newsletters: Data: 9.52MB + Index: 8.03MB + Engine InnoDB<br>wp_mailpoet_statistics_opens: Data: 3.52MB + Index: 8.58MB + Engine InnoDB<br>wp_mailpoet_statistics_unsubscribes: Data: 0.05MB + Index: 0.05MB + Engine InnoDB<br>wp_mailpoet_statistics_woocommerce_purchases: Data: 0.06MB + Index: 0.08MB + Engine InnoDB<br>wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailpoet_subscribers: Data: 4.52MB + Index: 7.08MB + Engine InnoDB<br>wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_subscriber_segment: Data: 2.52MB + Index: 3.03MB + Engine InnoDB<br>wp_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_user_agents: Data: 0.38MB + Index: 0.06MB + Engine InnoDB<br>wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailster_action_bounces: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_mailster_action_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_mailster_action_errors: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_mailster_action_opens: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_mailster_action_sent: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_mailster_action_unsubs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_mailster_forms_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailster_forms_tags: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailster_links: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailster_lists_subscribers: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_mailster_queue: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>wp_mailster_subscriber_fields: Data: 0.09MB + Index: 0.16MB + Engine InnoDB<br>wp_mailster_subscriber_meta: Data: 0.06MB + Index: 0.09MB + Engine InnoDB<br>wp_mailster_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nx_entries: Data: 0.08MB + Index: 0.03MB + Engine InnoDB<br>wp_nx_maps: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_nx_posts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_nx_stats: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wp_options: Data: 8.44MB + Index: 1.58MB + Engine InnoDB<br>wp_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_pimwick_gift_card_activity: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_pmxe_exports: Data: 1.50MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_google_cats: Data: 0.38MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_templates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_postmeta: Data: 256.80MB + Index: 197.63MB + Engine InnoDB<br>wp_posts: Data: 26.55MB + Index: 10.06MB + Engine InnoDB<br>wp_ppress_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_ppress_formsmeta: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wp_ppress_meta_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_shortpixel_folders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_shortpixel_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_sm_tasks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_sm_task_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_social_users: Data: 0.08MB + Index: 0.06MB + Engine InnoDB<br>wp_sp_api_log: Data: 284.52MB + Index: 0.00MB + Engine InnoDB<br>wp_sp_cog_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_sp_cog_order_product_lookup: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_sp_cog_order_stats: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_sp_product_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_sp_purchase_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_sp_purchase_orders_products: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_sp_suppliers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_sp_warehouses: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_stock_log: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_termmeta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.33MB + Index: 0.20MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_usermeta: Data: 58.58MB + Index: 39.14MB + Engine InnoDB<br>wp_users: Data: 3.52MB + Index: 2.47MB + Engine InnoDB<br>wp_uwp_form_extras: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_uwp_form_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_uwp_profile_tabs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_uwp_user_sorting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wccs_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wccs_condition_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wcpdf_invoice_number: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.11MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 1.05MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 3.52MB + Index: 2.00MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_bundle_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.11MB + Index: 0.13MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 6.52MB + Index: 6.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 3.52MB + Index: 3.53MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.23MB + Index: 0.48MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wdr_order_discounts: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>wp_wdr_order_item_discounts: Data: 0.08MB + Index: 0.05MB + Engine InnoDB<br>wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfconfig: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wfknownfilelist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY<br>wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfsecurityevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfstatus: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wlr_earn_campaign: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_wlr_earn_campaign_transaction: Data: 0.02MB + Index: 0.17MB + Engine InnoDB<br>wp_wlr_levels: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_wlr_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wlr_points_ledger: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wlr_referral: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wlr_rewards: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wlr_reward_transactions: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_wlr_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_wlr_user_rewards: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_woocommerce_bis_activity: Data: 0.13MB + Index: 0.19MB + Engine InnoDB<br>wp_woocommerce_bis_notifications: Data: 0.08MB + Index: 0.14MB + Engine InnoDB<br>wp_woocommerce_bis_notificationsmeta: Data: 0.19MB + Index: 0.14MB + Engine InnoDB<br>wp_woocommerce_bundled_itemmeta: Data: 0.17MB + Index: 0.17MB + Engine InnoDB<br>wp_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_gc_activity: Data: 0.05MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_gc_cards: Data: 0.06MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_gc_cardsmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_wpc_accesslocks: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_wpc_login_fails: Data: 0.45MB + Index: 0.00MB + Engine InnoDB<br>wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpml_mails: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wpsr_caches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpsr_optimize_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpsr_reviews: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_wps_hit: Data: 4.52MB + Index: 13.64MB + Engine InnoDB<br>wp_wps_index: Data: 34.56MB + Index: 43.42MB + Engine InnoDB<br>wp_wps_key: Data: 2.52MB + Index: 1.52MB + Engine InnoDB<br>wp_wps_object_term: Data: 0.48MB + Index: 1.05MB + Engine InnoDB<br>wp_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_wps_query: Data: 0.20MB + Index: 0.17MB + Engine InnoDB<br>wp_wps_uri: Data: 13.52MB + Index: 4.55MB + Engine InnoDB<br>wp_wps_user_agent: Data: 0.17MB + Index: 0.09MB + Engine InnoDB<br>wp_wsal_metadata: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wsal_occurrences: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wsal_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wcwl: Data: 1.52MB + Index: 0.31MB + Engine InnoDB<br>wp_yith_wcwl_lists: Data: 0.19MB + Index: 2.06MB + Engine InnoDB<br>wp_yith_ywpar_points_log: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>wp_yoast_indexable: Data: 2.52MB + Index: 0.50MB + Engine InnoDB<br>wp_yoast_indexable_hierarchy: Data: 0.11MB + Index: 0.16MB + Engine InnoDB<br>wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yoast_primary_term: Data: 0.08MB + Index: 0.09MB + Engine InnoDB<br>wp_yoast_prominent_words: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_yoast_seo_links: Data: 1.52MB + Index: 0.39MB + Engine InnoDB<br>wp_yoast_seo_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB Post Type Counts<br><br>acf-field: 6<br>acf-field-group: 2<br>amn_mi-lite: 2<br>attachment: 4378<br>aw_workflow: 9<br>blocks: 18<br>custom_css: 3<br>custom_order_status: 6<br>customize_changeset: 12<br>cwginstocknotifier: 25305<br>fc_template: 1<br>featured_item: 8<br>gift_card: 38<br>jetpack_migration: 2<br>job_application: 9<br>job_listing: 1<br>mailpoet_page: 1<br>mc4wp-form: 2<br>nav_menu_item: 21<br>notificationx: 1<br>oembed_cache: 8<br>page: 48<br>pi_dpmw_rules: 1<br>post: 5<br>product: 1702<br>revision: 66<br>shop_coupon: 4789<br>shop_order: 26664<br>shop_order_refund: 33<br>sidebar: 1<br>ux_template: 18<br>wcpf_item: 1<br>wcpf_project: 1<br>wp_global_styles: 2<br>wp_social_reviews: 3<br>wpcode: 2<br>wpsr_reviews_notify: 2<br>wpsr_social_chats: 1 Security<br><br>Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔ Active Plugins (48)<br><br>Advanced Custom Fields PRO: by WP Engine – 6.3.1.2<br>AutomateWoo: by WooCommerce – 6.0.26<br>Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 5.4.0<br>Code Snippets: by Code Snippets Pro – 3.6.5.1<br>Custom Order Status for WooCommerce: by Tyche Softwares – 2.4.1<br>Facebook for WooCommerce: by Facebook – 3.2.4<br>FluentSMTP: by FluentSMTP & WPManageNinja Team – 2.2.73<br>Google Listings and Ads: by WooCommerce – 2.7.3<br>GPLVault Update Manager: by GPL Vault – 5.2.0<br>Jetpack: by Automattic – 13.5<br>Koko WooCommerce Plugin: by dInnovation (Pvt) Ltd – 1.0.4<br>MailPoet Premium: by MailPoet – 4.52.0<br>MailPoet: by MailPoet – 4.52.0<br>MalCare WordPress Security Plugin - Malware Scanner, Cleaner, Security Firewall: by MalCare Security – 5.56<br>Mintpay: by Mintpay (Private) Limited – 1.0.4<br>MrNotify SMS for WooCommerce: by MrNotify – 1.0<br>PayHere Payment Gateway: by PayHere (Private) Limited – 2.3.3<br>Thyāga WooCommerce2: by Etcetera Solutions – 1.0.0<br>Product Subtitle For WooCommerce: by Varun Sridharan – 4.6.2<br>WooCommerce Smart COD: by woosmartcod.com – 1.7.2<br>Discount Rules PRO 2.0: by Flycart – 2.6.4<br>Discount Rules Core: by Flycart – 2.6.4<br>Force Authentification Before Checkout for WooCommerce: by Luiz Bills – 1.4.4<br>WooCommerce New Customer Report - WP Fix It: by WP Fix It – 2.0<br>WP Sheet Editor - WooCommerce Orders Pro: by WP Sheet Editor – 1.3.15<br>WPC Product Bundles for WooCommerce: by WPClever – 8.0.8<br>WP Sheet Editor - WooCommerce Products (Premium): by WP Sheet Editor – 1.8.13<br>WooCommerce.com Update Manager: by Automattic – 1.0.3<br>Woo Back In Stock Notifications: by Woo – 1.7.1<br>Checkout Field Editor for WooCommerce (Pro): by ThemeHigh – 3.6.3<br>Woo Conditional Shipping and Payments: by Woo – 1.15.11<br>Woo Gift Cards: by Woo – 1.16.14<br>Google Analytics for WooCommerce: by WooCommerce – 2.1.2<br>PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.8.4<br>Woo Product Bundles: by Woo – 7.1.2<br>WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.70<br>WooCommerce Product Search: by itthinx – 5.5.0<br>Brevo - WooCommerce Email Marketing: by Brevo – 4.0.23<br>WooCommerce: by Automattic – 9.0.1<br>Yoast SEO: by Team Yoast – 22.9<br>WP Config File Editor: by AHMeD HAMeD – 1.7.1<br>WP Crontrol: by John Blackbourn – 1.16.3<br>WP Hide & Security Enhancer: by Nsp Code – 2.3.9<br>WP-Optimize - Clean, Compress, Cache: by David Anderson<br>Ruhani Rabin<br>Team Updraft – 3.3.2<br><br>WP Sheet Editor - Media Library: by WP Sheet Editor – 1.10.15<br>WP Social Ninja Pro: by WP Social Ninja Team - WPManageNinja LLC – 3.13.1<br>WP Social Ninja: by WP Social Ninja Team - WPManageNinja LLC – 3.13.1<br>YITH WooCommerce Wishlist: by YITH – 3.35.0 Inactive Plugins (3)<br><br>Add-on: Export CSV - Back In Stock Notifier for WooCommerce: by codewoogeek – 1.1<br>Advanced Order Export For WooCommerce: by AlgolPlus – 3.5.3<br>Converter for Media: by matt plugins – 5.12.5 Dropin Plugins ()<br><br>advanced-cache.php: advanced-cache.php Must Use Plugins (1)<br><br>wp-hide-loader.php: by – Settings<br><br>API Enabled: –<br>Force SSL: ✔<br>Currency: LKR (Rs. )<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: bundle (bundle)<br>external (external)<br>gift-card (gift-card)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br>woosb (woosb)<br><br>Taxonomies: Product Visibility: exclude_from_catalog (exclude_from_catalog)<br>exclude_from_search (exclude_from_search)<br>exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: ✔<br>Enforce Approved Product Download Directories: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – Logging<br><br>Enabled: ✔<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 3 MB WC Pages<br><br>Shop base: #65 - /shop/<br>Cart: #64 - /cart/<br>Checkout: #63 - /checkout/<br>My account: #62 - /my-account/<br>Terms and conditions: #1125 - /terms-and-conditions/ Theme<br><br>Name: Flatsome Child<br>Version: 3.15.3.1675919971<br>Author URL: http://www.uxthemes.com/<br>Child Theme: ✔<br>Parent Theme Name: Flatsome<br>Parent Theme Version: 3.19.2<br>Parent Theme Author URL: https://uxthemes.com<br>WooCommerce Support: ✔ Templates<br><br>Overrides: flatsome/woocommerce/archive-product.php<br>flatsome/woocommerce/cart/cart-empty.php<br>flatsome/woocommerce/cart/cart-shipping.php<br>flatsome/woocommerce/cart/cart.php<br>flatsome/woocommerce/cart/mini-cart.php<br>flatsome/woocommerce/checkout/form-checkout.php<br>flatsome/woocommerce/checkout/form-coupon.php<br>flatsome/woocommerce/checkout/order-received.php<br>flatsome/woocommerce/checkout/terms.php<br>flatsome/woocommerce/checkout/thankyou.php<br>flatsome/woocommerce/content-product-cat.php<br>flatsome/woocommerce/content-product.php<br>flatsome-child/woocommerce/content-single-product.php<br>flatsome/woocommerce/content-widget-product.php<br>flatsome/woocommerce/global/breadcrumb.php<br>flatsome/woocommerce/global/quantity-input.php<br>flatsome/woocommerce/global/wrapper-end.php<br>flatsome/woocommerce/global/wrapper-start.php<br>flatsome/woocommerce/loop/header.php<br>flatsome/woocommerce/loop/loop-end.php<br>flatsome/woocommerce/loop/loop-start.php<br>flatsome/woocommerce/loop/pagination.php<br>flatsome/woocommerce/loop/rating.php<br>flatsome/woocommerce/loop/result-count.php<br>flatsome/woocommerce/loop/sale-flash.php<br>flatsome/woocommerce/myaccount/form-login.php<br>flatsome/woocommerce/myaccount/navigation.php<br>flatsome/woocommerce/notices/error.php<br>flatsome/woocommerce/notices/notice.php<br>flatsome/woocommerce/notices/success.php<br>flatsome/woocommerce/product-searchform.php<br>flatsome/woocommerce/single-product/photoswipe.php<br>flatsome/woocommerce/single-product/price.php<br>flatsome/woocommerce/single-product/product-image.php<br>flatsome/woocommerce/single-product/product-thumbnails.php<br>flatsome/woocommerce/single-product/rating.php<br>flatsome/woocommerce/single-product/related.php<br>flatsome/woocommerce/single-product/review.php<br>flatsome/woocommerce/single-product/sale-flash.php<br>flatsome/woocommerce/single-product/share.php<br>flatsome/woocommerce/single-product/short-description.php<br>flatsome/woocommerce/single-product/tabs/tabs.php<br>flatsome/woocommerce/single-product/title.php<br>flatsome/woocommerce/single-product/up-sells.php<br>flatsome/woocommerce/single-product-reviews.php<br>flatsome/woocommerce/single-product.php MailPoet<br><br>Sending Method: SMTP<br>Send all site's emails with: Default WordPress sending method<br>Task Scheduler method: WordPress<br>Cron ping URL: https://jumpbooks.lk?mailpoet_router&endpoint=cron_daemon&action=ping Back In Stock<br><br>Database Version: 1.7.1<br>Loopback Test: ✔ Gift Cards<br><br>Database Version: 1.16.14<br>Loopback Test: ✔<br>Task Queueing Test: ✔ Product Bundles<br><br>Database Version: 7.1.2<br>Loopback Test: ✔<br>Template Overrides: – Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br><br>Disabled Features: minified-js<br>new-product-management-experience<br>pattern-toolkit-full-composability<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>launch-your-store<br>product-editor-template-system<br><br>Daily Cron: ✔ Next scheduled: 2024-06-22 19:57:24 +05:30<br>Options: ✔<br>Notes: 212<br>Onboarding: completed Action Scheduler<br><br>Complete: 2,053,135<br>Oldest: 2024-05-03 13:55:46 +0000<br>Newest: 2024-06-22 15:13:51 +0000<br><br>Pending: 14,344<br>Oldest: 2024-06-21 18:10:36 +0000<br>Newest: 2024-06-24 04:51:26 +0000<br><br>Failed: 12,653<br>Oldest: 2023-08-05 04:27:36 +0000<br>Newest: 2024-06-22 14:44:53 +0000 Status report information<br><br>Generated at: 2024-06-22 20:44:12 +05:30<br>Fatal Error Logs (Most recent)
https://gist.github.com/nishandesilva/7f8cc1f1e813c6609f420c2b21841ca2
Hope these will help. Thanks.
Forum: Plugins
In reply to: [WooCommerce] WooCommerce Analytics is not updated@xue28 Thanks so much for the suggestions. I followed the steps to the dot. It worked like a charm. Analytics is up to date now.
I further investigated the issue and found out why it happened. Here’s the complete explanation.
A couple of weeks ago, while browsing the WooCommerce Mobile app (Android), I came across “Payments” under the “General” tab in the “Menu.” When I clicked on it, automatically WooCommerce app enabled the In-Person payments. However, in-person payments are not available where our store is (Sri Lanka).
This changed the Payment settings on WooCommerce. We had Cash on Delivery as a payment method. It was automatically converted into in-person payments. We changed it immediately to Cash on Delivery and we were back in business.
Since then, the WooCommerce Analytics app did not include Cash on Delivery orders in the metrics. We exported the total orders and found out that Cash on-delivery values are not reflected in WooCommerce>Analytics.
However, the “old” report (WooCommerce>Reports) was recording all payment methods and orders accurately.
Again, thanks for clearing this issue.
Forum: Plugins
In reply to: [WooCommerce] “Your orders report will be emailed to you” – report missing?@onlinenz @jscottd @billfinn @weppa I was experiencing the same problem until I updated Woocommerce Database. Then reports started to appear in my inbox. Whenever you get a message to update your Woocommerce Database, do that immediately. Keep on doing it until you get an Updated message. Then try downloading the reports. That worked for me.
Forum: Plugins
In reply to: [Meta for WooCommerce] Something went wrong – Can’t connect to FacebookHello @amandasjackson
You were right! The issue was with my currency. Facebook does not support LKR. I temporarily changed my currency to USD. Then I was able to connect to Facebook. Then I changed the currency back to LKR.
Thanks for recommending it. You were very supportive.
Forum: Plugins
In reply to: [Meta for WooCommerce] Something went wrong when connecting to FacebookHello,
I followed the exact steps which are recommended in this thread. But it didn’t work for me.
Here’s the new thread I created.
https://wordpress.org/support/topic/something-went-wrong-cant-connect-to-facebook/#post-13742120Can you suggest a solution? It’s been almost 2 months now.
thanks,
Forum: Plugins
In reply to: [WooCommerce] “Your orders report will be emailed to you” – report missing?@k730hs I was experiencing the same problem until I updated Woocommerce Database. Then reports started to appear in my inbox. Whenever you get a message to update your Woocommerce Database, do that immediately. Keep on doing it until you get an Updated message. Then try downloading the reports. That worked for me.
Forum: Plugins
In reply to: [WooCommerce] “Your orders report will be emailed to you” – report missing?@galasecrets Thanks for the recommendation. I installed WP Mail SMTP plugin and configured it to my hosting provider’s email server. I ran a successful test email.
Still, when I generate a Woocommerce Analytics Report, I never get the email. When I checked the Mail log, there’s no emails sent.
I am so frustrated with this. Anything else you can recommend? It would mean a lot. Thanks.Forum: Plugins
In reply to: [WooCommerce] “Your orders report will be emailed to you” – report missing?Hi, I’m experiencing the same problem. I installed WP Mail Log plugin and realized that emails have not been sent. I also checked wp-content and realized that csv files are not there.
https://ibb.co/pzFg6PwBut I was able to get those reports couple of months ago and you will see them in the image.
Has someone figured this out? If so, any guidance is much appreciated. Thanks.
Viewing 10 replies - 1 through 10 (of 10 total)