id

float

[en] Unique claim identifier.

date_created

timestamp

[en] Claim creation date.

fulfilled

boolean

last_updated

timestamp

[en] Last update date of the claim.

parent_id

text

[en] ID of another claim this one depends on.

reason_id

text

resolution_applied_coverage

boolean

resolution_benefited

text

resolution_closed_by

text

resolution_date_created

timestamp

resolution_reason

text

resource

text

[en] Identifier of the resource the claim is filed against.

resource_id

text

[en] Resource ID the claim is filed against, depending on the resource type.

    Orders > > id

site_id

text

[en] Site ID where the claim is processed.

stage

text

[en] Current stage of the claim.

status

text

[en] Current status of the claim.

type

text

[en] Claim type (e.g., mediations).

reclamacao_id

float

[en] Unique claim identifier.

players_role

text

[en] User role in the claim (complainant or defendant).

players_type

text

[en] Role played by the person in the claimed transaction (buyer or seller).

players_user_id

float

[en] User ID of the player in this role.

reclamacao_id

float

[en] Unique claim identifier.

players_user_id

float

[en] User ID of the player in this role.

    Claims > players > players_user_id

player_action

text

[en] Possible action to be performed by the participant.

player_action_mandatory

boolean

[en] Indicates whether the action is mandatory.

player_action_due_date

timestamp

[en] Deadline for executing the action.

id

text

[pt] Id do item

accepts_mercadopago

boolean

automatic_relist

boolean

available_quantity

float

buying_mode

text

catalog_listing

boolean

catalog_product_id

text

category_id

text

category_name

text

channels

text

total_visits_last_90_days

int

[pt] informa o numero de visitas no intervalo dos último 90 dias

date_to

timestamp

[pt] Data final, que define o intervalo de consulta para os últimos 90 dias.

date_from

timestamp

[pt] Data inicial, que define o intervalo de consulta para os últimos 90 dias.

condition

text

currency_id

text

date_created

timestamp

differential_pricing

text

domain_id

text

end_time

timestamp

expiration_time

timestamp

geolocation_latitude

float

geolocation_longitude

float

health

float

initial_quantity

float

international_delivery_mode

text

inventory_id

text

last_updated

timestamp

listing_source

text

listing_type_id

text

official_store_id

text

parent_item_id

text

permalink

text

secure_thumbnail

text

seller_address_address_line

text

seller_address_city_name

text

seller_address_city_id

text

seller_address_comment

text

seller_address_country_name

text

seller_address_country_id

text

seller_address_id

float

seller_address_latitude

float

seller_address_longitude

float

seller_address_search_location_city_id

text

seller_address_search_location_city_name

text

seller_address_search_location_neighborhood_id

text

seller_address_search_location

text

seller_address_search_location_state_id

text

seller_address_search_location_state_name

text

seller_address_state_id

text

seller_address_state_name

text

seller_address_zip_code

float

seller_contact

text

seller_custom_field

text

seller_id

float

shipping_dimensions

text

shipping_free_methods

text

shipping_free_shipping

boolean

shipping_local_pick_up

boolean

shipping_logistic_type

text

shipping_mode

text

shipping_store_pick_up

boolean

shipping_tags

text

site_id

text

sold_quantity

float

start_time

timestamp

status

text

stop_time

timestamp

subtitle

text

tags

text

thumbnail

text

thumbnail_id

text

title

text

video_id

text

warranty

text

id

text

[pt] Id do item

attributes_attribute_group_id

text

attributes_attribute_group_name

text

attributes_id

text

attributes_name

text

attributes_value_id

float

attributes_value_name

text

attributes_value_struct_number

float

attributes_value_struct

text

attributes_value_type

text

id

text

[pt] Id do item

sale_terms_id

text

sale_terms_name

text

sale_terms_value_id

float

sale_terms_value_name

text

sale_terms_value_struct_number

float

sale_terms_value_struct_unit

text

sale_terms_value_type

text

item_id

text

[pt] ID do item

    Items > > id

metric_date

date

[pt] Data da métrica

item_title

text

[en] Product title.

item_category_id

text

item_category_name

text

item_tags

text

[pt] lista das tags selecionadas pelo vendedor, como entregue, pago. [KONDADO: Este campo é retornado concatenado]

total_visits

int

[pt] Total de visitas recebidas pelo item no dia.

total_phone_views

int

[pt] Total de visualizações de número de telefone recebidas pelo item no dia

total_whatsapp_clicks

int

[pt] Total de clicks no botão Whatsapp recebidas pelo item no dia.

item_id

text

[pt] Id do produto

    Items > > id

amount

float

conditions_context_restrictions

text

conditions_end_time

timestamp

conditions_start_time

timestamp

currency_id

text

item_price_id

float

last_updated

timestamp

regular_amount

text

type

text

item_id

text

[pt] Id do produto

    Items > > id

amount

float

promotion_id

text

promotion_type

text

currency_id

text

price_id

float

reference_date

timestamp

regular_amount

text

user_product_id

text

[pt] Identificador único do produto associado ao usuário.

type

text

[pt] meli_facility: O estoque está localizado nos depósitos de Fulfillment do Mercado Livre. Gerenciado pelo Mercado Livre (Full). selling_address: Endereço de origem do vendedor para itens com estoque Flex em publicações que também estão no Fulfillment do Mercado Livre. seller_warehouse: Múltiplos depósitos gerenciados pelo vendedor. Permite ao vendedor gerenciar o estoque em diferentes localidades.

item_id

text

[pt] Identificador único do item.

    Items > > id

user_id

text

[pt] Identificador único do usuário.

user_nickname

text

[pt] Apelido do usuário.

quantity

int

[pt] Quantidade disponível em estoque.

availability_type

text

[pt] Indica a disponibilidade do item

network_node_id

text

[pt] Identificador do nó da rede.

store_id

text

[pt] Identificador da loja.

store_description

text

store_location_address_line

text

store_location_country

text

store_location_latitude

text

store_location_longitude

text

store_location_state

text

store_status

text

store_tags

text

item_id

text

[pt] Id do item

    Items > > id

item_variation_id

float

[pt] Id da variação de produto

catalog_product_id

text

available_quantity

float

inventory_id

text

seller_custom_field

text

sold_quantity

float

item_id

text

[pt] Id do item

item_variation_id

float

[pt] Id da variação de produto

attribute_combinations_id

text

attribute_combinations_name

text

attribute_combinations_value_id

float

attribute_combinations_value_name

text

attribute_combinations_value_struct_number

float

attribute_combinations_value_struct_unit

text

attribute_combinations_value_type

text

id

text

[en] Unique identifier for the order.

date_closed

timestamp

[en] Order confirmation timestamp; set when the order first reaches confirmed/paid status and inventory is decremented.

last_updated

timestamp

[en] Timestamp of the most recent order update.

coupon__amount

float

[en] Amount discounted on the order via coupon.

coupon__id

text

[en] Identifier of the applied coupon.

currency_id

text

[en] Currency identifier for the order.

cancel_detail__code

text

[en] Cancellation reason code.

cancel_detail__application_id

text

[en] Identifier of the application that requested the cancellation.

cancel_detail__description

text

[en] Description of the cancellation reason.

cancel_detail__requested_by

text

[en] Who requested the cancellation (buyer, seller, or Mercado Livre).

cancel_detail__date

timestamp

[en] Timestamp when the cancellation was registered.

cancel_detail__group

text

[en] Logical group for the cause (mediations, fiscal, buyer, fraud, item, shipment, delivery, seller, internal).

manufacturing_ending_date

text

[en] Scheduled end date for manufacturing the item.

seller__nickname

text

[en] Seller nickname on Mercado Livre.

seller__id

text

[en] Seller identifier on Mercado Livre.

order_request__return

text

[en] Flag showing whether a return request is linked to the order.

order_request__change

text

[en] Flag showing whether an exchange request is linked to the order.

status

text

[en] Current order status (confirmed, payment_required, payment_in_process, partially_paid, paid, partially_refunded, pending_cancel, cancelled, or invalid).

date_last_updated

timestamp

[en] Timestamp of the latest change to the order.

tags

text

[en] List of seller-selected tags (e.g., delivered, paid). [Kondado: value returned as a concatenated string]

pack_id

text

[en] Identifier for the associated logistics pack.

pickup_id

text

[en] Identifier for the related pickup request.

status_detail__code

text

[en] Detailed status code for the order.

status_detail__description

text

[en] Detailed status description for the order.

buyer__nickname

text

[en] Buyer nickname on Mercado Livre.

buyer__id

text

[en] Buyer identifier on Mercado Livre.

total_amount

float

[en] Total amount of the order.

expiration_date

timestamp

[en] Deadline for rating the transaction; after this date feedback is published, payments settle, and charges are generated.

taxes__currency_id

text

[en] Currency used for tax amounts; convert when different from items.currency_id.

taxes__amount

float

[en] Total tax amount charged for the order.

fulfilled

boolean

[en] Indicates whether the order was fully fulfilled.

paid_amount

float

[en] Amount actually paid by the buyer.

date_created

text

[en] Date when the order was created.

order_id

text

[en] Unique identifier of the order.

    Orders > > id

buyer_first_name

text

[en] Buyer first name.

buyer_last_name

text

[en] Buyer last name.

buyer_email

text

[en] Buyer email address on Mercado Livre.

buyer__nickname

text

[en] Buyer nickname.

buyer__id

text

[en] Buyer identifier on Mercado Livre.

order_id

text

[en] Unique order identifier.

    Orders > > id

date_last_updated

timestamp

context_application

text

context_channel

text

context_flows

text

context_product_id

text

context_site

text

order_id

text

[en] Unique order identifier.

    Orders > > id

feedback_id

text

purchase_app_id

float

purchase_date_created

timestamp

purchase_extended_feedback

text

purchase_from_id

float

purchase_from_nickname

text

purchase_from_points

float

purchase_from_status

text

purchase_fulfilled

boolean

[en] Indicates whether the transaction was completed (True/False).

purchase_has_seller_refunded_money

text

purchase_item_currency_id

text

purchase_item_price

float

purchase_item_title

text

purchase_item_id

float

purchase_message

text

[en] Feedback message with up to 160 characters.

purchase_modified

boolean

purchase_rating

text

[en] Transaction rating: negative, neutral, or positive (only when fulfilled is true).

purchase_reason

text

[en] Feedback reason (see accepted values in documentation).

purchase_reply

text

purchase_role

text

purchase_site_id

text

purchase_status

text

purchase_to_id

float

purchase_to_nickname

text

purchase_to_points

float

purchase_to_status

text

purchase_visibility_date

text

sale

text

order_id

text

[pt] Identificador único da ordem

    Orders > > id

base_currency_id

text

base_exchange_rate

text

bundle

text

currency_id

text

element_id

text

full_unit_price

float

item_category_id

text

item_condition

text

item_global_price

float

item_id

text

[en] Sold item identifier.

    Items > > id

item_net_weight

float

item_seller_custom_field

text

item_seller_sku

text

item_title

text

[en] Sold product title.

item_variation_id

float

item_warranty

text

listing_type_id

text

manufacturing_days

float

picked_quantity

float

quantity

float

requested_quantity_measure

text

requested_quantity_value

float

sale_fee

float

unit_price

float

date_closed

timestamp

[en] Order confirmation timestamp; set when the order first reaches confirmed/paid status.

last_updated

timestamp

[en] Timestamp of the most recent order update.

date_created

text

[en] Date when the order was created.

date_last_updated

timestamp

[en] Timestamp of the latest change to the order.

expiration_date

timestamp

[en] Deadline for rating the transaction.

order_status

text

[en] Current order status (confirmed, payment_required, paid, cancelled, etc.).

item_category_name

text

[en] Category name of the sold item.

order_id

text

item_id

text

    Orders: items > > item_id

item_variation_attributes_id

text

item_variation_attributes_name

text

item_variation_attributes_value_id

text

item_variation_attributes_value_name

text

order_id

text

[en] Unique order identifier.

    Orders > > id

id

float

[en] Unique payment identifier in Mercado Pago.

activation_uri

text

atm_transfer_reference_company_id

text

atm_transfer_reference_transaction_id

float

authorization_code

text

[en] Transaction authorization code.

available_actions

text

card_id

float

collector_id

float

[en] Collector account identifier.

coupon_amount

float

[en] Coupon amount applied to the payment.

coupon_id

text

currency_id

text

[en] Currency identifier used in the payment (ARS, BRL, CLP, MXN, COP, PEN, UYU).

date_approved

timestamp

[en] Payment approval date. The creation date may not match if the payment passed through an intermediate state.

date_created

timestamp

[en] Payment creation date.

date_last_modified

timestamp

deferred_period

text

[en] Payment deferral period.

installment_amount

float

[en] Selected financing installment amount.

installments

float

[en] Number of installments selected.

issuer_id

float

[en] Payment method issuer identifier.

operation_type

text

[en] Payment operation type (regular_payment, money_transfer, recurring_payment, account_fund, payment_addition, cellphone_recharge, pos_payment).

overpaid_amount

float

[en] Overpaid amount by the payer.

payer_id

float

payment_method_id

text

[en] Identifier of the selected payment method.

payment_type

text

[en] Payment method type (account_money, ticket, bank_transfer, atm, credit_card, debit_card, prepaid_card).

reason

text

shipping_cost

float

[en] Shipping cost paid by the buyer. If no shipping was charged due to a promotion, the returned value is zero. This information is also available in the orders: shipments integration (shipping_option_list_cost).

site_id

text

status

text

[en] Payment status (pending, approved, authorized, in_process, in_mediation, rejected, cancelled, refunded, charged_back).

status_code

text

status_detail

text

[en] Detailed payment status with specific transaction result code.

taxes_amount

float

[en] Tax amount calculated for the payment.

total_paid_amount

float

[en] Total amount charged to the payer.

transaction_amount

float

[en] Transaction amount.

transaction_amount_refunded

float

[en] Refunded transaction amount.

transaction_order_id

text

order_id

text

[en] Unique identifier of the order.

    Orders > > id

seller__nickname

text

[en] Seller nickname.

seller__id

text

[en] Seller identifier on Mercado Livre.

seller_first_name

text

[en] Seller first name.

seller_last_name

text

[en] Seller last name.

seller__alternative_phone__area_code

text

[en] Area code of the seller's alternate phone.

seller__alternative_phone__extension

text

[en] Extension of the seller's alternate phone.

seller__alternative_phone__number

text

[en] Number of the seller's alternate phone.

seller__email

text

[en] Seller email address.

seller__phone__area_code

text

[en] Area code of the seller's main phone.

seller__phone__extension

text

[en] Extension of the seller's main phone.

seller__phone__number

text

[en] Number of the seller's main phone.

seller__phone__verified

boolean

[en] Indicates whether the main phone has been verified.

order_id

text

[en] Unique order identifier.

    Orders > > id

application_id

text

base_cost

float

carrier_info

text

comments

text

cost_components_compensation

float

cost_components_gap_discount

float

cost_components_loyal_discount

float

cost_components_ratio

float

cost_components_special_discount

float

created_by

text

date_created

timestamp

date_first_printed

timestamp

id

float

[en] Unique shipment identifier.

last_updated

timestamp

logistic_type

text

market_place

text

mode

text

order_cost

float

receiver_address_address_line

text

receiver_address_agency

text

receiver_address_city_name

text

receiver_address_city_id

text

receiver_address_comment

text

receiver_address_country_name

text

receiver_address_country_id

text

receiver_address_delivery_preference

text

receiver_address_geolocation_last_updated

timestamp

receiver_address_geolocation_source

text

receiver_address_geolocation_type

text

receiver_address_id

float

receiver_address_intersection

text

receiver_address_latitude

float

receiver_address_location_id

text

receiver_address_longitude

float

receiver_address_municipality_name

text

receiver_address_municipality_id

text

receiver_address_neighborhood_name

text

receiver_address_neighborhood_id

text

receiver_address_receiver_name

text

receiver_address_receiver_phone

text

receiver_address_scoring

text

receiver_address_state_name

text

receiver_address_state_id

text

receiver_address_street_name

text

receiver_address_street_number

text

receiver_address_types

text

receiver_address_zip_code

text

receiver_id

float

return_details

text

return_tracking_number

text

sender_address_address_line

text

sender_address_agency

text

sender_address_city_name

text

sender_address_city_id

text

sender_address_comment

text

sender_address_country_name

text

sender_address_country_id

text

sender_address_geolocation_last_updated

timestamp

sender_address_geolocation_source

text

sender_address_geolocation_type

text

sender_address_id

float

sender_address_intersection

text

sender_address_latitude

float

sender_address_location_id

text

sender_address_longitude

float

sender_address_municipality_name

text

sender_address_municipality_id

text

sender_address_neighborhood_name

text

sender_address_scoring

text

sender_address_state_name

text

sender_address_state_id

text

sender_address_street_name

text

sender_address_street_number

text

sender_address_types

text

sender_address_zip_code

text

sender_id

float

service_id

float

shipping_option_buffering_date

text

shipping_option_cost

float

[en] Cost of the chosen shipping option, representing the delivery fee paid by the buyer.

shipping_option_currency_id

text

shipping_option_delivery_promise

text

shipping_option_delivery_type

text

shipping_option_estimated_delivery_extended_date

timestamp

shipping_option_estimated_delivery_extended_offset

float

shipping_option_estimated_delivery_final_date

timestamp

shipping_option_estimated_delivery_final_offset

float

shipping_option_estimated_delivery_limit_date

timestamp

shipping_option_estimated_delivery_limit_offset

float

shipping_option_estimated_delivery_date

timestamp

shipping_option_estimated_delivery_handling

float

shipping_option_estimated_delivery_offset_date

timestamp

shipping_option_estimated_delivery_offset_shipping

float

shipping_option_estimated_delivery_pay_before

timestamp

shipping_option_estimated_delivery_schedule

text

shipping_option_estimated_delivery_shipping

float

shipping_option_estimated_delivery_time_frame_from

text

shipping_option_estimated_delivery_time_frame_to

text

shipping_option_estimated_delivery_time_type

text

shipping_option_estimated_delivery_time_unit

text

shipping_option_estimated_handling_limit_date

timestamp

shipping_option_estimated_schedule_limit_date

timestamp

shipping_option_id

float

shipping_option_list_cost

float

shipping_option_name

text

shipping_option_processing_time

text

shipping_option_shipping_method_id

float

sibling_date_created

text

sibling_description

text

sibling_last_updated

text

sibling_reason

text

sibling_sibling_id

text

sibling_source

text

site_id

text

status

text

status_history_date_cancelled

timestamp

status_history_date_delivered

timestamp

status_history_date_first_visit

timestamp

status_history_date_handling

timestamp

status_history_date_not_delivered

timestamp

status_history_date_ready_to_ship

timestamp

status_history_date_returned

timestamp

status_history_date_shipped

timestamp

substatus

text

tags

text

tracking_method

text

tracking_number

text

type

text

order_id

text

[en] Unique order identifier.

    Orders > > id

substatus_history_date

timestamp

substatus_history_status

text

substatus_history_substatus

text

user_id

text

[pt] Id do usuário

metric_date

date

[pt] Data da métrica

total_questions

int

[pt] Total de perguntas recebidas pelo usuário no intervalo especificado.

total_visits

int

[pt] Total de visitas recebidas aos itens do usuário no intervalo especificado.

total_phone_views

int

[pt] Total de visualizações do número de telefone recebidas pelos itens no intervalo especificado.

total_whatsapp_clicks

int

[pt] Total de clicks no botão Whatsapp recebidas pelo itens no intervalo especificado.

metric_date

date

[en] Metric date

id

text

[en] Unique campaign identifier

name

text

[en] Campaign name

advertiser_id

text

[en] Advertiser ID

status

text

[en] Campaign status

last_updated

timestamp

[en] Campaign last updated date

date_created

timestamp

[en] Campaign creation date

metric_date

date

[en] Metric date

id

text

[en] Ad group ID

campaign_id

text

[en] Campaign ID

campaign_name

text

[en] Campaign name

sll

text

[en] SLL (Sistema de Lojas Livres)

ad_group_type

text

[en] Ad group type

ad_group_external_id

text

[en] Ad group external ID

title

text

[en] Ad group title/name

status

text

[en] Ad group status

original_advertiser_id

text

[en] Original advertiser ID

channel

text

[en] Ad channel (marketplace, mshops)

brand_value_name

text

[en] Brand name

thumbnail

text

[en] Thumbnail URL

catalog_listing

boolean

[en] Catalog listing

domain_id

text

[en] Domain ID

official_store_id

text

[en] Official store ID

brand_value_id

text

[en] Brand ID

date_created

timestamp

[en] Ad group creation date

current_advertiser_id

text

[en] Current advertiser ID

metric_date

date

[en] Metric date

item_id

text

[en] Item ID

title

text

[en] Ad title

ad_group_id

text

[en] Ad group ID

ad_group_name

text

[en] Ad group name

campaign_id

text

[en] Campaign ID

campaign_name

text

[en] Campaign name

logistic_type

text

[en] Logistic type

price

float

[en] Item price

brand_value_id

text

[en] Brand ID

brand_value_name

text

[en] Brand name

date_created

timestamp

[en] Ad creation date

condition

text

[en] Item condition (new, used)

thumbnail

text

[en] Thumbnail URL

permalink

text

[en] Ad permalink

buy_box_winner

boolean

[en] Whether it is buy box winner

recommended

boolean

[en] Whether the ad is recommended

current_level

text

[en] Current reputation level

deferred_stock

boolean

[en] Has deferred stock

has_discount

boolean

[en] Has discount

tags

text

[en] Ad tags

listing_type_id

text

[en] Listing type

picture_id

text

[en] Main image ID

family_id

text

[en] Product family ID

family_name

text

[en] Product family name

user_product_id

text

[en] User product ID

user_product_name

text

[en] User product name

status_raw

text

[en] Raw ad status

clicks

float

[en] Number of clicks

prints

float

[en] Number of impressions

cost

float

[en] Total cost

cpc

float

[en] Cost per click

acos

float

[en] Ad cost over sales (ACOS)

organic_units_quantity

int

[en] Units sold without advertising

organic_units_amount

float

[en] Amount of units sold without advertising

organic_items_quantity

int

[en] Orders without advertising

direct_items_quantity

int

[en] Direct orders via advertising

indirect_items_quantity

int

[en] Assisted orders via advertising

advertising_items_quantity

int

[en] Orders via advertising

direct_units_quantity

int

[en] Units sold in direct sales

indirect_units_quantity

int

[en] Units sold in assisted sales

units_quantity

int

[en] Total orders

direct_amount

float

[en] Direct sales amount

ctr

float

[en] Click-through rate (clicks/impressions)

cvr

float

[en] Conversion rate (orders/clicks)

roas

float

[en] Return on ad spend (ROAS)

sov

float

[en] Share of voice (SOV)

indirect_amount

float

[en] Assisted sales amount

total_amount

float

[en] Total sales amount

id

text

[en] Unique payment identifier, generated automatically by Mercado Pago.

date_created

timestamp

[en] Date when the payment was created.

date_approved

timestamp

[en] Date when the payment was approved. A payment can be created in an intermediate state and then approved.

date_last_updated

timestamp

[en] Date when the last payment event was registered.

money_release_date

timestamp

[en] Date when the money was released to the seller.

payment_method_id

text

[en] Payment method identifier (e.g., master, visa, pix, bolbradesco).

payment_type_id

text

[en] Payment type (credit_card, debit_card, ticket, bank_transfer, etc.).

status

text

[en] Current payment status (pending, approved, authorized, in_process, in_mediation, rejected, cancelled, refunded, charged_back).

status_detail

text

[en] Payment status detail (e.g., accredited, pending_contingency, cc_rejected_high_risk).

currency_id

text

[en] Payment currency identifier (BRL, USD, etc.).

description

text

[en] Payment description.

collector_id

text

[en] Collector/seller identifier who receives the payment.

payer_id

text

[en] Payer identifier.

payer_email

text

[en] Payer email address.

payer_identification_type

text

[en] Payer identification document type (CPF, CNPJ, etc.).

payer_identification_number

text

[en] Payer identification document number.

payer_type

text

[en] Payer type (customer, registered, guest).

external_reference

text

[en] External payment reference. Can be, for example, an order ID from the seller's system.

transaction_amount

float

[en] Total transaction amount.

transaction_amount_refunded

float

[en] Total refunded transaction amount.

coupon_amount

float

[en] Coupon amount applied to the payment.

transaction_details_net_received_amount

float

[en] Net amount received after fee deductions.

transaction_details_total_paid_amount

float

[en] Total amount paid by the buyer.

transaction_details_overpaid_amount

float

[en] Overpaid amount.

transaction_details_installment_amount

float

[en] Amount of each installment.

installments

int

[en] Number of payment installments.

order_id

text

[en] Mercado Livre order ID associated with the payment.

    Orders > > id