Supplier CSV to Shopify Migration

Supplier files are rarely Shopify-ready. They arrive with strange headers, repeated rows, image columns that change every month, category codes, missing SKUs, and price rules that live in someone's inbox.

Data.Page can turn messy supplier CSV, Excel, XML, or JSON feeds into Shopify import files as a one-off catalog migration or repeatable workflow.

This is usually a data-normalization job

The supplier file is the raw material. Shopify needs a clean product model: one row per variant, consistent handles, image ordering, option names, prices, inventory quantities, and product metadata. If the source file is not normalized first, the Shopify import will either fail or create a catalog that is hard to maintain.

Common supplier file problems

One product is split across several rows without a stable parent identifier.
Images are stored as multiple columns such as image1, image2, and image3.
Category codes are meaningful only in the supplier's system.
Prices need markup rules, currency conversion, or minimum advertised price handling.
Stock values use words such as in stock, low, or call instead of quantities.

Typical conversion mapping

Supplier field	Shopify target	Transformation
`item_code`	`Variant SKU`	Trim spaces, preserve leading zeroes, flag duplicates.
`product_name`	`Title`	Clean casing and remove supplier-only abbreviations if needed.
`category_path`	Collections or tags	Map supplier taxonomy to storefront taxonomy.
`wholesale_price`	`Variant Price`	Apply agreed markup and rounding rules.
`image_*`	`Image Src`	Explode multiple image columns into Shopify image rows.

How we build the import

Review the supplier file and define the product identity rule.
Normalize rows into Shopify's product and variant shape.
Apply category, price, stock, and image rules.
Generate a Shopify import CSV and an exceptions report.
Test a small sample in Shopify before loading the full catalog.

The exceptions report matters

A useful supplier conversion does not hide bad records. It should show duplicate SKUs, missing titles, impossible prices, broken image URLs, products without categories, and rows that could not be assigned to a parent product. That report is often more valuable than a blind import file.

Have a supplier file that Shopify rejects?

Send us the file and the rules you want for price, category, and stock. We can quote a one-off cleanup and Shopify import package.

Get a migration quote