From messy CSV to Shopify-ready products

Import supplier product data into Shopify. AI maps columns, validates everything, and fixes issues — you just confirm.

This supplier file has 15 issues. Watch them get fixed.

This supplier file has 4 issues. Watch them get fixed.

Raw supplier file

#	title	prc	status	wght	photo_url	inv_policy
1	ORGANIC COTTON TEE	$29.99	published	0.5kg	https://cdn.com/tee.jpg	backorder
2	Denim Jacket	USD 89.50	draft	1.2 lbs	https://cdn.com/jacket.jpg	deny
3	RUNNING SHOES	65.00 USD	enabled	350	https://cdn.com/shoes.jpg	allow
4	Wool Beanie	$ 12.99	actve	200g	https://cdn.com/beanie.jpg	keep selling

Product 1

Fixed

titleauto

title

ORGANIC COTTON TEE

Fixed ALL CAPS → Title Case

prcAI

prc

$29.99

Stripped $ symbol

statusauto

status

published

"published" → "active"

wghtAI

wght

0.5kg

Converted to grams

supplier_messy_products.csv · 4 rows · 6 columns

·Click any step to jump

Create Free Account or Log In →

Free during beta · No credit card required

Without Portaim

Manually matching supplier columns to Shopify fields. Every. Single. Time.

With Portaim

AI maps columns automatically. Just confirm the matches and move on.

Without Portaim

Upload to Shopify, get rejected. Fix one thing, rejected again. Repeat.

With Portaim

Every issue caught before you export — invalid values, wrong formats, missing fields. No surprises.

Without Portaim

Hours cleaning up prices, weights, statuses, and typos in spreadsheets.

With Portaim

Auto-fix, bulk value mapping, and AI suggestions handle the cleanup.

Step 1

Upload

Drop your supplier CSV or Excel file. Pick the sheet and header row — we handle the rest.

Upload File

Drop your file here

or click to browse

CSV or Excel files up to 10MB

Upload File

Drop your file here

or click to browse

CSV or Excel files up to 10MB

Step 2

Map Columns

AI reads your supplier headers and suggests the right Shopify fields. Green means auto-matched, purple means AI-suggested. You just confirm.

6 of 6 columns mappedAuto-matchedAI-suggested

SKU

Handle

Title

Body (HTML)

Price

Variant Price

Status

Weight (kg)

Variant Grams

OCT-001

Organic Cotton Tee

Soft 100% organic cotton t-shirt

29.99

active

0.2

DJC-045

Denim Jacket Classic

Vintage-wash denim jacket

89.50

draft

0.9

RSP-112

Running Shoes Pro

Lightweight performance running shoes

65.00

active

0.35

6/6 mappedAutoAI

Handle

OCT-001

Title

Organic Cotton Tee

Variant Price

29.99

Status

active

homegoods-warehouse-spring-catalog.csv3 rows

Step 3

Fix & Preview

Every row is checked against 40+ Shopify-specific rules. Invalid values, wrong formats, missing fields — all flagged with one-click fixes and AI suggestions.

Fix & Review

7 errors7 warnings

Select the correct value from the dropdown. One fix applies to all matching rows.3 / 3 filled

Status3 rows · 2 values

Your valueMap to Shopify value

“hidden”

Did you mean "draft"? Valid: active, draft, archived

Row 20 · STAT-003

draft

“published”

Did you mean "active"? Valid: active, draft, archived

Row 18 · STAT-001

active

Inventory Policy2 rows · 2 values

Weight Unit2 rows · 2 values

Fix & Review

7 errors7 warnings

Invalid Values7

Status field · 2 values fixed

hiddendraft

publishedactive

+ Inventory Policy, Weight Unit also fixed

homegoods-warehouse-spring-catalog.csv83 rows

Step 4

Export

Download a clean, Shopify-formatted CSV — or connect your store and push products directly via API. Your import summary shows exactly what was fixed.

Export DataReview your cleaned data and export when ready.

Products

83 rows

Fixes Applied

3 auto · 1 manual

Warnings Left

All issues resolved

Mapped Fields

All columns mapped

View field mappings (17 fields)

Download Clean CSV

Shopify-formatted, ready for manual import

homegoods-warehouse-spring-catalog_shopify.csv4.0 KB

Export to Shopify

Push products directly to your Shopify store via API

my-amazing-store.myshopify.comConnected

Will export 83 products to your store

Export Data

Products

83 rows

Fixes Applied

3 auto · 1 manual

Warnings Left

All resolved

Mapped Fields

All mapped

Export to Shopify

my-amazing-store—83 products

Export Mode

Create new products

Creates all products as new. May create duplicates if products already exist.

Smart upsert (by Handle)

Updates existing products matched by Handle, creates new ones if no match found.

Export Preview83 rows · 17 columns

homegoods-warehouse-spring-catalog.csv83 rows

The transformation

Your messy supplier data goes in. Clean, Shopify-ready products come out.

	Supplier file		Shopify-ready
Column name	prod_desc_lng	→	Body (HTML)
Price format	€12,50	→	12.50
Status value	enabled	→	active
Option value	BLUE / XL	→	Blue
Missing SKU	(empty)	→	SUP-001-BLU-XL
Inventory policy	backorder	→	deny

Stop fighting spreadsheets. Start importing.

Free during beta. No credit card. Real supplier files welcome.

Create Free Account