Understanding the Shopee Template
The information provided is based on Shopee's Education Hub articles related to Bulk import, available here.
Shopee expects different table compositions and behaviours depending on whether the product is a single product or if there are variants under it.
In both cases, the unique identifier for that product is the SKU, which is generated from the Product Name for single products, and the Variant Group Name for variants. Effectively, all variants will hence have the same Product Name and Product Description values.
Variant Products will take multiple rows grouped under the same Variation Integration No. (mapped to Product ID of the variable product), and The parent's data will determine the Product Name and Product Description for the variation group, as well as the Images and other SPU-level fields.
Learn more about Product Variants in Trustana.
Trustana transforms your product information when exporting so it matches their template logic.
Example:
Legend: colouring for highlighting purposes only.
Green shows a Variant Group with many variant products (one per row)
Light blue shows a single product.
Product Data Mapping Logic
Header Name | Description | Single Product | Variable/Variant Product |
Category | Indicate the appropriate category ID for each product. An accurate category ID would boost search results. | Empty | Empty |
Product Name | Product name should include product brand and model. Avoid irrelevant keywords as it may cause the listing to be banned. For multi model products, just fill in product name for the first model and leave blank for other models |
User mapped
| Parent's |
Product Description | A good product description enhances the quality of your listing and increases chances of sales. For multi model products, just fill in product description for the first model and leave blank for other models |
| Parent's |
Parent SKU | Parent SKU is used to identify parent products. It is recommended that you do not duplicate this within your shop. | Empty | Empty
|
Variation Integration No. | Mandatory for products with variations. You may use this as a unique key for a parent product and all its variations. | Empty | Parent's |
Variation Name1 | Please indicate the first variation name, if applicable. | Empty | Parent's |
Option for Variation 1 | Indicate the first variation value. | Empty | Product value for the Tier 1 variation |
Image per Variation | Upload an image per variation, mapped to the variation value in the first variation. | Empty | SKU's |
Variation Name2 | Indicate the second variation name, if applicable. | Empty | Parent's |
Option for Variation 2 | Please indicate the second variation value. | Empty | Product value for the Tier 2 variation |
Price | Input your product price in your local currency. Only positive numbers are accepted. |
|
|
Stock | Input your product stock. Only positive values are accepted. |
|
|
SKU | SKU is a unique identifier for each product variation. SKU value cannot be duplicated in a shop. |
|
|
Size Chart | Please insert size chart template id, you can find the id of size chart in size chart management page | Empty | Empty |
GTIN | GTIN is an identifier for trade items, developed by the international organization GS1. They have 8 to 14 digits. The most common are UPC, EAN, JAN and ISBN. |
|
|
Cover image | Upload the URL of your main product image. The image cannot be duplicated with other listings in your shop. |
|
|
Item image 1 | Enter the URL of this product image |
|
|
Item Image 2 | Enter the URL of this product image |
|
|
Item Image 3 | Enter the URL of this product image |
|
|
Item Image 4 | Enter the URL of this product image |
|
|
Item image 5 | Enter the URL of this product image |
|
|
Item image 6 | Enter the URL of this product image |
|
|
Item image 7 | Enter the URL of this product image |
|
|
Item image 8 | Enter the URL of this product image |
|
|
Weight | Input your product weight. Only positive numbers are accepted. Note: Inaccurate weight may cause inaccurate shipping fees and rejected deliveries by logistic partners. |
|
|
Length | Fill up all the dimensions. Dimensions will be used to calculate the shipping fees for shipping channels. |
|
|
Width | Input your product width. Only 0 or positive numbers are accepted. Note: Inaccurate dimensions may cause inaccurate shipping fees and rejected deliveries by logistic partners.
|
in cm |
in cm |
Height | Input your product height. Only 0 or positive numbers are accepted. Note: Inaccurate dimensions may cause inaccurate shipping fees and rejected deliveries by logistic partners. |
|
|
Doorstep Delivery | Please toggle "on" at least one channel for each item. | On | On |
Pre-order DTS | Pre-order days to ship (DTS) indicates the days required for a pre-order product to be shipped. If left blank, your shipment will be set to non preorder {} days by default. |
|
|
Important columns: when products do not have data
Header Name | Mapped Trustana Attribute | Failover Logic |
Product Name |
| Empty |
Product Description |
| Empty |
Price |
| Empty |
Stock |
| 1 |
Weight |
| Empty |
Image Handling
Uploading your images to Trustana generates a unique URL for each image asset. This is then used when exporting to the Shopee template. Shopee then will download the image from the Trustana server and add it to the correct SKU on your Shopee account, making the image import process completely seamless.
The current export version supports:
1 cover image (
Image1) per from variable/simple product8 Images (
Image2-9 ) per from variable/simple product1 variation image (
Image1) per SKU product within variable product
Shopee Requirements
Format: JPG, JPEG, PNG
Minimum Resolution: 1 x 1 px
Maximum Size: Under 2 MB
Note: The image cannot be duplicated with other listings in your shop
Output File
Filename: Shopee[Currency]-YYYYMMDDHHMMSS.csv
For example, "ShopeeSGD-20231226170123.csv"
This will be downloaded to your browser's configured Downloads folder.
What happens next?
Please follow Shopee's Education Hub Article on how to import products using the Basic Template here.
Once successfully imported, please review the product information before publishing it to your storefront, especially if it was not a first-time import.