Import the messy reality, not the ideal
Vendor catalogs come in every shape. Some have one row per variant, some one row per product. Some name their option columns "Size" and "Color," some "S" and "C," some don’t name them at all. Vendee Pro’s import is built for the spreadsheets you actually receive, not the spreadsheets you wish vendors sent.
No column mapping required
Vendee Pro reads your spreadsheet’s header row and works out which column is which — product name, SKU, wholesale and retail price, options, images, and more — automatically. A Shopify export, a vendor portal download, and a brand’s home-baked line sheet all import without you mapping a single column by hand. It’s deliberately forgiving about inconsistent naming, so you spend your time buying, not wrangling headers.
Products and variants, sorted out for you
Vendor files are inconsistent: some give you one row per variant, some one row per product. Either way, Vendee Pro automatically rolls the rows up into clean products carrying their full set of variants — sizes, colors, and other options — with SKU, barcode, and pricing kept at the variant level. No pre-formatting and no spreadsheet gymnastics required.
Images come in with the catalog
If the file references product images, Vendee Pro pulls them in and optimizes them for you — no separate upload step. A broken or missing image link never sinks the import; it’s flagged on that row and everything else sails through.
Per-row error reporting
Imports work at the product level, not all-or-nothing. If a handful of rows have a problem — a missing field, a bad price, a dead image link — the rest still import, and the problem rows are reported with the exact row and reason. Fix those, re-upload just that slice, and you’re done.
Downloadable template
The import page includes a downloadable template with sample rows for both simple and variant products — a clean starting point when you’re shaping a vendor file. Vendee Pro’s export uses the same format, so a catalog you build here can be downloaded, archived, or reused as the basis for the next vendor’s file.
Background processing
Imports run in the background, so you can keep working while a large catalog loads. The import list shows live progress — total rows, processed, succeeded, and failed — as it advances.
Or just hand it to the AI
When a catalog isn’t a tidy CSV — a PDF line sheet, an XLSX with non-standard headers, even a photo of a printed catalog page — drop it straight into a chat with our AI assistant. It reads the file, extracts a structured product list, and shows you every line on a confirm card; the records are created only after you approve. It’s the same advanced engine that drafts purchase orders from Faire, NuOrder, and Joor files.
Frequently asked questions
What file formats are supported?
The direct importer takes CSV files; saving an Excel sheet as CSV works fine. For XLSX, PDF, or a photo of a catalog, hand it to the AI assistant instead — it reads those natively and proposes a structured import you confirm.
Can I update existing products via the CSV import?
The direct CSV importer creates new products. To update existing ones, edit them in the product detail page, or use the AI assistant’s bulk update tools (which can take a file as input) for batched changes you confirm.
How big a file can I import?
Up to 50 MB per upload. Large catalogs of several thousand rows finish in the background within minutes. Split very large catalogs into separate files so a single bad row never blocks the rest.
What happens to imported images?
Imported images are downloaded, optimized for fast loading, and stored on your account, then attached to the product automatically.
Upload your first vendor line sheet.
Get started and import a real catalog in five minutes - CSV import is included on Basic and up.
Get Started