Vendor Price List → Import Sheet

Import Sheet Generator

Paste a vendor price list below, configure mappings once, then export the finished TSV/CSV for import.

Vendor column delimiter Must match how the pasted list is separated.

Vendor header row present?

Shopify Vendor

Vendor 1 name/code

Subsidiary

Tax Schedule

Currency

Price Level

Preferred vendor? (Yes/No)

Default Cost Category

Matrix color options (comma list) Used when exploding a parent into variants.

Use the vendor preview to set which vendor column feeds each import field. Indices are 0‑based.

External ID ← vendor column index 0‑based; leave blank to auto‑generate.

Item Name/Number ← vendor column index

Base Name/Title ← vendor column index Used for Display Name, Shopify Title, etc.

MSRP ← vendor column index

Purchase price ← vendor column index