Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

 

Hello hello! 

I have been trying to build a zap between our Wix and SquareUp using webhooks with no luck. The business I work for currently has a Square POS and inventory, however they wanted a dynamic website which is why we built a new website with Wix. Now any orders that are processed through Wix need to have an automation that removes product from our Square inventory.

I created the Wix webhook and tested it with no issue. Then I tested the next step—removing the inventory from Square. At first my error message was that my SKU couldn’t be found from Wix in Square. I tested two products individually, double checked that both had the exact same SKU in Wix and Square, and continued to get the error message that the SKU couldn’t be found. I tested a third item and now its reporting that it can’t process the request because I have negative quantity when in actuality the item is in stock with quantity in both Wix and Square. I’m not sure why these errors are happening, if anyone has any insight I would greatly appreciate it! I don’t have screenshots for the previous error messages, but below is the quantity error message. 

Zapier view and Square view

 

Hey ​@Meeting Greeb,

The error indicates that you can’t send negative value. Try sending 1 instead of -1 in quantity to adjust the inventory to see if it fixes your issue. Hope it helps!

Hi there ​@Meeting Greeb 👋

Did setting it to 1 instead of -1 as Sparsh suggested do the trick? 

Let us know how it went, want to make sure you’re all set! 

Hi there!

 

Thank you both, I was able to find the problem—the table wanted to list Wix SKUs and Square Catalog IDs and the table I initially created listed the same SKU code for both (seems intuitive, yes?).

I’m a little concerned as to how this Square Catalog ID/ Wix SKU configuration will work since 1. they are different ID’s and 2. the Square Catalog ID seems to only represent the product page, not the multiple variants that have individual SKU’s. I haven’t been able to find any material on this, so any further information would be greatly appreciated!

Hey ​@Meeting Greeb,

I think you will have to use Lookup Tables to match the Wix SKU to the correct Catalog Object ID. Here is a helpful article about creating Lookup tables- https://help.zapier.com/hc/en-us/articles/8496305146765-Create-lookup-tables-in-Zaps. Hope it helps!

Sorry for the delay in my reply here ​@Meeting Greeb. Great job on getting to the bottom of what was causing the issue! 🙌

Sparsh is correct, if it’s after the Catalog Object ID not the SKU then you’d need to create a lookup table to automatically convert the SKU value into the corresponding Catalog Object ID, since there’s no “Find Product” action available for Square. 

That said, if you’ve got a large number of products you might want to try using an API Request action to search for the product by it’s SKU to get it’s Catalog Object ID. Looks like Square’s Search catalog items endpoint would be the one you’d need to use for that: https://developer.squareup.com/reference/square/catalog-api/search-catalog-items. It’s a bit more advanced but you can ask Copilot to help build it for you, and I’d be happy to lend a hand if you get stuck.

Keep us posted on how it goes! 🙂

Terms & ConditionsAccessibility statement