Catalog Operations & Analytics

Real-time throughput metrics, compliance health, and quick actions for your store.

Free Tier ($0 / forever)

Monthly Quota: 0 of 1 catalogs used · Cap: Up to 25 products & 100 variants

Retained Catalogs Workspace

0

0 approved, 0 downloaded CSVs

Active Products Matrix Unpacked

0

0 active variants generated

Explicit Corrections Overrides

0

Manual value corrections saved across batches

Unresolved Blockers Audit

0

0 review warnings across retained jobs

Processing Throughput

Variants and products structured over recent batches

Variants Products

Quick-Start Supplier Tests

Test our 5-layer mapping engine and variant expander instantly:

👕

Apparel Collection (20 Variants)

Multi-image horizontal columns, 3 size/color options, price markup.

⚡

German Chaotic Supplier

Corrupted Excel barcodes (4.01E+12), € prices, non-English headers.

Recent Catalog Batches

Job ID	Source File	Status	Date	Action
Loading recent batches...

Catalog Jobs

Select an existing catalog batch or import a new supplier file.

Job ID	Store / Customer	Source File	Status	Created	Action
Loading jobs...

Add a supplier file

Upload a CSV or XLSX supplier price list for processing.

Choose a CSV or XLSX file

Drag and drop here, or select from your computer

Supports CSV and XLSX (≤10 MB, ≤5,000 rows). Formulas detected as text without execution.

Confirm your column mapping

Check how your supplier data will become products.

Saved recipe:

Supplier column	Example values	Use as	Review

Transformation Rules

Product grouping

Grouping column (Parent Key)

Rows with identical values in this column are grouped into one multi-variant product.

Option Slots

Option 1 Name

Option 2 Name

Option 3 Name

Prices and currency

Number Locale

Currency

Price Mode

Markup Multiplier

10.00 × 2.50 = 25.00 USD

Weight and inventory

Default weight unit

Inventory policy

Review products

supplier.csv

Product	Variants	Price	Review status

Select a product

—

Select a product row to inspect lineage, variants, and issues.

0 blockers remaining

Approve your import file

Review preflight results and approve cryptographic deliverable.

1. Destination check

Shopify new-product imports forbid overwriting existing products with the same handle.

Declare empty destination store (fresh catalog with no existing products)

Or paste existing store handles (one per line):

2. Export summary

Included Products

0

Total Variants

0

Excluded Products

0

Status / Published

draft / FALSE

3. Approval & Download

Approving freezes this catalog state with a deterministic SHA-256 hash. Any subsequent recipe or review decision edits invalidate this approval.

Store & Workspace Profile

These settings apply by default when generating handles and pricing.

Company or Store Name *

Shopify Store Domain Used for draft import validation.

Default Currency

Default Locale

Weight Unit Default

Primary Niche

Subscription & Billing

Your active plan tier and monthly catalog quotas.

Active

ACTIVE SUBSCRIPTION

Free Plan

$0 / forever

Monthly Catalogs Processed 0 of 1 catalogs

Max Products: 25

Max Variants: 100

File Formats: CSV & XLSX

Exports: Shopify CSV Drafts

Payments, subscriptions, and merchant of record services securely managed by Lemon Squeezy. Cancel or change plans anytime.

Account Credentials

Your identity and access tier on Parseify.

Full Name Loading...

Email Address Loading...

Email Status

Verification Pending

Connected Provider Google OAuth

Workspace Isolation ID Loading...

🛡️

Customer-Isolated Data Storage

All supplier files, recipes, and hash signatures are cryptographically partitioned in isolated directories.

Interactive Reference & Guide

Supplier Formats & Transformation Walkthrough

Learn how Parseify automatically converts unstandardized wholesale spreadsheets into 100% compliant Shopify relational CSVs.

Interactive Transformation Comparison

Toggle between the raw supplier spreadsheet and the resulting Shopify relational CSV to see how collapsed variants and scientific barcodes are fixed.

Handle Parent Key	Title	Option1 Name	Option1 Value	Variant SKU	Variant Price	Variant Barcode Restored	Image Src	Image Pos	Status Safe
linen-summer-shirt	Linen Summer Shirt	Size	S	10042-S	$29.00	401234567891	.../10042_front.jpg	1	draft
linen-summer-shirt	[inherited from parent]	Size	M	10042-M	$29.00	401234567892	.../10042_back.jpg	2	draft
linen-summer-shirt	[inherited from parent]	Size	L	10042-L	$29.00	401234567893	—	—	draft
linen-summer-shirt	[inherited from parent]	Size	XL	10042-XL	$29.00	401234567894	—	—	draft

Item_ID	Product_Name	Sizes Collapsed	Color	Wholesale_Price	Image_1	Image_2 Horizontal	EAN_Barcode Corrupted
10042	Linen Summer Shirt	S, M, L, XL	Navy	€ 14,50	https://cdn.example.com/fotos/10042_front.jpg	https://cdn.example.com/fotos/10042_back.jpg	4.01235E+12

🔗

1. Handle Inheritance

All variants share identical Handle slugs. Secondary variant rows leave Title blank so Shopify groups them under one parent catalog entry.

🖼️

2. Image Unrolling

Horizontal image columns (Image_1, Image_2) become sequential rows with incrementing Image Position integers (1, 2, 3...).

🔢

3. Barcode Recovery

Excel corrupts 13-digit EANs into scientific notation (4.01E+12). Parseify decodes the mantissa and recovers the complete intact integer barcode.

🛡️

4. Forced Draft Safety

Exports are guaranteed with Status = draft and Published = FALSE to protect live store visitors from unreviewed changes.

The 5-Layer Transformation Pipeline

How raw spreadsheet bytes are transformed into cryptographically verified Shopify relational catalogs.

01

Deterministic Ingestion & SHA-256 Digest

Safety Layer

Streams CSV or XLSX sheets without executing formulas or macros. Calculates a cryptographic SHA-256 fingerprint on raw bytes to guarantee audit immutability.

SHA-256: 8f4b23c9... • Strict Encoding Sniffer: UTF-8 / Windows-1252 • Formula Injection Guard

↓

02

5-Layer Intelligent Column Resolver

Mapping Engine

Evaluates supplier column headers across 5 fallback strategies to identify titles, handles, options, pricing, barcodes, and images with confidence scores.

1. Exact Header Match 2. Multilingual Synonym Lookup 3. Token Jaccard Overlap 4. Levenshtein Fuzzy Distance 5. Value Heuristic Scanner

↓

03

Canonical Matrix & Variant Unpacking

Matrix Expansion

Decompresses comma-delimited options (S, M, L, XL), horizontal size matrix columns, and multi-row grouping keys into relational canonical variants.

Parent Handle Slug • Option1 Value Unpacking • SKU Concatenation: {Parent}-{Opt1}

↓

04

Data Repair & Semantic Normalization

Repair Engine

Repairs corrupted IEEE-754 floating barcodes, normalizes European comma/decimal formatting, converts weight units to grams, and applies markup formulas.

4.01E+12 → 401234567891 • € 14,50 → 14.50 USD • Formula: Wholesale × Multiplier (2.00x)

↓

05

Cryptographic Approval & Official 46-Column Export

Compliance Layer

Verifies zero destination handle collisions, enforces Status = draft and Published = FALSE, freezes the catalog state with a SHA-256 signature, and outputs official Shopify CSV.

46 Standard Headers Zero Collision Check Audit Certificate Generated

Comprehensive Transformation Rules

Concrete explanations, problem scenarios, and automated solutions for messy supplier spreadsheets.

Rule 01 Shopify Compatibility

Variant Matrix Expansion

The Supplier Problem: Wholesale spreadsheets compress multiple sizes into a single cell (e.g. Sizes: S, M, L, XL) or horizontal price columns (Price_S, Price_M). Shopify strictly requires each variant on its own row.

The Parseify Fix: Automatically decomposes the matrix into sequential rows sharing the exact parent handle and generates structured SKUs (10042-S, 10042-M).

Output Transformation Row 1: Handle: shirt, Option1: S • Row 2: Handle: shirt, Option1: M

Rule 02 Media Pipeline

Horizontal Image Unrolling

The Supplier Problem: Suppliers place multiple image URLs in separate columns (e.g. Image_1, Image_2, Image_Back). Shopify only accepts one image per row under Image Src.

The Parseify Fix: Unrolls horizontal image columns into secondary product rows, assigning incremental Image Position integers (1, 2, 3...) with matching parent handles.

Output Transformation Row 1: Image Src: front.jpg, Pos: 1 • Row 2: Image Src: back.jpg, Pos: 2

Rule 03 Barcode Integrity

Excel Scientific Barcode Recovery

The Supplier Problem: Opening a CSV in Excel converts 12–14 digit UPC and EAN barcodes into scientific floating-point numbers (e.g. 4.01235E+12), losing the last 4 digits on save.

The Parseify Fix: Decodes the IEEE-754 mantissa, strips exponents, and reconstructs the full integer barcode without precision truncation.

Output Transformation Input: 4.01234567891E+12 → Restored Barcode: 401234567891

Rule 04 Pricing Engine

Currency & Number Locale Normalization

The Supplier Problem: European catalogs use comma decimals (€ 1.250,50) and non-USD currencies, which crash Shopify's US-formatted price parser.

The Parseify Fix: Parses locale-aware number strings, strips currency symbols, normalizes to two decimal places, and optionally calculates retail markup via cost multiplier.

Output Transformation Input: "€ 14,50" → Clean Cost: 14.50 → 2.0x Markup Price: 29.00 USD

Rule 05 Store Safety

Forced Draft Protection

The Supplier Problem: Accidentally importing unreviewed supplier catalogs directly to your live store can expose placeholder prices, raw supplier descriptions, and unverified inventory.

The Parseify Fix: Forces Published = FALSE and Status = draft on every exported product. Your live store never displays products until an admin explicitly publishes them.

Guaranteed Safety Headers Published: FALSE • Status: draft • Variant Inventory Policy: deny

Rule 06 Collision Guard

Handle Collision Prevention

The Supplier Problem: If an imported product handle matches an existing product in your Shopify store, Shopify silently overwrites the live item during import.

The Parseify Fix: Cross-checks generated handles against your existing store handle list during preflight review and generates unique slug suffixes if collisions exist.

Deduplication Protection Existing: linen-summer-shirt → Resolved: linen-summer-shirt-2

Official Shopify 46-Column Relational Schema

Complete categorized reference of all 46 official columns required for error-free Shopify catalog imports.

Group A

Product Identity & Organization (9 Headers)

Handle Primary Key Title Parent Only Body (HTML) Vendor Product Category Type Tags Published FALSE Status draft

Group B

Option Slots (6 Headers)

Option1 Name Option1 Value Option2 Name Option2 Value Option3 Name Option3 Value

Group C

Variant Logistics & Pricing (10 Headers)

Variant SKU Variant Grams Variant Inventory Tracker Variant Inventory Qty Variant Inventory Policy Variant Fulfillment Service Variant Price Variant Compare At Price Variant Requires Shipping Variant Taxable Variant Barcode

Group D

Images & Media (3 Headers)

Image Src Image Position Image Alt Text

Group E

SEO & Google Shopping Feeds (18 Headers)

Gift Card SEO Title SEO Description Google Shopping / Google Product Category Google Shopping / Gender Google Shopping / Age Group Google Shopping / MPN Google Shopping / Condition Google Shopping / Custom Product Google Shopping / Custom Label 0–4 Variant Image Variant Weight Unit Variant Tax Code Cost per item

Ready to Test?

Run a Live Catalog Transformation Now

Try our automated 5-layer engine on realistic wholesale catalogs. Zero setup or card required.