Support » Plugin: WooCommerce Square » Having many sync problems in 2.0.3

  • With Woocommerce as the Product System Of Record, when I sync my products to Square the following problems occur:

    1. All the photos in Square disappear and don’t come back with another sync.

    2. Every Simple product in Woocommerce gets imported as a variable product in Square with one variation.

    3. If a Simple product has a sale price in Woocommerce then the imported Square product has two variations, one at the regular price and one at the sale price. This is ultra bad.

    4. All the stock numbers are now ‘-‘ or 0 in Square which is even more of a problem because stock levels in Woocommerce are locked until you press ‘Fetch inventory from Square’ which changes the real stock level to 0. Then you have to put it in again and save before it goes into Square. This stock level is getting back into Woocommerce on random products somehow and putting lots of things out of stock. This is ultra ultra bad.

    5. About 30% of the product prices that end in .99 in Woocommerce have been inexplicably been rounded down to .98 in Square.

    I’ve tried unlinking and relinking Woocommerce and Square several times and also mass deleting all the products in Square (which messes with the Square server which thinks the products still exist) and resyncing.

Viewing 15 replies - 1 through 15 (of 15 total)
  • Plugin Support Melinda

    (@melindahelt)

    Automattic Happiness Engineer

    We’d like to take a look at your log files.

    Please contact us at WooCommerce.com > My Account > Tickets. 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 help you further there.

    Thank you Melinda, I’ve started a WooCommerce ticket, quoting this forum thread. I’ve located the (new) Square logs in WooCommerce and I’m happy to send them when I receive details of how you want them sent 🙂

    I too am unable to sync with Square. Says syncing now… does nothing. If I interpret the support page correctly, given I have purchased nothing and have no subscriptions with WooCommerce, I am unable to submit a ticket.

    • This reply was modified 11 months, 4 weeks ago by thefatquarter. Reason: Added more information

    @thefatquarter I had to submit as ‘WooCommerce Gemeral’ then put the plugin name in the subject line

    The victim here as well

    In the end, our sync issue was nothing to do with Square, WooCommerce, or the WooCommerce Square plugin. Rather it was an security setting set up by us. Thankfully our server support were able to track the source and a fix was easy. Everything is working now.

    @faracademy

    Commenting on your #4 item.

    It too see the same behavior, but it’s more than that.

    If I look at ALL variations of a single product in WC they all have quantities of 5 for five variations. When I click the “Fetch stock from Square”, it sets the Stock Quantity to 0. I adjust the stock and save. Not touching ANY of the other quantities within that product/variations. When it syncs and you look at Square it updated the one I adjusted BUT it set ALL the other quantities/variations of that product to NONE. If I look at what’s in WC. The quantities show correct. Now inventory is out of sync. A manual sync does nothing.

    There’s no way I am going to click “Fetch stock from Square” and adjust inventory for every single product and variation.

    I’ve opened a ticket, but support is unresponsive to date.

    This update is so disappointing in so many areas. I fully understand why the plugin has a 1.4 out of 5 rating. It’s terrible as of v2.x!!!

    @faracademy @melindahelt

    I’ve been having the same problem, sync was just constantly hanging but after a bit of messing about, I found Wordfence was the culprit.

    The solution, disable Wordfence, run the sync then once finished enable Wordfence again. Not ideal having to disable site security, but its a workaround for the moment.

    Hope that helps, especially if you’re running Wordfence, it might also be the issue with other security plugins so maybe try disabling it and running a sync.

    Plugin Support Mike W

    (@nixiack8)

    Hi all,

    Thank you @theshaman for this insight! Indeed, if syncing is not working a good solution is to disable other plugins except Square and WooCommerce (preferably on a staging site, or at least back up the site prior to doing so). This would rule out any conflictions that other plugins may cause during the sync process.

    @mathewlewis 0

    When I click the “Fetch stock from Square”, it sets the Stock Quantity to 0. I adjust the stock and save. Not touching ANY of the other quantities within that product/variations. When it syncs and you look at Square it updated the one I adjusted BUT it set ALL the other quantities/variations of that product to NONE. If I look at what’s in WC. The quantities show correct. Now inventory is out of sync. A manual sync does nothing.

    This depends on what your System of Record is set to now as of ver. 2.0. If it is set to Square, it will fetch the stock from Square. If you have your products in Square and update everything from Square, be sure your System of Record is Square. If you have your products originating from WooCommerce and update your settings from WooCommerce, have it set to WooCommerce.

    After that, do a sync and see if it works.

    @nixiack8

    This depends on what your System of Record is set to now as of ver. 2.0. If it is set to Square, it will fetch the stock from Square. If you have your products in Square and update everything from Square, be sure your System of Record is Square. If you have your products originating from WooCommerce and update your settings from WooCommerce, have it set to WooCommerce.

    When having the System of Record as WooCommerce it still happens. You do an initial sync and it will import all the items from WooCommerce to Square but 80% or so of them don’t import the stock level and it’s just set as ‘-‘, the same as 0. Gradually Square will report to WooCommerce that the stock level is – for everything and change the stock on WooCommerce despite WooCommerce being the System of Record. It’s all completely broken and I’m not going to use it until all this is fixed…

    This is absolutely what is happening, the whole system has had a mind of its own.
    system of record is Woocommerce, yet i still have a locked stock management as its run by square. Then goes to zero when fetching from square.
    What has happened ? it was all running perfectly and then this gets thrown in and completely stuffs my stock and syncing. woocommerce won’t even sync now. it just says failed sync.
    So now i have to double handle woocomerse and square and enter prices in so they match my website to store. This has cost me many hours of trying to sort out.

    Plugin Support Mike W

    (@nixiack8)

    Hi again @faracademy and @lisalowry,

    When having the System of Record as WooCommerce it still happens. You do an initial sync and it will import all the items from WooCommerce to Square but 80% or so of them don’t import the stock level and it’s just set as ‘-‘, the same as 0.

    This is absolutely what is happening, the whole system has had a mind of its own. System of Record is Woocommerce, yet i still have a locked stock management as its run by square. Then goes to zero when fetching from square.

    Do you have any other plugin that has inventory management options? We have found inventory control plugins and some security plugins such as WordFence to cause issues with syncing with Square. We have patched a lot of the issues up with ver. 2.0.4 so make sure to update it to this version. After that if possible disable all plugins other than WooCommerce and Square, and then set a sync up again. If it errors out then, please open a ticket with us if you have not already – reference this thread as well as place your Status Report (found under WooCommerce > Status) so we can take a closer look.

    elmdesignworks

    (@elmdesignworks)

    Just adding my voice to the conversation. We, too, are on 2.0.4, and need to have our SOR set to Woo. It looks like when new orders are coming in, those might be syncing to Square, and manual edits to a Woo product listing are syncing to Square (after having to go through the annoying “Fetch from Square” process for each), but just running a full site sync doesn’t push the existing data in WC to Square, at least not for inventory counts. The syncs say they complete, and when I look at the logs, just about every aspect of a product’s data is pushing over to Square, but inventory counts are not included in the sync log, from what I can see.

    This is super problematic, because we rarely use Square, but we need it to be up to date when we do. With all this disconnecting and not-syncing that’s been going on, our WC site is (presumed) correct, and we need to push those correct numbers to Square, which hadn’t been getting consistent updates and is therefore out of date.

    (We also have an issue with not being able to bulk import inventory updates in WC, which we used to be able to do, but I’ll leave that topic for another thread,)

    Plugin Support madeincosmos

    (@madeincosmos)

    Automattic Happiness Engineer

    Hi everyone!

    Thank you for your patience while we’re working on this. There are many different topics covered in this conversation already, so let me summarize all that we know so far to make sure I don’t miss anything.

    Items going out of stock after sync

    There was a bug in one of previous plugin versions causing this. It should be fixed now in Square plugin version 2.0.4. If you’re afraid to enable product sync again, which is understandable, you can try the following:

    – Create a new test location in Square, so that products imported from Woo end up there,
    – Enable logging in Square,
    – Set up a staging copy of your whole site. If you don’t have one yet, you can use the WP Staging plugin: https://wordpress.org/plugins/wp-staging/
    – Switch your test site to sync with this other location and enable sync with WooCommerce as SOR,
    – If everything works fine this time, enable sync on the real site too.

    If the stock levels get reset on the staging site even after updating to Square 2.0.4, we’ll need to look at this in details. In such case please submit a support ticket at https://woocommerce.com/my-account/create-a-ticket/ and set up an admin account for woologin@woocommerce.com.

    Running a full sync from Woo doesn’t update inventory in Square

    This is a known bug, and our developers are working on it. There’s no estimate how long this might take, so I’d recommend to keep an eye on future updates.

    Thanks!

    Plugin Support madeincosmos

    (@madeincosmos)

    Automattic Happiness Engineer

    We haven’t heard back from you in a while, so I’ll mark this thread as resolved now. If you’re still experiencing some problems with items going out of stock, please start a new thread and include the System Status Report.

    Thanks a lot!

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Having many sync problems in 2.0.3’ is closed to new replies.