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:

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!

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.
 

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

Thanks for the update here, @yadwinder. 

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


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


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?

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

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!