• Resolved davidgimenez

    (@davidgimenez)


    How is it possible that I updated WooCommerce with the latest version and it deleted more than 500 products that I cannot restore. I need an urgent solution. It is a store in production. and not only products, I also deleted pages

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Julia Amosova

    (@jamosova)

    Hi @davidgimenez!

    Sorry to hear you are having issues with orders being deleted. Can you please confirm what version of WooCommerce you updated to?

    Can you please also let us know if you have enabled “High performance order storage” option via WooCommerce>Settings>Advanced/Features/Data storage for orders? If so, have you had it enabled prior to updating your site?

    Plugin Author Rodel Calasagsag a11n

    (@rodelgc)

    HI @davidgimenez! As Julia mentioned, it would be helpful if we could have more details about your issue, like the version you updated to.

    It would also be helpful if you could share with us the System Status Report, but please feel free to remove any sensitive details there. So far I couldn’t reproduce your issue with 500+ products and after trying out several other settings. Additional details will help us discover the root cause of your issue. Thanks!

    Thread Starter davidgimenez

    (@davidgimenez)

    “Data storage for orders” is disabled and the version I updated of WooCommerce is 8.1.0, the orders and users were not deleted but more than 550 products disappeared, also comments more than 1000 also entries more than 400, 60 products also disappeared tutor lms

    Thread Starter davidgimenez

    (@davidgimenez)

    Hello @rodelgc, what more exactly are you asking me to share with you that I don’t understand… isn’t there some private way for me to send you access so that you can review it?

    Thread Starter davidgimenez

    (@davidgimenez)

    WordPress Environment
    
    WordPress address (URL):
    Site address (URL):
    WC Version: 8.1.0
    REST API Version: ? 8.1.0
    WC Blocks Version: ? 10.9.3
    Action Scheduler Version: ? 3.6.2
    Log Directory Writable: ?
    WP Version: 6.3.1
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: –
    Language: es_ES
    External object cache: – Server Environment
    
    Server Info: LiteSpeed
    PHP Version: 7.4.33
    PHP Post Max Size: 1 GB
    PHP Time Limit: 300
    PHP Max Input Vars: 500
    cURL Version: 7.86.0
    OpenSSL/1.1.1s
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.31
    Max Upload Size: 1 GB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ? Database
    
    WC Database Version: 8.1.0
    WC Database Prefix: wp_
    Tama?o total de la base de datos: 254.23MB
    Tama?o de los datos de la base de datos: 181.76MB
    Tama?o del índice de la base de datos: 72.47MB
    wp_woocommerce_sessions: Datos: 3.02MB + índice: 0.09MB + Motor InnoDB
    wp_woocommerce_api_keys: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_woocommerce_attribute_taxonomies: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_woocommerce_downloadable_product_permissions: Datos: 0.83MB + índice: 0.85MB + Motor MyISAM
    wp_woocommerce_order_items: Datos: 0.78MB + índice: 0.51MB + Motor MyISAM
    wp_woocommerce_order_itemmeta: Datos: 15.31MB + índice: 3.96MB + Motor MyISAM
    wp_woocommerce_tax_rates: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wp_woocommerce_tax_rate_locations: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_woocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_woocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
    wp_woocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_woocommerce_payment_tokens: Datos: 0.16MB + índice: 0.08MB + Motor InnoDB
    wp_woocommerce_payment_tokenmeta: Datos: 0.47MB + índice: 0.55MB + Motor InnoDB
    wp_woocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_actionscheduler_actions: Datos: 0.91MB + índice: 0.47MB + Motor MyISAM
    wp_actionscheduler_claims: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_actionscheduler_groups: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wp_actionscheduler_logs: Datos: 0.96MB + índice: 0.51MB + Motor MyISAM
    wp_affiliate_wp_affiliatemeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    wp_affiliate_wp_affiliates: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_affiliate_wp_campaigns: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    wp_affiliate_wp_connections: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_affiliate_wp_coupons: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_affiliate_wp_creatives: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_affiliate_wp_customermeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    wp_affiliate_wp_customers: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    wp_affiliate_wp_custom_links: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_affiliate_wp_groups: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_affiliate_wp_notifications: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_affiliate_wp_payouts: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    wp_affiliate_wp_referralmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    wp_affiliate_wp_referrals: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_affiliate_wp_rest_consumers: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_affiliate_wp_sales: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_affiliate_wp_visits: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_cartflows_ca_cart_abandonment: Datos: 0.16MB + índice: 0.02MB + Motor InnoDB
    wp_cartflows_ca_email_history: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    wp_cartflows_ca_email_templates: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_cartflows_ca_email_templates_meta: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_commentmeta: Datos: 0.01MB + índice: 0.02MB + Motor MyISAM
    wp_comments: Datos: 3.87MB + índice: 1.71MB + Motor MyISAM
    wp_e_events: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_fa_user_logins: Datos: 1.40MB + índice: 0.83MB + Motor MyISAM
    wp_ff_scheduled_actions: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_fluentform_entry_details: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_fluentform_forms: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_fluentform_form_analytics: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_fluentform_form_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_fluentform_logs: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_fluentform_submissions: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_fluentform_submission_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_links: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_options: Datos: 5.72MB + índice: 0.80MB + Motor MyISAM
    wp_postmeta: Datos: 31.36MB + índice: 12.43MB + Motor MyISAM
    wp_posts: Datos: 4.80MB + índice: 0.86MB + Motor MyISAM
    wp_pv_commission: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_queue: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_rank_math_404_logs: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
    wp_rank_math_analytics_ga: Datos: 0.88MB + índice: 0.32MB + Motor MyISAM
    wp_rank_math_analytics_gsc: Datos: 0.13MB + índice: 0.09MB + Motor MyISAM
    wp_rank_math_analytics_inspections: Datos: 1.52MB + índice: 0.22MB + Motor InnoDB
    wp_rank_math_analytics_keyword_manager: Datos: 0.05MB + índice: 0.02MB + Motor MyISAM
    wp_rank_math_analytics_objects: Datos: 0.12MB + índice: 0.06MB + Motor MyISAM
    wp_rank_math_internal_links: Datos: 0.25MB + índice: 0.07MB + Motor MyISAM
    wp_rank_math_internal_meta: Datos: 0.12MB + índice: 0.10MB + Motor MyISAM
    wp_rank_math_redirections: Datos: 0.01MB + índice: 0.00MB + Motor MyISAM
    wp_rank_math_redirections_cache: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_rednao_wc_invoice: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_rednao_wc_invoices_created: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_rednao_wc_invoices_custom_field: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_sib_model_contact: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_sib_model_country: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_snippets: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    wp_termmeta: Datos: 0.23MB + índice: 0.14MB + Motor MyISAM
    wp_terms: Datos: 0.22MB + índice: 0.33MB + Motor MyISAM
    wp_term_relationships: Datos: 0.23MB + índice: 0.42MB + Motor MyISAM
    wp_term_taxonomy: Datos: 0.26MB + índice: 0.36MB + Motor MyISAM
    wp_tutor_earnings: Datos: 0.06MB + índice: 0.00MB + Motor InnoDB
    wp_tutor_notifications: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_tutor_quiz_attempts: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_tutor_quiz_attempt_answers: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_tutor_quiz_questions: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_tutor_quiz_question_answers: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_tutor_withdraws: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_usermeta: Datos: 9.64MB + índice: 4.47MB + Motor MyISAM
    wp_users: Datos: 0.41MB + índice: 0.30MB + Motor MyISAM
    wp_wcv_feedback: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_wcv_product_report: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_wc_admin_notes: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_wc_admin_note_actions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_wc_category_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    wp_wc_customer_lookup: Datos: 0.25MB + índice: 0.20MB + Motor InnoDB
    wp_wc_download_log: Datos: 1.18MB + índice: 0.93MB + Motor MyISAM
    wp_wc_orders: Datos: 3.52MB + índice: 3.22MB + Motor InnoDB
    wp_wc_orders_meta: Datos: 12.52MB + índice: 28.17MB + Motor InnoDB
    wp_wc_order_addresses: Datos: 1.52MB + índice: 4.83MB + Motor InnoDB
    wp_wc_order_bundle_lookup: Datos: 0.02MB + índice: 0.09MB + Motor InnoDB
    wp_wc_order_coupon_lookup: Datos: 0.14MB + índice: 0.20MB + Motor InnoDB
    wp_wc_order_operational_data: Datos: 1.52MB + índice: 0.70MB + Motor InnoDB
    wp_wc_order_product_lookup: Datos: 0.47MB + índice: 0.48MB + Motor InnoDB
    wp_wc_order_stats: Datos: 0.38MB + índice: 0.31MB + Motor InnoDB
    wp_wc_order_tax_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    wp_wc_product_attributes_lookup: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_wc_product_download_directories: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_wc_product_meta_lookup: Datos: 0.02MB + índice: 0.09MB + Motor InnoDB
    wp_wc_rate_limits: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_wc_reserved_stock: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_wc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_wc_webhooks: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_wnbell_recipients: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_wnbell_recipients_role: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    wp_woocommerce_bundled_itemmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    wp_woocommerce_bundled_items: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    wp_wpmailsmtp_debug_events: Datos: 73.59MB + índice: 0.00MB + Motor InnoDB
    wp_wpmailsmtp_tasks_meta: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_wpr_rocket_cache: Datos: 1.52MB + índice: 1.77MB + Motor InnoDB
    wp_wpr_rucss_used_css: Datos: 0.02MB + índice: 0.09MB + Motor InnoDB
    wp_yith_wcwl: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_yith_wc_stripe_blacklist: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
    wp_ywf_user_fund_log: Datos: 0.02MB + índice: 0.01MB + Motor MyISAM Post Type Counts
    
    acf-field: 3
    acf-field-group: 1
    attachment: 688
    carousels: 1
    carts: 6
    content-locker: 1
    courses: 16
    custom_css: 2
    cycloneslider: 1
    dhwc_template: 1
    elementor_library: 10
    elementor-hf: 7
    elementskit_content: 1
    elementskit_template: 1
    et_pb_layout: 33
    ffw: 5
    header: 1
    jet-menu: 2
    jet-woo-builder: 3
    lesson: 861
    mc4wp-form: 2
    ml-slide: 3
    ml-slider: 1
    mts_notification_bar: 1
    nav_menu_item: 81
    oembed_cache: 59
    opal_menu_item: 1
    page: 23
    post: 77
    postman_sent_mail: 250
    product: 70
    rmp_menu: 1
    rvp: 1
    sa_slider: 1
    shop_coupon: 15
    shop_order: 8145
    shop_order_refund: 2
    shop_order_vendor: 74
    sp_wps_shortcodes: 1
    tm_global_cp: 1
    topics: 167
    tutor_enrolled: 266
    videoplayer: 1
    wa_wps: 1
    wc_product_tab: 1
    wcct_countdown: 1
    wcp_ruleset: 1
    wcps: 1
    wcst_trigger: 9
    wfacp_checkout: 1
    woocarousel: 1
    woolentor-template: 1
    wp_global_styles: 1
    wpcf7_contact_form: 5
    yay-currency-manage: 8
    yith_wcps_type: 1
    yith-wcbm-badge: 3
    yith-wcdppm-rule: 1
    yith-wcet-etemplate: 3
    yith-wcmbs-plan: 3
    ylc-macro: 1
    ywcm_message: 1
    ywcmbs-membership: 1
    ywdpd_discount: 1
    ywrac_cart: 2
    ywrac_email: 4
    ywrfd-discount: 1
    ywsbs_subscription: 1 Security
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    advanced-cache.php: advanced-cache.php Settings
    
    API Enabled: –
    Force SSL: ?
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: .
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: bundle (bundle)
    external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    Connected to WooCommerce.com: –
    Enforce Approved Product Download Directories: –
    HPOS feature screen enabled: –
    HPOS feature enabled: –
    Order datastore: WC_Order_Data_Store_CPT
    HPOS data sync enabled: – WC Pages
    
    Base de la tienda: #108050 -
    Carrito: #155298 -
    Finalizar compra: #78115 -
    Mi cuenta: #155286 - Theme
    
    Name: Storefront
    Version: 4.5.2
    Author URL: https://woocommerce.com/
    Child Theme: ? – Si estás modificando WooCommerce en un tema padre que no has creado personalmente
    te recomendamos utilizar un tema hijo. Ver: Cómo crear un tema hijo
    
    WooCommerce Support: ? WC Vendors Pro
    
    Theme compatability: -
    Pro Dashboard Page: ? -Tu página Dhasboard Pro no se puede ajustar a tu página de Dashboard libre. Presione aquí para cambiar .
    Feedback form page: ? Las calificaciones de Vendedor no funcionarán sin este conjunto de páginas. Haga clic aquí para configurar la página.
    Vendedor Shop Permalink: - vendedores Templates
    
    Overrides: – Admin
    
    Enabled Features: activity-panels
    analytics
    product-block-editor
    coupons
    core-profiler
    customer-effort-score-tracks
    import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page
    
    Disabled Features: customize-store
    minified-js
    new-product-management-experience
    product-variation-management
    settings
    async-product-editor-category-field
    
    Daily Cron: ? Next scheduled: 2023-09-13 19:12:19 +02:00
    Options: ?
    Notes: 14
    Onboarding: completed Action Scheduler
    
    Canceled: 144
    Oldest: 2023-08-14 09:57:56 +0200
    Newest: 2023-09-12 23:54:37 +0200
    
    Complete: 1.622
    Oldest: 2023-08-14 09:48:40 +0200
    Newest: 2023-09-13 00:46:24 +0200
    
    Failed: 2.519
    Oldest: 2023-05-12 01:51:24 +0200
    Newest: 2023-09-12 23:50:11 +0200
    
    Pending: 8
    Oldest: 2023-09-13 09:20:58 +0200
    Newest: 2023-10-13 00:35:27 +0200 Status report information
    
    Generated at: 2023-09-13 08:36:38 +02:00
    `
    Saif

    (@babylon1999)

    Hello @davidgimenez,

    Sorry to know the last update caused your products to disappear.

    All of your WooCommerce data, including products, orders, taxonomies, and more, is stored in your database. Therefore, updating the plugin should not delete any of this data.

    Even if you uninstall WooCommerce, the database tables will remain intact unless you specifically add a constant in your wp-config file to remove them.

    I noticed that you removed the active plugins section from your system status. Could you please try disabling all plugins except for WooCommerce and let us know if the products are still missing?

    Additionally, please check if there are any fatal errors in the WooCommerce > Status > Logs that date back to when this issue started.


    Link to image: https://d.pr/i/AnGUky

    Look forward to hearing back from you.

    Plugin Support Gabriel – a11n

    (@gabrielfuentes)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error fatal’ is closed to new replies.