Import and export materials with Excel
Create many library materials at once from an Excel file using the template, and export your materials to Excel from the Material Library.
Under review. This page is published while we check it against the live app, so some details may have changed.
Instead of creating materials one by one, you can fill in an Excel file and upload it, or export the materials you already have. Both live on the Material Library Page.
LibraryMaterials
Permission: UPDATE_PRODUCT,VIEW_PRODUCT
Note
This is the import for materials. To import techpacks, size charts or SKU lists, see Import templates.
Download the template
Click "Upload Excel"
Click the Upload Excel button at the top right of the Material Library Page. The Create Library from Excel dialog opens.
Click "Download Template"
Click Download Template. Vestis downloads an Excel file prepared for your brand and shows "Template downloaded successfully".
The template has two sheets:
- Products holds the column headings and one example row. Replace the example with your own data.
- ListData lists the values your brand already uses: the types, categories, units, tiers, suppliers, currencies, compositions, care instructions and attributes. Copy values from it so the names match exactly.
Template columns
| Column | What to enter |
|---|---|
| name | Material name. |
| code | Supplier code (SKU). |
| materialCode | Your own material code. |
| type | PRIVATE or PUBLIC. |
| category | Category name. |
| description | Short description. |
| weight, width, length, thickness | The number, each followed by its own unit column: weightDimention, widthDimention, lengthDimention, thicknessDimention. |
| price, priceDimention, currency | The price, its unit, and the currency written exactly as in the ListData sheet (the currency name followed by its code). |
| moq, moqDimention | Minimum order quantity and its unit. |
| construction, finishing, memo | Free text. |
| tier, supplier | A tier written as "Tier 1 - Name" and a supplier name, both as they exist in your brand. |
| composition, compositionPercentage | One composition and its percentage per row. |
| colorCode, colorName | One colour per row. |
| careInstruction | One care instruction per row. |
| mediaTitle, mediaUrl | A linked media item per row. |
| attribute | An attribute written as "Attribute master - Attribute". |
| picture | A picture placed in this row of the sheet. |
Fill in the file
- Use one row for a material. Fill in at least name and code: a row that has both starts a new material.
- A material with several compositions, colours, pictures, care instructions or media items takes extra rows directly below it. Leave name and code empty on those rows and fill only the columns you are adding.
- A category, unit, composition or care instruction that does not exist yet is created for you while the file is read.
- A tier or supplier that does not match an existing one is left empty on the material.
Tip
Start with two or three materials to check the result, then upload the rest.
Upload the file
Click "Upload Excel"
Click Upload Excel on the Material Library Page.
Click "Upload file"
Under Upload Excel File, click Upload file and choose your .xlsx file. The file name replaces the button.
Click "Upload"
Click Upload. When it finishes you see "Excel uploaded successfully" and the new materials appear in the list.
If the file is not an .xlsx workbook, the field shows "Please select a valid Excel file." If the file has no rows, the upload fails and nothing is created. Click Cancel to close the dialog without uploading.
Export materials to Excel
Select materials (optional)
Check the materials you want to export. If you select none, every material is exported.
Click "Actions"
Open the Actions menu above the list.
Click "Export Excel"
Click Export Excel. Vestis shows "Preparing Excel download..." and then "Download complete".
The file has one sheet, Products, with a Thumbnail column first. The other columns are Material Name, Code, Material Code, Type, Category, Description, Supplier, Weight, Width, Length, Thickness (each with its unit), Price, Price Unit, Currency, MOQ, MOQ Unit, Construction, Finishing, Tier, Memo, Compositions, Colors and Attributes.
Note
If you chose your own table columns on the Material Library Page, the export only includes the columns you left visible. See Material library page overview.
Troubleshooting
The Upload Excel button is missing. Your role needs the permission to update products, and the button is hidden on the Public Library tab. Switch to My Materials.
"Failed to download Excel" appears. Try again. If it keeps failing, contact support.