Skip to content
Book a demo

Connect documentation

All documentation
Documentation

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.

FieldAdverity UI nameType
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.

booking_snDimension
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.

can_partial_cancel_orderDimension
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.

validation_typeDimension
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).