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.

The List of Product Attributes:

Name

Description

Status

Product SKU

Unique product identifier that is COMMON for a group of variants of ONE product. It's NOT the same as SKU.

Requirements:

  • English letters and numbers only.
  • Max. length: 128 symbols.
  • It should be the same for all the variants of ONE product.

RIGHT ✓:

Product SKU: DR-001
SKU:

DR-001_Pink_S 

DR-001_Pink_M 

DR-001_Blue_M 

 

WRONG ✗: 

Product SKU: DR-001
SKU:

DR-001

DR-001

DR-001
______________2019-08-05___13.14.22.png

Store ID 

How to find the Store ID:

  1. Create a store.
  2. Find the Store ID – it's indicated on the store page to the right of the store's name.
  3. Fill in the Store ID in the file.
  4. If you have more than 1 store, indicate the ID of the specific store you want to add products for.
  ______________2019-08-05___13.14.22.png

Name

The product’s features and its basic characteristics.

The product naming template:

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

Requirements:

  • English letters and numbers only.
  • Max. length: 150 symbols.
  • Spaces between words: required.
  • The product name should be the same for all the variants of ONE product.
  • Must be easy to read and understand.
  • The same Product SKU = the same Product name.

DON'T indicate:

  • CAPITAL letters only.
  • lowercase letters only.

RIGHT ✓:

Women's Cotton Running Shoes Adidas 

 

WRONG ✗: 

JEANS SALE AMAZON DR-001 SALE
______________2019-08-05___13.14.22.png

Description

Readable text describing your product. 

Requirements:

  • Language: English.
  • Max. length: 10 000 symbols.
  • It should be the same for all the variants of ONE product.
  • The same Product SKU = the same Description.

DON'T indicate:

  • Invalid symbols such as HTML codes.
  • Images.
  • Any contact information.
  • CAPITAL letters only.
  • lowercase letters only.

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
______________2019-08-05___13.14.22.png

Product GTIN

Global Trade Item Number – unique number for your group of products.

GTINs cannot be removed – only modified.

If you have an error while filling it, please check and change the formatting of this field. 

Please refer to this article to learn more.

 ______________2019-08-05___13.14.16.png

Brand

The brand name that was given by the brand owner. 

  • Not mandatory for non-branded products.
  • If you fill in this field, you will be asked to provide proof of your resale or ownership rights.

Refer to the article to learn more.

 ______________2019-08-05___13.14.16.png

Search Tags

Keywords that help users to find your products easily.

Requirements:

  • Language: English.
  • Use commas or space to separate tags.
 ______________2019-08-05___13.14.22.png
Labels

For internal grouping of products.

Requirements:

  • Max. 40 symbols.

Please refer to this article to learn more.

 ______________2019-08-05___13.14.16.png

Price

Your product price in euro.

Requirements:

  • EUR only.
  • Use a dot as a delimiter, not a comma.
  • If you have an error while filling it, please check and change the formatting of this field. 

DON'T indicate the currency, only the numbers.

Please indicate the prices without the VAT amount. Joom automatically calculates the VAT according to the country for each merchant.

 

RIGHT ✓:

2.55

 

WRONG ✗: 

2,55 EUR

 

 ______________2019-08-05___13.14.22.png

MSRP

Manufacturer's suggested retail price.

It will be shown as the crossed-out original price. The number in the PRICE column is the actual sale price.

Example:

28 EUR  25 EUR

Requirements:

  • EUR only.
  • Use a dot as a delimiter, not a comma.
  • If you have an error while filling it, please check and change the formatting of this field. 

DON'T Indicate the currency, fill in the numbers only.

 

RIGHT ✓:

20.5

 

WRONG ✗: 

 20,5 EUR
______________2019-08-05___13.14.16.png

Dangerous Kind

Used to define the product type.

To enter the product attribute "dangerous kind" correctly, please consider using 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.

 ______________2019-08-05___13.14.22.png

Landing Page URL

 URL to the product page on other platforms.

 ______________2019-08-05___13.14.16.png

Product Main Image URL

Upload ONE common product main image for all the product variants.

We advise uploading the square image. If you upload a non-square picture, the squarest one will be selected as the main.

Requirements:

  • Direct link to the main image of your product.
  • Minimum resolution: no less than 550х550 px.
  • Side ratio from 1:1 to 3:4.
  • High quality, frontal.
  • Square or rectangular image.

DON'T:

  • Add frames and watermarks to the picture.
  • Use the photos provided by customers.
  • Upload repeated images.
  • Indicate the words "HOT, SALE, NEW", etc. on the picture.

Please refer to this article to learn more. 

 ______________2019-08-05___13.14.22.png

Extra Image URLs

Requirements:

  • Images must be added in one cell separated by spaces. Don't use commas or semicolons!
  • Max. 20 images.
  • Images must refer to the same product.
  • Product should be shown from new sides and angles, don't duplicate all your main product or variant images here again.

Please refer to this article to learn more. 

 ______________2019-08-05___13.14.16.png
Video ID

This feature is available for Top Stores only. 

Once you upload a video to the platform, copy its Video ID and insert it in your file.

Please refer to this article to learn more on how to upload videos.

 ______________2019-08-05___13.14.16.png

Suggested Category ID

If you don't know which product category your product belongs to, you can leave this field blank. We will determine the product category ourselves. Specifying the product category will help us moderate the product faster. 

You can find the list of all Product Category IDs here.

______________2019-08-05___13.14.16.png

Variant SKU

Unique product variant identifier that cannot be repeated. It's NOT the same as the Product SKU.

Requirements:

  • English letters and numbers only.
  • Max. length: 128 symbols.

RIGHT ✓:

Product SKU: DR-001

SKU:

DR-001_Pink_S 

DR-001_Pink_M 

DR-001_Blue_M 

 

WRONG ✗: 

Product SKU: DR-001
SKU:

DR-001

DR-001

DR-001
______________2019-08-05___13.14.22.png

Color

Fill in this field only if your product variants vary in color.

Requirements:

  • Language: English.
  • You can indicate a few colors separated by commas.
  • Check if your color is in the Joom list of accepted colors.
  • If it's difficult to determine the color, fill in "as the picture" and add an image URL (required).
 ______________2019-08-05___13.14.16.png

Size

Fill in this field only if your product variants vary in size. 

Requirements:

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

Please refer to this article to learn more about the Size Charts.

 ______________2019-08-05___13.14.16.png

Currency

Only euro.

RIGHT ✓:

EUR

 

WRONG ✗: 

RUB, UAH, USD, GBP
______________2019-08-05___13.14.22.png

Inventory

The number of products that are currently in stock.

Requirements:

  • Integer numbers only.
  • Max. length: 100 000.
  • If you have an error while filling it, please check and change the formatting of this field. 

RIGHT ✓:

 1000

 

WRONG ✗: 

999,9 or 999.9
______________2019-08-05___13.14.22.png

Variant Main Image URL

Direct link to the main image for your product variant that shows the different styles, colors, angles, etc.

We advise uploading the square image. If you upload a non-square picture, the most square one will be selected as the main.

Requirements:

  • Direct link to the main image of your product variant.
  • Minimum resolution: no less than 550х550 px.
  • Side ratio from 1:1 to 3:4.
  • High quality, frontal.
  • Square or rectangular image.

DON'T:

  • Add frames and watermarks to the picture.
  • Use the photos provided by customers.
  • Upload repeated images.
  • Indicate the words "HOT, SALE, NEW", etc. on the picture.

Please refer to this article to learn more. 

 ______________2019-08-05___13.14.16.png

Shipping price

Shipping cost for a certain product variant.

Requirements:

  • EUR only.
  • If you have 1 shipping price for all countries, you can fill it in and upload it in 1 file.
  • If you have different shipping prices for several countries, please indicate a default shipping price and refer to the article to set up different shipping prices.
  • If you have an error while filling it, please check and change the formatting of this field. 

DON'T indicate the currency, only the numbers.

RIGHT ✓:

 4

 

WRONG ✗: 

4 EUR
______________2019-08-05___13.14.16.png

Shipping weight

Product weight in kilograms (kg) after packaging.

Requirements:

  • Numbers only – don't indicate the abbreviation "kg".
  • If you have an error while filling it, please check and change the formatting of this field. 
 ______________2019-08-05___13.14.16.png

Shipping length

Product length in centimeters (cm) after packaging.

Requirements:

  • Numbers only – don't indicate the abbreviation "cm".
  • If you have an error while filling it, please check and change the formatting of this field. 
 ______________2019-08-05___13.14.16.png

Shipping width

Product width in centimeters (cm) after packaging.

Requirements:

  • Numbers only – don't indicate the abbreviation "cm".
  • If you have an error while filling it, please check and change the formatting of this field. 
 ______________2019-08-05___13.14.16.png

Shipping height

Product height in centimeters (cm) after packaging.

Requirements:

  • Numbers only – don't indicate the abbreviation "cm".
  • If you have an error while filling it, please check and change the formatting of this field. 
 ______________2019-08-05___13.14.16.png

 

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.