Syncing Square Sales in Store with WooCommerce Inventory Online Issues

Resolved wurdpressuzer
(@wurdpressuzer)

1 year, 8 months ago

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)

1 2 →

Igor H

(@ihereira)

1 year, 8 months ago

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)

1 year, 8 months ago

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

Igor H

(@ihereira)

1 year, 8 months ago

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)

1 year, 8 months ago

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?

Igor H

(@ihereira)

1 year, 8 months ago

Hello,

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

Thanks 🙂

Thread Starter

wurdpressuzer

(@wurdpressuzer)

1 year, 8 months ago

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!

Juan G. woo-hc

(@judagutor)

1 year, 8 months ago

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)

1 year, 8 months ago

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!

Juan G. woo-hc

(@judagutor)

1 year, 8 months ago

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)

1 year, 8 months ago

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!

Margaret S. woo-hc

(@margaretwporg)

1 year, 8 months ago

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/

Margaret S. woo-hc

(@margaretwporg)

1 year, 8 months ago

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)

1 year, 8 months ago

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.

This reply was modified 1 year, 8 months ago by wurdpressuzer.
This reply was modified 1 year, 8 months ago by wurdpressuzer.

Igor H

(@ihereira)

1 year, 8 months ago

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)

1 year, 8 months ago

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)

1 2 →

The topic ‘Syncing Square Sales in Store with WooCommerce Inventory Online Issues’ is closed to new replies.

Syncing Square Sales in Store with WooCommerce Inventory Online Issues

Topic Tags

Views