Woocommerce duplicate orders

[Collect]

All of a sudden we started having an issue with woocommerce where every subscription we have is now double charged with 2 hours difference. We had a staging site but deleted it. Woocommerce are being very helpful but square doesn’t say anything. We have been asked by woocommerce to ask square to tell us how many access tokens we have - but are are told it’s not their issue. Any ideas on how to solve this? TIA

[BofBArtStudio]

Hi @Collect 

Are you using the WooCommerce Square plugin for WordPress? 

It might help to go to your Square Dashboard on your computer, and in the menu scroll down to Settings and then choose app integrations. 

Look there to see if you have more than one for WooCommerce.

[Collect]

Let us try that! It’s been weeks and I’m losing the will! Thank you for responding 

[Collect]

Yes. I am using WooCommerce Square plugin for WordPress. 

[Collect]

there is no more website. just one

[BofBArtStudio]

Okay I'm using that plug-in as well. 

Probably the next thing I would try is to disconnect Square from the plugin settings page. 

(You might want to do this during a period of time with low potential for sales) 

And then check in your square dashboard under the app integrations again and see if it still shows there. If it does, you can remove it from the square app integrations page. 

Then go back to your plug-in in WordPress and reconnect the plug-in to square and make sure you're using your live store for the connection rather than a staging store. 

Sometimes if you're doing multiple connections for testing, it might just need a refresh.

[Collect]

After Disconnect, 

still exists . so which one should remove? please

[BofBArtStudio]

Since you will be reconnecting the WooCommerce Square plug-in to square, I would remove that entry in the Square dashboard for WooCommerce. 

Again be very careful if you're doing this while orders might be trying to come in because I would hate for you to miss those orders. I usually play with these kind of things in the middle of the night or when I know that sales will be low.

Basically you want to refresh everything and make sure that you have only one connection since your theory is that you have a connection left over from when you were testing and staging.

Also if you're using another plug in that might be connecting to square from your WooCommerce, make sure that there isn't a connection potentially from there. You mentioned that you were using subscriptions, therefore, are you using a plug-in in your WordPress that connects to square for subscriptions?  Or is the only plug-in the WooCommerce Square connector?

[Collect]

Note: I have subscription order. so if remove this then it can be any issue?

[Collect]

I have to sure, if remove those then Previous api will exists? since this api used with all orders. 

[BofBArtStudio]

It's important to know if you're using another WordPress plug-in that connects to square besides the WooCommerce Square plugin. 

If the woocommerce Square plug-in is the only one that you're using, then you'll be reconnecting through that plug-in to square and reinitializing the connection, so it should not be a problem.

Since you said that you had a staging testing site as well as a live site, the thought is that you may have duplicate connections in play.

By refreshing the live site connection, you should be able to ensure that only one connection exists so that there isn't an issue with duplicates. 

These are the steps that I would take as I've been using the WooCommerce Square connector for about 10 years. However, please perform your own investigations as well to make sure that you don't have another plug-in for WooCommerce connected to Square. 

If you do, you probably want to refresh both of them. 

Without seeing your setup, I can only advise on what I have done in the past when connections are giving me trouble with the WooCommerce Square connector.  

The nice thing is is you don't lose any of the previous transactions or sales or data by refreshing your connections. 

But definitely proceed with a clear mind and considering all of the variables.

If you're feeling uneasy about deleting That Woocommerce app integration in the Square Dashboard, then definitely don't do it.  especially if you have multiple websites that are connected to square via WooCommerce. 

 The situation may even fix itself by reconnecting from the WooCommerce Square plug-in without removing anything from the square app integrations. 

[Collect]

I don't use another plugin for square

[BofBArtStudio]

And when you reconnect from the woocommerce Square plug-in, it will create a fresh entry in the square app integrations list for WooCommerce.

[Collect]

Removed WooCommerce. but second one impossible to remove. 

[BofBArtStudio]

Oh, that collect corner sandbox could be your culprit. Did you create that app in the Square developer console?

It looks like by the message that it is a custom app that you created in the Square developer console. 

That might be a step towards solving your problem. 

I also have a couple of custom apps that I have created. And you do need to take care of those over in The Square developer console. 

I would definitely jump over there and log in and see what you have going on. Perhaps when you were doing staging and testing you created two different app instances in the developer console? Or created that to do a similar thing as the WooCommerce Square?

[Collect]

This sandbox id, Access token used on my woocommerce square plugin. so will I remove this app??

[BofBArtStudio]

I am not totally sure what that application was created for for the collect corner sandbox. 

Do you have any additional information on that? Is it something that you developed or somebody else? The fact that it's a "sandbox" app That is connected to your live Square instance, leads me to believe that it is probably creating those duplicate entries. 

However without knowing exactly what that application was developed for and what exactly it is developed to do, I can't really say for sure. 

If your intention is to utilize only WooCommerce Square plug-in and there is no longer any need for that custom application, then I would say that it is a safe bet to remove that custom application or at least temporarily disconnect it so that you can do testing.

And then in your live WordPress, you can go to the plug-in for WooCommerce Square and then reconnect it to Square through the settings in the plugin 

And then run some tests and see if your problem has been solved. If so then you know that it was the sandbox app that was creating the duplicate entries.

[Collect]

That's mean I have to remove "collect corner SandBox" this app. right??

[BofBArtStudio]

Again, I don't have any information on what that app is or what it was built for. Is that something that you created? Do you know anything about it? Since it's a custom app it's not anything that I can give information about.  

If you have further details, you can post that here. Or if you're able to confirm that it is something that was used just for testing, then you can disable it and see if that solves your issue.

[Collect]

in my woocommerce square using this app api . when I enable sandbox then appear this sandbox id, access token. 

[BofBArtStudio · Accepted solution]

Okay that makes sense. 

So the next thing that I would do is enable it for production in the WooCommerce Square plug-in. 

Make sure you link it to the correct square store location if you have more than one location. 

And then run a test placing an order from your website and see if you are still seeing duplicate transactions.

I've never experienced to this issue unless I happen to have multiple connections going, so the steps we have taken, to disconnect the connectors and then reconnect fresh, should be able to clear this all up.