Automate daily inventory & price sync across 50k supplier SKUs

Shopify Catalog Feed Normalizer — Automated Multi-Variant CSV Engine

Stop Paying $200–$500/Month for Rigid Catalog SaaS. Normalize 10,000+ Raw Supplier SKUs into Standardized, Schema-Compliant Shopify Product Feeds for $0.05 Base Fee ($50 / 1,000 runs).

---

🎯 Pre-Configured 1-Click Task Pages

Run pre-configured, validated task workflows directly on the Apify Store:

• Normalize Supplier CSV for Shopify Import: Standardize raw multi-variant supplier feeds into RFC 4180 Shopify CSVs with currency formatting and formula escaping.
• Validate Product CSV Before Shopify Import: Run pre-import diagnostic audits to catch duplicate SKUs, missing handles, and malformed prices before importing to Shopify Admin.

---

⚡ The Pain vs. Instant Relief

Manual CSV formatting and broken spreadsheet imports cost e-commerce agencies dozens of wasted billable hours:

• The Catastrophic Cost of Broken Imports: A single missing variant handle, unescaped comma in HTML descriptions, or raw price notation (1.499,00 €) corrupts Shopify imports, causes silent variant overwrites, or triggers immediate Google Shopping feed suspension.
• The 1-Click Solution: Feed in messy, raw vendor CSVs from dropshippers or distributors. This Actor automatically groups variants under parent handles, normalizes currencies to clean two-decimal floats, sanitizes formula injections (=, +, -, @), and outputs 100% compliant RFC 4180 Shopify product import CSVs in seconds.

🔄 What This Actor Does to Your Raw Data (Before & After)

Raw Vendor CSV Input (Dirty)	Clean Shopify Import Output (Normalized)
Title: "Men's Running Shoe =SUM(A1:A10)"	Title: "'Men's Running Shoe =SUM(A1:A10)" (Formula escaped)
Price: "1.499,00 €"	Variant Price: 1499.00 (Strict 2-decimal float)
Option 1: "Red / XL / Cotton"	Option1 Name: "Color", Option1 Value: "Red"
Handle: "" (Missing handle)	Handle: "mens-running-shoe" (Deterministic slug)

---

💰 Cost Anchoring vs. Legacy SaaS

Solution	Cost	Setup Time	Limitations
Enterprise PIM / Matrixify Plans	$200 – $500 / month	Days / Complex Config	Strict row tiers, monthly lock-in, seat charges
Manual VA / Freelance Cleanup	$15 – $25 / hour	24–48 hours turnaround	Human error, missing variant links, unescaped quotes
Shopify Catalog Feed Normalizer	$0.05 per run ($50 / 1,000 runs)	Instant (Zero Setup)	Unlimited volume, 100% RFC 4180 standard, serverless

(Pay-Per-Event Primary Event feed-normalization-run assessed at $0.05 upon run start. Secondary per-item event [$0.0005/item] is uninvoked by code; entire batch normalizes under the base fee. Standard platform compute credits apply; Free plan includes $5.00/month).

---

🛡️ Validation & Quarantine Guarantee

Automated Audit Quarantine: If your supplied supplier feed contains unparseable syntax or missing mandatory columns, this Actor does not fail silently. It outputs detailed diagnostics and quarantined records in VALIDATION_REPORT.json, allowing your team to identify and correct supplier data anomalies instantly.

---

🚀 Key Capabilities

• Automatic Multi-Variant SKU Grouping: Groups sibling variant rows under clean Shopify handles while preserving Option1, Option2, and Option3 matrices (Size, Color, Material).
• RFC 4180 & Spreadsheet Protection: Neutralizes Excel/Google Sheets formula injection attacks and enforces strict CSV escaping.
• Currency & Decimal Normalization: Converts European punctuation (1.299,50 €), negative parentheticals, and currency symbols to exact two-decimal numbers.
• Audit Validation Report: Produces a downloadable VALIDATION_REPORT.json flagging duplicate SKUs, missing barcodes, and orphan images.

---

🔌 Plug-and-Play Integrations

1. Claude Desktop & Cursor IDE (MCP Server)

Connect directly to your AI development environment via Model Context Protocol:

{
  "mcpServers": {
    "catalog-normalizer": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-fetch", "https://mcp.apify.com/?actors=deepaksheoran172/catalog-feed-normalizer"]
    }
  }
}

2. Clay.com HTTP Enrichment

Enrich your e-commerce supplier databases automatically inside Clay tables:

• Method: POST
• URL: https://api.apify.com/v2/acts/deepaksheoran172~catalog-feed-normalizer/run-sync-get-dataset-items
• Headers:
  • Authorization: Bearer YOUR_APIFY_TOKEN
  • Content-Type: application/json
• Body:

  {
    "rawCsv": "{{supplier.raw_csv}}",
    "defaultVendor": "{{supplier.brand_name}}"
  }
  

3. n8n & Make.com Automated Cron

Import our pre-built n8n template (tool1_catalog_normalizer_n8n.json) to automatically fetch vendor CSVs via FTP/HTTP, run normalization, and upload the clean dataset directly to Shopify Admin REST/GraphQL APIs on a daily schedule.

---

📥 Input Parameters & 1-Click Prefill

Ready to test immediately without typing — click "Start" on Apify Store with the prefilled sample data:

Parameter	Type	Required	Description
rawCsv	String	Optional*	Direct vendor CSV content. Pre-filled with multi-variant test data.
csvUrl	String	Optional*	Remote URL to download supplier CSV catalog feed.
mapping	Object	Optional	Custom column overrides (e.g. {"vendor_title": "Title"}). Auto-detected if omitted.
defaultVendor	String	Optional	Default brand name fallback (Prefill: ApexSuppliers Inc.).
defaultStatus	String	Optional	Product publication status (active or draft).

*Provide either rawCsv or csvUrl.

---

📤 Output Artifacts

1. Dataset: Structured Shopify product records ready for downstream table visualization or webhook consumption.
2. Key-Value Store:
   • OUTPUT_SHOPIFY_CSV.csv: 1-click importable file for Shopify Admin (Products > Import).
   • VALIDATION_REPORT.json: Complete audit log with SKU counts, rejected rows, and field mapping summaries.

---

❓ High-Intent B2B FAQs

Q: How does it group multi-variant products together?

A: The normalizer detects identical product titles or parent SKU patterns and groups subsequent rows under the same URL handle, populating Option1 Name, Option1 Value, and leaving parent fields padded in strict compliance with Shopify import rules.

Q: Will this protect against spreadsheet formula injection?

A: Yes. Any field prefixed with formula evaluation triggers (=, +, -, @) is safely escaped to prevent remote code execution or spreadsheet formula exploitation.

Q: Can I run this directly in our agency's custom Python backend?

A: Yes. Run via the Apify Python SDK or execute offline using standard CLI:

$python cli.py convert vendor_catalog.csv -o shopify_import.csv

---

🚀 Ready to Normalize Your Supplier Catalog?

Clean messy vendor feeds into Shopify-compliant import CSVs in seconds:

1. Click Try for free at the top right of this page.
2. Paste sample CSV text or provide a supplier feed URL.
3. Download OUTPUT_SHOPIFY_CSV.csv and import directly into Shopify Admin > Products > Import.