In this guide, we will show you how to update your products using our Excel import feature.
The Excel import lets you update already existing products by uploading an Excel (.xlsx) file.
You can also create products using this method, read more here.
You'll need to make sure that Sello is able to match the changes in the file to an actual product, this is done by including one of two unique identifiers:
- "Sku" - Your internal product ID.
- "Id" - Sello's article number.
Failure to include either of these will result in an error.
You will also need to make sure that all your column names meet our standard, a list of supported column names can be found in the bottom of the Excel import page.
Your cells need to be filled with relevant data. Leaving cells empty is not allowed.
When your file is ready, it's time to start the import.
- Log into Sello.
- In the top-left menu, find "Import / export".
- Find "Excel" in the Import -section.
- Click: "Import".
- Choose: "Update products with my file".
- Select your file.
- Click: "Start".
Your file will now be queued for processing, you can see your estimated wait time to the right.
Good to know:
- If you have a large file with thousands of lines of data it might be a good idea to divide it into smaller files. Long texts are usually what increases file size the most.
- You do not need Microsoft Excel to work with XLSX files, there are plenty of free spreadsheet editors, such as https://www.libreoffice.org.
- Images need to be available on a web address (URL). You can import more than one image per product, just separate the URL with commas.
- We suggest importing texts under "Standard name" and "Standard description" as in most cases this is what you want. You can import a marketplace specific text but then that text will override the "Standard name" and "Standard description" and only work for that marketplace.
- Keep in mind that including new images for a product in the file will overwrite the old ones, so if you want to add more, make sure to include the URL to the old ones as well.