WooCommerce and Square inventory is no longer synced when adding new products.

  • Resolved tomitatsuyoshi

    (@tomitatsuyoshi)


    1 year, 6 months ago

    Hello. This is an inquiry from Japan.

    My e-commerce site uses WooCommerce for its shopping cart and Square for payments.
    We also sell face-to-face, and even in that case, we sell credit cards through Square, so we manage inventory consistently on Square.

    It has worked well for products I have registered in the past.
    However, when I recently registered a new product, I’m having trouble linking Woo and Square’s inventory for some reason.

    If the cooperation between Woo and Square is going well,

    1. test purchase a product
    2. When I look at the inventory count on Woo’s product page management screen, it is 1 less than before the purchase.
    3. At the same time, the product list set in Square also decreases by 1

    This is the correct state.

    Items that have been registered in the past are as shown above. However, for a newly registered product recently, after the test purchase, the inventory in Woo’s management screen has decreased by one, but the number has not changed in Square’s product management screen.

    And vice versa.
    Basically, Square manages the number of products in stock, and for conventional products, if I increase the inventory in Square, it will be reflected in Woo 15 minutes later.
    However, for newly registered products, even if I change the stock quantity on Square, it will not be reflected in Woo’s stock quantity.

    There are two types of WooCommerce products: basic products and products with variations. In “basic products”, inventory management works in conjunction with newly registered products.

    However, in the previous registered products, the inventory is linked without any problem even if it is a “variety product”.

    I looked carefully to see if there were any differences in the registration method and items between the previous product and the newly registered product, but there was no particular difference.

    Thinking that there might be some hidden differences, I tried exporting Woo’s product data, including meta tags, and found the following.

    ?For products with problems,
    “meta: _square_item_id”
    “Meta: _square_item_variation_id
    ”
    column does not contain the unique code that should have been entered

    ?”Meta: _square_item_version
    and “meta: _square_item_variation_version
    ” contains some numbers, but the data is strange with 0 other than the first 3 digits

    Probably, if this metadata is entered properly, it seems to work without problems. Why is there no metadata?

    I would appreciate it if someone could let me know how to solve this problem.

    Tsuyoshi Tomita

    The page I need help with: [log in to see the link]

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

  • Hi @tomitatsuyoshi

    Thanks for reaching out!

    We appreciate your detailed inquiry and we’re here to help you resolve the issue you’re facing with your inventory management between WooCommerce and Square.

    Firstly, I’d like to acknowledge that you have done extensive research and testing on the issue, which is very helpful in understanding the problem. Based on your description, it seems that the issue is related to the missing or incorrect metadata for the newly registered products with variations.

    Can you please share with us if there were any changes made on your site prior to this issue happening? Like, theme, plugin or template update?

    For us to test this further, can you please try to switch to the default Storefront theme and only WooCommerce and Square plugins are enabled, create a new product, sync with Square, create a test order for this new product using Square Sandbox Mode and see if this resolves the issue?

    If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

    If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.

    If this did not resolve the issue, please share your System Status Report, that will help us further troubleshoot.

    You can find it via WooCommerce > Status. Select Get system report and then Copy for support. Once you’ve done that, you can paste it into your reply here.

    If you could also provide the fatal error logs (if any) under WooCommerce > Status > Logs.

    You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

    Let us know how it goes!

    Thread Starter tomitatsuyoshi

    (@tomitatsuyoshi)

    Hi! @xue28

    Thank you for your advice!

    Before I set up my test environment, I first turned off the plugin on my site and tested it.
    I disabled some of the recent additions to see if there was any change in how Square and Woo’s inventory worked together.

    Then, the inventory cooperation was revived!

    After that, I reactivated the plug-ins one by one and tried to see if the inventory linkage was cut off. Then, strangely enough, I had no problem activating all the plugins.

    There are still some unknowns, but in any case, Woo and Square’s inventory linkage was restored. Thanks for your advice.

    Very truly yours

    Tsuyoshi Tomita


    Hi @tomitatsuyoshi

    You are most welcome and we’re glad that worked! ??

    I will be marking this thread as resolved. Should you have further inquiries, kindly create a new topic here.

    Meanwhile, if you have a moment to spare, we would love it if you could share your thoughts with us by leaving a review or feedback. Your experience and feedback are important to help us improve and ensure we’re always providing the best possible support.

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WooCommerce and Square inventory is no longer synced when adding new products.’ is closed to new replies.