Bibliothek / E-Commerce & Zahlungen
E-Commerce & Zahlungen
Shopify-Produkte mit Lagerbestand aus Google Sheets in Masse anlegen
Beim Start liest er Produkte aus Google Sheets, legt fehlende per GraphQL in Shopify an und aktiviert die Bestandsverfolgung mit Anfangsmengen.
Was sie bewirkt
## Create Products in Shopify from a Google Sheet This workflow creates products in your Shopify store from a google sheet. It also enables inventory tracking and sets the quantity of an inventory item at your store's default location. This is a great way to get test data into test or staging stores to try out apps, update template or try out new designs. This Automation will only import new products. It will skip existing products if the slug matches an existing product's handle (Shopify's term for a slug). ### Setup Notes The Google Sheet has the following columns title - free text description - free text company - free text category - free text status - ACTIVE, DRAFT or ARCHIVE slug - used in the product url, text with no spaces, can also use hyphen. price - sale price of the products compare_at_price - compare at price for products sku - unique code for each product stock_on_hand - quantity of this item available for purchase. Use those labels in the first row of your sheet and N8N will create one object per row with the column names as object fields. ### Update GraphQL nodes with your Shopify store URL 1) Replace the URL in all GraphQL nodes with the URL for your Shopify store. 2) These GraphQL requests all use the Shopify 2025-04 GraphQL Admin API.
Die Schritte
- Start Workflow
- Google Sheet, Fetch Products
- Shopify, ProductQuery
- If product exists
- Shopify, CreateProduct
- Loop Over Items
- Shopify, GetLocations
- Shopify, Enable InventoryTracking
- Shopify, Set InventoryLevel
- Finished
Ähnliche Automatisierungen
E-Commerce & ZahlungenShopify-Produkte mit einer GraphQL-Cursor-Schleife seitenweise abrufen4 SchritteE-Commerce & ZahlungenKampagnenbilder per GraphQL zu Shopify hochladen6 SchritteDatensynchronisierung & ETLShopify-Kunden mit GraphQL nach Baserow exportieren5 SchritteE-Commerce & ZahlungenUTM-Daten von Shopify-Bestellungen in Baserow speichern8 Schritte