nmballa
Forum Replies Created
-
Forum: Plugins
In reply to: [WooCommerce] Woocommerce database cachingSo we found the attribute data and it was still in the correct tables and locations. It looks like what happened is the plugin reformatted the data values. So we simply corrected the formatting and are gtg. Thanks…
Forum: Plugins
In reply to: [WooCommerce] Woocommerce database cachingThanks. Unfortunately the bulk attributes was used going back to prelaunch. It worked just fine but after several woo and wordpress updates when we went to use again we ended up in this situation. I backup the site, export the orders database, and try a cleaner perhaps this evening or tomorrow.
Forum: Plugins
In reply to: [WooCommerce] Woocommerce database caching### WordPress Environment ### WordPress address (URL): https://vtxtools.com Site address (URL): https://vtxtools.com WC Version: 6.6.0 REST API Version: ? 6.6.0 WC Blocks Version: ? 7.6.0 Action Scheduler Version: ? 3.4.0 Log Directory Writable: ? WP Version: 6.0 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ? Language: en_US External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 7.4.29 PHP Post Max Size: 32 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 5.7.38 Max Upload Size: 32 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 6.6.0 WC Database Prefix: wpfd_ Total Database Size: 79.08MB Database Data Size: 66.79MB Database Index Size: 12.29MB wpfd_woocommerce_sessions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB wpfd_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpfd_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.42MB + Engine InnoDB wpfd_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpfd_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB as_ups_api: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_actionscheduler_actions: Data: 1.02MB + Index: 0.63MB + Engine InnoDB wpfd_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_actionscheduler_logs: Data: 0.30MB + Index: 0.25MB + Engine InnoDB wpfd_ahm_assets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_ahm_asset_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_ahm_download_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_ahm_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_ahm_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_ahm_social_conns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_ahm_user_download_counts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_comments: Data: 0.08MB + Index: 0.09MB + Engine InnoDB wpfd_dgwt_wcas_index: Data: 0.09MB + Index: 0.02MB + Engine InnoDB wpfd_dgwt_wcas_invindex_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_dgwt_wcas_invindex_doclist: Data: 0.44MB + Index: 0.38MB + Engine InnoDB wpfd_dgwt_wcas_invindex_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_dgwt_wcas_invindex_wordlist: Data: 0.13MB + Index: 0.06MB + Engine InnoDB wpfd_dgwt_wcas_var_index: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpfd_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB wpfd_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wpfd_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wpfd_login_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_mw_wc_qbo_sync_customer_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_mw_wc_qbo_sync_log: Data: 0.11MB + Index: 0.00MB + Engine InnoDB wpfd_mw_wc_qbo_sync_paymentmethod_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_mw_wc_qbo_sync_payment_id_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_mw_wc_qbo_sync_product_pairs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_mw_wc_qbo_sync_qbo_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_mw_wc_qbo_sync_qbo_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_mw_wc_qbo_sync_real_time_sync_history: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wpfd_mw_wc_qbo_sync_real_time_sync_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_mw_wc_qbo_sync_shipping_product_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_mw_wc_qbo_sync_tax_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_mw_wc_qbo_sync_variation_pairs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpfd_mw_wc_qbo_sync_wq_cf_map: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wpfd_options: Data: 6.47MB + Index: 0.30MB + Engine InnoDB wpfd_postmeta: Data: 5.52MB + Index: 1.75MB + Engine InnoDB wpfd_posts: Data: 1.08MB + Index: 0.23MB + Engine InnoDB wpfd_po_plugins: Data: 0.05MB + Index: 0.06MB + Engine InnoDB wpfd_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_termmeta: Data: 0.08MB + Index: 0.13MB + Engine InnoDB wpfd_terms: Data: 0.08MB + Index: 0.09MB + Engine InnoDB wpfd_term_relationships: Data: 0.14MB + Index: 0.09MB + Engine InnoDB wpfd_term_taxonomy: Data: 0.09MB + Index: 0.11MB + Engine InnoDB wpfd_um_metadata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpfd_usermeta: Data: 0.20MB + Index: 0.19MB + Engine InnoDB wpfd_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpfd_wcfm_daily_analysis: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_wcfm_detailed_analysis: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_enquiries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_enquiries_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_enquiries_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_enquiries_response_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_fbc_chat_rows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_fbc_chat_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_wcfm_fbc_chat_visitors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_fbc_offline_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_following_followers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_wcfm_marketplace_orders_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_product_multivendor: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_wcfm_marketplace_refund_request: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_refund_request_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_reverse_withdrawal: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_reverse_withdrawal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_reviews: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_reviews_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_reviews_response_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_review_rating_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_shipping_zone_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_store_taxonomies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_vendor_ledger: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_withdraw_request: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_marketplace_withdraw_request_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_membership_subscription: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_wcfm_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_messages_modifier: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_messages_stat: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_support: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_support_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_support_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcfm_support_response_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wpfd_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_wc_order_product_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB wpfd_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpfd_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_wc_product_attributes_lookup: Data: 0.38MB + Index: 0.22MB + Engine InnoDB wpfd_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wpfd_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wdr_rules: Data: 0.11MB + Index: 0.00MB + Engine InnoDB wpfd_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpfd_wfconfig: Data: 2.28MB + Index: 0.00MB + Engine InnoDB wpfd_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wffilemods: Data: 20.55MB + Index: 0.00MB + Engine InnoDB wpfd_wfhits: Data: 2.02MB + Index: 0.22MB + Engine InnoDB wpfd_wfhoover: Data: 8.52MB + Index: 1.52MB + Engine InnoDB wpfd_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpfd_wfknownfilelist: Data: 9.52MB + Index: 0.00MB + Engine InnoDB wpfd_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpfd_wfpklist_template_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpfd_wfstatus: Data: 0.13MB + Index: 0.13MB + Engine InnoDB wpfd_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_woof_query_cache: Data: 2.52MB + Index: 2.52MB + Engine InnoDB wpfd_woot_tables: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_woot_tables_columns: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_woot_tables_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_woot_vocabulary: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbscrm_api_keys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_admlog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_aka: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_zbs_companies: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpfd_zbs_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_zbs_customfields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_zbs_dbmigration_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_zbs_dbmigration_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpfd_zbs_events: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpfd_zbs_event_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_externalsources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_zbs_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_zbs_invoices: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wpfd_zbs_lineitems: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_zbs_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpfd_zbs_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_object_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_zbs_quotes: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wpfd_zbs_quotes_templates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_zbs_security_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_segments_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_settings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_zbs_sys_cronmanagerlogs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_sys_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_sys_email_hist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_zbs_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_tags_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpfd_zbs_tax_table: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_temphash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpfd_zbs_transactions: Data: 0.02MB + Index: 0.14MB + Engine InnoDB ### Post Type Counts ### acf-field: 11 acf-field-group: 4 attachment: 279 br_product_filter: 1 customize_changeset: 2 custom_css: 1 elementor_icons: 1 elementor_library: 9 is_search_form: 1 nav_menu_item: 31 oembed_cache: 1 page: 17 post: 3 product: 116 product_variation: 10 shop_coupon: 16 shop_order: 448 shop_order_refund: 4 um_directory: 1 um_form: 4 wc_dynamic_pricing: 3 wpcf7_contact_form: 1 wp_block: 1 wp_global_styles: 1 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (41) ### weLaunch Framework: by weLaunch.io – 1.0.12 Advanced Custom Fields: by Delicious Brains – 5.12.2 FiboSearch - AJAX Search for WooCommerce (Pro): by FiboSearch Team – 1.18.0 Change WordPress Login Logo: by Boopathi Rajan – 1.1.7 Complianz - Terms and Conditions: by Really Simple Plugins – 1.1.0 Contact Form 7: by Takayuki Miyoshi – 5.5.6.1 Cookiebot | GDPR/CCPA Compliant Cookie Consent and Control: by Cybot A/S – 4.1.0 Grid/List View for WooCommerce: by BeRocket – 1.1.3.3 Jetpack: by Automattic – 11.0 LiteSpeed Cache: by LiteSpeed Technologies – 4.6 Login No Captcha reCAPTCHA (Google): by Robert Peake and Contributors – 1.6.11 Max Mega Menu - StoreFront Integration: by megamenu.com – 1.0.3 Max Mega Menu: by megamenu.com – 2.9.7 WooCommerce Sync for QuickBooks Online - Custom Field Mapping: by MyWorks Software – 1.3.0 WooCommerce Sync for QuickBooks Online - by MyWorks Software: by MyWorks Software – 2.5.5 Password Protected: by WPExperts – 2.5.2 WooCommerce PDF Invoices, Packing Slips, Delivery Notes and Shipping Labels: by WebToffee – 3.0.1 Purchase Orders for WooCommerce: by McGregor Media Web Design – 1.8 Really Simple SSL: by Really Simple Plugins – 5.3.2 Sheets API Integration: by – 1.0.0 SVG Support: by Benbodhi – 2.4.2 UPS API Integration: by – 1.0.0 User Role Editor: by Vladimir Garagulya – 4.62 WooCommerce Bulk Order Form Pro: by WP Overnight – 3.3.1 Woocommerce Partial Shipment Pro: by Vikram S – 1.6 WooCommerce Address Book: by Hall Internet Marketing – 2.1.2 Cart All In One For WooCommerce: by VillaTheme – 1.1.9 Woo Discount Rules PRO 2.0: by Flycart – 2.4.1 Woo Discount Rules: by Flycart – 2.4.1 Payment Plugins for Stripe WooCommerce: by Payment Plugins [email protected] – 3.3.21 WooCommerce Bulk Order Form: by WP Overnight – 3.5.0 WooCommerce Cart All in One Premium: by VillaTheme – 1.0.1.4 WooCommerce PDF Catalog: by weLaunch – 1.16.8 WOOF - WooCommerce Products Filter: by realmag777 – 2.2.7 WooCommerce: by Automattic – 6.6.0 WOOF by Category: by KAGG Design – 2.16 Wordfence Security: by Wordfence – 7.5.11 WP Mail SMTP: by WPForms – 3.4.0 Smart Image Resize PRO: by Nabil Lemsieh – 1.7.6.4 ReCaptcha v2 for Contact Form 7: by IQComputing – 1.4.0 Jetpack CRM: by Automattic - Jetpack CRM Team – 5.0.1 ### Inactive Plugins (0) ### ### 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) subscription (subscription) variable (variable) variable subscription (variable-subscription) 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: – ### WC Pages ### Shop base: #32 - /shop/ Cart: #33 - /cart/ Checkout: #34 - /checkout/ My account: #35 - /my-account/ Terms and conditions: #1580 - /terms-conditions/ ### Theme ### Name: Child Theme Version: 1.0.3 Author URL: https://www.facebook.com/alex.steiner.5 Child Theme: ? Parent Theme Name: Storefront Parent Theme Version: 4.1.0 Parent Theme Author URL: https://woocommerce.com/ WooCommerce Support: ? ### Templates ### Overrides: – ### Admin ### Enabled Features: activity-panels analytics coupons customer-effort-score-tracks experimental-products-task experimental-import-products-task experimental-fashion-sample-products 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 wc-pay-promotion wc-pay-welcome-page wc-pay-subscriptions-page Disabled Features: minified-js settings Daily Cron: ? Next scheduled: 2022-06-16 19:27:01 -05:00 Options: ? Notes: 10 Onboarding: completed ### Action Scheduler ### Complete: 1,692 Oldest: 2022-05-16 10:46:32 -0500 Newest: 2022-06-15 15:14:35 -0500 Failed: 11 Oldest: 2022-03-22 17:07:40 -0500 Newest: 2021-08-20 20:05:09 -0500 Pending: 3 Oldest: 2022-06-15 17:30:21 -0500 Newest: 2022-06-20 15:36:14 -0500 ### Status report information ### Generated at: 2022-06-15 15:22:10 -05:00
Forum: Plugins
In reply to: [WooCommerce] Woocommerce database cachingHi Mirko P. woo-hc,
Thanks for the feedback. Unfortunately we noticed the issue a few days after the issue first arrived. My fault for not having used the sandbox we have to test. So issue with a restore of the database would be all of the orders we have had since. I am manually going through and reassigning the attributes at this point but still have the issue where we are getting the double display.
Also, it seems that caching issue is also displaying the wrong number of items on the store page.
Hi,
Thanks for the prompt response. We have an idea for a solution.
We are going to populate a postbox in the new order page with all coupons and hide them. Then unhide the coupon when the page refreshes when a product is added. We will then query the quantity and auto apply the coupon. And then set an event listener for quantity changes and reapply. It does mean for each discount rule we will also have to create a coupon but figure we can just export the discount rules, copy and paste, and then set as coupon.
At some point we will figure out how to tie the coupon back so that in the event the discount rule changes it will be update the coupon to reflect the discount rule.
Will update you when we have it working. Might be something you would want to include in a future release.
Forum: Plugins
In reply to: [Order Splitter for WooCommerce] Presale questionSorry my example above original order should have been;
Item A: qty 25
Item B: qty 100
Item C: qty 12Forum: Plugins
In reply to: [Order Splitter for WooCommerce] Presale questionAlso, I do not believe that we are a unique scenario. I think this is a very common practice of how to handle this and would definitely be a functionality that could drive sales for your plugin. We implemented this type of functionality in magento and magento derivative product in the past for previous ecommerce stores.
Forum: Plugins
In reply to: [Order Splitter for WooCommerce] Presale questionHi Fahad,
I think I may have thrown too many questions at you at once rather than just focus on the one that is of the most importance to our workflow. Per danielcoopers comment it appears that what we aim to do is possible.
Here is a bit of an in depth look at what our workflow would look like.
We are b2b selling to specific segment of manufacturing industry. Our top 20 products we expect to see inventory turn on a weekly basis. Our customers will order the product to either inventory on their end, order for several jobs flowing through their production, or by individual job. Many customers will order on next day air delivery as they may receive rush orders or may have missed ordering for a particular job.
This means that we have to manage our stock commitment/promised manually. We may have qty 100 in stock but have multiple orders for total qty 50 but expect another order shortly for another 100 but still have to maintain inventory for any rush orders coming in. So we will short ship qty in order to fulfill existing orders, backorders, and potential future orders till our next inventory replenishment arrives. This is why using the default backorder and stock level in woocommerce will not work for us. This in turn leads us to why we need to be able to split order by qty manually.
In addition we have a particular category that will always ship freight due to size and weight restrictions of most parcel shippers. This category of product we will initially have our supplier blind ship on our behalf. So we would automate this category to always split out as a child order. We can handle this by just scripting that if an order contains this category or product turn on “Auto Split” and apply split so that exclusive category or product is split in to child order. Then reset split_status custom field back to “0” in the event that any of the other product needs to be short shipped as per above. And finally turn off “Auto Split”. Then the shipping person can short ship remainder order if required.
Example:
Order 0001 (status processing)
Item A: qty 25
Item B: qty 10
Item C: qty 100Script (pseudo):
function(checkNewOrderCategoryC) {
var newOrder = wc_new_order;
var autoSplit = auto_split;
var splitStatus = split_status;
autoSplit = 0;//wc_category_c is always exclusive so will be split to new order
if (newOrder.includes(wc_category_c)) {
autoSplit = 1;
split();if (splitStatus == 1 && autoSplit == 1) {
splitStatus = 0;
autoSplit = 0;
}
}else {
autoSplit = 0;
splitStatus = 0; //redundant reset to “0”, just in case.
}
}Result:
Order 0001-1 (status processing)
Item A: qty 25
Item B: qty 100Order 0001-2 (status processing)
Item C: qty 12
The user now needs to review Order 0001-1 to determine if they need to short ship. Since split_status should have been set to “0” the user can manually split as needed.
We would also script that any time a manual qty split is performed the second child order_status is always set to “backordered”.
User performs the qty split manually and the final result may look something like this.
Order 0001-2 (status processing)
Item C: qty 12
Order 0001-3 (status processing)
Item A: qty 13
Item B: qty 10Order 0001-4 (status backordered)
Item A: qty 12
Item B: qty 90We would script in to the edit order page a “qty shipped” input field that only accepts numeric input and is initially set to the qty ordered. At bottom we would place a “update” button that when clicked would change order status to “complete”. Once order_status is “complete” we would push to our inventory system and reduce our inventory by this amount.
In the event that any line item has “qty shipped” value changed to other than the qty ordered we would apply the split action on “update” button click and then set order_status to “complete” on the first child order created and “backordered” on the second child order.
The second order which has order_status “backordered” could then be qty manual split again if user needs to fulfill another partial shipment of any qty. And so on.
Since we are only every qty manual split by 1 order we would populate the meta “qty shiped”:”qty ordered – qty shipped” in the event the “qty shipped” field has changed.
Hope this isn’t too much info but it is the workflow that we expect to implement. So any documentation that could be provided for us to quickly implement would be appreciated.
Forum: Plugins
In reply to: [Order Splitter for WooCommerce] Presale questionDigging further it appears there is no way to group line items in to new child order if manually splitting. Again reference my example above. This would be a requirement for us and it appears from a few posts others are looking for this. Is this something that is in development and if so how far out are we looking for release?
Forum: Plugins
In reply to: [Order Splitter for WooCommerce] Presale questionAlso, is it possible to set the default split by category vs. individual product? Category A, Category B, Category C. Category A and B should always be inclusive. Any order containing category C should always be exclusive but should still be split in to one child order containing all quantity ordered of category C.
Here is what I currently have but this obviously makes the border animation quite jumpy. That is why being able to use a before and then left, top, bottom, right would be ideal.
}
#search-circle {
border: 3px solid transparent;}
#search-circle:hover {
background-color: white;
border-radius: 100% !important;
box-sizing: initial !important;
box-shadow: 0 2px 10px rgb(0 0 0 / 25%) !important;
cursor: pointer;
border-top: 3px solid #78a300 !important;
border-right: 3px solid #78a300 !important;
border-bottom: 3px solid #78a300 !important;
border-left: 3px solid #78a300 !important;
right: -3px !important;
top: -3px !important;
transition:
border-color 0s ease-out 0.5s,
border-top 0.2s ease-out,
border-right 0.2s ease-out 0.1s,
border-bottom 0.2s ease-out 0.225s,
border-left 0.2s ease-out 0.36s;
}Also, to clarify, as I realized I am not giving the full picture here. I am applying the #search-circle id via js to the fibosearch icon in my functions.php. What I actually did was create a svg circle that I then placed behind the icon and then append the icon in to the svg circle.
add_action( 'wp_footer', 'search_icon_append'); function search_icon_append (){ ?> <script> document.addEventListener("DOMContentLoaded", function(event) { var cir2 = document.getElementById("account-circle"); var cir2_clone = cir2.cloneNode(true); var icon = document.getElementsByClassName('dgwt-wcas-ico-magnifier')[0]; document.getElementsByClassName("site-search")[0].appendChild(cir2_clone); cir2_clone.id = "search-circle"; icon.setAttribute("viewBox", "0 0 100 100"); icon.setAttribute("x", "12.5px"); icon.setAttribute("y", "12.5px"); var fragment = document.createDocumentFragment(); fragment.appendChild(icon); cir2_clone.appendChild(fragment); }); </script> <?php }
I then apply the class to the svg circle when my cart is not triggered. I can scrap the scripts and just use the standard icon but still looking to understand how fibosearch hides the before and after pseudo.
/*********** Show Overlay On Search Icon Click ************/ add_action( 'wp_footer', 'search_icon_overlay'); function search_icon_overlay (){ ?> <script> document.addEventListener("click", function(event) { var form = document.getElementsByClassName("dgwt-wcas-search-form")[0]; var searchBox = document.getElementsByClassName("dgwt-wcas-search-input")[0]; var prime = document.getElementsByClassName('storefront-primary-navigation')[0]; var cartIcon = document.getElementsByClassName("vi-wcaio-sidebar-cart-icon-wrap")[0]; var head = document.getElementById("masthead"); var body = document.getElementsByTagName("body")[0]; var target = event.target.className; var overlay = document.getElementsByClassName("vi-wcaio-sidebar-cart-overlay")[0]; var triggered = false; if (overlay.className == "vi-wcaio-sidebar-cart-overlay") { triggered = true; } else { triggered = false; } if(target == "vi-wcaio-sidebar-cart-overlay" && triggered || target == "search-circle" && triggered) { overlay.className = "vi-wcaio-sidebar-cart-overlay vi-wcaio-disabled"; prime.style.display = "block"; form.style.display = "none"; cartIcon.classList.remove("site-search-on-click-others"); searchIcon.classList.remove('site-search-on-click'); head.classList.remove("site-search-on-click-head"); body.classList.remove("site-search-lock-scroll"); } else if (target == "[object SVGAnimatedString]") { overlay.className = "vi-wcaio-sidebar-cart-overlay"; prime.style.display = "none"; form.style.display = "block"; cartIcon.classList.add("site-search-on-click-others"); searchBox.classList.add("site-search-on-click-box"); head.classList.add("site-search-on-click-head"); head.classList.add("scrolled"); body.classList.add("site-search-lock-scroll"); } }); </script> <?php }
Forum: Plugins
In reply to: [WooCommerce] Hierarchy SlugAwesome. Thanks so much.
Awesome. Worked perfectly. Thanks so much!
Here is a link to an image of what I am trying to change. So as you can see I have multiple attributes with the same name. I am trying to get this to display the term slug rather than the term name. Just trying to get a general idea of where in the woocommerce directory this code is stored.
https://drive.google.com/file/d/1DKMZTbdEySJ5ToPBmIu5Ex46kUYJdBTy/view?usp=sharing