Jump to content

Update inventory with Google Sheets

Recommended Posts

Site URL: https://www.enfiletonmasque.com

Hi everyone,

I am wondering how to connect a Google Sheet to Squarespace Inventory.

The goal is that Sheets gets updated each time someone purchases an item. And Squarespace product inventory gets updated each time I change the value in the Google Sheet (when I sell products through a physical store).

 

Lets say I have products with two size (M and S). I would like to create a Sheet, looking as follow.

  inventory
product name M S
Raph 50 12
Rosie 2 37
Titi 26 16
Travis 6  
Le Président 24 32

 

 

STEP 2 is to connect a Sheet, where all customer information regarding the delivery (name, surname, order, address) is summarized.

So that I can automate the shipment and let it done by a third party company.

 

PS: I have the Advanced Commerce plan, so I imagined doing this with an API key.

Any help appreciated.

 

Thanks everyone,

Dorian

 

Link to comment
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

With the Advanced Commerce Plan, Squarespace allows you to read and write stock levels for your physical inventory using the Products API, so in theory it should be possible to use a Robotic Process Automation (RPA) tool like Parabola or Make (formally Integromat) to do this.

   If a post helps you, please click a "Like" option below  ↘️

Edited by paul2009
Integromat became Make

Improve your online store with our extensions.
About: Squarespace Circle Leader since 2017. I value honesty, transparency, appreciation and great design ♥.
Work: Squarespace Developer and founder of SF Digital, building the features Squarespace didn't include™.
Content: Links in my posts may refer to SF Digital products or may be affiliate links.

Buy me a coffee

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.