How to fill in the CSV/XLSX templates?
This article will help you correctly fill in CSV and XLSX templates to add your products to the store.
You can use these links to quickly find the necessary information
The List of Product Attributes | |
How to work with the template? | Template With Preset Attributes |
How to Check if The File Uploaded Successfully? |
Product Attribute â is a parameter and your product's feature that we use on Joom to represent your products in their product cards.
Product attributes can be divided into 2 groups:Â
- Required â those you must list while filling in your product's card or a CSV/XLSX file.
- Recommended â those you don't necessarily need but should provide to give your customers as much info as possible.
PLEASE NOTE:
- You can check the second row under each attribute name to see whether it's "required" or "recommended". Delete this row before uploading the file. You can delete it during or after filling it out.
- All "recommended" columns can be left blank or deleted for convenience.
- Make sure the format of the cells in the file is Text to avoid recognition errors.
Product Basic Attributes
Name |
Description |
Status |
||||||||
Product SKU |
A unique product identifier that is shared among a group of variants of a single product. Product SKU is not the same as Variant SKU. Requirements:
RIGHT â:
 WRONG â:Â
|
Required, irreversible | ||||||||
Name |
The product's features and basic characteristics. Product naming template: Product type (what) + Brand (who) + Characteristics (color, size) + Version. Requirements:
RIGHT â:
 WRONG â:Â
|
Required | ||||||||
Description |
Please provide a readable text describing your product. Requirements:
RIGHT â:
 WRONG â:Â
|
Required | ||||||||
Search Tags |
These keywords help users find your products easily. Requirements:
|
Recommended | ||||||||
Labels |
For organizing products internally. Requirements:
Please refer to this article to learn more about it. |
Optional | ||||||||
Brand |
The brand name provided by the brand owner. Not required for non-branded products. If you fill in this field, you may be asked to provide proof of resale or ownership rights. Please refer to this article to learn more about it. |
Recommended | ||||||||
Landing Page URL |
URL to the product page on other platforms. |
Recommended | ||||||||
Product Main Image URL |
We recommend uploading a square image. If you upload a non-square picture, the closest square image will be selected as the main. Requirements:
Avoid the following:
Please refer to this article to learn more about it. |
Required | ||||||||
Extra Image URLs (max 20) |
Additional images to showcase your product in detail. Requirements:
Please refer to this article to learn more about it. |
Recommended | ||||||||
Suggested Category ID |
If you are unsure about the product category your product belongs to, you can leave this field blank. We will determine the product category ourselves. However, specifying the product category will help us moderate the product faster. You can find the list of all Product Category IDs here. |
Recommended | ||||||||
Dangerous Kind |
This field is used to determine the type of product. It is required for logistical purposes. To enter the product attribute "dangerous kind" correctly, please choose from the following variants (for CSV and ERP):
Please refer to this article to learn more about it. |
Optional if you donât use JLÂ Required if you use JL |
||||||||
Video ID |
This feature is available for Top Stores only. Please refer to this article to learn more about it. |
Recommended | ||||||||
Store IDÂ |
To find the Store ID:
|
Required, irreversible | ||||||||
Rich Content |
A high-quality image with an extended product description. The text in such images should be localized for the target region. Please refer to this article to learn more about it. |
Optional |
Product Variant Attributes
Name |
Description |
Status |
||||||||
Variant SKU |
A unique product variant identifier that must not be repeated. It should be distinct from the Product SKU. Requirements:
RIGHT â:
 WRONG â:Â
|
Required, irreversible |
||||||||
Variant Main Image URL |
A direct link to the main image for your product variant, showcasing different styles, colors, angles, and more. We recommend uploading a square image. If you upload a non-square picture, the closest square one will be selected as the main image. Requirements:
Please avoid the following:
|
Recommended |
||||||||
Shipping Weight (kg) |
Product weight in kilograms (kg) after packaging. This field is mandatory for those who use Joom Logistics. If you ship your orders offline, you can disregard this field. Requirements:
|
Optional if you donât use JLÂ Required if you use JL |
||||||||
Shipping Length (cm) |
Product length in centimeters (cm) after packaging. This field is mandatory for those who use Joom Logistics. If you ship your orders offline, you can disregard this field. Requirements:
|
Optional if you donât use JLÂ Required if you use JL |
||||||||
Shipping Width (cm) |
Product width in centimeters (cm) after packaging. This field is mandatory for those who use Joom Logistics. If you ship your orders offline, you can disregard this field. Requirements:
|
Optional if you donât use JLÂ Required if you use JL |
||||||||
Shipping Height (cm) |
Product height in centimeters (cm) after packaging. This field is mandatory for those who use Joom Logistics. If you ship your orders offline, you can disregard this field. Requirements:
|
Optional if you donât use JLÂ Required if you use JL |
||||||||
Manufacture GTIN |
The Global Trade Item Number (GTIN) is a unique identifier for products used worldwide. Please refer to this website to verify the validity of a GTIN code. Requirements:
Please refer to this article to learn more about it. |
Recommended |
||||||||
HS Code |
The Harmonized System Code is used by customs authorities to classify traded products. |
Optional |
||||||||
Color |
Fill in this field only if your product variants vary in color. Requirements:
|
Recommended | ||||||||
Size |
Fill in this field only if your product variants vary in size. You can specify not only the size, but also other attributes that distinguish one option from another, such as the number of pieces or any other relevant detail. Requirements:
Please refer to this article to learn more about it. |
Recommended | ||||||||
Price (without VAT)Â |
Your product price in EUR. Requirements:
RIGHT â:
 WRONG â:Â
 |
Required | ||||||||
Currency |
Requirements:
RIGHT â:
 WRONG â:Â
|
Required | ||||||||
Inventory (default warehouse)Â |
Number of products currently in stock in the default warehouse. The Default warehouse is the warehouse that is automatically created when the merchant's account is set up. The default warehouse is always the same as the merchant's origin. Requirements:
Please refer to this article to learn more about Default and Overseas warehouses. RIGHT â:
 WRONG â:Â
|
Required | ||||||||
Shipping Price without VAT (default warehouse) |
Shipping cost for a specific product variant. Requirements:
RIGHT â:
 WRONG â:Â
|
Required | ||||||||
Declared Value |
The declared value of the variant in EUR for customs clearance when shipping online. Requirements:
|
Recommended if you donât use JL Required if you use JL |
||||||||
MSRP |
Manufacturer's Suggested Retail Price (MSRP). In Europe, MSRP is no longer displayed as a crossed-out discounted price. Requirements:
RIGHT â:
 WRONG â:Â
|
Recommended |
Â
How To Work With The Template?
- Open a CSV/XSLX file.Â
- Start filling in product information from the second row. Please refer to the Product Attributes list to learn more on how to fill in the fields.
- Start filling the information on product variants with the Variant SKUÂ column.
4. Use a new row for each product variant.
5. To group a few product variants into one product, fill in the same Product SKU.
6. The Product Name, Description, Search Tags, Dangerous Kind, and Main Image of the Product attributes are common to all grouped product variants. Make sure that the product information is valid for all grouped variants.
7. Fill in the Store ID information.Â
8. Save the document as a CSV or XSLX file.
PLEASE NOTE:
- The first row contains default names of product attributes.
-
Those fields that cannot be changed but are required to be filled in are marked as required.
- Non-mandatory attributes can be left blank.
Video Tutorial on How To Fill in Templates
Template With Preset Attributes
When adding your products, you can create Templates for specific product categories with all the required and recommended attributes set in the template by default.
- Go to the Products page in your Joom account.
- Click on the Manage Products button.
- Choose Create/Change via CSV/XLSX.
- Click on the Set up a template CSV/XLSX button.
  5. When selecting a Template type, pick Per Category.
  6. Pick the Product Categories (up to 5).
  7. Select the file format you prefer (CSV or XLSX).
  8. Click on the Download button.
  9. Edit the file and upload it to the Merchant Panel.Â
How To Check If The File Uploaded Successfully?
1. Open the Uploads page in your Merchant panel.
2. Find the uploaded file in the list and check its status.
3. You will see Completed if it was uploaded successfully, and Completed with errors if it wasnât.
4. If the status is Completed with errors, click on the file name to learn more about the error.
5. Record + number indicates the row where the error occurred.
6. After " : " you can see the detailed information about the error.
Â
For more information on how to upload the file to the platform, please refer to this article. |
Â
Comments
0 comments
Please sign in to leave a comment.