English (US) 한국어
search shadow

Menu

Articles in this section

How to fill in the CSV/XLSX templates?

Avatar
Valerie Mitroshenko
  • Updated

This article will help you correctly fill in CSV and XLSX templates to add your products to the store.

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:

Product SKU

Unique product identifier. Alternative name: Parent SKU. It can be left blank when a product is uploaded for the first time. 

  • Latin symbols and numbers only;
  • Should be unique within an entire account.
 3.png

Name

Each word in the product name should start with capital letters
E.g., Festive Christmas Reindeer Socks

  • Should be in English;
  • UTF-8 standard;
  • Min: 5 symbols;
  • Max: 100 symbols.

The product naming template:

[Brand] + Product Type + Characteristics (color/ size/ effect/ features/ volume) + Version Example: [Cos De Baha] Anti-Wrinkle peptide Facial Serum with Matrixyl 3000 and Argireline 30ml / 60ml		 3.png
Description

Contains basic product information, such as package set, main product characteristics, color, material, size, etc. 

Should be:

  • provided in English;
  • without images;
  • easy to read, contain all the spaces and punctuation required;
  • UTF-8 standard.

Shouldn't:

  • contain invalid symbols (HTML code);
  • only uppercase or lower case letters;
  • any contact information.

You can specify the required attributes in the description as well. Learn more here.

If you are uploading cosmetics, please read How to upload cosmetics

If you are uploading K-pop albums, please read How to upload K-pop albums

 3.png
Search Tags

Keywords assigned to your product which help the customers find your product on search results.

  • No more than 10 tags per product. Extra tags will be ignored by the system automatically.
  • Use commas to separate different tags. There should be no comma inside a tag. 
  • Latin symbols only.
 1.png
Labels

For internal grouping of products. You can leave this field blank.

 1.png
Brand Fill in the name of verified brand. See more about How to authorize your brand on Joom 3.png
Product GTIN Used for off-site advertising. It is a unique number used to identify products and product sets. Should be unique for each product variation.  1.png
Landing Page URL

Direct link to the Landing Page of your product.

If the product does not have a Landing Page, leave it blank or delete it.

 1.png
Product Main Image URL

Direct link to the main image (picture) of your product.

  • Minimum size: 550х550px
  • Images must be square.
  • Rectangular images are acceptable, but their proportion must be between 1:1 and 3:4;
  • Good quality; frontal
  • If the product comes in different variants, the main image should showcase all the variants

Don't:

  • Photoshop an image;
  • Add frames and watermarks;
  • Use the photos provided by customers;
  • Upload repeated images;
  • Use "HOT, SALE, NEW" etc.
 3.png
Extra Image URLs (max 20)

Direct link to the extra image of your product. 

We recommend adding:

  • А photo of the product from different angles;
  • А photo describing the effects and features (in English);

When listing multiple URLs:

  • Use a space to separate links;
  • Don't insert very long URLs, as there are character limits.
 3.png
Suggested Category ID

The ID of your product's category.

If you don't know the Category ID of your product, leave it blank or delete it. It will be set automatically after the product is uploaded to the platform.

 1.png
Dangerous Kind

Used to define the product type. Products could be divided into Dangerous Kind and Non-Dangerous Kind.

Learn more in this article.

 3.png
Video ID 

This feature is available for the Top Stores only.

If the product doesn't belong to the Top Store, leave this row blank or delete it.

Learn more about the Video Feature in this article.

 1.png

Variant SKU

Unique product variation identifier. Alternative name: SKU.

  • Latin symbols and numbers only;
  • Should be unique within an entire account.

To add a new variant:

  • Create a new row below the main one;
  • Copy the product information, and paste it into a new row;
  • Don't forget to change the Variant SKU, picture in Variant Main Image, and Color/Size to the different one for each variant.

If a product has only one variant, you can use the same Product SKU. 

3.png
Variant Main Image URL  

Direct link to the main image of your product variation. Relevant image should be provided for each product variation.

Check the Main Image URL attribute to see the image requirements.

 1.png
Shipping weight

Weight of the product after packaging in kilograms (kg).

You should always try to indicate the Shipping weight as precisely as possible in case the refund situation with the customer occurs.

Example:

100 grams must be written as 0.1.
50 grams must be written as 0.05.

 3.png
Shipping Width

Width of the product after packaging in millimeters (mm).

Example:

20 cm must be written as 200.
1 cm must be written as 10.

 1.png
Shipping Length

Length of the product after packaging in millimeters (mm).

20 cm must be written as 200.
1 cm must be written as 10.

 1.png
Shipping Height

Height of the product after packaging in millimeters (mm).

20 cm must be written as 200.
1 cm must be written as 10.

 1.png
Manufacture GTIN Used for off-site advertising. It is a unique number used to identify products and product sets. Should be unique for each product variation.  1.png
HS Code It is a list of numbers used by customs to classify a product. Just leave this row blank if you don't know it. 1.png
Color

The main color of your product variation.

Use ONLY titles for colors from the accepted colors list. Otherwise, your product would be rejected!

To define your color, use Size column instead.

If it's difficult to determine, fill in "as the picture" and add an image URL (required).

If you are uploading cosmetics and have problems with color tones, please read How to upload cosmetics

 1.png
Size
  • Should be in cm or mm
  • Max: 25 symbols
  • Language: English

Please provide size information for each product variant.

 1.png
Price

The price of the product without the cost of international shipping.
Тo state the international shipping cost, use the Default Warehouse Shipping Price field.

  • Should be provided in USD.
 3.png
Currency Fill in USD to confirm that your product price is provided in the correct currency.   3.png

Default Warehouse Inventory

The current inventory of your products in stock.

  • Max: 100,000.
 3.png

Shipping price

 Offline shipping cost. Learn more about Offline Shipping in this article.

  • Should be provided in USD.
 3.png
Declared Value

The declared value indicates the maximum liability for a lost or damaged package.

Shouldn't:

  • Include the cost of international shipping;
  • Be higher than the product's value.
 1.png

MSRP

Manufacturer's suggested retail price. It can be used to set your discounts for the products you sell on the Joom platform in order to show the customer that you are selling the product cheaper than manufacturer suggested.

Learn more about MSRP in the article How to set discounts in Merchant Panel

 1.png

Store ID 

 Required only if you have more stores than 1 to specify which store exactly the products belongs to.

 3.png

 

How to work with the template?

As an example you can download the filled-in template based on the cosmetic product .

  1. Open a CSV/XSLX file. 
  2. Start filling in product information from the second row. If you don't know how to fill in some fields.
  3. Start filling the information of product variants from 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. If there is only one store in your account, you don't have to fill it in; if there is more than one store in your account, you must fill it in;
8. Save the document as a CSV or XSLX file.

⚠️ PLEASE NOTE:

  • You can upload CSV and XLSX files only with the required attributes. You should add all the unique attributes specific to your products to the product description;
  • 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, irreversible;

  • Non-mandatory attributes can be left blank.

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;
  • Toggle the New design switch to enable the Template feature;
  • Click on the Set up a template CSV/XLSX button;
new_design_create_change.png
  • When choosing a Template type, select Per Category;
  • Choose the Product Categories (up to 5);
  • Select the file Format you prefer (CSV or XLSX);
  • Click on the Download button;
______________2022-01-21___02.35.39.png
  • 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?

  • Open the Uploads page in your Merchant panel;______________2022-02-21___07.53.11.png
  • Find the uploaded file in the list and check its status;
  • You will see Completed if it was uploaded successfully and Completed with errors if it wasn't;______________2022-02-21___07.56.38.png
  • If the status is Completed with errors, click on the file name to learn more about the error;
  • Record + number indicates the row where the error occurred;
  • After " : " you can see the detailed information about the error. ______________2022-02-21___08.04.19.png

 

Related articles

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk