| CBT

 

Flat File User Guide

Uploading New SKUs

Steps to upload your SKUs

  • Log into your MercadoLibre CBT account,
  • Go to Flat File > Upload Files,
  • Select "Add SKU",
  • Select the file from your computer,
  • Click "Upload".

The system accepts CSV files (comma-separated) with a maximum file size of 7MB. Encoding should be UTF-8.

You can find a sample upload file here. The table below provides a description of all required and optional fields with examples. It's required that the first column must be "sku".

Once you have uploaded your files, they may take several hours to process before your listings show up in MercadoLibre. Once we have processed a file, we will indicate the status on the Flat File interface

  • Pending: your file is in the processing queue; processing has not started yet,
  • Processing: we have begun processing the file,
  • Success: we have processed the file and successfully added SKUs to MercadoLibre CBT,
  • Error: we have processed your file but found errors.

Once we have processed your file, you will be able to download a response file from the Flat File interface. If we were able to process your file successfully, the success response file will contain your SKU and its reference MPID (MercadoLibre Product ID).

The MPID is our unique reference to your SKUs. It provides a key to your products as you interact with the MercadoLibre platform.

If we processed your file but found errors, an error file is generated that contains the SKU and the error message.

It is normal for a file to have both a success response file and an error response file. For example, if you uploaded 500 SKUs, you could receive a successful file indicating that 450 SKUs were successfully uploaded and a response file indicating that 50 SKUs contained errors.

If your product title, product description or any other text fields have commas (ex. your description is "This is a great product, you will love it"), please make sure the text is between double quotes (") in your csv file. If you fail to do so, the system will assume that the comma is a separator and will read "This is a great product" as one field and "you will love it" as another field, generating errors.

Fields, Descriptions, and Examples:

The table below lists the field names, a description of the fields, and an example of how to add a product using these fields:

Field Name: Description Example
sku
  • Product SKU
  • This is seller's unique identifier and will be the primary key for orders.
  • Required
  • Maximum Length: 50 Characters
12345
primary_variation_sku
  • Product SKU of primary variation product (aka parent SKU)
  • If you are submitting items in multiple variations (ex. shirt with colors and sizes), this field should include the SKU of the parent product
  • You can find a sample upload file here
  • Optional
  • Maximum length: 50 characters
1234
is_primary_variation
  • Field to specify a parent SKU
  • Optional, default value is 0
  • Set it to 1 for adding a parent SKU (aka primary variation SKU)
0 or 1
product_type
  • Product type information as String.
  • Optional
  • Maximum length 25 characters.
Women Suglasses, Rechargable Flashlight, etc
product_title_english
  • Product title in English
  • Required
  • Maximum length: 150 characters
Sport Wrist Watch LED illuminated
product_title_portuguese
  • Product title in Portuguese
  • Optional
  • If not included, listing will be sent to translation queue
  • Maximum length: 60 characters
Relogio de Pulso Exporte iluminado LED
product_title_spanish
  • Product title in Spanish
  • Optional
  • If not included, listing will be sent to translation queue
  • Maximum length: 60 characters
Reloj del deporte LED iluminado
description_english
  • Product description in English
  • Either description english and/or specification_english should be provided
  • Maximum length: 4000 characters
This is the product offered
description_portuguese
  • Product description in Portuguese
  • Optional
  • If not included, listing will be sent to translation queue
  • Maximum length: 4000 characters
Este é o produto oferecido
description_spanish
  • Product description in Spanish
  • Optional
  • If not included, listing will go to translation queue
  • Maximum length: 4000 characters
Este es el producto que se ofrece
specification_english
  • Product specifications
  • Specifications are name:value pairs
  • Each name:value pair is separated by tilde (~) and each name should seperated by colon (:)
  • Optional
  • Required only if description is not provided
  • Maximum length: 2000 characters
brand: Test~product Type: watch~condition: new
specification_portuguese
  • Product specifications in Portuguese
  • Specifications are name:value pairs
  • Each name value pair is seperated by tilde (~) and each name should seperated by colon (:)
  • Optional
  • If not included, listing will be sent to translation queue
  • Maximum length: 2000 characters
ORIGINAL BRAND NAME:Test Brand~PRODUCT TYPE: Watch~CONDITION: new
specification_spanish
  • Product specifications in Spanish
  • Specifications are name:value pairs
  • Each name value pair is seperated by tilde (~) and each name should seperated by colon (:)
  • Optional
  • If not included, listing will be sent to translation queue
  • Maximum length: 2000 characters
ORIGINAL BRAND NAME: Test Brand~PRODUCT TYPE: Watch~CONDITION: new
category_id
  • MercadoLibre Category ID for Cross-Border Trade Platform
  • Numeric
  • Refer to category structure
  • Note: You have to list your items using the lowest-level category(leaf level) in the category structure
1799
brand
  • Product Brand
  • Optional but highly recommended to improve translation quality
  • Maximum length: 50 characters
Citizen
model
  • Product Model
  • Optional but highly recommended to improve translation quality
  • Maximum length: 50 characters
A12345
image_url
  • Product image URLs separated with ~^~,
  • Required
  • Maximum 6 images per product
  • Maximum total pictures size 10MB
  • Picture format can be .jpg, .jpeg, .png or .gif(without animation)
http://img2.mlstatic.com/s_MLB_v_I_f_233107321_9038.jpg~^~http://img2.mlstatic.com/s_MLB_v_I_f_233107321_9038.jpg
video_url
  • Optional
  • Product Video URL
  • Only YouTube Videos supported at this time
  • Maximum length 1024 characters
 
country_of_origin US
shipping_from US
upc
  • Universal Product Code (UPC Code) or EAN code
  • Optional but highly recommended in order to improve marketing efficacy in local markets
  • Maximum length: 25 characters
123456789
currency
  • Product Price currency
  • Optional
  • USD, GBP. Default value based on merchant preference
sale_price
  • Price in dollars
  • Should not include currency symbol
  • Required
  • Note: Your products will fail if you pass US$ 50. You should include just 50
54.05
quantity
  • Quantity in hand
  • Required
  • Maximum quantity allowed: 999
10
merchant_shipping_cost
  • Shipping cost in dollars. This should be the domestic shipping cost (if any) to our warehouse
  • Should not include currency symbol
  • Required
  • If included in product price (free shipping), use 0
5.45
international_shipping_cost
  • Flat international shipping cost for DDU to all countries in dollars
  • Optional
  • Decimal number without currency symbol
5.45
international_shipping_cost_by_country
  • international shipping cost by country for DDU separated by tilda("~")
  • If international shipping cost for a country is provided, flat international shipping cost will be ignored.
  • Optional
  • Decimal number without currency symbol
BR:10~MX:4
estimated_delivery_time
  • Estimated delivery time of product (in days). This is the estimated time from order for the item to be delivered to our warehouse
  • Required
  • Integer
3
weight_unit
  • Weight unit: lb or kg
  • Required
lb
package_weight
  • Package Weight
  • Numeric value only
  • Required
2.5
dimension_unit
  • Dimension unit: in or cm
  • Optional
  • Required if width, height or length are provided
in
package_width
  • Numeric value only
  • Optional
in
package_height
  • Numeric value only
  • Optional
10
package_length
  • Numeric value only
  • Optional
8
condition
  • New, Used or Refurbished
  • Required
  • Note: at this time the Cross-Border Trade Platform can only support New items
New
warranty_english
  • Text describing product warranty in English
  • Maximum length: 1024 characters
  • Optional
1 Year Warranty
warranty_portuguese
  • Text describing product warranty in Portuguese
  • Maximum length: 1024 characters
  • Optional
Garantia de 1 ano
warranty_spanish
  • Text describing product warranty in Spanish
  • Maximum length: 1024 characters
  • Optional
1 ano de garantia
attribute_id_1
  • Attribute Id 1
  • If variation is required for the category, then "id" is mandatory
  • Numeric
  • Please include the numeric ID of the attribute found in the category page
  • Note: this field should be populated with the Attribute ID and not the value. For example, for color, enter 10001
10001
attribute_value_id_1
  • Attribute Value Id 1
  • If variation is required for the category, then "value_id" is mandatory
  • Numeric
  • Please include the numeric ID of the attribute found in the category page
  • Note: this field should be populated with the Attribute value ID and not the value. For example, for the color green, enter 10025
10001
attribute_id_2
attribute_id_3
attribute_id_4
attribute_id_5
attribute_id_6
attribute_id_7
attribute_id_7
attribute_id_8
attribute_id_9
attribute_id_10
  • Same as attribute id 1
  • i.e: Size
10000
attribute_value_id_2
attribute_value_id_3
attribute_value_id_4
attribute_value_id_5
attribute_value_id_6
attribute_value_id_7
attribute_value_id_8
attribute_value_id_9
attribute_value_id_10
  • Same as value id 1
  • i.e: Medium (M)
10066
product_attribute_id_1
  • Product Attribute Id 1
  • Attribute name
  • Examples: BRAND, MODEL, ISBN, EAN, etc.
BRAND
product_attribute_value_id_1
  • Product Attribute Value Id 1
  • Attribute value
  • Examples: A12345 , Citizen, etc.
Citizen
product_attribute_id_2
  • Product attribute Id 2
  • Same as value id 1
  • Example: MODEL
MODEL
product_attribute_value_id_2
  • Product attribute value 2
  • Same as value id 1
  • Example: A12345
A12345
product_attribute_id_3
  • Product attribute Id 3
  • Same as value id 1
  • Example: WATER_RESISTANCE
WATER_RESISTANCE
product_attribute_value_id_3
  • Product attribute value 3
  • Same as value id 1
  • Example: 10m
10m
product_attribute_id_4
  • Product attribute Id 4
  • Same as value id 1
  • Example: CHRONOGRAPH
CHRONOGRAPH
product_attribute_value_id_4
  • Product attribute value 4
  • Same as value id 1
  • Example: Yes
Yes
product_attribute_id_N
  • Maximum: 50 attributes
product_attribute_value_id_N
  • Maximum: 50 attributes

Tips

  • New accounts are initially limited to one hundred SKUs. If you are reaching that limit, please contact us so we can check your data and increase your limit,
  • If you are submitting a large file that requires translation, it may take several hours for us to process the file,
  • You should use the MercadoLibre CBT (MercadoLibre CBT) category structure. You must list your items using the lowest-level category (leaf level) in the category structure. A leaf-level category is one that has no children or subcategories,
  • We use automatic translation technology for translating content. Sellers who are able to provide their own content in the local language (Spanish or Portuguese) see much better results in search and conversion.
  • If your product title, product description or any other text fields have commas (ex. your description is "This is a great product, you will love it"), please make sure the text is between double quotes (") in your csv file. If you fail to do so, the system will assume that the comma is a separator and will read "This is a great product" as one field and "you will love it" as another field, generating errors.