Import supplier CSV files into Shopify without manual cleanup

Supplier product files rarely arrive in Shopify’s exact format.

Portaim helps you upload supplier CSV, XLSX, or XLS files, map supplier columns to Shopify product fields, validate product data, fix common issues, and export products to Shopify — without spending hours cleaning spreadsheets by hand.

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. During upload you choose the sheet and header row so Portaim understands 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 can reuse your corrections the next time a file with the same column layout is uploaded.

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.
• 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;
• non-sequential option slots, such as Option2 defined without Option1;
• products that exceed or come close to Shopify’s current product structure limits, such as option axes, variant count, or media count.

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