id

float

[en] Unique claim identifier.

date_created

timestamp

[en] Claim creation date.

fulfilled

boolean

[en] Indicates whether the claim was fulfilled.

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

[en] Identifier of the reason for the post-sale claim or dispute on Mercado Livre.

resolution_applied_coverage

boolean

[en] Indicates whether coverage was applied in the claim resolution.

resolution_benefited

text

[en] Indicates who was benefited by the claim resolution.

resolution_closed_by

text

[en] Indicates by whom the claim resolution was closed.

resolution_date_created

timestamp

[en] Date and time the claim resolution was created, in ISO-8601 format.

resolution_reason

text

[en] Reason for the resolution of the post-sale claim or dispute on Mercado Livre.

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

[en] Item ID.

accepts_mercadopago

boolean

[en] Indicates whether the listing accepts payment via Mercado Pago.

automatic_relist

boolean

[en] Indicates whether the listing is automatically relisted upon expiration.

available_quantity

float

[en] Quantity of units available for sale in the listing.

buying_mode

text

[en] Buying mode of the listing.

catalog_listing

boolean

[en] Indicates whether the listing is a catalog listing.

catalog_product_id

text

[en] Identifier of the catalog product linked to the listing.

category_id

text

[en] Identifier of the listing's category.

category_name

text

[en] Name of the listing's category.

channels

text

[en] Sales channels through which the listing is available.

total_visits_last_90_days

int

[en] Reports the number of visits in the last 90 days range.

date_to

timestamp

[en] End date, which defines the query range for the last 90 days.

date_from

timestamp

[en] Start date, which defines the query range for the last 90 days.

condition

text

[en] Condition of the advertised product (new or used).

currency_id

text

[en] Identifier of the currency used in the listing's price.

date_created

timestamp

[en] Date and time the listing was created (ISO-8601).

differential_pricing

text

[en] Differential pricing configuration applied to the listing.

domain_id

text

[en] Identifier of the domain (product category) to which the listing belongs.

end_time

timestamp

[en] End date and time of the listing (ISO-8601).

expiration_time

timestamp

[en] Expiration date and time of the listing (ISO-8601).

geolocation_latitude

float

[en] Latitude of the listing's geolocation.

geolocation_longitude

float

[en] Longitude of the listing's geolocation.

health

float

[en] Listing quality index, ranging from 0 to 1.

initial_quantity

float

[en] Initial quantity of units made available in the listing.

international_delivery_mode

text

[en] International delivery mode configured for the listing.

inventory_id

text

[en] Identifier of the inventory associated with the listing.

last_updated

timestamp

[en] Date and time of the listing's last update (ISO-8601).

listing_source

text

[en] Source of the listing.

listing_type_id

text

[en] Identifier of the listing type.

official_store_id

text

[en] Identifier of the official store associated with the listing.

parent_item_id

text

[en] Identifier of the parent listing to which this listing is linked.

permalink

text

[en] Permanent URL of the listing's public page.

secure_thumbnail

text

[en] Secure (HTTPS) URL of the listing's thumbnail image.

seller_address_address_line

text

[en] Full street address line of the seller's address.

seller_address_city_name

text

[en] City name of the seller's address.

seller_address_city_id

text

[en] City identifier of the seller's address.

seller_address_comment

text

[en] Comment or additional information of the seller's address.

seller_address_country_name

text

[en] Country name of the seller's address.

seller_address_country_id

text

[en] Country identifier of the seller's address.

seller_address_id

float

[en] Identifier of the seller's address.

seller_address_latitude

float

[en] Latitude of the seller's address.

seller_address_longitude

float

[en] Longitude of the seller's address.

seller_address_search_location_city_id

text

[en] City identifier of the search location of the seller's address.

seller_address_search_location_city_name

text

[en] City name of the search location of the seller's address.

seller_address_search_location_neighborhood_id

text

[en] Neighborhood identifier of the search location of the seller's address.

seller_address_search_location

text

[en] Neighborhood name of the search location of the seller's address.

seller_address_search_location_state_id

text

[en] State identifier of the search location of the seller's address.

seller_address_search_location_state_name

text

[en] State name of the search location of the seller's address.

seller_address_state_id

text

[en] State identifier of the seller's address.

seller_address_state_name

text

[en] State name of the seller's address.

seller_address_zip_code

float

[en] Postal code of the seller's address.

seller_contact

text

[en] Seller contact information associated with the listing.

seller_custom_field

text

[en] Custom field defined by the seller for the listing.

seller_id

float

[en] Identifier of the seller responsible for the listing.

shipping_dimensions

text

[en] Package dimensions used in the listing's shipping calculation.

shipping_free_methods

text

[en] Shipping methods offered for free on the listing.

shipping_free_shipping

boolean

[en] Indicates whether the listing offers free shipping.

shipping_local_pick_up

boolean

[en] Indicates whether the listing allows local pickup by the buyer.

shipping_logistic_type

text

[en] Logistics type applied to the listing's shipping.

shipping_mode

text

[en] Shipping mode configured for the listing.

shipping_store_pick_up

boolean

[en] Indicates whether the listing allows pickup at the physical store.

shipping_tags

text

[en] Tags of the listing's shipping configuration.

site_id

text

[en] Identifier of the site (country marketplace) where the listing is published.

sold_quantity

float

[en] Number of units already sold through the listing.

start_time

timestamp

[en] Date and time when the listing started being active (ISO-8601).

status

text

[en] Current status of the listing.

stop_time

timestamp

[en] Date and time when the listing stops being active (ISO-8601).

subtitle

text

[en] Subtitle of the listing.

tags

text

[en] Tags associated with the listing.

thumbnail

text

[en] URL of the listing's thumbnail image.

thumbnail_id

text

[en] Identifier of the listing's thumbnail image.

title

text

[en] Title of the listing.

video_id

text

[en] Identifier of the video associated with the listing.

warranty

text

[en] Free-text description of the warranty offered by the seller for the listing.

id

text

[en] Item ID.

attributes_attribute_group_id

text

[en] Identifier of the group to which the product attribute belongs.

attributes_attribute_group_name

text

[en] Name of the group to which the product attribute belongs.

attributes_id

text

[en] Identifier of the product attribute.

attributes_name

text

[en] Name of the product attribute.

attributes_value_id

float

[en] Identifier of the product attribute's value.

attributes_value_name

text

[en] Name (text) of the product attribute's value.

attributes_value_struct_number

float

[en] Number of the product attribute's structured value.

attributes_value_struct

text

[en] Unit of the product attribute's structured value.

attributes_value_type

text

[en] Type of the product attribute's value.

id

text

[en] Item ID.

sale_terms_id

text

[en] Identifier of the listing's sale term.

sale_terms_name

text

[en] Name of the listing's sale term.

sale_terms_value_id

float

[en] Identifier of the listing's sale term value.

sale_terms_value_name

text

[en] Name (text) of the listing's sale term value.

sale_terms_value_struct_number

float

[en] Number of the listing's structured sale term value.

sale_terms_value_struct_unit

text

[en] Unit of the listing's structured sale term value.

sale_terms_value_type

text

[en] Type of the listing's sale term value.

item_id

text

[en] Item ID.

    Items > > id

metric_date

date

[en] Metric date.

item_title

text

[en] Product title.

item_category_id

text

[en] Identifier of the item category to which the listing is associated.

item_category_name

text

[en] Name of the item category to which the listing is associated.

item_tags

text

[en] List of the tags selected by the seller, such as delivered, paid. [KONDADO: This field is returned concatenated]

total_visits

int

[en] Total visits received by the item on the day.

total_phone_views

int

[en] Total phone number views received by the item on the day.

total_whatsapp_clicks

int

[en] Total clicks on the WhatsApp button received by the item on the day.

item_id

text

[en] Product ID

    Items > > id

amount

float

[en] Amount of the listing price, in R$ (BRL).

conditions_context_restrictions

text

[en] Context restrictions applicable to the listing price conditions.

conditions_end_time

timestamp

[en] End date and time of the validity of the listing price conditions, in ISO-8601 format.

conditions_start_time

timestamp

[en] Start date and time of the validity of the listing price conditions, in ISO-8601 format.

currency_id

text

[en] Identifier of the currency of the listing price.

item_price_id

float

[en] Identifier of the listing price on Mercado Livre.

last_updated

timestamp

[en] Date and time of the last update of the listing price, in ISO-8601 format.

regular_amount

text

[en] Regular amount of the listing price, in R$ (BRL).

type

text

[en] Type of the listing price on Mercado Livre.

item_id

text

[en] Product ID

    Items > > id

amount

float

[en] Amount of the listing's promotional price, in R$ (BRL).

promotion_id

text

[en] Identifier of the promotion associated with the listing's promotional price.

promotion_type

text

[en] Type of promotion associated with the listing's promotional price.

currency_id

text

[en] Identifier of the currency of the listing's promotional price.

price_id

float

[en] Identifier of the listing's promotional price on Mercado Livre.

reference_date

timestamp

[en] Reference date of the listing's promotional price, in ISO-8601 format.

regular_amount

text

[en] Regular amount of the listing's promotional price, in R$ (BRL).

user_product_id

text

[en] Unique identifier of the product associated with the user.

type

text

[en] meli_facility: The stock is located in Mercado Livre's Fulfillment warehouses. Managed by Mercado Livre (Full). selling_address: Seller's origin address for items with Flex stock on listings that are also in Mercado Livre's Fulfillment. seller_warehouse: Multiple warehouses managed by the seller. Allows the seller to manage stock across different locations.

item_id

text

[en] Unique identifier of the item.

    Items > > id

user_id

text

[en] Unique identifier of the user.

user_nickname

text

[en] User's nickname.

quantity

int

[en] Quantity available in stock.

availability_type

text

[en] Indicates the availability of the item.

network_node_id

text

[en] Network node identifier.

store_id

text

[en] Store identifier.

store_description

text

[en] Description of the store/warehouse where the item stock is located.

store_location_address_line

text

[en] Address line of the location of the store/warehouse where the item stock is located.

store_location_country

text

[en] Country of the location of the store/warehouse where the item stock is located.

store_location_latitude

text

[en] Latitude of the location of the store/warehouse where the item stock is located.

store_location_longitude

text

[en] Longitude of the location of the store/warehouse where the item stock is located.

store_location_state

text

[en] State of the location of the store/warehouse where the item stock is located.

store_status

text

[en] Status of the store/warehouse where the item stock is located.

store_tags

text

[en] Tags associated with the store/warehouse where the item stock is located.

item_id

text

[en] Item ID

    Items > > id

item_variation_id

float

[en] Product variation ID

catalog_product_id

text

[en] Identifier of the catalog product associated with this listing variation.

available_quantity

float

[en] Quantity available in stock for this listing variation.

inventory_id

text

[en] Inventory identifier associated with this listing variation.

seller_custom_field

text

[en] Custom field defined by the seller for this listing variation.

sold_quantity

float

[en] Quantity sold of this listing variation on Mercado Livre.

item_id

text

[en] Item ID

item_variation_id

float

[en] Product variation ID

attribute_combinations_id

text

[en] Identifier of the attribute that makes up the combination defining the listing variation.

attribute_combinations_name

text

[en] Name of the attribute that makes up the combination defining the listing variation.

attribute_combinations_value_id

float

[en] Identifier of the attribute value that makes up the combination defining the listing variation.

attribute_combinations_value_name

text

[en] Name of the attribute value that makes up the combination defining the listing variation.

attribute_combinations_value_struct_number

float

[en] Number of the structured attribute value that makes up the combination defining the listing variation.

attribute_combinations_value_struct_unit

text

[en] Unit of the structured attribute value that makes up the combination defining the listing variation.

attribute_combinations_value_type

text

[en] Type of the attribute value that makes up the combination defining the listing variation.

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

[en] Date and time of the last update of the order context, in ISO-8601 format.

context_application

text

[en] Application associated with the order context on Mercado Livre.

context_channel

text

[en] Channel through which the order originated, within the order context.

context_flows

text

[en] Flows associated with the order context on Mercado Livre.

context_product_id

text

[en] Identifier of the product associated with the order context.

context_site

text

[en] Identifier of the Mercado Livre site on which the order was generated, within the order context.

order_id

text

[en] Unique order identifier.

    Orders > > id

feedback_id

text

[en] Unique identifier of the purchase feedback.

purchase_app_id

float

[en] Identifier of the application that originated the purchase feedback.

purchase_date_created

timestamp

[en] Creation date of the purchase feedback, in ISO-8601 format.

purchase_extended_feedback

text

[en] Extended comment associated with the purchase feedback.

purchase_from_id

float

[en] Identifier of the user who recorded the purchase feedback.

purchase_from_nickname

text

[en] Nickname of the user who recorded the purchase feedback.

purchase_from_points

float

[en] Points of the user who recorded the purchase feedback.

purchase_from_status

text

[en] Status of the user who recorded the purchase feedback.

purchase_fulfilled

boolean

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

purchase_has_seller_refunded_money

text

[en] Indicates whether the seller refunded the amount related to the purchase feedback.

purchase_item_currency_id

text

[en] Currency identifier of the rated item in the purchase feedback.

purchase_item_price

float

[en] Price of the rated item in the purchase feedback, monetary value in R$ (BRL).

purchase_item_title

text

[en] Title of the rated item in the purchase feedback.

purchase_item_id

float

[en] Identifier of the rated item in the purchase feedback.

purchase_message

text

[en] Feedback message with up to 160 characters.

purchase_modified

boolean

[en] Indicates whether the purchase feedback was modified.

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

[en] Reply associated with the purchase feedback.

purchase_role

text

[en] Role of the user who recorded the purchase feedback.

purchase_site_id

text

[en] Mercado Livre site identifier associated with the purchase feedback.

purchase_status

text

[en] Status of the purchase feedback.

purchase_to_id

float

[en] Identifier of the rated user in the purchase feedback.

purchase_to_nickname

text

[en] Nickname of the rated user in the purchase feedback.

purchase_to_points

float

[en] Points assigned to the rated user in the purchase feedback.

purchase_to_status

text

[en] Status of the user who was rated in the purchase feedback.

purchase_visibility_date

text

[en] Date on which the purchase feedback became visible.

sale

text

[en] Rating related to the sale side of the order on Mercado Livre.

order_id

text

[en] Unique identifier of the order

    Orders > > id

base_currency_id

text

[en] Identifier of the base currency used in the currency conversion of the item in the order.

base_exchange_rate

text

[en] Base exchange rate used in the currency conversion of the item in the order.

bundle

text

[en] Bundle information of the item in the order.

currency_id

text

[en] Currency identifier of the item in the order.

element_id

text

[en] Element identifier of the item in the order.

full_unit_price

float

[en] Full unit price of the item in the order, monetary value in R$ (BRL).

item_category_id

text

[en] Category identifier of the item sold in the order.

item_condition

text

[en] Condition of the item sold in the order.

item_global_price

float

[en] Global price of the item sold in the order, monetary value in R$ (BRL).

item_id

text

[en] Sold item identifier.

    Items > > id

item_net_weight

float

[en] Net weight of the item sold in the order.

item_seller_custom_field

text

[en] Seller custom field for the item sold in the order.

item_seller_sku

text

[en] Seller SKU for the item sold in the order.

item_title

text

[en] Sold product title.

item_variation_id

float

[en] Identifier of the variation of the item sold in the order.

item_warranty

text

[en] Warranty of the item sold in the order.

listing_type_id

text

[en] Identifier of the listing type of the item in the order.

manufacturing_days

float

[en] Number of manufacturing days for the item in the order.

picked_quantity

float

[en] Quantity of the item actually picked for the order.

quantity

float

[en] Quantity of the item in the order.

requested_quantity_measure

text

[en] Unit of measure of the requested quantity of the item in the order.

requested_quantity_value

float

[en] Value of the requested quantity of the item in the order.

sale_fee

float

[en] Sale fee charged on the order item, monetary value in R$ (BRL).

unit_price

float

[en] Unit price of the item in the order, monetary value in R$ (BRL).

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

[en] Unique identifier of the order to which the item variation attribute belongs.

item_id

text

[en] Identifier of the item to which the variation attribute is associated.

    Orders: items > > item_id

item_variation_attributes_id

text

[en] Identifier of the attribute of the purchased item variation in the order.

item_variation_attributes_name

text

[en] Name of the attribute of the purchased item variation in the order.

item_variation_attributes_value_id

text

[en] Value identifier of the attribute of the purchased item variation in the order.

item_variation_attributes_value_name

text

[en] Value name of the attribute of the purchased item variation in the order.

order_id

text

[en] Unique order identifier.

    Orders > > id

id

float

[en] Unique payment identifier in Mercado Pago.

activation_uri

text

[en] Activation URI associated with the order payment.

atm_transfer_reference_company_id

text

[en] Company identifier of the bank transfer reference of the order payment.

atm_transfer_reference_transaction_id

float

[en] Transaction identifier of the bank transfer reference of the order payment.

authorization_code

text

[en] Transaction authorization code.

available_actions

text

[en] Available actions for the order payment.

card_id

float

[en] Identifier of the card used in the order payment.

collector_id

float

[en] Collector account identifier.

coupon_amount

float

[en] Coupon amount applied to the payment.

coupon_id

text

[en] Identifier of the coupon applied to the order payment.

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

[en] Date of the last modification of the order payment, in ISO-8601 format.

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

[en] Identifier of the payer of the order payment.

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

[en] Reason associated with the order payment.

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

[en] Mercado Livre site identifier associated with the order payment.

status

text

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

status_code

text

[en] Status code of the order payment.

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

[en] Transaction order identifier associated with the order payment.

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

[en] Identifier of the application associated with the shipment

base_cost

float

[en] Base shipping cost of the shipment, a monetary value in R$ (BRL)

carrier_info

text

[en] Information about the carrier responsible for the shipment

comments

text

[en] Comments associated with the shipment

cost_components_compensation

float

[en] Compensation component applied to the shipping cost, a monetary value in R$ (BRL)

cost_components_gap_discount

float

[en] Gap discount component applied to the shipping cost, a monetary value in R$ (BRL)

cost_components_loyal_discount

float

[en] Loyalty discount component applied to the shipping cost, a monetary value in R$ (BRL)

cost_components_ratio

float

[en] Ratio used in the apportionment of the shipping cost components

cost_components_special_discount

float

[en] Special discount component applied to the shipping cost, a monetary value in R$ (BRL)

created_by

text

[en] Identification of who or what created the shipment

date_created

timestamp

[en] Date and time when the shipment was created (ISO-8601)

date_first_printed

timestamp

[en] Date and time when the shipment label was first printed (ISO-8601)

id

float

[en] Unique shipment identifier.

last_updated

timestamp

[en] Date and time of the last update of the shipment (ISO-8601)

logistic_type

text

[en] Logistic type used in the shipment

market_place

text

[en] Marketplace to which the shipment is linked

mode

text

[en] Mode of the shipment

order_cost

float

[en] Cost of the order associated with the shipment, a monetary value in R$ (BRL)

receiver_address_address_line

text

[en] Full address line of the destination (receiver) address of the shipment

receiver_address_agency

text

[en] Agency/point associated with the destination (receiver) address of the shipment

receiver_address_city_name

text

[en] Name of the city of the destination (receiver) address of the shipment

receiver_address_city_id

text

[en] Identifier of the city of the destination (receiver) address of the shipment

receiver_address_comment

text

[en] Comment/complement of the destination (receiver) address of the shipment

receiver_address_country_name

text

[en] Name of the country of the destination (receiver) address of the shipment

receiver_address_country_id

text

[en] Identifier of the country of the destination (receiver) address of the shipment

receiver_address_delivery_preference

text

[en] Delivery preference set for the destination address of the shipment

receiver_address_geolocation_last_updated

timestamp

[en] Date and time of the last geolocation update of the destination (receiver) address of the shipment (ISO-8601)

receiver_address_geolocation_source

text

[en] Geolocation source of the destination (receiver) address of the shipment

receiver_address_geolocation_type

text

[en] Geolocation type of the destination (receiver) address of the shipment

receiver_address_id

float

[en] Identifier of the destination (receiver) address of the shipment

receiver_address_intersection

text

[en] Intersection reference of the destination (receiver) address of the shipment

receiver_address_latitude

float

[en] Geographic latitude of the destination (receiver) address of the shipment

receiver_address_location_id

text

[en] Location identifier of the destination (receiver) address of the shipment

receiver_address_longitude

float

[en] Geographic longitude of the destination (receiver) address of the shipment

receiver_address_municipality_name

text

[en] Name of the municipality of the destination (receiver) address of the shipment

receiver_address_municipality_id

text

[en] Identifier of the municipality of the destination (receiver) address of the shipment

receiver_address_neighborhood_name

text

[en] Neighborhood name of the destination (receiver) address of the shipment

receiver_address_neighborhood_id

text

[en] Identifier of the neighborhood of the destination (receiver) address of the shipment

receiver_address_receiver_name

text

[en] Receiver name in the destination address of the shipment

receiver_address_receiver_phone

text

[en] Receiver phone in the destination address of the shipment

receiver_address_scoring

text

[en] Scoring of the destination (receiver) address of the shipment

receiver_address_state_name

text

[en] Name of the state of the destination (receiver) address of the shipment

receiver_address_state_id

text

[en] Identifier of the state of the destination (receiver) address of the shipment

receiver_address_street_name

text

[en] Street name of the destination (receiver) address of the shipment

receiver_address_street_number

text

[en] Street number of the destination (receiver) address of the shipment

receiver_address_types

text

[en] Types of the destination (receiver) address of the shipment [KONDADO: This field is returned concatenated]

receiver_address_zip_code

text

[en] Postal code of the destination (receiver) address of the shipment

receiver_id

float

[en] Identifier of the receiver (buyer) of the shipment

return_details

text

[en] Details of the shipment return

return_tracking_number

text

[en] Tracking number of the shipment return

sender_address_address_line

text

[en] Full address line of the origin (sender) address of the shipment

sender_address_agency

text

[en] Agency/point associated with the origin (sender) address of the shipment

sender_address_city_name

text

[en] Name of the city of the origin (sender) address of the shipment

sender_address_city_id

text

[en] Identifier of the city of the origin (sender) address of the shipment

sender_address_comment

text

[en] Comment/complement of the origin (sender) address of the shipment

sender_address_country_name

text

[en] Name of the country of the origin (sender) address of the shipment

sender_address_country_id

text

[en] Identifier of the country of the origin (sender) address of the shipment

sender_address_geolocation_last_updated

timestamp

[en] Date and time of the last geolocation update of the origin (sender) address of the shipment (ISO-8601)

sender_address_geolocation_source

text

[en] Geolocation source of the origin (sender) address of the shipment

sender_address_geolocation_type

text

[en] Geolocation type of the origin (sender) address of the shipment

sender_address_id

float

[en] Identifier of the origin (sender) address of the shipment

sender_address_intersection

text

[en] Intersection reference of the origin (sender) address of the shipment

sender_address_latitude

float

[en] Geographic latitude of the origin (sender) address of the shipment

sender_address_location_id

text

[en] Location identifier of the origin (sender) address of the shipment

sender_address_longitude

float

[en] Geographic longitude of the origin (sender) address of the shipment

sender_address_municipality_name

text

[en] Name of the municipality of the origin (sender) address of the shipment

sender_address_municipality_id

text

[en] Identifier of the municipality of the origin (sender) address of the shipment

sender_address_neighborhood_name

text

[en] Neighborhood name of the origin (sender) address of the shipment

sender_address_scoring

text

[en] Scoring of the origin (sender) address of the shipment

sender_address_state_name

text

[en] Name of the state of the origin (sender) address of the shipment

sender_address_state_id

text

[en] Identifier of the state of the origin (sender) address of the shipment

sender_address_street_name

text

[en] Street name of the origin (sender) address of the shipment

sender_address_street_number

text

[en] Street number of the origin (sender) address of the shipment

sender_address_types

text

[en] Types of the origin (sender) address of the shipment [KONDADO: This field is returned concatenated]

sender_address_zip_code

text

[en] Postal code of the origin (sender) address of the shipment

sender_id

float

[en] Identifier of the sender (seller) of the shipment

service_id

float

[en] Identifier of the shipping service used in the shipment

shipping_option_buffering_date

text

[en] Buffering date and time of the chosen shipping option

shipping_option_cost

float

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

shipping_option_currency_id

text

[en] Currency identifier of the costs of the chosen shipping option

shipping_option_delivery_promise

text

[en] Delivery promise associated with the chosen shipping option

shipping_option_delivery_type

text

[en] Delivery type of the chosen shipping option

shipping_option_estimated_delivery_extended_date

timestamp

[en] Extended estimated delivery date and time of the chosen shipping option (ISO-8601)

shipping_option_estimated_delivery_extended_offset

float

[en] Offset of the extended estimated delivery date for the chosen shipping option

shipping_option_estimated_delivery_final_date

timestamp

[en] Final estimated delivery date and time of the chosen shipping option (ISO-8601)

shipping_option_estimated_delivery_final_offset

float

[en] Offset of the final estimated delivery date for the chosen shipping option

shipping_option_estimated_delivery_limit_date

timestamp

[en] Estimated delivery limit date and time of the chosen shipping option (ISO-8601)

shipping_option_estimated_delivery_limit_offset

float

[en] Offset of the estimated delivery limit date for the chosen shipping option

shipping_option_estimated_delivery_date

timestamp

[en] Estimated delivery date and time of the chosen shipping option (ISO-8601)

shipping_option_estimated_delivery_handling

float

[en] Handling time component of the estimated delivery for the chosen shipping option

shipping_option_estimated_delivery_offset_date

timestamp

[en] Reference date and time of the offset for the estimated delivery of the chosen shipping option (ISO-8601)

shipping_option_estimated_delivery_offset_shipping

float

[en] Shipping offset applied to the estimated delivery of the chosen shipping option

shipping_option_estimated_delivery_pay_before

timestamp

[en] Payment deadline date and time to guarantee the estimated delivery of the chosen shipping option (ISO-8601)

shipping_option_estimated_delivery_schedule

text

[en] Schedule of the estimated delivery for the chosen shipping option

shipping_option_estimated_delivery_shipping

float

[en] Shipping time component of the estimated delivery for the chosen shipping option

shipping_option_estimated_delivery_time_frame_from

text

[en] Lower bound of the estimated delivery time frame of the chosen shipping option

shipping_option_estimated_delivery_time_frame_to

text

[en] Upper bound of the estimated delivery time frame of the chosen shipping option

shipping_option_estimated_delivery_time_type

text

[en] Type of the estimated delivery time of the chosen shipping option

shipping_option_estimated_delivery_time_unit

text

[en] Time unit of the estimated delivery for the chosen shipping option

shipping_option_estimated_handling_limit_date

timestamp

[en] Estimated handling limit date of the chosen shipping option (ISO-8601)

shipping_option_estimated_schedule_limit_date

timestamp

[en] Estimated scheduling limit date of the chosen shipping option (ISO-8601)

shipping_option_id

float

[en] Identifier of the chosen shipping option for the shipment

shipping_option_list_cost

float

[en] List cost of the chosen shipping option, a monetary value in R$ (BRL)

shipping_option_name

text

[en] Name of the chosen shipping option/method

shipping_option_processing_time

text

[en] Processing time of the chosen shipping option

shipping_option_shipping_method_id

float

[en] Identifier of the shipping method of the chosen shipping option

sibling_date_created

text

[en] Date and time when the related (sibling) shipment was created

sibling_description

text

[en] Description of the related (sibling) shipment to the current shipment

sibling_last_updated

text

[en] Date and time of the last update of the related (sibling) shipment

sibling_reason

text

[en] Reason for the relationship between the current shipment and the related (sibling) shipment

sibling_sibling_id

text

[en] Identifier of the related (sibling) shipment to the current shipment

sibling_source

text

[en] Source of the related (sibling) shipment to the current shipment

site_id

text

[en] Identifier of the Mercado Livre site/marketplace to which the shipment belongs

status

text

[en] Current status of the shipment

status_history_date_cancelled

timestamp

[en] Date and time when the shipment was cancelled (ISO-8601)

status_history_date_delivered

timestamp

[en] Date and time when the shipment was delivered (ISO-8601)

status_history_date_first_visit

timestamp

[en] Date and time of the first delivery attempt for the shipment (ISO-8601)

status_history_date_handling

timestamp

[en] Date and time when the shipment entered the handling stage (ISO-8601)

status_history_date_not_delivered

timestamp

[en] Date and time when the shipment was recorded as not delivered (ISO-8601)

status_history_date_ready_to_ship

timestamp

[en] Date and time when the shipment became ready to ship (ISO-8601)

status_history_date_returned

timestamp

[en] Date and time when the shipment was returned (ISO-8601)

status_history_date_shipped

timestamp

[en] Date and time when the shipment was shipped (ISO-8601)

substatus

text

[en] Current substatus of the shipment, detailing the situation within the main status

tags

text

[en] Tags associated with the shipment [KONDADO: This field is returned concatenated]

tracking_method

text

[en] Method or carrier responsible for tracking the shipment

tracking_number

text

[en] Tracking number assigned to the shipment by the carrier

type

text

[en] Type of the shipment

order_id

text

[en] Unique order identifier.

    Orders > > id

substatus_history_date

timestamp

[en] Date and time of an entry in the shipment substatus history (ISO-8601)

substatus_history_status

text

[en] Main status associated with an entry of the shipment substatus history

substatus_history_substatus

text

[en] Substatus recorded in an entry of the shipment substatus history

user_id

text

[en] User ID.

metric_date

date

[en] Metric date.

total_questions

int

[en] Total questions received by the user in the specified interval.

total_visits

int

[en] Total visits received by the user's items in the specified interval.

total_phone_views

int

[en] Total phone number views received by the items in the specified interval.

total_whatsapp_clicks

int

[en] Total clicks on the WhatsApp button received by the items in the specified interval.

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

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

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

current_advertiser_id

text

[en] Current advertiser ID

item_id

text

[en] Item ID

    Items > > id

ad_group_id

text

[en] Ad group ID

ad_group_name

text

[en] Ad group name

logistic_type

text

[en] Logistic type

price

float

[en] Item price

condition

text

[en] Item condition (new, used)

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

order_id

text

[en] Order ID on Mercado Livre

    Orders > > id

invoice_id

text

[en] Invoice ID

invoice_number

float

[en] Invoice number

invoice_series

text

[en] Invoice series

invoice_key

text

[en] NF-e access key

invoice_status

text

[en] Invoice status

invoice_amount

float

[en] Total invoice amount

issued_date

text