Shopee: Most-used fields
The table below gives information about most-used fields that you can import from Shopee. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
actual_shipping_fee actual_shipping_feeDimension
The final shipping cost for an order, which is a positive value. For non-integrated logistics channels, this value is 0. This field is only displayed for non-CB SIP affiliate shops.
actual_shipping_fee_confirmedDimension
Indicates if the actual shipping fee for an order has been confirmed.
add_on_deal_idDimension
A unique identifier for an add-on deal or promotion.
attribute_listDimension
A list of attributes defining specific characteristics of a product.
attribute_list.attribute_idDimension
The unique identifier for a product attribute.
attribute_list.attribute_value_list.original_value_nameDimension
The original name of the attribute value, as retrieved from the product attributes API.
attribute_list.attribute_value_list.value_idDimension
The unique identifier for a specific attribute value.
attribute_list.attribute_value_list.value_unitDimension
The unit of measurement for a quantitative product attribute value.
attribute_list.is_mandatoryDimension
Indicates if the product attribute is mandatory for listing.
attribute_list.original_attribute_nameDimension
The original name of the product attribute.
attributesDimension
A collection of product attributes defining its characteristics.
brandDimension
Contains information about the brand of the product.
brand.brand_idDimension
The unique identifier for the brand.
brand.original_brand_nameDimension
The original name of the brand.
buyer_cancel_reasonDimension
The reason provided by the buyer for cancelling an order.
buyer_cpf_idDimension
The CPF ID of the buyer (specific to certain regions like Brazil). This field is available when requesting optional fields in order details.
buyer_user_idDimension
The unique identifier for the buyer of an order.
buyer_usernameDimension
The username of the buyer who placed the order. This information is available when retrieving order details.
cancel_byDimension
Indicates who canceled the order. This field is available when requesting optional fields in order details.
cancel_reasonDimension
The reason provided for the cancellation of an order.
category_idDimension
The unique identifier for the product category.
category_nameDimension
The name of the product category.
cmt_countMetric
The total number of comments or reviews received for a product.
codDimension
Indicates if the order is a Cash on Delivery (COD) order.
countryDimension
The two-letter ISO ALPHA-2 code representing the country.
create_timeDimension
The timestamp when the order or item was created.
currencyDimension
The three-digit ISO currency code for the order's total amount.
dateDimension
A standardized date field derived from API timestamps, representing the date of an event.
days_to_shipMetric
The number of days required to ship a pre-order item.
descriptionDimension
The detailed description of the product.
description_infoDimension
Contains detailed description information about the product.
description_info.extended_description.field_list.field_typeDimension
This field defines the type of content within an extended product description. It indicates whether a specific part of the description contains text or an image. Possible values include "text" and "image".
description_info.extended_description.field_list.image_info.image_idDimension
The unique identifier for an image included in a product's extended description.
description_info.extended_description.field_list.image_info.image_urlDimension
The URL where an image, part of a product's extended description, can be accessed.
description_info.extended_description.field_list.textDimension
The textual content of a specific field within a product's extended description.
dimensionDimension
The physical dimensions of the item or package.
dimension.package_heightMetric
The height of the product package in centimeters.
dimension.package_lengthMetric
The length of the product package in centimeters.
dimension.package_widthMetric
The width of the product package in centimeters.
discount_idDimension
The unique identifier for a discount promotion.
discount_nameDimension
The name of the discount promotion.
dropshipperDimension
Indicates whether the order is handled by a dropshipper. This field is available when requesting optional fields in order details.
dropshipper_phoneDimension
The phone number of the dropshipper. This field is available when requesting optional fields in order details.
end_timeDimension
The timestamp indicating when a discount activity or promotion ends.
escrow_amountMetric
The amount held in escrow for an order, which is released to the seller upon successful completion of the transaction.
escrow_taxMetric
Cross-border tax imposed by the Indonesian government on sellers. This field is only displayed for non-CB SIP affiliate shops.
estimated_shipping_feeMetric
The estimated shipping fee for the order.
fulfillment_flagDimension
A flag indicating how the order is fulfilled (e.g., by Shopee, cross-border seller, local seller).
goods_to_declareDimension
Information related to goods that need to be declared. This field is available when requesting optional fields in order details.
has_modelDimension
Indicates whether a product has specific models, which are often used to define variations or distinct versions of a product.
has_uploaded_shipping_proofDimension
Indicates whether shipping proof, such as a tracking receipt or photo, has been uploaded for the return.
has_variationDimension
Indicates whether a product has different variations, such as size, color, or other attributes.
imageDimension
Contains image-related information for the product.
image.image_id_listDimension
A list of unique identifiers for product images.
image.image_url_listDimension
A list of URLs for product images.
imagesDimension
A list of image URLs for the product.
invoice_dataDimension
Invoice-related data for an order. This field is available when requesting optional fields in order details.
is_actual_shipping_fee_confirmedDimension
Indicates whether the actual shipping fee has been confirmed. This field is available when requesting optional fields in order details.
is_add_on_dealDimension
Indicates if the item is part of an add-on deal.
is_arrived_at_warehouseMetric
Indicates if the returned item has arrived at the designated warehouse.
is_main_itemDimension
Indicates if the item is the main item in a bundle or a sub-item.
is_partial_quantity_returnDimension
Indicates if the return request involves a partial quantity of items from the original order.
is_pre_orderDimension
Indicates if the item is a pre-order item.
is_prescription_itemDimension
Indicates if the item is a prescription-required product.
is_refund_amount_adjustedDimension
Indicates whether the refund amount for the return request has been adjusted from the original value.
is_reverse_logistics_channel_integratedDimension
Indicates if the reverse logistics channel used for the return is integrated with the Shopee platform.
is_seller_arrangeDimension
Indicates if the seller is responsible for arranging the return shipping or other logistics for the item.
is_shipping_proof_mandatoryDimension
Indicates whether uploading shipping proof is a mandatory requirement for the current return or refund request.
is_split_upDimension
Indicates if an order has been split into multiple packages. This field is available when requesting optional fields in order details.
is_wholesaleDimension
Indicates if the item is available for wholesale purchase.
itemDimension
Details about the specific product item involved in the order or return request.
item_idDimension
Shopee's unique identifier for a product item.
item_listDimension
A list of items included in an order or package.
item_list.add_on_dealDimension
Indicates if the item in the list is part of an add-on deal.
item_list.add_on_deal_idDimension
The unique identifier for an add-on deal that this item belongs to.
item_list.image_info.image_urlDimension
The URL of the image for the product item in the list.
item_list.is_prescription_itemDimension
Indicates if the item in the list is a prescription-required product.
item_list.item_idDimension
Shopee's unique identifier for the product item in the list.
item_list.item_nameDimension
The name of the product item in the list.
item_list.item_skuDimension
The Stock Keeping Unit (SKU) for the product item in the list.
item_list.main_itemDimension
Indicates if the item is the main item in a bundle or a sub-item.
item_list.model_discounted_priceMetric
The discounted price of the specific product model within the item list.
item_list.model_idDimension
The unique identifier for the product model within the item list.
item_list.model_nameDimension
The name of the product model within the item list.
item_list.model_original_priceMetric
The original price of the product model within the item list.
item_list.model_quantity_purchasedMetric
The quantity of a specific model within a product that has been purchased as part of an order.
item_list.model_skuDimension
The Stock Keeping Unit (SKU) for the product model within the item list.
item_list.order_item_idDimension
The unique identifier for the order item within the item list.
item_list.product_location_idDimension
The unique identifier for the warehouse or location where the product item in the list is stored.
item_list.promotion_group_idDimension
The unique identifier for a product promotion group within an item list.
item_list.promotion_idDimension
The unique identifier for the promotion applied to this item in the list.
item_list.promotion_typeDimension
The type of promotion applied to this item in the list.
item_list.weightMetric
The weight of the item, measured in kilograms (KG). For product models, if not specified, it defaults to the item's weight.
item_list.wholesaleDimension
Indicates if the item in the list is available for wholesale purchase.
item_nameDimension
The name of the product item.
item_original_priceMetric
The original price of the product item before any discounts or promotions.
item_promotion_priceMetric
The discounted price of the item during a promotion. If the item has variations, this value will be 0, and the promotion price for variations should be checked separately.
item_promotion_stockMetric
The reserved stock quantity of the item for a promotion. This parameter is necessary if the item has no variation.
item_skuMetric
The Stock Keeping Unit (SKU) for the product item, defined by the seller.
item_statusDimension
The current status of the product item on Shopee (e.g., normal, banned, unlisted).
likesMetric
The number of likes a product has received. This metric is available through the v2.product.get_item_extra_info API and represents the cumulative value of likes for a product.
logistic_infoDimension
Contains detailed information about the logistics arrangements for an order.
logistic_info.enabledDimension
Indicates if a specific logistics option is enabled.
logistic_info.estimated_shipping_feeMetric
The estimated shipping fee for the specific logistics option.
logistic_info.is_freeDimension
Indicates whether free shipping is offered for the logistics option or product.
logistic_info.logistic_idDimension
The unique identifier for the logistics channel.
logistic_info.logistic_nameDimension
The name of the logistics channel or service.
logisticsDimension
Contains general logistics information for the product or order.
logistics_statusDimension
The current status of the logistics process for the returned item.
message_to_sellerDimension
A message from the buyer to the seller for the order.
model_listDimension
A list of product models or variations for an item.
model_list.model_idDimension
The unique identifier for a specific product model.
model_list.model_nameDimension
The name of the product model.
model_list.model_normal_stockDimension
The regular stock quantity available for the product model.
model_list.model_original_priceDimension
The original price of the product model before any discounts.
model_list.model_promotion_priceDimension
The discounted price of a specific model (variation) during a promotion.
model_list.model_promotion_stockDimension
The reserved stock quantity of a specific model (variation) for a promotion.
nameDimension
The name of the item in the local language.
negotiationDimension
Information about the negotiation process between the buyer and seller regarding the return or refund request.
normal_stockMetric
The regular stock quantity available for an item, not including promotional or reserved stock.
noteDimension
A note made by the seller for internal reference regarding the order.
note_update_timeDimension
The timestamp when the seller's note for the order was last updated.
order_chargeable_weight_gramMetric
The chargeable weight of the order in grams, used for calculating shipping fees.
order_item_idDimension
The unique identifier for an item within a specific order.
order_snDimension
Shopee's unique identifier for an order.
order_statusDimension
The current status of the order (e.g., unpaid, ready to ship, completed).
ordersnDimension
Shopee's unique identifier for an order.
original_priceMetric
The original price of the product or its variation before any discounts.
package_heightMetric
The height of the product package in centimeters.
package_lengthMetric
The length of the product package in centimeters.
package_listDimension
A list of packages associated with an order.
package_list.item_list.item_idDimension
Shopee's unique identifier for an item within a package list.
package_list.item_list.model_idDimension
The unique identifier for a product model within an item in the package list.
package_list.logistics_statusDimension
The logistics status of a specific package within an order.
package_list.package_numberDimension
Shopee's unique identifier for a package within an order.
package_list.parcel_chargeable_weight_gramMetric
The chargeable weight of the parcel in grams, used for calculating shipping fees.
package_list.shipping_carrierDimension
The name of the shipping carrier for the package.
package_query_numberDimension
An identifier used to query the status of a specific package, often a tracking number.
package_widthMetric
The width of the product package in centimeters.
pay_timeDimension
The timestamp indicating when the buyer completed payment for the order. This field is available when requesting optional fields in order details.
payment_methodDimension
The method used by the buyer to pay for the order.
pickup_done_timeDimension
The timestamp when the package pickup for the order was completed by the logistics provider.
pre_orderDimension
Contains information indicating if the item is a pre-order.
pre_order.days_to_shipMetric
The number of days required to ship a pre-order item.
pre_order.is_pre_orderDimension
Indicates if the item is designated as a pre-order.
priceMetric
The original price of the item before any promotions or discounts in the listing currency.
price_infoDimension
Contains detailed pricing information for the product, including current and original prices.
price_info.currencyDimension
The three-digit ISO currency code for the product's price.
price_info.current_priceMetric
The current price of the item in the listing currency. If the product is under an ongoing promotion, this will be the promotion price.
price_info.original_priceMetric
The original price of the product before any discounts.
product_location_idDimension
The unique identifier for the warehouse or location where the product is stored.
promotion_idDimension
The unique identifier for a promotion.
promotion_typeDimension
The type of promotion applied to the item (e.g., Flash Sale, Bundle Deal).
purchase_limitMetric
The maximum number of this product that can be purchased at the promotion price in a discount activity.
rating_starMetric
The average star rating given to a product by buyers.
reasonDimension
The reason provided for the return or refund request.
reassessed_request_reasonDimension
The reason for a return request after it has been reassessed, potentially by a Shopee agent.
recipient_addressDimension
The complete address details of the recipient for the order.
recipient_address.cityDimension
The city component of the recipient's address.
recipient_address.districtDimension
The district component of the recipient's address.
recipient_address.full_addressDimension
The complete, detailed address of the recipient.
recipient_address.nameDimension
The name of the recipient.
recipient_address.phoneDimension
The phone number of the recipient.
recipient_address.regionDimension
The region component of the recipient's address.
recipient_address.stateDimension
The state or province component of the recipient's address.
recipient_address.townDimension
The town of the recipient's address. The presence of this field depends on the region and/or country.
recipient_address.zipcodeMetric
The postal code of the recipient's address for an order or a shop address.
refund_amountMetric
The amount of money to be refunded to the buyer for the return or cancellation.
regionDimension
The two-digit code representing the region where the order originated.
reserved_stockMetric
The total quantity of stock reserved for ongoing promotions or sales events.
return_addressDimension
The address where the returned item should be sent.
return_pickup_addressDimension
The address from which the returned item will be picked up.
return_refund_request_typeMetric
The specific type of request made by the buyer, such as 'Refund Only' or 'Return & Refund'.
return_refund_typeDimension
The general category or type of the return or refund, e.g., for damaged goods or wrong item.
return_request_due_dateDimension
The deadline for the buyer to complete actions related to the return request, such as shipping the item back.
return_seller_due_dateDimension
The deadline for the seller to take action on a return or refund request.
return_ship_due_dateDimension
The deadline by which the buyer must ship the returned item.
return_snDimension
The unique serial number identifier for a specific return request.
return_solutionMetric
The proposed or accepted solution for resolving a return or refund request, such as a full refund, partial refund, or product exchange.
reverse_logistics_channel_nameDimension
The name of the logistics channel used for the reverse logistics process (returning the item).
reverse_logistics_statusDimension
The current status of the reverse logistics process for a returned item.
reverse_shipping_feeMetric
The shipping fee for returning an item.
salesMetric
The total number of units sold for a product or the total sales revenue generated.
seller_compensationDimension
Information regarding any compensation provided to the seller in connection with a return or refund.
seller_proofDimension
Evidence provided by the seller, such as photos or documents, related to a return or refund dispute.
service_codeDimension
A code required at some sorting hubs for cross-border orders, which must be included on the shipping label.
ship_by_dateDimension
The deadline for the seller to ship out the package.
shipping_carrierDimension
The name of the logistics service provider or shipping carrier.
shopidMetric
Shopee's unique identifier for a shop.
size_chartDimension
Information about the size chart applicable to the product.
split_upDimension
Indicates if the order has been split into multiple shipments. This field is available when requesting optional fields in order details.
start_timeDimension
The timestamp indicating when a discount activity or promotion starts.
statusDimension
The current status of an order or return, such as 'CANCELLED' or 'ACCEPTED'.
stockMetric
The current available stock quantity for the item.
stock_infoDimension
Comprehensive information regarding the stock levels and availability of a product.
stock_info.current_stockMetric
The current available stock quantity of an item.
stock_info.reserved_stockMetric
The quantity of stock reserved, often due to ongoing or upcoming promotions or pending orders. This field is part of an older stock information structure.
stock_info.stock_typeMetric
The classification or category of stock for a product, such as regular stock, pre-order stock, or promotional stock.
stock_info_v2Dimension
Detailed stock information including total reserved stock, total available stock, seller stock, and Shopee stock. This field provides a more accurate representation of stock when both seller and Shopee stock are present.
stock_info_v2.seller_stock.stockMetric
The stock quantity managed by the seller for a specific product or model. This field can be associated with different warehouse locations.
stock_info_v2.summary_info.total_available_stockMetric
The total quantity of a product's stock that is currently available for sale across all locations.
stock_info_v2.summary_info.total_reserved_stockMetric
The total quantity of stock that is reserved for promotions or other purposes, as part of the detailed stock information.
total_amountMetric
The total amount paid by the buyer for the order.
tracking_noMetric
The tracking number for the shipment or return parcel.
tracking_numberDimension
The unique number used to track the shipment of an order or return package.
update_timeDimension
The timestamp when the item or record was last updated.
variation_discounted_priceMetric
The discounted price of a specific variation within an item.
variation_idDimension
Shopee's unique identifier for a specific variation (model) of an item.
variation_nameDimension
The name of the variation that belongs to the same item.
variation_original_priceMetric
The original price of a specific product variation.
variation_quantity_purchasedMetric
The quantity of a specific product variation that has been purchased.
variation_skuDimension
The SKU (stock keeping unit) for a specific variation of an item.
variationsDimension
A collection of all variations (models) available for an item, including their details.
video_infoDimension
Information about product videos, including upload IDs.
video_info.durationMetric
The length of the video in seconds.
video_info.thumbnail_urlDimension
The URL of the thumbnail image associated with the video.
video_info.video_urlDimension
The URL where the video can be accessed for playback.
viewsMetric
The total number of times a product listing or shop page has been viewed.
weightMetric
The weight of the item in kilograms (KG).