Shopify and Hyperzod describe the same product data in completely different CSV structures. Shopify exports one row per variant with columns like Option1 Name and Option1 Value. Hyperzod expects a product row with PRODUCT.* columns and option groups defined inside the row. Converting between them by hand is slow and error-prone — every variant row must be collapsed, every price recalculated, every image reattached. This guide shows how CSV Pilot does the conversion automatically and what to check afterwards.
Why the two formats don't match
A Shopify export for a t-shirt in two colors looks like this:
- Row 1: Handle, Title, Body,
Option1 Name = Color,Option1 Value = Black, Variant Price, Variant SKU, Image Src - Row 2: Handle,
Option1 Value = White, Variant Price, Variant SKU, Image Src
The same t-shirt in the Hyperzod structure is one product row where colors live in an option group: a Color group with variants inside it, each carrying the price difference over the base price. Simple products — those without real variants — arrive with Shopify's placeholder Option1 Name = Title, Option1 Value = Default Title, which must be dropped so they stay flat.
The conversion is not a rename. It is a restructuring: variant rows must be collapsed into option groups, prices must be recalculated as deltas, and the base price must be chosen so the final prices stay exactly the same.
The conversion flow
1. Upload the Shopify export
In CSV Pilot, click Upload CSV and select your Shopify product export. The tool detects the Shopify format automatically and holds the file unchanged — it will not convert anything until you ask. This hold-and-convert design means an accidental upload never modifies or destroys your data.
2. Ask for the conversion
Tell the agent: "Convert this CSV for import." CSV Pilot then:
- Groups rows by product Handle
- Turns
Option1/2/3 Namecolumns into option groups - Converts variant prices into deltas over the product base price (the cheapest variant becomes the base)
- Maps title, description (with HTML cleaned), SKU, images and inventory to the Hyperzod columns
- Drops Shopify's "Default Title" placeholder rows, so simple products stay flat instead of gaining a fake option
- Keeps product status from Shopify's active/draft/archived state
3. Review and export
The converted catalog appears in the preview grid. Check a few products you know well — a simple one, one with variants, and one with images — then export. The downloaded file matches the Hyperzod import structure and is ready for the catalogue import.
What carries over
| Shopify column | Hyperzod result | | --- | --- | | Title | Product name | | Body (HTML) | Description (HTML cleaned) | | Handle | Not copied into the product ID — fresh import identity | | Variant Price (lowest) | Base selling price | | Other variant prices | Option deltas on top of the base | | Option1/2/3 Name + Value | Option groups with variants | | Variant SKU / Inventory | Carried to the matching variants | | Image Src | Product image | | Status | Active/inactive |
What to check after conversion
- Multi-option products — a product with Size and Color becomes one option group per dimension; verify both groups exist with the right values.
- Base price — the cheapest variant becomes the base. If that is not what customers should see first, adjust the base in the preview.
- "Default Title" products — simple products must not show an empty option group. If one appears, it is a bug in the source file, not the conversion.
- Images — multi-image products keep their first image; verify the URLs resolve.
CSV Pilot is an independent tool and is not affiliated with Shopify or Hyperzod. The conversion targets the Hyperzod-compatible import structure while Shopify remains the source of your original data.