Product tags: Catalog, SKU, Spreadsheet, Import

After setting the category tree and adding product specifications and SKUs to your store, you must complete the values for the specifications you created. In the VTEX Admin, you can do this process manually or using a spreadsheet when adding products and SKUs. If you get the message "An error occurred in the data writing process. Make sure your worksheet data is consistent with the instructions and try again." when importing SKUs via spreadsheet, this may be due to:

• Incomplete mandatory SKU specifications.

• Incorrect file formatting.

You can solve this problem by:

• Changing the file: The file must follow specific formatting rules and be saved as an XML spreadsheet in .xls format.

1. In the VTEX Admin, go to Catalog > Import and Export > All Products > Export / Import and click the Import tab.
2. Click Click Here to download the spreadsheet template.
3. Edit the spreadsheet template with the SKUs you want, following all the recommendations on the Import and Export page.
4. Save the spreadsheet in .xls format.
5. On the same page, under Upload Import File, select the file and click Import.

If the error persists after changing the file, please contact our Support team.