Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter Steve D

    (@awdsteve)

    WooCommerce existed before square was setup. All products are added in WC which is why we have it as our source of record. The locations are the website (90% of volume) and then a square terminal/POS in the art gallery accounts for the remaining sales. Are you saying if we delete the duplicates on the square side they should not return? Below is a copy of the system report:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://sedonaartscenter.org
    Site address (URL): https://sedonaartscenter.org
    WC Version: 4.3.3
    REST API Version: ✔ 1.0.10
    WC Blocks Version: ✔ 2.7.3
    Action Scheduler Version: ✔ 3.1.6
    WC Admin Version: ✔ 1.3.1
    Log Directory Writable: ✔
    WP Version: ❌ 5.4.2 - There is a newer version of WordPress available (5.5)
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.6
    PHP Post Max Size: 100 MB
    PHP Time Limit: 3600
    PHP Max Input Vars: 10000
    cURL Version: 7.58.0
    OpenSSL/1.1.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.29-32-log
    Max Upload Size: 50 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 4.3.3
    WC Database Prefix: wp_
    Total Database Size: 422.20MB
    Database Data Size: 251.51MB
    Database Index Size: 170.69MB
    wp_woocommerce_sessions: Data: 0.08MB + 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.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.50MB + Index: 0.22MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 3.52MB + Index: 5.03MB + 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.03MB + Index: 1.27MB + 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.08MB + Index: 1.30MB + Engine InnoDB
    wp_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 4.52MB + Index: 5.86MB + Engine InnoDB
    wp_facetwp_index: Data: 0.23MB + Index: 0.30MB + Engine InnoDB
    wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_fooevents_check_in: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_addon_payment_callback: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_addon_payment_transaction: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_entry: Data: 3.52MB + Index: 0.45MB + Engine InnoDB
    wp_gf_entry_meta: Data: 9.52MB + Index: 10.58MB + Engine InnoDB
    wp_gf_entry_notes: Data: 1.52MB + Index: 0.33MB + Engine InnoDB
    wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_meta: Data: 0.30MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gf_form_view: Data: 0.28MB + Index: 0.23MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailchimp_carts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mclean_refs: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_mclean_scan: Data: 1.52MB + Index: 0.23MB + Engine InnoDB
    wp_mgmlp_folders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 4.42MB + Index: 0.27MB + Engine InnoDB
    wp_pantheon_sessions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_images: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_imports: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_pmxi_posts: Data: 0.52MB + Index: 0.33MB + Engine InnoDB
    wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_postmeta: Data: 57.59MB + Index: 55.19MB + Engine InnoDB
    wp_posts: Data: 6.52MB + Index: 3.63MB + Engine InnoDB
    wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_redirection_404: Data: 1.02MB + Index: 0.56MB + Engine InnoDB
    wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_redirection_logs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_swp_cf: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_swp_index: Data: 8.52MB + Index: 8.00MB + Engine InnoDB
    wp_swp_log: Data: 1.52MB + Index: 2.13MB + Engine InnoDB
    wp_swp_tax: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_swp_terms: Data: 1.52MB + Index: 1.03MB + Engine InnoDB
    wp_termmeta: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.33MB + Index: 0.27MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.06MB + 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: 68.59MB + Index: 59.22MB + Engine InnoDB
    wp_users: Data: 8.52MB + Index: 7.55MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    wp_wc_deposits_payment_plans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_deposits_payment_plans_schedule: Data: 0.02MB + Index: 0.02MB + 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: 0.16MB + Index: 0.16MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.14MB + Index: 0.16MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.22MB + Index: 0.42MB + 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_woocommerce_square_customers: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
    wp_woo_square_integration_deleted_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woo_square_integration_logs: Data: 49.59MB + Index: 0.00MB + Engine InnoDB
    wp_yoast_indexable: Data: 5.52MB + Index: 4.22MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 0.14MB + Index: 0.22MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.11MB + Index: 0.11MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_seo_meta: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    acf-field: 130
    acf-field-group: 19
    attachment: 2727
    custom_css: 1
    elementor_library: 3
    event_magic_tickets: 2330
    mgmlp_media_folder: 14
    nav_menu_item: 42
    oembed_cache: 9
    page: 53
    people: 219
    post: 16
    product: 1728
    product_variation: 19
    revision: 63
    shop_coupon: 11
    shop_order: 3791
    shop_order_refund: 309
    tribe_events: 81
    tribe_organizer: 4
    tribe_venue: 25
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (49) ###
    
    The Events Calendar: by Modern Tribe
    Inc. – 5.1.5
    
    Gravity Forms: by Gravity Forms – 2.4.20
    Admin Columns Pro - WooCommerce: by AdminColumns.com – 3.5.1
    Admin Columns Pro: by AdminColumns.com – 5.2.3
    Advanced Cron Manager: by BracketSpace – 2.4.0
    Advanced Custom Fields PRO: by Elliot Condon – 5.9.0
    Autoptimize: by Frank Goossens (futtta) – 2.7.6
    Classic Editor: by WordPress Contributors – 1.6
    Elementor Pro: by Elementor.com – 2.10.3
    Elementor: by Elementor.com – 2.9.14
    Enhanced Media Library: by wpUXsolutions – 2.7.2
    The Events Calendar PRO: by Modern Tribe
    Inc. – 5.1.4
    
    FacetWP: by FacetWP
    LLC – 3.5.10
    
    Featured Image by URL: by Knawat Team – 1.1.6
    FooEvents Calendar: by FooEvents – 1.5.19
    FooEvents for WooCommerce: by FooEvents – 1.11.44
    FooEvents Custom Attendee Fields: by FooEvents – 1.4.19
    FooEvents Multi-Day: by FooEvents – 1.2.11
    Gravity Forms Mailchimp Add-On: by Gravity Forms – 4.7
    JetElements For Elementor: by Crocoblock – 2.3.2
    Mailchimp for WooCommerce: by Mailchimp – 2.4.5
    Mailgun: by Mailgun – 1.7.1
    Manage Notification E-mails: by Virgial Berveling – 1.5.1
    Media Cleaner (Pro): by Jordy Meow – 6.0.1
    Multiple Roles: by Florian TIAR – 1.3.1
    Redirection: by John Godley – 4.8
    Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.3
    SearchWP WooCommerce Integration: by SearchWP – 1.3.4 – Installed version not tested with active version of WooCommerce 4.3.3
    SearchWP: by SearchWP
    LLC – 3.1.14
    
    Theme My Login: by Theme My Login – 7.1.1
    User Switching: by John Blackbourn & contributors – 1.5.5
    Product Customer List for WooCommerce: by Kokomo – 2.9.2 – Installed version not tested with active version of WooCommerce 4.3.3
    WebP Express: by Bjørn Rosell – 0.17.5
    WooCommerce Extended Coupon Features PRO: by Soft79 – 2.6.3 – Installed version not tested with active version of WooCommerce 4.3.3
    WooCommerce Create Customer on Order: by cxThemes – 1.36 – Installed version not tested with active version of WooCommerce 4.3.3
    WooCommerce Deposits: by WooCommerce – 1.5.2 – Installed version not tested with active version of WooCommerce 4.3.3
    Multi-Carrier Shipping Plugin for WooCommerce: by PluginHive – 1.8.0
    WooCommerce POS: by kilbot – 0.4.24 – Installed version not tested with active version of WooCommerce 4.3.3
    WooCommerce Product Add-ons: by WooCommerce – 3.0.38 – Installed version not tested with active version of WooCommerce 4.3.3
    WooCommerce Square: by WooCommerce – 2.1.6
    WooCommerce Waitlist: by Neil Pie – 2.1.24
    WooCommerce: by Automattic – 4.3.3
    WooSquare Pro: by wpexperts.io – 5.6
    Yoast SEO: by Team Yoast – 14.8
    WP Image Zoom: by SilkyPress – 1.43
    WP-Optimize - Clean, Compress, Cache: by David Anderson
    Ruhani Rabin
    Team Updraft – 3.1.2
    
    WP Rocket: by WP Media – 3.6.3
    Smush: by WPMU DEV – 3.6.3
    WP Engine Advanced Cache Options: by Ethan Kennedy
    Steven Word – 1.3.3
    
    ### Inactive Plugins (1) ###
    
    Async JavaScript: by Frank Goossens (futtta) – 2.20.03.01
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Must Use Plugins (4) ###
    
    Force Strong Passwords - WPE Edition: by Jason Cosper – 1.6.4
    WP Engine Seamless Login Plugin: by WP Engine – 1.5.5
    WP Engine Security Auditor: by wpengine – 1.0.9
    WP Engine System: by WP Engine – 4.0.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)
    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: ✔
    
    ### WC Pages ###
    
    Shop base: #75 - /shop/
    Cart: #76 - /cart/
    Checkout: #77 - /checkout/
    My account: #78 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Sedona Arts Center
    Version: 1.0.0
    Author URL: https://mind.sh/are/
    Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: sedona/woocommerce/checkout/form-checkout.php
    sedona/woocommerce/content-product.php version 3.4.0 is out of date. The core version is 3.6.0
    sedona/woocommerce/content-product_cat.php
    sedona/woocommerce/content-single-product.php version 3.4.0 is out of date. The core version is 3.6.0
    sedona/woocommerce/emails/email-addresses.php version 3.2.1 is out of date. The core version is 3.9.0
    sedona/woocommerce/emails/email-customer-details.php
    sedona/woocommerce/emails/email-downloads.php
    sedona/woocommerce/emails/email-footer.php version 2.3.0 is out of date. The core version is 3.7.0
    sedona/woocommerce/emails/email-header.php version 2.4.0 is out of date. The core version is 4.0.0
    sedona/woocommerce/emails/email-order-details.php version 3.3.1 is out of date. The core version is 3.7.0
    sedona/woocommerce/emails/email-order-items.php version 3.4.0 is out of date. The core version is 3.7.0
    sedona/woocommerce/emails/email-styles.php version 3.3.0 is out of date. The core version is 4.0.0
    sedona/woocommerce/loop/add-to-cart.php
    sedona/woocommerce/loop/loop-end.php
    sedona/woocommerce/loop/loop-start.php
    sedona/woocommerce/myaccount/form-login.php version 3.4.0 is out of date. The core version is 4.1.0
    sedona/woocommerce/myaccount/my-address.php
    sedona/woocommerce/single-product/related.php version 3.0.0 is out of date. The core version is 3.9.0
    
    Outdated Templates: ❌
    					
    					
    						Learn how to update
    
    ### Square ###
    
    Environment: Production
    Tokenization Enabled: –
    Debug Mode: Off
    
    ### Action Scheduler ###
    
    Canceled: 1
    Oldest: 2020-08-06 08:39:47 -0700
    Newest: 2020-08-06 08:39:47 -0700
    
    Complete: 4,409
    Oldest: 2020-07-18 08:49:14 -0700
    Newest: 2020-08-18 07:34:20 -0700
    
    Failed: 34
    Oldest: 2019-01-18 14:54:41 -0700
    Newest: 2020-02-28 10:53:40 -0700
    
    Pending: 2
    Oldest: 2020-08-18 08:34:20 -0700
    Newest: 2020-08-24 14:48:52 -0700
    
    
    Thread Starter Steve D

    (@awdsteve)

    Resolved for the most part…there are a handful of products still not syncing over. The biggest issue was that we needed to actually set the setting for “Product system of record” in WC >> settings as it was set to do not sync 🙂 I may open this back up if I can’t find out why a handful of products aren’t syncing out of almost 600 products.

    Thank you for this fix! Popup Maker used to work for conditional logic in the past so I switched to elementor popups (I do love elementor btw – it’s really an amazing page builder)…in any case this resolved the issue 🙂

    Thread Starter Steve D

    (@awdsteve)

    Seems to be a combination of these plugins (multiple-roles – https://wordpress.org/plugins/multiple-roles/) and (theme my login – https://wordpress.org/plugins/theme-my-login/) when I turned off theme my login it redirects me to the my-account page (we have WooCommerce installed…latest 3.7) but it shows the name of me the admin…very odd.

    I will spend more time this afternoon troubleshooting…its been bothering me all weekend 🙂

    Thread Starter Steve D

    (@awdsteve)

    All plugins active (incognito mode), still running WP 2019 theme error is now “Could not switch users.” I will start deactivating plugins to find the culprit.

    Thread Starter Steve D

    (@awdsteve)

    Interesting…went in incognito mode and that seemed to do the trick! What’s the next troubleshooting step…active each plugin one by one to see which one is causing the conflict?

Viewing 6 replies - 1 through 6 (of 6 total)