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.
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).
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.
The list of product attributes:
|
Please note:
|
Product Basic 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:
RIGHT ✓
WRONG ✗
|
 |
||||||||
|
Store ID |
How to find the Store ID
|
|
||||||||
|
Product name |
The product’s features and its basic characteristics. The product naming template: Product type (what) + Brand (who) + Characteristics (color, size) + Version Requirements:
DON'T indicate:
RIGHT ✓
WRONG ✗
|
|
||||||||
|
Description |
Readable text describing your product. Requirements:
DON'T indicate:
RIGHT ✓
WRONG ✗:
|
|
||||||||
|
GTIN |
A Global Trade Item Number (GTIN) is a barcode assigned to each product variant. GTINs cannot be removed – only modified. If you have an error while filling it, please check and change the formatting of this field. |
|
||||||||
|
Search Tags |
Keywords that help users to find your products easily. Requirements:
|
|
||||||||
|
Price |
Your product price in dollars. Requirements:
Do not 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 ✓
WRONG ✗
|
|
||||||||
|
Dangerous Kind |
Used to define the product type. Acceptable values for Dangerous Kind’s field can be found here. To enter the product attribute Dangerous kind correctly, please consider using the following variants (for CSV and ERP):
|
|
||||||||
|
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:
Do not:
|
|
||||||||
|
Brand |
The brand name that was given by the brand owner.
|
 |
||||||||
| Labels |
For internal grouping of products. Requirements:
|
|
||||||||
|
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: Requirements:
Do not indicate the currency, fill in the numbers only.
RIGHT ✓
WRONG ✗
|
|
||||||||
|
Landing Page URL |
URL to the product page on other platforms. |
|
||||||||
|
Extra Image URLs |
Requirements:
|
|
||||||||
| Video ID |
This feature is available for Top Stores only. Please refer to this article to learn more on how to upload videos. Once you upload a video to the platform, copy its Video ID and insert it in your file. |
|
||||||||
|
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. |
|
How to work with the template?
As an example, you can download the filled-in template based on the cosmetic product .
- Open a CSV/XSLX file.
- Start filling in product information from the second row. If you don't know how to fill in some fields.
- Start filling the information with product variants from 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. 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.
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.
- When selecting a Template type, select Per Category.
- Select the Product Categories (up to 5).
- Select the file Format you prefer (CSV or XLSX).
- Click on the Download button.
- Edit the file and upload it to the Merchant Panel.
How to check if the file uploaded successfully?
- Open the Uploads page in your Merchant panel.
- 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.
- 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.
Disable checkingPremium suggestions
Comments
0 comments
Please sign in to leave a comment.