Quick overview
A tutorial and reusable import gate for Shopify CSVs: run failing and passing examples, validate CSV text, route blocking findings separately, and download line-level issue reports before reviewing Shopify’s import preview.
How it works
- Run two synthetic catalog examples manually: one contains a duplicate option combination, malformed price and blank overwrite field; the other passes the supported checks.
- Send each CSV text and import mode to Catalog Import Guard using your own RapidAPI Header Auth credential. Two tutorial items consume two API requests.
- Check the response structure and stop on an unexpected response instead of treating an HTTP success as proof that the catalog is safe.
- Generate a decision plus a UTF-8 CSV report file attached to each item. Report columns include physical line number, severity, code, column and message.
- Route errors, failed checks or truncated reports to the blocked output; route passing, untruncated reports to the review output. Both outputs are connected.
- Download the report from either final node. Replace the sample source with your own workflow input when ready. This template never imports products or sends messages; review warnings and Shopify’s own import preview first.
Setup
- Import the workflow and choose a Catalog Import Guard plan on RapidAPI. Create or select Header Auth with header name X-RapidAPI-Key and your own key value. The JSON includes no credentials or active schedule.
- In Check Shopify CSV, select that credential and retain X-RapidAPI-Host: catalog-import-guard.p.rapidapi.com. Run the two synthetic examples and confirm one blocked item with two errors and one warning, plus one review item without findings.
- Open each final node’s Binary view and download report. For real use replace Sample product CSV with a source returning csv and mode. Remove personal information first: the HTTP node transmits CSV text to the API. No Shopify account connection is required.
Requirements
- Own RapidAPI key and plan; UTF-8 Shopify-compatible product CSV text. Encoded JSON request up to 256 KiB and 5,000 CSV rows. Review Shopify import preview; checks are intentionally limited.
Customization
- Replace the sample source with your CSV text source. Attach your existing storage or notification step to the blocked branch if needed, and keep any product import behind your own approval. No external messages or automatic imports are configured.
Additional info
Disclosure: I maintain Catalog Import Guard. The template is free. API BASIC includes 100 requests/month at $0; PRO includes 1,000/month at $5, subject to current RapidAPI terms and bandwidth limits. Your own n8n hosting may cost money. The tutorial makes two API requests per run. CSV text is sent to the API; for local-only checking use https://catalog-import-guard.mayasmile.workers.dev/try . Tested in local n8n 2.46.6 with the actual Worker handler through a localhost fixture and synthetic credentials, not n8n Cloud or a real Shopify import. No guarantee of import acceptance.