About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

Shopify error: Please enter a value for either "Adjust Quantity By" or "Set Quantity To", but not both.

  • 12 March 2024
  • 7 replies
  • 75 views
Y

I'm doing an inventory integration between Squarespace and Shopify, but I'm getting this error. Could you please help me find out what I should enter in these fields?

https://prnt.sc/J_lZ0dqS5vx5
https://prnt.sc/5do2z4MUIorg

https://prnt.sc/LirZa1tPNLFy

If I leave the fields blank, then it shows this error:
https://prnt.sc/zqXfAQbLv_2d

Thanks!

7 replies

SamB
Rank
Userlevel 7
Badge +11

Hi there @yadwinder 👋

Welcome to the Community! It looks as though the value for the Product Variant Inventory ID field is filled out correctly. But for the Adjust Quantity By field you’d instead want to select the relevant field from the Squarespace form that contains the number of products that’s being selected:

ba322ce282894945c589146875de1430.png

I’d also suggest adding the minus modifier (-) if the number on the Squarespace form should take away that many items from the current total available. E.g. if the selected field from the Squarespace form contains the number 2 then it would read it as -2 and remove 2 items from the total available for that specific product variant.

Hope that helps to get you pointed in the right direction. If I’ve misunderstood or you run into any further trouble on that do let us know!

Y

Hi @SamB , Thank you.

It's now connected. However, I want to update inventory according to Squarespace inventory. Currently, the inventory in Squarespace is 15 https://prnt.sc/fCm4suYt2Mpf

I have tried to do this, but it's not working
https://prnt.sc/rVOS1gMlfAIM


It is working now. The quantity in Shopify is 1
https://prnt.sc/KVqyOCgG3Xm3

I want an automatic process for inventory synchronization between the platforms.
 

Y

Hi Team, is there any solution for my above query?

SamB
Rank
Userlevel 7
Badge +11

Thanks for the update here, @yadwinder. 

The Adjust Quantity By field would only add or remove values from the current quantity total in Shopify: 
41c91e2b432f754eaa6c200c5cfbf58b.png

The Set Quantity To field should allow to set the current quantity total in Shopify to match whatever value has been added into it. 
767ba79a1deab64c1c43f816f329be7f.png

So if the quantity total in Shopify needs to match what’s on the Squarespace form, in the Set Quantity To field, you’ll need to select a field from the Squarespace trigger step that contains the quantity value you want to update the quantity total to. 

Then when the Zap runs whatever numerical value is in the selected Squarespace field should be set as the quantity total for that product in Shopify.

Can you give that a try and let me know if that sorts it?

Y

Hi @SamB Thank you for the update.

Okay, I will select the option in 'Set Quantity To'

https://prnt.sc/_JMGCtNsY1V1

However, only these options are available. Could you please let me know which option I should select?

https://prnt.sc/ghnXd_bldBjY
https://prnt.sc/S0v8ZvV5IUjG
https://prnt.sc/DlLTcvEio0p8
https://prnt.sc/KkjqnuRIrzoR
https://prnt.sc/oCaVj0Cxx1c2

Y

Hi @SamB , is there any solution for my above query?

Actually, now I have free trail for Zapier, if there is no solution for it then I need to move on another platform.
And I don’t want it.

Thank you.

SamB
Rank
Userlevel 7
Badge +11

Thanks for getting back to me @yadwinder. Sorry for the delay in a reply here - happy to keep troubleshooting this with you if you’re still interested in getting this up and running on Zapier. 🙂

Hmm, from the screenshots it looks like the test record brought in from the Squarespace form doesn’t have a quantity field. It also looks like the form might be being used to take orders am I understanding that correctly?

If so, then I think the previously mentioned approach of using the Adjust Quantity By field (and not the Set Quantity To field) would be the way to go as it would allow the Zap to remove the quantity being ordered on the Squarespace form from the current quantity total in Shopify. 

With regard to which option to select, does the form itself have a quantity field to indicate how many is being ordered?

If yes, can you confirm if a quantity was supplied for the test form submission pictured in the screenshot? If a quantity wasn’t supplied then can you try resubmitting the Squarespace form ensuring that a value is entered into each of the fields. That way the relevant quantity field should then come through as an option to select from the Squarespace trigger.

Looking forward to hearing from you!

Reply


Terms & Conditions