Support » Plugin: WooCommerce » Syncing Square Sales in Store with WooCommerce Inventory Online Issues

  • Resolved wurdpressuzer

    (@wurdpressuzer)


    Hi everyone, I’ve been working on our store’s site for a few weeks now and have inputted over 400 items one by one, it’s actually pretty cool (sort of like gardening lol). Everything has been going perfectly, including making barcodes and even seeing the items I add to WordPress show up in our Square inventory at the cash register — but the plot thickens!

    After we did a test sale on our first credit card transaction yesterday (today is our grand opening!), everything worked great at the checkout, BUT not-so-great with our WooCommerce inventory management since we sell both online and in-store (our website will launch 2/2/22).

    PROBLEMS
    1) The test sale we did on a pair of earrings that we have 3 sets of wasn’t reflected in our WooCommerce inventory count. I did some reading and saw that it can take up to a full hour for stock reconciliation for in-person/store sales, but even after several hours Square still didn’t “tell” WooCommerce there should now be 2 pairs of earrings, not 3?

    2) My troubleshooting attempt was to ensure WooCommerce was our inventory master management system (it was) and to re-sync all items by clicking update after disconnecting and reconnecting Square… but the hourglass just turned and turned for over an hour, ultimately “updating” 48 products of our 400+, which basically just meant it was making duplicates or something in WooCommerce as ‘new’ items.

    I don’t know how to share screenshots in this forum since I don’t see an upload feature, but I can share anything that helps.

    We really want to be able to sell with Square up front to customers in-person, and use WooCommerce to sell online and manage ALL inventory.

Viewing 15 replies - 1 through 15 (of 24 total)
  • Plugin Support Igor H woo-hc

    (@ihereira)

    Hi there,

    For better assistance please provide the following:

    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”. 

    Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

    For screenshots you may want to use https://snipboard.io – please follow the instructions on that page, then paste the URL in this thread.

    Once you’ve done that, paste it here in your response. Thank you.

    Thread Starter wurdpressuzer

    (@wurdpressuzer)

    Hi @ihereira thanks for your reply! Sure, here you go:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://thebirdsnestboutique.com
    Site address (URL): https://thebirdsnestboutique.com
    WC Version: 6.0.0
    REST API Version: ✔ 6.0.0
    WC Blocks Version: ✔ 6.3.3
    Action Scheduler Version: ✔ 3.3.0
    WC Admin Version: ✔ 2.9.4
    Log Directory Writable: ✔
    WP Version: 5.8.3
    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.21
    PHP Post Max Size: 512 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 1000
    cURL Version: 7.68.0
    OpenSSL/1.1.1f
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.3.29-MariaDB-0ubuntu0.20.04.1
    Max Upload Size: 512 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 6.0.0
    WC Database Prefix: wp_
    Total Database Size: 27.93MB
    Database Data Size: 19.74MB
    Database Index Size: 8.19MB
    wp_woocommerce_sessions: Data: 0.16MB + 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.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.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: 1.52MB + Index: 0.88MB + 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: 0.48MB + Index: 0.39MB + Engine InnoDB
    wp_barcode_v3_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_barcode_v3_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_barcode_v3_label_sheets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_barcode_v3_paper_formats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_barcode_v3_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_barcode_v3_templates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_barcode_v3_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_barcode_v3_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
    wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
    wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_jet_smart_filters_indexer: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 5.06MB + Index: 0.31MB + Engine InnoDB
    wp_postmeta: Data: 8.34MB + Index: 3.98MB + Engine InnoDB
    wp_posts: Data: 2.52MB + Index: 0.56MB + Engine InnoDB
    wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_sbi_instagram_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.27MB + Index: 0.19MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.06MB + 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.02MB + Index: 0.03MB + 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.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.17MB + Index: 0.33MB + 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_woocommerce_square_customers: Data: 0.02MB + 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: 0.02MB + Index: 0.00MB + 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
    
    ### Post Type Counts ###
    
    attachment: 1103
    elementor_font: 2
    elementor_library: 9
    jet-popup: 1
    jet-smart-filters: 3
    jet-woo-builder: 5
    nav_menu_item: 10
    page: 11
    post: 3
    product: 526
    product_variation: 709
    revision: 282
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (15) ###
    
    Elementor Pro: by Elementor.com – 3.4.1
    Elementor: by Elementor.com – 3.5.3
    Smash Balloon Instagram Feed: by Smash Balloon – 2.9.9
    JetCompareWishlist For Elementor: by Crocoblock – 1.4.3
    JetPopup: by Crocoblock – 1.4.1
    JetSmartFilters: by Crocoblock – 2.3.7
    JetWooBuilder For Elementor: by Crocoblock – 1.11.3
    OneSignal Push Notifications: by OneSignal – 2.2.3
    Barcode Printing for WooCommerce & Contact Form 7 - (business): by UkrSolution – 3.3.15
    WooCommerce Square: by WooCommerce – 2.7.0
    WooCommerce: by Automattic – 6.0.0
    APIExperts Square for WooCommerce: by Wpexpertsio – 4.1.1
    WordPress Importer: by wordpressdotorg – 0.7
    YITH WooCommerce Quick View: by YITH – 1.10.0
    YITH WooCommerce Wishlist: by YITH – 3.4.0
    
    ### Inactive Plugins (2) ###
    
    YITH Custom Login: by YITH – 1.1.8
    YITH WooCommerce Affiliates: by YITH – 1.12.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: #6 - /shop/
    Cart: #7 - /cart/
    Checkout: #8 - /checkout/
    My account: #9 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Hello Elementor
    Version: 2.4.1 (update to version 2.4.2 is available)
    Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
    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: –
    
    ### Square ###
    
    Environment: Production
    Tokenization Enabled: ✔
    Debug Mode: Off
    
    ### Action Scheduler ###
    
    Complete: 2,334
    Oldest: 2021-12-12 22:16:44 +0000
    Newest: 2022-01-07 20:01:06 +0000
    
    Pending: 2
    Oldest: 2022-01-07 21:01:06 +0000
    Newest: 2022-01-12 14:58:15 +0000
    
    ### Status report information ###
    
    Generated at: 2022-01-07 20:57:26 +00:00
    

    Also, here is the listing under “Fatal Error Log” below:

    2021-12-29T02:11:56+00:00 CRITICAL Uncaught Error: Cannot use object of type WP_Error as array in /home/thebirdsnestboutique.com/public_html/wp-content/plugins/woosquare/admin/modules/product-sync/_inc/WooToSquareSynchronizer.class.php:1577
    Stack trace:
    #0 /home/thebirdsnestboutique.com/public_html/wp-content/plugins/woosquare/admin/modules/product-sync/_inc/WooToSquareSynchronizer.class.php(1456): WooToSquareSynchronizer->uploadImage()
    #1 /home/thebirdsnestboutique.com/public_html/wp-content/plugins/woosquare/admin/modules/product-sync/product_sync.php(416): WooToSquareSynchronizer->addProduct()
    #2 /home/thebirdsnestboutique.com/public_html/wp-includes/class-wp-hook.php(303): woo_square_add_edit_product()
    #3 /home/thebirdsnestboutique.com/public_html/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters()
    #4 /home/thebirdsnestboutique.com/public_html/wp-includes/plugin.php(470): WP_Hook->do_action()
    #5 /home/thebirdsnestboutique.com/public_html/wp-includes/post.php(4468): do_action()
    #6 /home/thebirdsnestboutique.com/public_html/wp-inclu in /home/thebirdsnestboutique.com/public_html/wp-content/plugins/woosquare/admin/modules/product-sync/_inc/WooToSquareSynchronizer.class.php on line 1577
    Plugin Support Igor H woo-hc

    (@ihereira)

    Hi there,

    So sorry to hear about what happened. This looks to be in relation to the Square plugin.

    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 assist you further there. Thank you 🙂

    Thread Starter wurdpressuzer

    (@wurdpressuzer)

    Thanks so much @ihereira I just completed the support ticket request.

    Is there anything I should do in the meantime to make sure items selling in the store are being properly removed and subtracted from the master inventory counts I inputted into WooCommerce?

    Plugin Support Igor H woo-hc

    (@ihereira)

    Hello,

    Our team will inform you as soon as they can, please expect a response for better assistance.

    Thanks 🙂

    Thread Starter wurdpressuzer

    (@wurdpressuzer)

    Hi @ihereira thank you so much, I’m impressed and thankful for your quick attention and help. It means a lot, because our grand opening was just 2 days ago, and once this inventory syncing situation is ironed out, we’ll be able to launch the website we’ve been developing since August of 2021!

    Could we please keep this thread open until the issue is resolved so I can share my insight to help others in the future?

    I’m looking forward to getting this resolved and appreciate the help!

    Plugin Support Juan G. woo-hc

    (@judagutor)

    Hi @wurdpressuzer!

    You are welcome; we are glad to assist.

    We will leave this thread open so you can share the solution you get.

    Thank you for keeping us posted!

    Thread Starter wurdpressuzer

    (@wurdpressuzer)

    Hi @judagutor & @ihereira I just double-checked my inbox and any spam folders, and I haven’t heard back from WordPress / WooCommerce on the support ticket from last week. That might be normal for processing time, but I wanted to make sure I wasn’t missing something. Thank you both!

    Plugin Support Juan G. woo-hc

    (@judagutor)

    Hi @wurdpressuzer!

    Usually, the response time is less than a few days. Nonetheless, let me check for you.

    Could you please share the ticket # or ID you received via email when you made the request?

    Thanks!

    Thread Starter wurdpressuzer

    (@wurdpressuzer)

    Hey @judagutor thanks for asking — I can’t find anything as far as a ticket or support number. Strange. I know I submitted it, included all the requested screen shots and data, and I even got a success message it was submitted. Is there anywhere I can check within my account for active tickets? If it helps my email associated with the ticket was birdsnestoakwood at the letter after-f-mail, thanks!

    Plugin Support Margaret S. woo-hc

    (@margaretwporg)

    Hi @wurdpressuzer

    I’m so sorry that you haven’t heard back yet on your support ticket. I’m checking on this and will get back to you ASAP.

    In the meantime, just FYI, you can also get in touch with our Square team on this forum – https://wordpress.org/support/plugin/woocommerce-square/

    Plugin Support Margaret S. woo-hc

    (@margaretwporg)

    Hi @wurdpressuzer

    I’m afraid we didn’t receive your ticket!

    Kindly resubmit it via WooCommerce.com > My Account > Support. You may need to log into your WooCommerce 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.

    When you submit a support request, you should receive a confirmation with a ticket number. You can expect to see that confirmation within a few minutes.

    It seems you had started a couple of forum threads.

    Please re-submit your support request and you’ll hear from us soon. 🙂

    Cheers

    Thread Starter wurdpressuzer

    (@wurdpressuzer)

    Hi @margaretwporg thanks a lot for your help. Should I support my ticket using the link you supplied just above, or the earlier link for WooCommerce Square Support?

    PS: In the meantime, I submitted at the WooCommerce support site within my account like you suggested, and was given a success message. *Do you know why this support ticket didn’t ask for the crash data and copy/paste web stats like I originally shared and included above last week in my original post reply?

    Thank you.

    Plugin Support Igor H woo-hc

    (@ihereira)

    Hello there,

    Happy to know you have received a confirmation, as mentioned the request should be placed at: WooCommerce.com > My Account > Support. As you already did.

    Do you know why this support ticket didn’t ask for the crash data and copy/paste web stats like I originally shared and included above last week in my original post reply?

    Feel free to reply to the ticket and submit any additional data, as well as the URL/link regarding this forum thread.

    Thanks for your patience while our team looks into this.

    Thread Starter wurdpressuzer

    (@wurdpressuzer)

    Thanks so much @ihereira I just heard from Shohan Hossain via email replying to my ticket from last week. He’s asking for some data from my end which I’ll provide immediately. As long as they’re a verified WordPress WooCommerce engineer, I wouldn’t be opposed to someone logging into my account and troubleshooting.

    I’ll reply back as soon as any progress happens, talk soon!

Viewing 15 replies - 1 through 15 (of 24 total)
  • You must be logged in to reply to this topic.