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 SKU specification import and export using a spreadsheet, as described in the sections below:
- Importing SKU specifications using a spreadsheet
- Exporting SKU specifications using a spreadsheet
- SKU specification spreadsheet fields
Importing SKU specifications using spreadsheet
To import SKU 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 bar at the top of the page.
- At the top of the page, click
Import. - Click
SKU 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 SKU 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 "SKU specifications imported successfully" and you'll receive a confirmation email.
Exporting SKU specifications using a spreadsheet
To export an .xlsx file with the SKU specification information, follow these steps:
The exported information corresponds to the fields described in the SKU 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 SKU specifications of certain items, apply a search or a filter as desired. This step isn't required when exporting all the SKU specifications in the catalog.
- At the top of the page, click
Export. - Click
SKU specifications.
While the operation 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 that opens 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.
SKU specification spreadsheet fields
The following table describes and includes an example of each field in the SKU specification import spreadsheet. Required fields are marked with an asterisk (*).
| Field | Description | Example |
|---|---|---|
| SKU ID* | Unique numeric code that identifies the SKU. | 310119261 |
| SKU Name | SKU name, which identifies the product variation. | M |
| SKU Reference Code | Unique SKU reference code, created to facilitate catalog management. Once this code is created, it can't be edited through the spreadsheet. This field is required unless the EAN/UPC field has a value. | shirt-color |
| Brand ID | Numeric code that identifies the SKU 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 SKU. 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 highest-level product category. | Clothing |
| Category ID | Unique number identifier of the SKU'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 related to the SKU's lowest-level category. | Tops |
| Field ID | Numeric code that identifies the SKU specification field for that SKU. | 892 |
| Field Name | SKU specification field name. | Color |
| Field Type Name | SKU specification field type:
| Radio |
| Field Value ID | Numeric code that identifies the field value. | 689 |
| Field Value Name | Field value name. | Color |
| Specification Code | Numeric code that identifies the relationship between the field and the SKU. | 397 |
| Specification Value | Value assigned to the SKU specification field. This is the only information that can be edited through the spreadsheet. | Blue |