Product Import Format (CSV & Excel)

How a spreadsheet import works

Supplier files rarely share a layout. One puts the header on row four, another splits dimensions across six columns, another sends prices with a currency symbol in every cell. So the import doesn't ask you to match columns on a form. The assistant reads the file and proposes the mapping, and you confirm it.

1. Open Import products on the Products page and upload up to five files: CSV, Excel, PDF price lists, spec sheets or photos. You can also point it at a website instead.
2. The assistant previews each sheet, finds the header row even when it isn't the first, and proposes which column feeds which product field.
3. You confirm or correct the mapping and any judgement calls, such as which of two price columns is the retail price.
4. The import runs in batches and reports how many products were created and updated, plus any row issues.

Standard Shopify and WooCommerce product exports are recognized from their headers and mapped automatically. When you confirm a mapping for a supplier's file, it can be saved, and the next file with the same headers starts from that mapping.

There's no fixed template. Upload the file in whatever layout you have, and the assistant maps it with you.

If you are starting from a supplier's spreadsheet rather than your own, furniture supplier catalog onboarding walks through the clean-up that comes before this step, and the furniture product data model explains which of the fields below matter for each product type.

Product details

Pricing

Prices are stored on the product's default variant. There's no currency column: amounts import in your catalog's currency, and if a cell or heading shows a different currency, the import warns you rather than converting. European number formats such as 1.251,00 are read correctly, and currency symbols in cells are ignored.

MAP and IMAP only appear in regions that use advertised price floors.

Images

Image URLs must be absolute (start with http:// or https://) and publicly reachable. Shared Dropbox, Google Drive and GitHub links are converted to direct links. After the import, images are copied into Furniture Connect, so the products don't depend on the original host. Furniture asset metadata covers why an image's role matters once it's in.

Put several URLs in one cell on separate lines, or separate them with commas or semicolons. If the same URL appears in more than one image column, it's stored once.

The assistant can also place images into your media slots, such as a white cutout, a lifestyle shot or a dimensional drawing. It can bind a whole column to a slot, or match gallery images to a slot by a fragment of the filename, such as -dims. Each slot holds one image.

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. Matching ignores upper and lower case.

Unknown codes are listed in the import issues. The product still imports, just without that material link. You can use the image columns and the material columns on the same row, because they fill different fields.

Dimensions and units

Metric and imperial both work. Keep measurements in the units the supplier used and put the unit in the column heading, such as Width (cm), Depth (in) or Weight (kg). The heading's unit is used first. If a heading has no unit, the import falls back to your catalog's default unit, so name the unit whenever you can.

Lengths can be in millimeters, centimeters, meters, inches or feet, and weights in kilograms, grams, pounds or ounces. A range such as 85-110 is stored as a minimum and maximum. A value such as 130/153 is rejected with a warning, so split it into two columns.

Keep product and package measurements in separate columns. The import recognizes:

Yes/no cells accept yes / no, true / false, 1 / 0 or y / n, in any case.

Lighting attributes

Regulatory

Other attributes

The import also recognizes common operational fields and creates them as attributes the first time you map them. These include stock, lead time, warehouse location, vendor, supplier name and part number, assembly, warranty, composition, discontinued and intro season. Free-text Fabric and Finish columns are kept as attributes too, but they don't link to the Materials page, so prefer the material code columns above.

Any other column needs a custom attribute that already exists in your catalog. If it doesn't, ask the assistant to create the attribute before the import runs. For multi-select attributes, separate the values with commas.

Variants and product families

Each row in a spreadsheet import becomes a standalone product. The import doesn't group rows that share a base name into variants.

For a range where one sofa comes in several fabrics, finishes or sizes, ask the Furniture Connect Agent to organize it into a product family. It reads the variant structure, confirms with you how to model it, then builds the family. A product can have up to three variant axes, such as size, fabric and leg finish.

Shopify exports list each variant on its own row with a blank title. Those rows take the parent row's details, but they still import as separate products.

How re-imports update products

A row whose SKU matches a live product updates that product instead of creating a duplicate. Only the fields the file carries change; everything else on the product is kept. A blank cell never clears a value, so to remove one, edit the product in the catalog.

Rows without a SKU always create a new product. If the only product with that SKU has been deleted, the row creates a new one. If your plan's product limit is reached, new rows are refused, but existing products still update.

If you are comparing import capabilities across systems, use the furniture PIM buyer's guide to test how each handles dimensions, variants and supplier files.

Other ways to get products in

A spreadsheet is the quickest route for a whole range, but it isn't the only one. Pick the route that matches where the data lives today.

Common issues

• Row skipped: missing required field "name": the row has no product name, or the name column wasn't mapped.
• 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 not stored: the URL isn't a valid http(s) address. Make sure it's absolute and publicly reachable.
• Currency warning: a cell or heading shows a different currency from your catalog's. The amount imports unchanged, so convert it first if it needs converting.
• Unknown mapping target: a column was mapped to a custom attribute that doesn't exist yet. Create the attribute, then run the import again.

Frequently asked questions

---

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