Sales history and products not visible on back-end
-
Hey! Our site was recently hit with some malware, and we had Sucuri clean it all up and subsequently made sure all our plugins were fully up to date, among taking other precautions. Ever since resuming control of our site, however, we haven’t been able to view any orders or products on the back-end. We get “ready to start selling something awesome?” type landing pages, as though we have no orders or products.
Meanwhile, I can see all our products on the front-end, I can see the page numbers on the orders landing page that clearly shows we have 3940 sales spread out over 40 pages, and orders keep coming in, which are thankfully being passed to our POS, so we can still access and fulfill them. Nothing’s showing for us in WordPress, though, which also means I can’t edit any of our products.
I don’t know if Sucuri accidentally over-cleaned some index pages, or if updating to the newest version of WordPress broke something, but this is a huge problem that I need to solve ASAP. I have created a staging ground on which I’ve disabled every plugin and extension other than core Woocommerce, and the problem persists, so it isn’t a plugin incompatibility.
Please help!
The page I need help with: [log in to see the link]
-
Sorry to hear that. Could you please share a copy of your site’s System Status?
You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
### WordPress Environment ### WordPress address (URL): https://www.redcapscorner.com Site address (URL): https://www.redcapscorner.com WC Version: 5.9.0 REST API Version: ? 5.9.0 WC Blocks Version: ? 6.1.0 Action Scheduler Version: ? 3.3.0 WC Admin Version: ? 2.8.0 Log Directory Writable: ? WP Version: 5.8.2 WP Multisite: – WP Memory Limit: 768 MB WP Debug Mode: – WP Cron: ? Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.4.26 PHP Post Max Size: 256 MB PHP Time Limit: 300 PHP Max Input Vars: 3000 cURL Version: 7.66.0 OpenSSL/1.1.1l-fips SUHOSIN Installed: – MySQL Version: 5.7.32-35-log Max Upload Size: 256 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 5.9.0 WC Database Prefix: cp9_ Total Database Size: 289.43MB Database Data Size: 214.31MB Database Index Size: 75.12MB cp9_woocommerce_sessions: Data: 4.03MB + Index: 0.17MB + Engine InnoDB cp9_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB cp9_woocommerce_order_items: Data: 1.52MB + Index: 0.22MB + Engine InnoDB cp9_woocommerce_order_itemmeta: Data: 6.52MB + Index: 5.03MB + Engine InnoDB cp9_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB cp9_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB cp9_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB cp9_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_actionscheduler_actions: Data: 2.50MB + Index: 1.05MB + Engine InnoDB cp9_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_actionscheduler_logs: Data: 1.52MB + Index: 0.44MB + Engine InnoDB cp9_bp_activity: Data: 0.16MB + Index: 0.38MB + Engine InnoDB cp9_bp_activity_meta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB cp9_bp_messages_messages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_bp_messages_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_bp_messages_notices: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_bp_messages_recipients: Data: 0.02MB + Index: 0.08MB + Engine InnoDB cp9_bp_notifications: Data: 0.02MB + Index: 0.11MB + Engine InnoDB cp9_bp_notifications_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_bp_xprofile_data: Data: 0.08MB + Index: 0.09MB + Engine InnoDB cp9_bp_xprofile_fields: Data: 0.02MB + Index: 0.08MB + Engine InnoDB cp9_bp_xprofile_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_bp_xprofile_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_bv_ip_store: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_commentmeta: Data: 0.08MB + Index: 0.09MB + Engine InnoDB cp9_comments: Data: 4.52MB + Index: 2.28MB + Engine InnoDB cp9_esign_documents: Data: 2.52MB + Index: 0.08MB + Engine InnoDB cp9_esign_documents_events: Data: 0.06MB + Index: 0.09MB + Engine InnoDB cp9_esign_documents_fields_data: Data: 0.02MB + Index: 0.05MB + Engine InnoDB cp9_esign_documents_meta: Data: 0.16MB + Index: 0.14MB + Engine InnoDB cp9_esign_documents_signatures: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_esign_documents_signer_field_data: Data: 0.14MB + Index: 0.02MB + Engine InnoDB cp9_esign_documents_stand_alone_docs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_esign_document_users: Data: 0.02MB + Index: 0.06MB + Engine InnoDB cp9_esign_invitations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_esign_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_esign_signatures: Data: 1.52MB + Index: 0.03MB + Engine InnoDB cp9_esign_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_gf_entry: Data: 0.27MB + Index: 0.06MB + Engine InnoDB cp9_gf_entry_meta: Data: 1.52MB + Index: 0.48MB + Engine InnoDB cp9_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_gf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_gf_form_view: Data: 1.52MB + Index: 0.42MB + Engine InnoDB cp9_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_iwp_backup_status: Data: 0.09MB + Index: 0.00MB + Engine InnoDB cp9_iwp_file_list: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_iwp_processed_iterator: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_mgmlp_folders: Data: 0.01MB + Index: 0.01MB + Engine MyISAM cp9_mlubgg: Data: 1.34MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_customers: Data: 3.52MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_customers_pairs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_data_pairs: Data: 0.41MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_items: Data: 30.55MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_list_account: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_list_class: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_list_customertype: Data: 0.00MB + Index: 0.00MB + Engine MyISAM cp9_mw_wc_qbo_desk_qbd_list_department: Data: 0.04MB + Index: 0.00MB + Engine MyISAM cp9_mw_wc_qbo_desk_qbd_list_inventorysite: Data: 0.00MB + Index: 0.00MB + Engine MyISAM cp9_mw_wc_qbo_desk_qbd_list_paymentmethod: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_list_salesrep: Data: 0.00MB + Index: 0.00MB + Engine MyISAM cp9_mw_wc_qbo_desk_qbd_list_salestaxcode: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_list_shipmethod: Data: 0.00MB + Index: 0.00MB + Engine MyISAM cp9_mw_wc_qbo_desk_qbd_list_template: Data: 0.00MB + Index: 0.00MB + Engine MyISAM cp9_mw_wc_qbo_desk_qbd_list_term: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_log: Data: 2.02MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_map_departments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM cp9_mw_wc_qbo_desk_qbd_map_paymentmethod: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_map_promo_code: Data: 0.00MB + Index: 0.00MB + Engine MyISAM cp9_mw_wc_qbo_desk_qbd_map_shipping_product: Data: 0.00MB + Index: 0.00MB + Engine MyISAM cp9_mw_wc_qbo_desk_qbd_map_tax: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_map_wq_cf: Data: 0.00MB + Index: 0.00MB + Engine MyISAM cp9_mw_wc_qbo_desk_qbd_product_pairs: Data: 0.28MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_variation_pairs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB cp9_mw_wc_qbo_desk_qbd_vendors: Data: 0.00MB + Index: 0.00MB + Engine MyISAM cp9_options: Data: 7.30MB + Index: 1.48MB + Engine InnoDB cp9_pmpro_discount_codes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB cp9_pmpro_discount_codes_levels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_pmpro_discount_codes_uses: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_pmpro_memberships_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_pmpro_memberships_pages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_pmpro_memberships_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB cp9_pmpro_membership_levelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_pmpro_membership_levels: Data: 0.02MB + Index: 0.05MB + Engine InnoDB cp9_pmpro_membership_orders: Data: 0.02MB + Index: 0.20MB + Engine InnoDB cp9_pollsa: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_pollsip: Data: 0.02MB + Index: 0.05MB + Engine InnoDB cp9_pollsq: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_postmeta: Data: 84.61MB + Index: 36.11MB + Engine InnoDB cp9_posts: Data: 13.52MB + Index: 4.00MB + Engine InnoDB cp9_rg_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_rg_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_rg_form_view: Data: 1.52MB + Index: 0.42MB + Engine InnoDB cp9_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_rg_lead: Data: 0.27MB + Index: 0.06MB + Engine InnoDB cp9_rg_lead_detail: Data: 1.52MB + Index: 0.48MB + Engine InnoDB cp9_rg_lead_detail_long: Data: 0.13MB + Index: 0.00MB + Engine InnoDB cp9_rg_lead_meta: Data: 0.09MB + Index: 0.11MB + Engine InnoDB cp9_rg_lead_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_scwatbwsr_bookedseats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_scwatbwsr_dailyschedules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_scwatbwsr_dailytimes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_scwatbwsr_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_scwatbwsr_prices: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_scwatbwsr_products: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_scwatbwsr_rooms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_scwatbwsr_schedules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_scwatbwsr_seats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_scwatbwsr_tables: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_scwatbwsr_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_signups: Data: 0.09MB + Index: 0.09MB + Engine InnoDB cp9_smush_dir_images: Data: 0.02MB + Index: 0.05MB + Engine InnoDB cp9_termmeta: Data: 0.06MB + Index: 0.09MB + Engine InnoDB cp9_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB cp9_term_relationships: Data: 1.52MB + Index: 0.38MB + Engine InnoDB cp9_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB cp9_usermeta: Data: 7.52MB + Index: 7.00MB + Engine InnoDB cp9_users: Data: 1.52MB + Index: 0.39MB + Engine InnoDB cp9_vikrestaurants_api_login_event_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB cp9_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wc_customer_lookup: Data: 0.23MB + Index: 0.25MB + Engine InnoDB cp9_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_wc_order_product_lookup: Data: 1.52MB + Index: 0.77MB + Engine InnoDB cp9_wc_order_stats: Data: 0.48MB + Index: 0.50MB + Engine InnoDB cp9_wc_order_tax_lookup: Data: 0.23MB + Index: 0.20MB + Engine InnoDB cp9_wc_product_meta_lookup: Data: 1.52MB + Index: 0.88MB + Engine InnoDB cp9_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB cp9_wfconfig: Data: 0.11MB + Index: 0.00MB + Engine InnoDB cp9_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB cp9_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_wfissues: Data: 0.05MB + Index: 0.06MB + Engine InnoDB cp9_wfknownfilelist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB cp9_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB cp9_wfstatus: Data: 0.02MB + Index: 0.03MB + Engine InnoDB cp9_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_woocommerce_square_customers: Data: 2.52MB + Index: 0.00MB + Engine InnoDB cp9_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_wpforo_accesses: Data: 0.00MB + Index: 0.01MB + Engine MyISAM cp9_wpforo_forums: Data: 0.00MB + Index: 0.01MB + Engine MyISAM cp9_wpforo_languages: Data: 0.00MB + Index: 0.01MB + Engine MyISAM cp9_wpforo_likes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_wpforo_phrases: Data: 0.02MB + Index: 0.05MB + Engine MyISAM cp9_wpforo_posts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB cp9_wpforo_profiles: Data: 0.06MB + Index: 0.05MB + Engine MyISAM cp9_wpforo_subscribes: Data: 0.02MB + Index: 0.06MB + Engine InnoDB cp9_wpforo_topics: Data: 0.02MB + Index: 0.08MB + Engine InnoDB cp9_wpforo_usergroups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM cp9_wpforo_views: Data: 0.02MB + Index: 0.05MB + Engine InnoDB cp9_wpforo_votes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_wppusher_packages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB cp9_yoast_indexable: Data: 6.52MB + Index: 3.55MB + Engine InnoDB cp9_yoast_indexable_hierarchy: Data: 0.36MB + Index: 0.42MB + Engine InnoDB cp9_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB cp9_yoast_primary_term: Data: 0.22MB + Index: 0.20MB + Engine InnoDB cp9_yoast_seo_links: Data: 0.13MB + Index: 0.09MB + Engine InnoDB cp9_yoast_seo_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB quickbooks_config: Data: 0.02MB + Index: 0.00MB + Engine InnoDB quickbooks_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB quickbooks_oauth: Data: 0.02MB + Index: 0.00MB + Engine InnoDB quickbooks_queue: Data: 0.05MB + Index: 0.06MB + Engine InnoDB quickbooks_recur: Data: 0.02MB + Index: 0.03MB + Engine InnoDB quickbooks_ticket: Data: 9.52MB + Index: 3.52MB + Engine InnoDB quickbooks_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### attachment: 2665 awdp_pt_products: 1 bp-email: 16 contact: 2 custom_css: 4 encyclopedia: 1 forum: 6 gs_faq: 15 mgmlp_media_folder: 11 nav_menu_item: 19 news: 2 o-discount: 17 o-list: 18 oembed_cache: 13 page: 69 post: 270 product: 5031 product_variation: 599 redirect_rule: 9 revision: 3781 rpt_pricing_table: 1 safecss: 1 shop_coupon: 82 shop_order: 3946 shop_order_refund: 178 soliloquy: 3 ticket-meta-fieldset: 25 trem-cafes: 2 tribe_events: 1310 tribe_organizer: 36 tribe_rsvp_attendees: 708 tribe_rsvp_tickets: 154 tribe_venue: 7 tribe_wooticket: 3046 woo_discount_cart: 1 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (63) ### InfiniteWP - Client: by Revmakx – 1.9.4.11 Gravity Forms: by Gravity Forms – 2.4.18 Akismet Anti-Spam: by Automattic – 4.2.1 Change Memory Limit: by Simon – 1.0 Classic Editor: by WordPress Contributors – 1.6.2 Responsive Pricing Table: by WP Darko – 5.1.6 DobsonDev Shortcodes: by Alex Dobson – 2.1.12 WP E-Signature Business add-ons: by Approve Me – 1.6.5 WP E-Signature: by Approve Me – 1.6.5 Enable Media Replace: by ShortPixel – 3.6.3 Event Tickets Plus: by The Events Calendar – 5.3.1 Event Tickets: by The Events Calendar – 5.2.1 The Events Calendar PRO: by The Events Calendar – 5.11.0 Genesis Connect for WooCommerce: by StudioPress – 1.1.1 Genesis Responsive Slider: by StudioPress – 1.0.1 Genesis Simple Edits: by StudioPress – 2.3.1 Genesis Simple FAQ: by StudioPress – 0.9.2 Genesis Simple Hooks: by StudioPress – 2.3.0 Genesis Simple Share: by StudioPress – 1.1.5 Genesis Simple Sidebars: by StudioPress – 2.2.2 Genesis Title Toggle: by Bill Erickson – 1.9.0 Maps Widget for Google Maps: by WebFactory Ltd – 4.22 Gravity Forms MailChimp Add-On: by rocketgenius – 4.6 Jetpack: by Automattic – 10.4 List Child Pages Shortcode: by Douglas Karr – 1.3.1 MailChimp: by MailChimp – 1.5.7 Meeple Like Us Boardgamegeek Plugin: by Michael Heron – 1.6.5 WooCommerce Sync for QuickBooks POS: by MyWorks Software – 1.3 Safe Redirect Manager: by 10up – 1.10.0 SiteGround Optimizer: by SiteGround – 6.0.5 Simple Social Icons: by StudioPress – 3.0.2 Soliloquy - Dynamic Addon: by Soliloquy Team – 2.3.3 Soliloquy: by Soliloquy Team – 2.6.0 TeamBy10Web: by 10Web – 1.1.7 The Events Calendar: Filter Bar: by The Events Calendar – 5.2.1 The Events Calendar XML Export: by – The Events Calendar: by The Events Calendar – 5.12.0 Theme My Login: by Theme My Login – 7.1.4 The Events Calendar Extension: Advanced iCal Export: by Modern Tribe Inc. – 1.1.0 The Events Calendar Extension: Calendar Customizer: by Modern Tribe Inc. – 1.0.0 Event Tickets Plus Extension: Show Cost Fields: by Modern Tribe Inc. – 1.0.0 Extra Product Options (Product Addons) for WooCommerce: by ThemeHigh – 3.0.8 WPC Product Bundles for WooCommerce: by WPClever – 6.0.1 Woocommerce Sidebar Category Accordion: by Marc Randall – 1.1.3 USPS Simple Shipping for Woocommerce: by dangoodman – 1.5.6 Conditional Discounts for WooCommerce by ORION: by ORION – 4.5.0 WP E-Signature - WooCommerce: by Approve Me – 1.6.4 WooCommerce Min/Max Quantities: by WooCommerce – 2.4.24 WOOF - WooCommerce Products Filter: by realmag777 – 1.2.6.2 WooCommerce Shipping & Tax: by WooCommerce – 1.25.20 WooCommerce Square: by WooCommerce – 2.7.0 Tipping for WooCommerce: by WPSlash – 1.0.9 WooCommerce: by Automattic – 5.9.0 WooSwipe: by Thrive Website Design – 1.1.13 Yoast SEO: by Team Yoast – 17.7.1 WP Email Manager: by Vendyderos – 4.1 WP-Polls: by Lester 'GaMerZ' Chan – 2.75.6 Smush: by WPMU DEV – 3.9.2 WP VI Post Duplicator: by Vivacity Infotech Pvt. Ltd. – 1.2 WPFront Notification Bar: by Syam Mohan – 3.1.0.120613 YITH Pre-Order for WooCommerce Premium: by YITH – 1.10.0 WP Page Widget: by Lukas Kostr – 1.1 WP Contact Filter: by Elena Grace – 2.2 ### Inactive Plugins (7) ### Autoptimize: by Frank Goossens (futtta) – 2.9.3 Booster for WooCommerce: by Pluggabl LLC – 5.4.9 Event Tickets Plus Extension: Enhance Woo Order Templates: by Modern Tribe Inc. – 1.0.2 Genesis Visual Hook Guide: by Christopher Cochran – 1.0.0 WooCommerce Side Cart Premium: by XootiX – 2.3 WP Pusher: by WP Pusher – 2.0.0 WP Stagecoach: by WP Stagecoach – 1.3.4 ### Settings ### API Enabled: ? Force SSL: – Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) woosb (woosb) 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: ? ### WC Pages ### Shop base: #7 - /shop/ Cart: #8 - /cart/ Checkout: #9 - /checkout/ My account: #10 - /my-account/ Terms and conditions: #3338 - /terms-of-service/ ### Theme ### Name: Outreach Pro Version: 13.1 Author URL: https://www.studiopress.com/ Child Theme: ? Parent Theme Name: Genesis Parent Theme Version: 3.3.5 Parent Theme Author URL: https://www.studiopress.com/ WooCommerce Support: ? ### Templates ### Overrides: – ### Square ### Environment: Production Tokenization Enabled: ? Debug Mode: Off ### Action Scheduler ### Complete: 2,992 Oldest: 2021-11-12 15:36:39 -0500 Newest: 2021-12-08 11:54:13 -0500 Pending: 1 Oldest: 2021-12-12 19:20:50 -0500 Newest: 2021-12-12 19:20:50 -0500 ### Status report information ### Generated at: 2021-12-08 12:23:40 -05:00
Hi @redcapscorner,
Thank you for sharing with us your System Status Report.
we haven’t been able to view any orders or products on the back-end.
It appears that there are no orders and products displayed in the backend but I can see from your report that you have the following stored in your database:
product: 5031 product_variation: 599 shop_order: 3946
Can you make sure you’re not seeing orders and products due to a conflict on your live site? Disable all plugins aside from WooCommerce and change the theme to the default Storefront. Go back to the orders and products backend pages, can you see data now? Before doing this take a full backup of your site and database.
The following step would be heading to WooCommerce > Status > Tools and regenerating product lookup tables and verifying base database tables.
Let us know how that goes.
Hey! I can’t disable all the plugins on the live site because it’s a functional site that’s important to the operation of our business, but I made a staging site based on the current snapshot, disabled all other plugins there, and still had the same problem. I have also now regenerated the product lookup tables and verified the base database tables, and neither seems to have fixed anything. Any other thoughts? I did notice some fatal errors in the WooCommerce logs from December 2nd and 3rd that could be related, but I’m a little nervous about posting that information to a public forum.
Please contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.
Please include a link to this forum thread, so that we can keep track of what’s already been done.
We will be able to help you further there.
We’ve attempted to do that, but we keep getting a “please confirm you email” message whenever we attempt to create a support ticket despite doing that multiple times, logging out and then back in, using different browsers, and clearing the browser caches.
-
This reply was modified 2 years, 11 months ago by
tdmn.
I’ve looked over the error that’s being experienced and it seems to be that the woocommerce plugin isn’t fully displaying all of the data it’s receiving from the database. I’ve also created a staging ground and fully replaced the woocommerce plugin with a fresh installation and it’s still having the same issue. Please either respond back to this thread or update us on how we can open a support ticket on the woocommerce site.
In the meantime, can you do a conflict test?
This kind of problem can be caused by a conflict with your theme or with another plugin. ? The best way to determine this is to: <ul> <li>Temporarily switch your theme to <a href="https://www.woocommerce.com/storefront/" target="_blank">Storefront</a></li> <li>Disable all plugins except for WooCommerce</li> <li>Repeat the action that is causing the problem</li> </ul> If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each until you find the one causing conflict. <a href="https://docs.woocommerce.com/document/how-to-test-for-conflicts/">You can find a more detailed explanation on how to do a conflict test here.</a>
To create a ticket, you need to create a https://WordPress.com account then sign in to https://woocommerce.com/my-account/create-a-ticket/?form=ticket.
I’ve opened a ticket #4605510 as of Saturday but haven’t heard anything back yet. In the meantime I took the suggested actions that you outlined and the problem is still persisting.
Since you’ve opened a ticket already, then the conversation will have to continue from there. Kindly await a response.
I’ll mark this thread as resolved now. If you have any further questions, I recommend passing them on to the ticket.
-
This reply was modified 2 years, 11 months ago by
- The topic ‘Sales history and products not visible on back-end’ is closed to new replies.