ppoils

Thanks for the quick response. I want to make sure I am understanding you correctly. I should be okay to do a database optimize on an Innodb running under MySql 5.7, Correct?

Our host is updating to MySql 8.0 on our server on October 11!

Thanks for all the help and patience. We have successfully started the sync from WC to Square.

I do have one suggestion. The button “Import all products from Square” (WooCommerce->Settings->Square->Settings) should change to say “Export all products to Square” when the Sync is WooCommerce. I can close this and submit a new issue, if you would like. I also happy to mark this as resolved if the suggestion could added to the list of suggestions.

xuw28, thanks that helps a lot. I want to clarify and maybe narrow down our “options” and reduce the amount of research I must do for requirements and sync issues.

We will use WC as our sync setting. We have multiple categories on 95% of our products to help customers find what they want, to control discounting, and to enable affiliate commissions. We do not really need categories in Square.

We do not keep inventory as all our items are packaged to order. So we use YITH Preorder to keep all of our products on pre-order and post notices so people know they will be charged at the time of order for all products.

The owners do limited sales from Square while they are on the road, so we do want products and prices synced to Square.

I am happy to do imports/merge of data within WC to update any setting on products to do a one-time cleanup of the settings.

So, here are some questions:

• When the sync from WC-> square occurs, I understand that the first alphabetical category syncs to square. When you say alphabetical category, does that also include all subcategories, or are subcategories ignored?
• In each product is a checkbox “Sync with Square”. Is this to sync Inventory data or product data or both? If we turn this off, does it still sync product updates (price and product name) to Square (assuming the sku matches in both systems)?
• If we add a new product in WC will it sync to Square? I am sure we need to put a sku in WC. Do we also need to check the “Sync with Square” box? Could this be clarified in the plugin documentation?
• Previous to last week, we were syncing Square. Is it safe to assume that implies that our WordPress host, WPEngine, has all the settings right for our sync?
• We are currently set to Sync WC. I am pretty certain that Product Names are not being synced from WC to Square. To give you diagnostic info to help resolve this issue, what steps should I take? I can modify any number of product titles in WC and do anything on the WC side.
• The information above that says which fields sync from WC to Square, could this be updated into the documentation for the plugin? I could not find this.

I am sure we will have an ongoing dialog! Thanks for all the help!

Igor,

I have done some testing and the failure that I described is not currently happening.

I would like to confirm something.  When WooCommerce is set as sync (our current setting), should product data sync from WC to Square?  If we modify the price or (long) description is WC, will those changes sync to Square?  What data Syncs from WC to Square?  I understand that the SKUs must match for the data to sync.

We want to WC as our system of record and sync Name, Description, and Price changes and new products from WC to Square.? Is that possible?

Right now, data changes in WC do not appear to be updating Square.

We have a problem. data is syncing from Square to WC. I can confirm that post_content and tax:product_cat from Square are overriding data that I manually update in WooCommerce. Our WooCommerce->Settings->Square settings are Sync Settings WooCommerce, Sync Inventory unchecked, Sync Interval 15 minutes, Enable Logging unchecked. This should NOT be happening.

What should I do to debug? Can we do a remote session and I can demonstrate?

I have confirmed that a few products have the “Send product data to Square” checked. I did not force a Sync as the button says “Sync all products from Square”. We do NOT want to sync products from Square to WC, we want the opposite. Is the button mis-labeled?

The reply just posted by Igor is to a previous comment that had already been replied to. The current comment/update/post is repeated below:

Last night, I set Sync to be WooCommerce with a 1 hour sync, Enable to push inventory changes to Square is OFF, Log Debug messages is off.

The products in WC did not get messed up, which is fantastic. However, product name and price updates did not sync to Square. That’s not what we expected. Again, we dont need inventory to sync, we do want product names and prices to sync. What should be our next step?

Igor, you responded to an earlier post that had already been replied to. Here is the current post repeated:

Last night, I set Sync to be WooCommerce with a 1 hour sync, Enable to push inventory changes to Square is OFF, Log Debug messages is off.

The products in WC did not get messed up, which is fantastic. However, product name and price updates did not sync to Square. That’s not what we expected. Again, we dont need inventory to sync, we do want product names and prices to sync. What should be our next step?

Last night, I set Sync to be WooCommerce with a 1 hour sync, Enable to push inventory changes to Square is OFF, Log Debug messages is off.

The products in WC did not get messed up, which is fantastic. However, product name and price updates did not sync to Square. That’s not what we expected. Again, we dont need inventory to sync, we do want product names and prices to sync. What should be our next step?

Saif, I will contact the site owners and see if they will let me test on the production site. I will have to do a backup of just the products with the intent to restore them if there is an issue. The site is live, and we need to be open to take orders.

This wont happen till at least Monday night PDT

Currently, Sync is set to Do Not Sync Product Data. The last time we set it to WC, our data was changed to match the Square data. We do not need to sync inventory as we make all products to order (all pre-order).

I am concerned that if I turn on Sync again on our production site that we will have to spend another three days cleaning up the data AGAIN. Our staging site probably isn’t set for this with Square either.

I am open to ideas you may have to protect the site data as well as to find the cause of the issues we experienced.

WordPress Environment

WordPress address (URL): https://www.plantpranaoils.com
Site address (URL): https://www.plantpranaoils.com
WC Version: 7.4.1
REST API Version: ?</img> 7.4.1
WC Blocks Version: ?</img> 9.4.4
Action Scheduler Version: ?</img> 3.5.4
Log Directory Writable: ?</img>
WP Version: 6.1.1
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?</img>
Language: en_US
External object cache: –

Server Environment

Server Info: Apache
PHP Version: 8.0.28
PHP Post Max Size: 100 MB
PHP Time Limit: 3600
PHP Max Input Vars: 10000
cURL Version: 7.74.0
OpenSSL/1.1.1n

SUHOSIN Installed: –
MySQL Version: 5.7.40-43-log
Max Upload Size: 50 MB
Default Timezone is UTC: ?</img>
fsockopen/cURL: ?</img>
SoapClient: ?</img>
DOMDocument: ?</img>
GZip: ?</img>
Multibyte String: ?</img>
Remote Post: ?</img>
Remote Get: ?</img>

Database

WC Database Version: 7.4.1
WC Database Prefix: wp_
Total Database Size: 297.04MB
Database Data Size: 195.56MB
Database Index Size: 101.48MB
wp_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 1.52MB + Index: 0.38MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 11.52MB + Index: 12.02MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 2.02MB + Index: 1.33MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 2.02MB + Index: 1.28MB + Engine InnoDB
wp_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_affiliatemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_affiliates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_campaigns: Data: 0.00MB + Index: 0.00MB + Engine
wp_affiliate_wp_coupons: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_creatives: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_customermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_payouts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_referralmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_referrals: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_rest_consumers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_sales: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_visits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_afwc_campaigns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_afwc_commission_plans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_afwc_hits: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_afwc_payouts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_afwc_payout_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_afwc_referrals: Data: 0.05MB + Index: 0.08MB + Engine InnoDB
wp_bookly_appointments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bookly_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_customer_appointments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_bookly_email_log: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_bookly_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_gift_cards: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_gift_card_services: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bookly_gift_card_staff: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bookly_holidays: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bookly_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_mailing_campaigns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bookly_mailing_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_mailing_list_recipients: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bookly_mailing_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_news: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_bookly_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_schedule_item_breaks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bookly_sent_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bookly_series: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_services: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bookly_shop: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_bookly_staff: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bookly_staff_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_staff_preference_orders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bookly_staff_schedule_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_bookly_staff_services: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_bookly_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_bookly_sub_services: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 10.52MB + Index: 10.08MB + Engine InnoDB
wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_entry: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_field_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_upgrades: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 13.31MB + Index: 0.34MB + Engine InnoDB
wp_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_pimwick_gift_card_activity: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_postmeta: Data: 73.59MB + Index: 61.05MB + Engine InnoDB
wp_posts: Data: 10.34MB + Index: 4.84MB + Engine InnoDB
wp_pv_commission: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_qk5kb9dbtm_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_qk5kb9dbtm_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_qk5kb9dbtm_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_qk5kb9dbtm_options: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
wp_qk5kb9dbtm_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_qk5kb9dbtm_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_qk5kb9dbtm_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_qk5kb9dbtm_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_qk5kb9dbtm_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_qk5kb9dbtm_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_qk5kb9dbtm_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_qk5kb9dbtm_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_qk5kb9dbtm_yoast_indexable: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_qk5kb9dbtm_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_qk5kb9dbtm_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_qk5kb9dbtm_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_qk5kb9dbtm_yoast_seo_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_qk5kb9dbtm_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
wp_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_revslider_slides_bkp: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_tec_events: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_tec_occurrences: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_tec_series_relationships: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 1.17MB + Index: 0.20MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_usermeta: Data: 3.47MB + Index: 2.86MB + Engine InnoDB
wp_users: Data: 0.14MB + Index: 0.14MB + Engine InnoDB
wp_user_registration_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 1.52MB + Index: 1.23MB + Engine InnoDB
wp_wc_order_stats: Data: 0.45MB + Index: 0.41MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.28MB + Index: 0.45MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfconfig: Data: 3.27MB + Index: 0.00MB + Engine InnoDB
wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilemods: Data: 17.55MB + Index: 0.00MB + Engine InnoDB
wp_wfhits: Data: 1.02MB + Index: 0.17MB + Engine InnoDB
wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfissues: Data: 0.03MB + Index: 0.06MB + Engine InnoDB
wp_wfknownfilelist: Data: 8.52MB + Index: 0.00MB + Engine InnoDB
wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wflogins: Data: 0.25MB + Index: 0.08MB + Engine InnoDB
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_role_counts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfpklist_template_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfstatus: Data: 0.20MB + Index: 0.13MB + Engine InnoDB
wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfwafconfig: Data: 3.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpfb_gettwitter_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpml_mails: Data: 21.52MB + Index: 0.00MB + Engine InnoDB
wp_wpstg_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wp_phpmyadmin_extension__errors_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcaf_affiliates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcaf_clicks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yith_wcaf_commissions: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wp_yith_wcaf_commission_notes: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcaf_payments: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcaf_payment_commission: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yith_wcaf_payment_notes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcaf_rate_rulemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yith_wcaf_rate_rules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_indexable: Data: 2.22MB + Index: 0.61MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.11MB + Index: 0.17MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_yoast_prominent_words: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.45MB + Index: 0.28MB + Engine InnoDB

Post Type Counts

attachment: 989
boxzilla-box: 1
custom_css: 2
giftcard: 4
mc4wp-form: 1
nav_menu_item: 36
nf_sub: 124
page: 39
portfolio: 9
post: 162
product: 1429
product_variation: 20
revision: 26
shop_coupon: 29
shop_order: 8421
shop_order_refund: 15
tribe_events: 145
tribe_organizer: 22
tribe_rsvp_attendees: 5
tribe_rsvp_tickets: 3
tribe_tpp_attendees: 2
tribe_tpp_orders: 26
tribe_tpp_tickets: 7
tribe_venue: 17
tribe_wooticket: 6795
urp_review: 6
user_registration: 1
wc_afrsm: 5
wp_global_styles: 2
wpcf7_contact_form: 4

Security

Secure connection (HTTPS): ?</img>
Hide errors from visitors: ?</img>

Active Plugins (39)

WP Engine Smart Plugin Manager: by WP Engine – 5.3.1
Gutenberg Block for WooCommerce Product Table: by Barn2 Plugins – 1.0.7
Bookly: by Bookly – 21.5.1
Contact Form 7: by Takayuki Miyoshi – 5.7.4
Customizer Export/Import: by The Beaver Builder Team – 0.9.5
Duplicate Page: by mndpsingh287 – 4.5.1
Enable Media Replace: by ShortPixel – 4.0.3
Event Tickets Plus: by The Events Calendar – 5.6.8
Event Tickets: by The Events Calendar – 5.5.9.1
The Events Calendar PRO: by The Events Calendar – 6.0.9.2
GA Google Analytics: by Jeff Starr – 20230306
Site Kit by Google: by Google – 1.95.0
WPBakery Page Builder: by Michael M - WPBakery.com – 6.10.0
MC4WP: Mailchimp for WordPress: by ibericode – 4.9.1
WooCommerce Merge Orders: by Vibe Agency – 1.3.8 (update to version 1.3.9 is available)
WooCommerce PDF Invoices, Packing Slips, Delivery Notes and Shipping Labels: by WebToffee – 4.0.7
PW WooCommerce Bulk Edit: by Pimwick
LLC – 2.111

PW WooCommerce Gift Cards Pro: by Pimwick
LLC – 1.434

Slider Revolution: by ThemePunch – 6.6.11
Skyla Essential: by WClassic – 1.0.0
WooCommerce Split Orders: by Vibe Agency – 1.6.6 (update to version 1.6.7 is available)
The Events Calendar: by The Events Calendar – 6.0.10
Events Tickets Extension: Virtual / Online Event Tickets: by Modern Tribe
Inc. – 1.1.1

Event Tickets/Eventbrite Extension: Show Cost Field: by Modern Tribe
Inc. – 1.0.1

Events Tickets Extension: Ticket Email Settings: by Modern Tribe
Inc. – 1.0.0

User Registration: by WPEverest – 2.3.2.1
Advanced Flat Rate Shipping For WooCommerce: by theDotstore – 4.1.2
WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.56
WooCommerce Product Table: by Barn2 Plugins – 3.0.5
WooCommerce Square: by WooCommerce – 3.6.1
WooCommerce: by Automattic – 7.4.1 (update to version 7.5.0 is available)
Wordfence Security: by Wordfence – 7.9.1
Yoast SEO Premium: by Team Yoast – 20.2.1
Yoast SEO: by Team Yoast – 20.2.1
WP phpMyAdmin: by Puvox.software – 5.2.1.02
YITH WooCommerce Affiliates Premium: by YITH – 2.11.0
YITH WooCommerce Ajax Search: by YITH – 1.28.0
YITH Pre-Order for WooCommerce Premium: by YITH – 2.11.0
YITH WooCommerce Wishlist: by YITH – 3.18.0

Inactive Plugins (0)

Dropin Plugins (1)

advanced-cache.php: advanced-cache.php

Must Use Plugins (6)

Force Strong Passwords - WPE Edition: by Jason Cosper – 1.8.0
installatron_hide_status_test.php: by –
WP Engine Cache Plugin: by WP Engine – 1.1.2
WP Engine Seamless Login Plugin: by WP Engine – 1.6.0
WP Engine Security Auditor: by wpengine – 1.0.10
WP Engine System: by WP Engine – 5.0.1

Settings

API Enabled: ?</img>
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
pw gift card (pw-gift-card)
simple (simple)
variable (variable)
wgm_gift_card (wgm_gift_card)

Taxonomies: Product Visibility: exclude_from_catalog (exclude_from_catalog)
exclude_from_search (exclude_from_search)
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: ?</img>
Enforce Approved Product Download Directories: –
Order datastore: WC_Order_Data_Store_CPT

WC Pages

Shop base: ?</img> Page visibility should be public
Cart: #6 - /cart/
Checkout: #7 - /checkout/
My account: #8 - /my-account/
Terms and conditions: #5840 - /terms-and-conditions/

Theme

Name: Skyla Child
Version: 1.0.1
Author URL:
Child Theme: ?</img>
Parent Theme Name: Skyla
Parent Theme Version: 1.0.1
Parent Theme Author URL: https://wpisset.com
WooCommerce Support: ?</img>

Templates

Overrides: –

Pimwick Plugins

PW WooCommerce Gift Cards Pro: License key: PW-632e410bb5d21
Result: success
Cached: 2023-03-18

Square

Environment: Production
Tokenization Enabled:
Debug Mode: Off

Admin

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
new-product-management-experience
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: minified-js
product-variation-management
settings

Daily Cron: ?</img> Next scheduled: 2023-03-18 18:28:47 -05:00
Options: ?</img>
Notes: 55
Onboarding: completed

Action Scheduler

Complete: 3,865
Oldest: 2023-02-14 23:28:58 -0600
Newest: 2023-03-17 23:05:58 -0500

Failed: 6
Oldest: 2023-02-23 21:54:00 -0600
Newest: 2023-03-09 21:34:22 -0600

Pending: 4
Oldest: 2023-03-18 00:05:58 -0500
Newest: 2023-03-24 15:18:19 -0500

Status report information

Generated at: 2023-03-18 00:03:47 -05:00
`

That was a quick response. When we last attempted to change that setting to WC, it again synced data from Square (over writing the accurate data in WC). WP/WC/Square are up to date (we do maintenance every two weeks to update). We are on PHP 8.0.

Is there any information I can provide/post?