How to Upload Products via CSV File?
How to Download a CSV File Template?
- Go to the Products page in your Joom account;
- Click on the Manage Products button and choose Create / Change via CSV;
3. Download a CSV or XLSX template.
⚠️ PLEASE NOTE: CSV template updates regularly. We recommend you to download a new one each time you want to add new products.
CSV Template |
- The first row contains default names of product attributes;
- Mandatory fields are marked with an asterisk (*);
- Use a new row for each product variation;
- Do not add or delete pages;
- Non-mandatory attributes can be left blank.
How to Fill in Product Information In the CSV File?
- Open a CSV file in the most convenient CSV editor. If you don't know how to open the CSV file, please refer to the article What is a CSV File?;
- Start filling product information from the second row.
- 👉 If you don't know how to fill in some fields, please refer to the article Product Basic Information;
- Start filling the information of product variations from the *SKU column;
4. Use a separate row for each new product variation;
5. To group a few product variations into one product, fill in the same Product SKU;
6. The Product Name, Description, Tags, Dangerous Kind and Main Image of the Product attributes are common to all grouped product variations. Make sure that the product information is valid for all grouped variations;
7. To add multiple Extra Images, provide their URLs in the related cell. Use Ctrl + Enter between links to separate them from each other. You can upload up to 20 extra images;
8. Please indicate the prices without the VAT amount. Joom automatically calculates the VAT according to the country for each merchant.
9. Fill the Store ID information. If there is only one store in your account, you don't have to fill this information; if there is more than one store in your account, it is required to fill this information;
10. Save the document as a CSV file. If you don't know how to save the CSV file, please refer to the article What is a CSV File?
XLSX Template |
XLSX template is a file with a detailed instruction and hints, please read the instruction on the first list of the document carefully and fill it out according to your products' information.
How to Upload the File Back to the System?
- Go to the Products page in your Joom account;
- Click on the Manage Products button and choose Create / Change via CSV;
- Put the file to the area;
- Click on the Upload button.
⚠️ PLEASE NOTE: For uploading, only CSV files are accepted. If you used XLSX template, you need to save it in a CSV format before upload.
After you clicked on Upload, the file will be added to the waiting list. You can close the web page, and the upload process will be run in the back stage automatically. You can find the uploaded file on the Uploads page in the My Files section in your Joom account. Please read the article My Files for more details.
Comments
0 comments
Please sign in to leave a comment.