English (US) Deutsch Español Français Polski РуссĐșĐžĐč TĂŒrkçe
search shadow

Menu

Articles in this section

How to fill in the CSV/XLSX templates?

Avatar
Marina Sokolova
  • Updated

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

Video Tutorial on How To Fill in Templates

 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: 

  1. Required – those you must list while filling in your product's card or a CSV/XLSX file.
  2. 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.______________2022-02-21___08.29.22.png
  • 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:

  • English letters and numbers only.
  • Maximum length: 128 characters.

RIGHT ✓:

Product SKU: DR-001
Variant SKU:

DR-001_Pink_S 

DR-001_Pink_M 

DR-001_Blue_M 

 

WRONG ✗: 

Product SKU: DR-001
Variant SKU:

DR-001

DR-001

DR-001
Required, irreversible

Name

The product's features and basic characteristics.

Product naming template:

Product type (what) + Brand (who) + Characteristics (color, size) + Version.

Requirements:

  • Use only your "upload language" and numbers.
  • Maximum length: 150 characters.
  • Spaces between words are required.
  • Must be easy to read and understand.
  • Don’t use only CAPITAL letters or lowercase letters.

RIGHT ✓:

Women's Cotton Running Shoes Adidas 

 

WRONG ✗: 

JEANS SALE AMAZON DR-001 SALE
Required

Description

Please provide a readable text describing your product.

Requirements:

  • Use your "upload language"
  • Maximum length: 10,000 characters.
  • Avoid using invalid symbols such as HTML codes.
  • Don’t include images or any contact information.
  • Avoid using only CAPITAL letters or lowercase letters.

RIGHT ✓:

Thigh High Women’s Cotton Socks Over Knee
Gender: Women
Material: 70% Cotton, 30% Polyester
Color: As Picture
Thickness: Standard
Size: One Size
Length: 50.5-52.5cm
Package includes: 1 pair of socks

 

WRONG ✗: 

AMAZON socks 

(731) 286-5309
595 Curtis Hill Church Ln
Bethel Springs, Tennessee (TN), 38315
Required

Search Tags

These keywords help users find your products easily.

Requirements:

  • Language: English.
  • Separate tags using commas. Don't include commas within a tag.
  • Limit the number of tags to 10 per product. Any additional tags will be automatically ignored by the system.
 Recommended

Labels

For organizing products internally.

Requirements:

  • Each label should be a maximum of 20 characters long.
  • Different labels should be separated by commas.
  • A maximum of 5 labels is allowed per product.
  • Language: English.

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:

  • Provide a direct link to the main image of your product.
  • The minimum resolution should be 550x550 pixels or higher.
  • Side ratio should be between 1:1 and 3:4.
  • High-quality and frontal image.
  • The image can be square or rectangular.

Avoid the following:

  • Adding frames and watermarks to the picture.
  • Using photos provided by customers.
  • Uploading duplicate images.
  • Including words such as "HOT, SALE, NEW," etc. on the picture.

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:

  • Images should be added in a single cell and separated by spaces. Avoid using commas or semicolons.
  • A maximum of 20 images are allowed.
  • All images should refer to the same product.
  • Show the product from different angles and perspectives, avoiding duplicates of the main product or variant images.

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):

  • notDangerous

  • liquid

  • powder

  • aerosoleAndGases

  • battery

  • withBattery

  • magnetizedItems

  • weapon

  • flammable

  • plants

  • teaLeafs

  • hair

  • lookAlikeWeapon

  • adult

  • highDensity

  • semiLiquid

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:

  1. Create a store.
  2. Look for the Store ID on the store page, located to the right of the store's name.
  3. Fill in the Store ID in the file.
  4. If you have multiple stores, specify the ID of the specific store you want to add products for.
  5. Remember to fill in the Store ID in the file.
  6. If you have more than one store, indicate the ID of the specific store you want to add products for.
 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:

  • English letters and numbers only.
  • Maximum length: 128 characters.

RIGHT ✓:

Product SKU: DR-001

Variant SKU:

DR-001_Pink_S 

DR-001_Pink_M 

DR-001_Blue_M 

 

WRONG ✗: 

Product SKU: DR-001
Variant SKU:

DR-001

DR-001

DR-001

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:

  • Direct link to the main image of your product variant.
  • Minimum resolution: 550x550 pixels.
  • Aspect ratio ranging from 1:1 to 3:4.
  • High-quality and frontal view.
  • Square or rectangular image.

Please avoid the following:

  • Adding frames and watermarks to the picture.
  • Using customer-provided photos.
  • Uploading duplicate images.
  • Including words such as "HOT, SALE, NEW," etc., on the picture.

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:

  • Enter numbers only, without indicating the abbreviation "kg".
  • If you encounter any errors while filling in this field, please double-check and adjust the formatting accordingly.

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:

  • Enter numbers only, without indicating the abbreviation "cm".
  • If you encounter any errors while filling in this field, please double-check and adjust the formatting accordingly.

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:

  • Enter numbers only, without indicating the abbreviation "cm".
  • If you encounter any errors while filling in this field, please double-check and adjust the formatting accordingly.

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:

  • Enter numbers only, without indicating the abbreviation "cm".
  • If you encounter any errors while filling in this field, please double-check and adjust the formatting accordingly.

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:

  • Indicating a GTIN is mandatory for all branded products.
  • GTINs cannot be removed; they can only be modified.
  • If you encounter any errors while filling in this field, please double-check and adjust the formatting accordingly.

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:

  • Language: English.
  • You can indicate multiple colors separated by commas.
  • Please check if your color is included in the Joom list of accepted colors.
  • If it is difficult to determine the color, please fill in "as the picture" and provide the image URL (required).
 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:

  • Language: English only.
  • Maximum length: 50 characters.
  • Format: XS, S, M, L, XL, etc.

Please refer to this article to learn more about it. 

 Recommended

Price (without VAT) 

Your product price in EUR.

Requirements:

  • EUR only.
  • Use a dot as a delimiter, not a comma.
  • If you encounter any errors while filling in this field, please double-check and adjust the formatting accordingly.
  • Do not indicate the currency, only the numbers.
  • Please indicate prices without including the VAT amount. Joom will automatically calculate the VAT according to the country for each merchant.

RIGHT ✓:

2.55

 

WRONG ✗: 

2,55 EUR

 

 Required

Currency

Requirements:

  • EUR only.

RIGHT ✓:

EUR

 

WRONG ✗: 

RUB, UAH, USD, GBP
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:

  • Only integer numbers are allowed.
  • Maximum length: 100,000.
  • If you encounter any errors while filling in this field, please double-check and adjust the formatting accordingly.

Please refer to this article to learn more about Default and Overseas warehouses. 

RIGHT ✓:

 1000

 

WRONG ✗: 

999,9 or 999.9
Required

Shipping Price without VAT (default warehouse)

Shipping cost for a specific product variant.

Requirements:

  • EUR only.
  • If you have a single shipping price for all countries, you can fill it in and upload it in one file.
  • If you have different shipping prices for multiple countries, please indicate a default shipping price and refer to the article for instructions on setting up different shipping prices.
  • If you encounter any errors while filling in this field, please double-check and adjust the formatting accordingly.
  • Do not indicate the currency, only the numbers.

RIGHT ✓:

 4

 

WRONG ✗: 

4 EUR
Required

Declared Value 

The declared value of the variant in EUR for customs clearance when shipping online.

Requirements:

  • Please indicate prices without including the VAT amount. Joom will automatically calculate the VAT according to the country for each merchant.

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:

  • EUR only.
  • Use a dot as a decimal delimiter, not a comma.
  • If you encounter any errors while filling this field, please check and adjust the formatting accordingly.
  • Please do not indicate the currency, only provide the numbers.

RIGHT ✓:

20.5

 

WRONG ✗: 

 20,5 EUR
Recommended

 

How To Work With The Template?

  1. Open a CSV/XSLX file. 
  2. 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.
  3. Start filling the information on product variants with the Variant SKU column.

______________2022-02-24___03.29.26.png

4. Use a new row for each product variant.

______________2022-02-24___03.31.01.png

5. To group a few product variants into one product, fill in the same Product SKU.

______________2022-02-24___03.33.18.png

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.

  1. Go to the Products page in your Joom account.
  2. Click on the Manage Products button.
  3. Choose Create/Change via CSV/XLSX.
  4. Click on the Set up a template CSV/XLSX button.
Screenshot_2023-02-28_at_11.26.04.png

    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.

Screenshot_2023-02-28_at_11.28.05.png

    9. Edit the file and upload it to the Merchant Panel. 

PLEASE NOTE:
Templates are regularly updated, so we recommend you download a new one each time you add new products.

How To Check If The File Uploaded Successfully?

1. Open the Uploads page in your Merchant panel.______________2022-02-21___07.53.11.png

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.______________2022-02-21___07.56.38.png

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. ______________2022-02-21___08.04.19.png

 

For more information on how to upload the file to the platform, please refer to this article.

 

Related articles

Comments

0 comments

Please sign in to leave a comment.