Import Supplier CSVs into Shopify Without Manual Cleanup

Published May 4, 2026

Import supplier CSV, XLSX, and XLS files into Shopify without spreadsheet cleanup — AI column mapping, 40+ validation rules, auto-fix for common issues, and export as a Shopify-ready CSV or direct API push.

Free plan available · No credit card required · Shopify connection optional

The problem with supplier CSV files

Shopify can import products from a CSV file, but supplier spreadsheets are usually not prepared for Shopify. Shopify expects a specific column layout — and supplier files almost never use it.

A supplier file may have columns like:

A direct import often means manual work:

• renaming supplier columns to Shopify’s expected names;
• copying values into Shopify’s expected fields;
• fixing prices, weights, and booleans;
• checking duplicate or missing SKUs;
• validating image URLs;
• making sure required fields like Title and Variant Price are populated;
• repeating all of it the next time the supplier sends a file.

Portaim is built for this exact workflow.

How Portaim helps

1. Upload your supplier file

Upload a CSV, XLSX, or XLS file from your supplier.

You can use Portaim even if the file does not match Shopify’s CSV format yet. After upload you pick the sheet (for multi-sheet XLSX files) and the header row so Portaim knows where your product data starts.

2. Map supplier columns to Shopify fields

Portaim suggests mappings between supplier columns and the official Shopify product CSV fields.

For example:

Review every suggestion before confirming, override any that does not fit, and Portaim's template auto-save remembers your corrections the next time a supplier file with the same column layout is uploaded — no re-mapping from scratch.

For product photography spread across several columns (image_1, image_2, image_3…), the mapper builds a real Shopify image gallery instead of picking one column and losing the rest — see the bulk-import image galleries guide.

3. Catch Shopify CSV import issues before export

Before sending products to Shopify, Portaim checks your mapped data against common CSV import issues and Shopify field expectations.

Common supplier-file issues and what Portaim does about them:

Portaim also catches variant-related problems that are easy to miss during spreadsheet cleanup — for example, missing option names, duplicate option combinations, or incomplete option columns.

Variants — color, size, and other product options

Variants are one of the trickiest parts of any Shopify CSV import. Shopify represents variants as multiple rows that share the same Handle, with each row carrying explicit option fields such as Option1 Name and Option1 Value. Products with two or three option axes use Option2 Name / Option2 Value and Option3 Name / Option3 Value as well.

Supplier files vary widely in how they handle this:

• Shopify-style. Some supplier files already include explicit Option1 Name / Option1 Value columns. Portaim maps these directly.
• Flattened columns. Some files use a single column per variant attribute, such as Color, Size, or Material, where each row contains the value for that variant. Portaim helps you map these to Shopify’s option columns and flags missing option names so your variant structure is not changed unexpectedly during import or update.
• Combined columns. Some suppliers cram every variant attribute into a single column like Variant or Attributes with values like Red / Small. Portaim's Split editor breaks that back into real Option1 / Option2 fields — see the variant options guide for the full walkthrough.
• Single-variant catalogs. Some suppliers send one row per product with no variants. These map to Shopify without option columns.

Portaim catches common variant traps before export, including:

• duplicate option combinations on the same product;
• option values without a matching option name;
• gaps in option numbering — if you leave Option1 empty but map Option2, the export compacts them so Shopify still receives a valid Option1/Option2 pair.

Export to Shopify or download a Shopify-ready CSV

After mapping and validation, you choose how to export:

• Direct Shopify export — connect your Shopify store and Portaim sends products via the Shopify API.
• CSV download — download a Shopify-formatted CSV and import it manually in Shopify admin.

Connecting your Shopify store is optional. You can use Portaim end-to-end and never connect a store — download the clean CSV, review it, and import it on your own schedule.

Built for repeat supplier imports

Most merchants do not import supplier files only once. The same supplier sends an updated catalog next month, then the month after.

Portaim recognizes when a supplier file with the same column layout is re-uploaded and applies your previous mapping automatically, so you can move to validation with less re-mapping and less setup. The matching is based on the file’s column structure — a fingerprint of the headers — so you do not need to remember a template name.

This is especially useful when:

• the same supplier sends regular product updates;
• each supplier has a different spreadsheet format;
• you work with multiple brands or wholesalers in parallel;
• you want a repeatable import process instead of manual cleanup every time.

When this page is for you

Portaim is a good fit if you:

• sell on Shopify;
• receive supplier, wholesaler, distributor, or dropship CSV/XLSX files;
• spend time cleaning product spreadsheets manually;
• need to map supplier columns to Shopify fields;
• want to catch CSV import issues before export;
• want to reuse mappings for repeat supplier files.

Portaim may not be the right fit if:

• you only add a handful of products manually;
• your supplier already provides a perfect Shopify-ready CSV;
• you need a full ERP or PIM system with inventory sync, accounting, and order management;
• you want a custom one-off migration project rather than a self-service import tool.

Why not just import the supplier CSV directly into Shopify?

If a supplier file already follows Shopify’s expected CSV format, you can import it directly.

But most supplier files do not. They use different headers, localized values such as German Beschreibung or French Prix, currency symbols, custom availability values, http image URLs, missing or extra columns, and inconsistent SKUs.

Portaim sits between the supplier file and Shopify:

Supplier CSV/XLSX → Portaim mapping + validation + fixes → Shopify-ready export

The goal is not to replace Shopify’s import. The goal is to prepare supplier data so the import is less likely to fail, your variant structure is not changed unexpectedly, and the same cleanup does not need to be repeated manually every month.

For a feature-by-feature breakdown and pricing, see the Portaim homepage.

Frequently asked questions

Related use cases

Split Combined Variant Columns into Shopify Options

Supplier files often cram variants into one column like "Red / Large". Here's how Portaim splits it into real Shopify Option1 / Option2 values.

Bulk Import Product Image Galleries from a Supplier CSV

Supplier files often spread product photos across several columns. See how Portaim turns image_1, image_2, image_3 into a real Shopify image gallery.