x

Square inventory not syncing with WooCommerce

Having an absolube nightmare with trying to upload my inventory from Square to WooCommerce. It has previsouly added products which we will have to delete as it has double up on some but the issue that I've got at the moment is that I have added stock levels into Square and then tried to force a manual upload within Wordpress but stock levels are not being uploaded. 😞 

 

Please please please help! 

Tags (1)
31,524 Views
Message 1 of 70
Report
1 Best Answer
Partner

Best Answer

I would recommend open a proper ticket for this plugin by going to https://woocommerce.com/my-account/create-a-ticket/


@n40beef wrote:

Only some products want to sync and there is no rhyme or reason


 This isn't normal and indicates either there is a problem with the original sync or some other issue on your site. Normally the plugin will sync all products that have a SKU.

 


@n40beef wrote:

A lot of valuable information is also missing from each product and there are major limitations in general.


I'm not sure which platform you are referring to but WooCommerce captures a number of data fields that do not exist in Square, so there would be no way to transfer that information to Square.

As I mentioned above, I would suggest opening a ticket with us for the plugin regarding the product syncing issue so that we can have a look. This is assuming that you are using the official WooCommerce Square plugin. If you are using a plugin from a third-party developer you would need to contact that developer directly.

View Best Answer >

23,954 Views
Message 64 of 70
Report
69 REPLIES 69
Square Community Moderator

Hi @JayGodbold

 

Sorry to hear about the trouble. 

 

There's not much we can help troubleshoot with in regards to the app integration with WooCommerce, as they build and support the integration itself on their end. 

 

Square allows for them to pull the data and information from your Square account. 

 

Reach out to WooCommerce Support directly and they should be able to get you squared away. 

21,089 Views
Message 2 of 70
Report

Has this issue been resolved? It seems to be on Squareup's side.

16,386 Views
Message 3 of 70
Report
Alumni

Hey @kevintunis - Did you by any chance grab a case number from WooCommerce that mentions this issue stemming from Square's end? If so, call into our Support Team with that case number for reference so we can escalate it further. 

Justin
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
16,369 Views
Message 4 of 70
Report

Im also experincing this. Its extremely infuriating and i dont have a woo comerce account bc i built my website around square. this is really annoying.,

2,482 Views
Message 5 of 70
Report

Just wrestling with implementing Inventory management. I've got a Wordpress/Woocommerce store and decided to switch to Square for my payment processing (along with Paypal). Looked all around for documentation from either Square or Woocommerce for a best practices on this subject but it doesn't exist. 

 

So. Here's my take. 

A. My online store has been up and running and I'm happy with my items having just cleaned it up substantially to make it more streamlined. I only have one product but many variations. So, after much back and forth I decided it made the most sense to buy the Square plugin so that woocommerce-square play nice. Inside my woocommerce settings dashboard I have the integrations tab where I access the setting for my square - you have to connect them first. And then I chose to manually sync WC-->Square. It took a little while but in the end I got all my items to show in Square. (By the way - right now a sync, if it works for you, will overwrite whatever else you have in your Square - so that would be one way to utilize locations if you offer things in person that you do not have online or vice versa).

 

B. It became apparent that the numbers weren't following to Square so I think I shall have to turn on the inventory option for each item. Then I will enter all my inventory numbers and force a manual sync Square-->WC

 

If anyone else is managing inventory in the wordpress/woocommerce environment I would love to hear how you do it!

21,068 Views
Message 6 of 70
Report

I was able to snyc all of my published skus in WooCommerce to Square effectively. All inventory updates from WooCommerce TO Square are working properly. However, if an item is sold in my store using Square (iPad) OR if we make a 're-count' of inventory in Square, that data is not consistently being pushed back to WooCommerce. It looks like about half or so (as an estimate) of my changes to inventory in Square are being synced back to WooCommerce properly. It seems strange that WooCommerce can effectively push inventory changes to Square, but that Square cannot consistently make changes back to WooCommerce. Please let me know how you can help or have figured out a work around?

21,057 Views
Message 7 of 70
Report

We are currently experiencing the same issue.  If an item is sold in store on Square Ipad it is not always taking inventroy off woocommerce website.  Did you ever find a solution?

20,185 Views
Message 8 of 70
Report

Unfortunately, no.

20,183 Views
Message 9 of 70
Report

We have had a heck of a time integrating woocommerce and square. For us, we started with square and added the woocommerce site later. We have tried different things to make the integration seamless, but there are still quirks that make the inventory process tedious:

  • We tried syncing Square --> WC. Failed the first few times. On the fourth try, we were able to get the products to sync over.
  • We rely on csv files a lot for some of our manual processes, so having the ability to download a csv file of all of our existing inventory was crucial. Upon printing a csv after the integration, we noticed that when inventory was input into Square, it would not cross over to WC. At all. This forced us to start inputting our inventory into WC, which then crossed over into Square. We can now do variable products with differing skus, manage stock on those skus and pull csvs from WC, and the changes are immediately available in Square.
  • There's a problem with communicating stock levels. When we make a sale in our brick and mortar, the stock levels are correctly adjusted in WC. However, when stock levels are depleted through WC, Square does not pick up on the change. Thus Square has become useless for inventory management purposes.
  • WC does not have an option to download csv files of products! A huge oversight as far as I'm concerned. We bought a premium plugin that allows us to export AND import inventory csv files. It returns a lot more data than we need, and it would be nice to specify the fields to export in more detail. But it works.
  • The import function does not work, however. When performing a mass inventory import via csv, WC produces the product correctly. We cannot, however, get products entered this way to go over to Square. I have had my best geeks on the case, and we cannot figure out why this is happening.
  • My BIGGEST issue with the system is that sales tax does not transfer over. Once I input the inventory into WC, I have to manually toggle sales tax for each item through the Point of Sale. We again can't figure out how to make this work.
  • So our workflow looks like this: enter inventory data for each individual product one at a time in WC; move to POS and toggle tax for every product; pull a csv from WC when we need an inventory report.
21,050 Views
Message 10 of 70
Report

Having a complete nightmare still with the reason of me buying the integration (stock inventory through the sites) still not working. 😞 

 

Might have to look somewhere else as an all in one package. 

21,045 Views
Message 11 of 70
Report

Hey Jay - 

 

Wondering if you ever found a solution or if you just moved on to another platform.  I switched everything over to Square because I was promised inventory integration with my website (and the salesperson knew I was on WooCommerce) and I have just about given up.  Now I'm in the busiest time of the year and overselling items online.  About to tear my hair out.  So... hoping you found a solution?  Otherwise I'm thinking shopify...

17,393 Views
Message 12 of 70
Report
Admin

@Woo_Phil Would you be able to take a look at the posts above from @smallakin and @JayGodbold? Any troubleshooting steps or insight would be much appreciated! 

️ Helen
Seller Community Manager

Did you find help in the Seller Community? Mark a Best Answer to help others.
17,360 Views
Message 13 of 70
Report

Hi, 

 

You mentioned you're having an inventory problem from WC --> Square

 

Here's my issue

1. Purchase made on WC

2. Inventory updates to -1 yes a NEGATIVE

3. Status updates to in-stock to out of stock

4. Status updates to on backorder

5. No inventory update on Square

 

Have you had any luck with WC updating square inventory? Or are you doing that manually?

15,058 Views
Message 14 of 70
Report

Hi, How did you get all of your items to sync into square.  I am trying to sync items and I have variable products (diffent sizes) and only 2 of the 5 variatiosn will sync..  Any advie??

15,458 Views
Message 15 of 70
Report

My honest opinion STILL is don’t bother. Square say it’s Woocommerce and Woocommerce saying it’s Square. Either way.. it doesn’t work for me as I have sub categories. Big shame.

15,116 Views
Message 16 of 70
Report
Partner

Hey @JayGodbold and @smallakin

 

I would need a bit more information on what the problem is and what exactly is happening in order to offer some help.

 

If you have all of your products set up in Square and they have a SKU, you'll want to do an initial force manual sync. You can do this by going to the WooCommerce > Settings > Integration tab. Make sure that on that page you have the inventory sync option enabled, then use the manual sync button for Square to WooCommerce.

 

Once that sync completes, you should have all your items and inventory in WooCommerce.

 

If you had previously created some of these items in WooCommerce manually, I would recommend deleting them. In order for your items to pair up correctly, it's best if they are created by the plugin through the sync process.

 

If the items are being created during the sync, but inventory is not being passed:

 

First check to ensure you have the inventory sync option enabled. As I mentioned that is on the WooCommerce > Settings > Integrations tab.

 

Next, enable logging on the same tab as I mentioned in the previous step. Once that's enabled, try the manual Square to WooCommerce sync again. Once the sync completes, review your logs to errors. You can find the logs by going to the WooCommerce > System > Logs tab.

 

If neither of those steps help at all and you purchase your Square plugin directly from WooCommerce.com, then I would suggest opening a ticket with our team. Since I didn't have your site URL or email address, I wasn't able to check if you had already opened a ticket. If you had, if you let me know the ticket number I can look into it for you.

15,020 Views
Message 17 of 70
Report

I have had my woocommerce site running for quite some time and don't want to delete items from there to create them from Square as that would delete all past sales data for things like 'bestsellers' as well as break clickable links directly to products from blogs, press releases, etc.  

 

We instead did a manual sync to start setting up our inventory in Square POS from the website (with all skus and information filled out) as we were told that it would be fine to get the connection started either way.    After doing that and updating inventory via the spreadsheet upload, the inventory successfully displayed in Square, but wasn't syncing to our website.  That's when we found out that we were incorrectly guided to have the website and the store set up as 2 separate locations if we wanted them to share inventory.  So we deleted the website location and switched the website to share the same location as the store as instructed.

 

At that point, we did a reverse manual sync from the square pos to the website to sync the inventory.  Some of it worked, some of it didn't.  It also created some random products that weren't active in POS and created duplicates of several products for some reason (even when the skus were correct in both places).  So we had to delete products and correct the display of a lot of variations and after doing all that, eventually selected the "do not sync" on a few of our products because they continue to seem to make duplicates and mess things up.  

It does seem like certain things are now syncing, but others are not.  Is there any good way to test the connection to see if ALL products are syncing?  We definitely oversold things on Black Friday because our website wasn't updating properly from in store sales.  So we will probably have to do a full inventory re-count (which took 5 employees a full day to conduct) to make sure everything is working again and I don't want to spend the labor hours if it's not going to work moving forward and need to find a different solution.

 

And yes, I had a ticket open with customer support about this and I was told to contact my web developer to have them look into it because it wasn't Square's responsibility and after I asked if there was anything she could help me with or somewhere she could direct me for answers as I had already paid my web developer a decent chunk of change to switch over hosting and payments to move to Square, she stopped responding.

15,017 Views
Message 18 of 70
Report
Partner

Hey @smallakin

 

"Some of it worked, some of it didn't.  It also created some random products that weren't active in POS and created duplicates of several products for some reason (even when the skus were correct in both places).  So we had to delete products and correct the display of a lot of variations and after doing all that, eventually selected the "do not sync" on a few of our products because they continue to seem to make duplicates and mess things up. "

 

That indicates to me that the items you manually created were not identical, which caused them to not be paired up during the initial sync. This is why we recommend users not manually re-create items and instead let the initial manual sync create the items.

 

As well, I would recommend avoiding doing manual syncs in both directions, especially if you have improperly manually recreated items as you described. Otherwise you can get duplicate items as well as mismatched inventory information (all of which you described). 

 

From the sounds of it most of the problems you are experiencing are due to an improper initial pairing during the manual sync. If WooCommerce is the master source that you want to use for your products, then I recommend removing all your products from Square. Once your Square account is blank, perform a WooCommerce to Square manual sync. If there are items you don't want sent to Square, use the "Avoid Syncing" option that you referenced earlier. 

 

Once that sync is complete you'll have your items in Square and you will know that they are all properly matched up. This will prevent issues with duplicate items or inventory not updating (due to the items not being paired up).

 

The most important thing is to let the plugin do all the work. Don't manually recreate items between the two platforms as they will not be connected.

15,012 Views
Message 19 of 70
Report

I haven't manually re-created any items.  I'm not actually sure what you mean there.  All the items that are shared between the website and the store have been copied over from the web. 

 

We did add some variations to items with additional SKUs in store that we don't offer online and some of those are what keep creating duplicates.  However, you would think it would add a variation in WooCommerce if anything, instead of creating a 2nd item in Square.  That is what is weird.  It's not adding those variations in WooCommerce (which is good because we dont want those available online) but the web keeps re-syncing 'it's version' to our POS even though it is creating duplicate SKUs.

 

There are also some items we offer in store that we don't offer online and we want to keep it that way, so yes, we have manually entered those in Square.

 

Also, the reverse sync of our items was once again a recommendation of Square support staff, and now you are saying that you don't recommend that.  So that is once again very frustrating as we have wasted SOOOO much time trying to get this right.

And ... deleting all of my products out of Square and re-syncing them is absolutely not an option right in the middle of holiday season. And also it would mess up sales data, plus we spent a handful of hours correcting the way variations read in both Square and WooCommerce after the first sync as it seemed to list them the way the product image was named instead of hte way we named the variation.  i.e. Grey Brown became grey-brown-2

15,008 Views
Message 20 of 70
Report

I have had similiar issues. I am able to sync most of my inventory with square, but have issues with the simple products coming over. The ones that are variations are fine. I also am not seeing that my orders from my square stand are going back to my woocommerce account for my overall orders to all be in one collective place. 

14,991 Views
Message 21 of 70
Report