Menu
Feedback
Start here
Tutorials
Developer portal

Known Issues
Support Rules
Troubleshooting

Frequently Asked Questions
Announcements
Troubleshooting
Error when trying to import SKUs via spreadsheet in the VTEX Admin
Error when trying to import SKUs via spreadsheet in the VTEX Admin
Published on 7/1/2024
Last update on 11/8/2024

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:

Solution

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.

Solution - Changing the file

  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.

Contributors
2
Photo of the contributor
Photo of the contributor
+ 2 contributors
Contributors
2
Photo of the contributor
Photo of the contributor
+ 2 contributors
On this page
Still got questions?
Ask the community
Find solutions and share ideas in the VTEX community.
Join our community
Request support from VTEX
For personalized assistance, contact our experts.
Open a support ticket
GithubDeveloper portalCommunityFeedback