How to fill in the Shopee listing template?Definition of Template Items
Item
Description
Condition
SKU
Stock Keeping Unit (SKU) refers to the lowest unit you can sell on Shopee. For example, iPhone 8 is one item, while iPhone 8 256GB and iPhone 8 64GB are 2 different SKUs.
Optional
Parent SKU
This is the identification code you use to manage your products. It is recommended that you do not repeat this in your store.
Optional
Variation Integration No.
Helps the system identify variations from different lines as one item. It is mandatory and cannot be repeated in one template.
Required for products with variations
Weight
The weight of your product will be used to estimate your shipping costs.
Required
Dimensions
Dimensions (e.g., length, width, height) are used to calculate shipping rates for certain logistics channels. Fill in all dimensions or leave the field empty.
Optional
Logistics channels
Logistics channels can be found and enabled through the My Shipping page. Please enable at least one logistics channel.
Required
Images
Images are used to represent your product. You can upload a cover image by entering a URL in the template or uploading it to the unpublished item edit page.
Required
Pre-order DTS
Pre-order Days (DTS) indicates the number of days to pre-order a product. If you leave this blank, your shipment will be set to the default two-day DTS.
To set DTS to Pre-order, find the DTS range for your product category and insert a valid value.
Optional
How do I fill out a listing template?
● Click to exit Protected View.
● The first three rows indicate whether the column is required or optional, what the column is defined as, and what you need to fill in.
● Enter your product details accordingly starting from the fifth row. Each row should represent a specific item.
Do not change or edit these rows:
How to fill in the first level structure product?
For products with one variation type (e.g. size), there should be one record for each variation option (S, M, L)
All versions of the same product should have the same version integration number.
Product Name
Variant Integration Number
Variant Name 1
Variant 1 Options
Variant Image
Variant Name 2
Variant 2 Options
Price
Stock
Huggies Pants
HP405
Size
M Size
Image url 1
65
59
Huggies Pants
HP405
Size
L Size
Image url 2
69
10
Huggies Pants
HP405
Size
XL Size
Image url 3
71
349
How to fill in the secondary structure product?
For products with 2 levels of variations (e.g. different colors and sizes), there should be one record for each variation, and all variations of the same product should have the same variation integration number.
Product Name
Variant Integration Number
Variant Name 1
Variant 1 Options
Variant Image
Variant Name 2
Variant 2 Options
Price
Stock
Korean lace dress
KL23
Colour
Pink
Image url 1
Size
S
88
14
Korean lace dress
KL23
Colour
Pink
Image url 1
Size
M
88
10
Korean lace dress
KL23
Colour
Pink
Image url 1
Size
L
88
25
Korean lace dress
KL23
Colour
Apricot
Image url 2
Size
S
88
0
Korean lace dress
KL23
Colour
Apricot
Image url 2
Size
M
88
3
Korean lace dress
KL23
Colour
Apricot
Image url 2
Size
L
88
0
Tip:
Indicate the stock quantity as 0 to indicate unavailable variations.
The images for each variation are at the first tier variation level. To enable this feature for a product, you need to enter the image URLs for all product versions.
Original details from shopee official website:
HOW TO FILL IN THE TEMPLATEDefinition of template items
Item
Description
Requirement
SKU
Stock Keeping Unit (SKU) refers to the minimum unit you can sell on Shopee. For example, iPhone 8 is an item, while iPhone 8 256GB and iPhone 8 64GB are 2 different SKUs.
Optional
Parent SKU
This is the identi?cation code for you to manage your items. It is recommended that you do not duplicate this within your shop.
Optional
Variation Integration No.
Variation integration no. helps the system to identify variations from different rows as one item. It is mandatory and cannot be duplicated within one template.
Required for product with variations
Weight
The weight of your product
Required
Dimensions
Dimensions (eg length, width, height) may be used to calculate shipping fees for some logistics channels. Either ?ll up all dimensions or keep the ?eld empty.
Optional
Logistics channels
Logistic channels can be found and
enabled via the My Shipping page. Please enable at least one logistic channel.
Required
Images
Images are used to represent your products. You can upload a cover image by inputting a URL in the template or uploading it into an unpublished item edit page.
Required
Pre-order DTS
Pre-order Days to Ship (DTS) indicates the days required for a pre-order product to be shipped. If this is left blank, your shipment will be set to the
default DTS of two days.
To set your ?rst 3 rows indicate whether the column is mandatory or optional, the column’s de?nition, and what you need to ?ll in.
● Input your product details accordingly from the 5th row onwards. Each row should represent one speci?c item.
Do not change or edit these rows:
How to fill in 1-tier structure products?
For products with one variation type (eg size), there should be one record for each variation option (S, M, L)
All variations of the same product should have the same Variation Integration No.
Title
Variation Integration No.
Variation Name1
Option for Variation 1
Image per 59
Huggies Pants
HP405
Size
L Size
Image url 2
69
10
Huggies Pants
HP405
Size
XL Size
Image url 3
71
349
How to fill in 2-tier structure products?
For products with 2-tier variations (such as different colours and sizes), there should be one record for each Variation Integration No.
Title
Variation Integration No.
Variation Name1
Option for Variation 1
Image per Variation
Variation Name2
Option for Variation 2
Price
Stock
Korean lace dress
KL23
Colour
Pink
Image url 1
Size
S
88
14
Korean lace dress
KL23
Colour
Pink
Image url 1
Size
M
88
10
Korean lace dress
KL23
Colour
Pink
Image url 1
Size
L
88
25
Korean lace dress
KL23
Colour
Apricot
Image url 2
Size
S
88
0
Korean lace dress
KL23
Colour
Apricot
Image url 2
Size
M
88
3
Korean lace dress
KL23
Colour
Apricot
Image url 2
Size
L
88
0
Tips:
Indicate stock as 0 for unavailable variations.
Image per variation is at the 1st tier variation level. To enable this feature for a product, you need to input image URLs for all its variations.
Article source: shopee official website