Product Import Format (CSV & Excel)

You can bring your whole catalog into Furniture Connect from a single spreadsheet. Upload a CSV or Excel file in the Import Products dialog on the Products page, map each column to a product field, and the importer does the rest. This page is the reference for what columns are supported and how each one is read.

The fastest way to start is to download the template and replace the example rows with your own. Every column below is optional unless marked Required—map only the ones you have.

How column mapping works

When you upload a file, the importer previews your headers and tries to match each one to a product field automatically. You can override any mapping before you start the import, and anything it can't match is simply skipped (you'll see those columns in the dialog so you can map them by hand).

Multi-value cells—gallery images, key features, keywords, material codes—can be separated by a comma, semicolon, or a new line within the cell.

A note on units. Dimension columns currently use imperial slugs (width_in, height_in, depth_in, and so on) because the importer predates our move to millimetres elsewhere in the product. Keep using the imperial columns below for now—millimetre aliases are on the way.

Top-level columns

Pricing

Images

Every image is stored with an optional role, which is what tells fabric and finish swatches apart from hero and lifestyle shots in the product view. Image URLs must be absolute (start with http:// or https://) and publicly reachable.

If the same URL appears in more than one image column, the first role wins.

Linking to your material library (recommended)

If you already maintain a material library on the Materials page, reference existing entries by their material code instead of re-uploading swatch images. The importer matches codes case-insensitively.

Unknown codes are listed in the import summary—the product still imports, just without that material link. You can use the image columns and the material columns on the same row; they populate different fields.

Dimensions and packaging

Boolean cells accept yes / no, true / false, 1 / 0, or y / n.

Lighting attributes

Material text columns (legacy)

Use these only when you don't have a structured material library—they store free text and don't link to the Materials page. Prefer the Fabric Materials / Finish Materials columns above whenever you can.

Regulatory

Custom attributes

Any column you map to a custom attribute is stored on the product's attributes. If the attribute doesn't exist yet, you can create it on the fly from the import dialog when you map the column—pick the data type and you're done. For multi-select attributes, provide a comma-separated value.

How re-imports update products

Rows whose SKU already exists in your catalog update the existing product instead of creating a duplicate. Rows without a SKU always create a new product. Variant auto-detection groups products that share a base name but differ by finish, color, size, or material into a single set of variants—you can turn this off in the dialog before importing.

Common issues

• Row skipped: "missing required field name" — the row didn't map a column to Product Name. Check the column mapping in the dialog.
• Unknown material code — the code doesn't exist in your material library. Add the material on the Materials page and re-import, or remove the code from the cell.
• Image URL not stored — the URL isn't a valid http(s) address. Make sure it's absolute and publicly reachable.

Still stuck on a file? Reach out to support with your spreadsheet and we'll help you map it.