Streaming live at 10am (PST)

Automate Ecomm Product Creation from Airtable

I’ve tried, tried, tried again. Has anyone been able to do this?

For more context:

I’ve tried with Zapier, Nobull and Integromat. With all of them I’m encountering 2 obvious issues (as far as I can tell)

  1. There is some sort of permissions issue
  2. None of them allow me to set the price field of the product

Thanks in advance for any feedback or insight!

Hello there @John_Krueger Michaela from Integromat here :wave:

We looked into this and the error you’re getting is happening due to the fact that the Webflow API endpoint changed from being a regular collection endpoint to:
/sites/:site_id/products/:product_id/skus/:sku_id

We are going to fix it in Integromat as soon as possible. Thanks for bringing our attention to this! :slightly_smiling_face:

Until the changes are implemented, you can use the ‘Make an API Call module’ according to Webflow’s documentation.

You can find a tutorial on performing custom API calls on Integromat
:arrow_right: here

Anyway, back to your specific case :sweat_smile:

You can use the following configuration

Where

  1. is the site ID and
  2. is the mapping from the Airtable module

JSON example:

{
“product”: {
“fields”: {
“name”: “product name 1",
“slug”: “cloak-of-invisibility”,
“sku-properties”: [
{
“id”: null,
“name”: “Color”,
“enum”: [
{
“id”: null,
“name”: “Obsidian Black”,
“slug”: “obsidian-black”
},
{
“id”: null,
“name”: “Smoke Grey”,
“slug”: “smoke-grey”
},
{
“id”: null,
“name”: “Forest Green”,
“slug”: “forest-green”
}
]
}
],
“description”: “A cloak that renders the wearer invisible to the eye.“,
“shippable”: true,
“_archived”: false,
“_draft”: false
}
},
“sku”: {
“fields”: {
“name”: “Cloak Of Invisibility Color: Obsidian Black”,
“slug”: “cloak-of-invisibility-color-obsidian-black”,
“product”: “5e8518516e147040726cc415”,
“sku-values”: {},
“main-image”: “https://d1otoma47x30pg.cloudfront.net/5e8402eb8a402e354bd469bb/5e8512181ae993035b15f315_external-content.duckduckgo.com.jpg”,
“more-images”: [
https://d1otoma47x30pg.cloudfront.net/5e8402eb8a402e354bd469bb/5e8512181ae993035b15f315_external-content.duckduckgo.com.jpg”,
https://d1otoma47x30pg.cloudfront.net/5e8402eb8a402e354bd469bb/5e8512181ae993035b15f315_external-content.duckduckgo.com.jpg”
],
“price”: {
“unit”: “USD”,
“value”: 120000
},
“download-files”: [
{
“id”: null,
“name”: “The modern web design process - Webflow Ebook.pdf”,
“url”: “https://dropbox.com/files/modern-web-design-process.pdf”
}
],
“width”: 56,
“length”: 0.3,
“height”: 72,
“weight”: 24,
“_archived”: false,
“_draft”: false
}
}
}


Hope this helps!