This feature is in beta, which means that we are working to improve it. If you have any questions, please contact our Support.
In VTEX Admin, you can manage product specification import and export using a spreadsheet, as described in the sections below:
- Importing product specifications using a spreadsheet
- Exporting product specifications using a spreadsheet
- Product specification spreadsheet fields
Importing product specifications using a spreadsheet
To import product specifications using a spreadsheet, follow these steps:
- In the VTEX Admin, go to Catalog > Products and SKUs, or type Products and SKUs in the search barat the top of the page.
- At the top of the page, click
Import. - Click
Product specifications. - Add the spreadsheet with an
.xlsor.xlsxextension. You can drag and drop the file onto the designated area, or click the window to select the file locally.
To get an import template, export the product specifications.
- Once the file is uploaded, click
Import.
The import time will depend on the size of the data being processed. Leaving the page won't interrupt the operation.
While the operation is running, a message will display indicating that the file is being processed. After the import is complete, the page will display "Product specifications imported successfully" and you'll receive a confirmation email.
Exporting product specifications using a spreadsheet
To export an .xlsx file with the product specification information, follow these steps:
The exported information corresponds to the fields described in the Product specification spreadsheet fields section.
- In the VTEX Admin, go to Catalog > Products and SKUs, or type Products and SKUs in the search bar at the top of the page.
- (Optional) If you want to export the product specifications of certain products, apply a search or a filter as desired. This step isn't required to export all product specifications from your catalog.
- At the top of the page, click
Export. - Click
Product specifications.
While the export is running, a message will display indicating that the file is being processed. Leaving the page won't interrupt the operation. You can track the export progress in the window displayed on the page.
Once the export is complete, you'll receive an email with a link to download the file. The download link is valid for 24 hours. After that, the link expires. You can also download the file from the window that opens on the page.
Product specification spreadsheet fields
The following table describes and includes an example for each field of the product specification import spreadsheet. Required fields are marked with an asterisk (*).
| Field | Description | Example |
|---|---|---|
| Product ID* | Unique numeric code identifying the product. | 310117603 |
| Product Name | Product name shown to customers during the browsing experience. | Cotton t-shirt |
| Product Reference Code | Unique product reference code, used internally by the store. To complete this field, use a combination of letters and/or numbers. | shirtColor |
| Brand ID | Numeric code that identifies the product brand. This information can be found in VTEX Admin under Catalog > Brands or by using the Get brand list endpoint. | 2000003 |
| Brand | Brand name of the product. Once this field has a value, it can't be edited. | AOC |
| Department ID | Numeric code that identifies the highest-level product category. | 1000014 |
| Department | Name of the product's highest-level category. | Clothes |
| Category ID | Unique number identifier for the product's lowest-level category. This information can be found in VTEX Admin under Catalog > Categories or by using the Get category tree endpoint. | 1000014 |
| Category | Name of the product's lowest-level category. | Tops |
| Field ID | Numeric code that identifies the product specification field for the product. | 493 |
| Field Name | Product specification field name. | Material |
| Field Type Name | Product specification field type:
| Text |
| Field Value ID | Numeric code that identifies the field value. | 290 |
| Field Value Name | Field value name. | Synthetic |
| Specification Code | Numeric code that identifies the relationship between the field and the product. | 418 |
| Specification Value | Value assigned to the product specification field. This is the only information that can be edited through the spreadsheet. | Polyester |