Excel Product Posting Guide
Excel Product Posting Guide
Title
Pictures
Measurement Unit
Sold in
Property Information
The properties listed under this block may vary according to the ca
After-Sales and Others Information
Package Weight
Package size-Length
Package size-Width
Package size-Height
Shipping Template
Service Template
Product Group
Sales property information
SKU Information
Product Retail Price
Left in Stock
Product Code
Description Information
Product Description
h Excel
Explaination
Product names are the first thing buyers see. It can influence whether buyers will be attracted to your
detail page. It’s better to keep your products names names accurate, clear and [Link] recommend
you don’t put ‘free shipping’ in your product title. It won’t help customers find the product, and if your
store doesn’t live up to the promise it will be punished.
The general pattern you can follow is: sales mode + product features/material + product name. You can
also include other information like: brand, status, color and type.
Note: If words are repeated often or different words with the same meaning are in the same product
name, it will be regarded as Word Repetition in Product Title and will be punished according to
theSearching Rank Rules
For example, if a product name is “cell phone, mobile phone, mobile telephone, OEM cell phone”, it will
rank on the last pages of the search list as punishment.
Multiple pictures that present your product from all dimensions and showing important details clearly
will increase buyers’ interest. We highly recommend you to upload pictures shot from all dimensions.
Note: Be alerted that pictures you upload can’t be of restricted productsor pictures that violet other
people’s property [Link] theft is highly prohibite
The minimum unit quantity for the products you are selling, such as piece or set
The minimum sales unit, this field may vary depending on the measurement unit you selected.
The properties listed under this block may vary according to the category you selected, please make sure all the mandatory f
By_Order:
For example, you have 10 products in stock, all 10 have been ordered, but only 4 of these orders have
been paid. This still means you have 10 – 10 = 0 products available. The advantage of this method is
that you will always be able to guarantee your buyers product availability, and no orders need to be
cancelled because you have run out of stock. However, you run a risk of showing that you have no more
products available, while in fact still have enough.
By_Payments:
Let’s use the same example. You have 10 products in stock, all 10 have been ordered, but only 4 of
these orders have been paid. Now, your product page will show that you have 10 – 4 = 6 products
available. The advantage of this method is that you will always be able to sell all your products.
However, you run a risk of overselling, which may lead to cancelled orders and unsatisfied customers.
Order shipment time calculation method:The order shipment time starts after the buyer has
successfully placed the order and auditing of the payment information is completed. The shipping
button appears at this time.
For example, if the delivery time is set for 3 days, the shipping information must be filled out within 3
work days (not including holidays) after the buyer payment is successful and the shipping button has
appeared.
For reference:
1) If an order is successfully made at 17:00 (Beijing time) on Thursday, and a 3 day shipment time is
set, then shipment must be started before 17:00 on Tuesday.
2) If an order is successfully made at 1:00 (Beijing time) on Sunday, and a 1 day shipment time is set,
then shipment must be started before 1:00 on Monday.
Note: Please set the delivery time cautiously to avoidOrders Not Fulfilled
The Weight of the package. Please write the size and weight of the package correctly to avoid
theshipping cost and business loss due to wrong information.
The Length of the package. (Unit: cm)Please write the size and weight of the package correctly to avoid
theshipping cost and business loss due to wrong information.
The Width of the package. (Unit: cm)Please write the size and weight of the package correctly to avoid
theshipping cost and business loss due to wrong information.
The Height of the package. (Unit: cm)Please write the size and weight of the package correctly to avoid
theshipping cost and business loss due to wrong information.
The logistics methods supported by your product. You can set multiple sets of logistics templates and
set one as the default.
The service supported by your product. You can set multiple sets of service templates and set one as
the default.
Product groups help buyers search for their desired products and they also streamline your product
management. You can set many product groups as needed and put similar products in the same group.
Depending on different category, the sku property may vary. PAY ATTENTION: you need to fill in all the combination of SKU
For example: color and size are filled as sku property, and you have blue and green for color, M and L for
1>. You must fill 4 combinations with different rows to publish product: Blue-M, Blue-L, Green-M, Green
2> If you only fill Blue-M and Green-L, system will not allow posting such product;
3> if you don't have Blue-L and Green-M in above case, you can set the [left in stock] field to 0;
Price,Price refers to the retail price shown in the detail page. (transaction fee included)
Note: Please set the product price cautiously. Cheating behaviors such as Very Low Product Price, Very
High Product Price and Very Low Product Price with Very High Shipping Cost are forbidden.
For example, if you post a phone with the price of $0.1/piece. It will be regarded as Very Low Product
Price.
The common stocks of products (excluding activities Stock, events require a single stock in the product
registration activities in other settings); buckles will be a real common stock when the buyer to
complete the payment. When there are multiple product SKU, need to set stock levels for each SKU.
When the product is sold out (means the stock is empty), the product will be "in sales" , but the buyer
can not make a purchase and add to cart.
You can put your own SKU code here
The detailed product description is one of the most important tools for a buyer to quickly find deep
information about the product. An excellent product description can increase buyers’ shopping desire
and speed the decision-making process.
1. Major indicators and functions of the products (such as a size chart for clothes or a model and
configuration parameters for electronics)
USC-1234 Yes
Yes
Yes
piece/pieces Yes
Sold by minimum unit of measure Yes
by_order No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
19.99
Yes
999
No
Yes
Product Information
Product Information
Product Information
Product Information
1005003059494800
200003824 239213593 CBE UK Tuya WiFi Socket Double U
1005003527560060
200003824 239213593 TUYA 9W WiFi Smart Light Bulb E
1005002577019530
200003824 239213593 Mini DIY Module Wifi Light Switch
1005003591184976
200003824 239213593 New Smart Wireless Remote Switc
1005002914204079
200003824 239213593 CBE Wifi Tuya Smart Wall Switch S
1005002577045359
200003824 239213593 Smart Plug WiFi Socket EU 16A Po
1005003081906820
200003824 239213593 CBE WiFi Smart Plug EU 16A Tuya
1005002941867566
200003824 239213593 New Tuya Smart Home Plug 16A UK
1005002891392119
200003824 239213593 CBE New WiFi Smart Sockets 16A
1005003561231420
200003824 239213593 16A EU Smart Wifi Power Plug wit
1005003071883916
200003824 239213593 eWeLink DIY Smart Light Switch W
1005002576982864
200003824 239213593 E27 Bluetooth Smart LED Bulb 9W
1005002697615164
200003824 239213593 CBE DIY Smart Home Switch Wifi R
1005002712191434
200003824 239213593 CBE E27 Smart Bulb WIFI Bluetoo
1005002577008597
200003824 239213593 Smart Bulb Control Lamp LED RGB
1005002577103002
200003824 239213593 New DIY Smart Wireless Remote Sw
1005002577072166
200003824 239213593 9W WiFi Tuya Smart Light Bulb E
1005003478175176
200003824 239213593 CBE New WiFi Smart Light Switch
1005002804875854
200003824 239213593 CBE Tuya Smart Home Magic WiFi
1005003619944308
200003824 239213593 Smart Home Wifi Wireless Remote
1005002667678927
200003824 239213593 E27 Smart Bulb WiFi Control Lam
1005002921354702
200003824 239213593 CBE UK Tuya WIFI Smart Wall Sock
1005002577022516
200003824 239213593 16A Smart Home Sockets Power Str
1005002986354974
200003824 239213593 CBE Tuya US Plug In-wall Smart Ke
1005002907636715
200003824 239213593 CBE Tuya WiFi Version Smart Rocke
1005004201388068
200003824 239213593 E27 Bluetooth Smart Light LED Bu
1005003038831232
200003824 239213593 Smart Home WiFi Wall Light Switc
1005002933259855
200003824 239213593 CBE Tuya eWelink Smart Home WiFi
1005004662175485
200003824 239213593 Tuya WiFi Smart Life LED Dimmer
1005002979819094
200003824 239213593 Smart Devices US WIFI Wall Touch
1005003224828436
200003824 239213593 CBE Tuya WiFi Smart Switch In-Wal
1005003077598297
200003824 239213593 CBE Tuya Smart Switch EU Plug Wi
1005006166197871
200003824 239213593 WiFi Smart Home Thermostat Heati
1005003678777697
200003824 239213593 16A Tuya Mini WiFi Switch Module
1005006165343384
200003824 239213593 Smart Home Zigbee Bridge Gateway
1005004683078499
200003824 239213593 Tuya Smart WiFi Boiler Switch Wa
1005004168078101
200003824 239213593 WiFi Smart Light Bulb E27 LED R
1005004661873769
200003824 239213593 Tuya Smart WIFI LED Dimmer Switc
1005002808937397
200003824 239213593 CBE WiFi Smart Home Sockets Bra
1005002954501204
200003824 239213593 Smart Home WiFi Wall Touch Switc
1005002783223189
200003824 239213593 CBE WIFI Smart Wall Socket 10A U
1005002980026352
200003824 239213593 CBE 10/16A US Plug Smart Sockets
1005002787593773
200003824 239213593 CBE 4/5/6 Gang Smart Wall Touch
1005002782797089
200003824 239213593 2 Pcs Tuya 1/2/3 Gang 2 Way Smar
1005002768159971
200003824 239213593 CBE Smart Home WiFi Wall Glass P
1005002990051900
200003824 239213593 Smart Home New WiFi US/AU 2-way
1005002805241024
200003824 239213593 2pcs/Set Tuya Smart Switch 1/2/3
1005003052736366
200003824 239213593 CBE Wall Smart Life APP WiFi dim
1005002979868796
200003824 239213593 CBE Graffiti Wall Smart Life APP
1005002767817319
200003824 239213593 CBE WiFi Wall Touch Switches Sur
1005003041734753
200003824 239213593 CBE Smart Home WiFi Remote Contr
Product Information Product Information
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
Product Information Product Information
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
Product Information Product Information
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
Product Information Product Information Product Information
en_US CBE
en_US CBE
en_US CBE
en_US CBE
en_US CBE
en_US CBE
en_US CBE
en_US CBE
en_US CBE
en_US CBE
en_US CBE
en_US CBE
en_US CBE
Property Information Property Information Property Information
Switches
Ride On Switches
Switches
Smart Plug
Smart Plug
EU02
Switches
Slot Switches
wifi Switches
Switches
Flashing
Smart Switch
Ride On CBE 12
Flashing
Flashing
Flashing
Flashing
2 CHANNELS
3 channels
2 CHANNELS
3 channels
3 channels
3 channels
3 channels
3 channels
2 CHANNELS
3 channels
3 channels
6 channels
3 channels
3 channels
3 channels
3 channels
2 CHANNELS
3 channels
3 channels
3 channels
Property Information After-Sales and other information
CE by orders paid
CE by orders paid
by orders paid
CE by orders paid
7 0.350
3 0.070
7 0.450
7 0.100
3 0.100
3 0.075
3 0.100
7 0.400
7 0.350
7 0.450
7 0.200
7 0.200
7 0.280
7 0.200
7 0.200
7 0.500
7 0.040
5 0.500
7 0.100
7 0.200
7 0.300
7 Custom weight not Support!
7 0.300
7 0.200
7 0.200
7 0.280
7 0.200
7 0.400
7 0.160
7 0.300
After-Sales and other information
After-Sales and other information
15 9
12 6
7 5
7 4
12 8
11 10
9 7
10 10
11 10
10 7
7 5
11 10
7 5
11 6
11 10
7 5
11 10
12 8
11 6
7 5
11 10
15 9
11 10
12 8
12 8
11 10
12 8
10 10
20 10
15 9
11 10
9 9
15 5
10 8
5 2
20 10
11 6
20 10
11 10
15 9
5 10
7 6
15 8
10 10
10 10
12 8
10 10
9 9
10 12
10 10
12 8
After-Sales and other information
After-Sales and other information
4
6
1005002948492312
200328240 239213593 Smart Home wifi Z-wave Smart Curta
Product Information Product Information
[Link] [Link]
Product Information Product Information
[Link] [Link]
Product Information Product Information
[Link] [Link]
Product Information Product Information Product Information
by orders paid
After-Sales and other information
After-Sales and other information
7 0.200
After-Sales and other information
After-Sales and other information
9 9
After-Sales and other information
After-Sales and other information
*Service template
Service Template for New Sellers
1005002740785507
200003818 239213593 CBE Smart Home Zigbee Set Bridg
1005003453294752
200003818 239213593 New Smart Home Zigbee Bridge Ga
Product Information Product Information
[Link] [Link]
[Link] [Link]
Product Information Product Information
[Link] [Link]
[Link] [Link]
Product Information Product Information
[Link] [Link]
[Link] [Link]
Product Information Product Information Product Information
WI-FI
Property Information Property Information
Ready-to-Go CE,FCC,RoHS
Ready-to-Go CE,FCC,UL,NONE
Property Information Property Information
No
Property Information After-Sales and other information
by orders paid
After-Sales and other information
After-Sales and other information
7 0.200
11 11
20 15
After-Sales and other information
After-Sales and other information
1005002594430235
301102 239213593 Wireless IP Camera Outdoor 4G Si
1005006172119912
301102 239213593 CBE Auto Tracking Hd Network Came
1005006167982963
301102 239213593 CBE Smart Wifi Ip Camera Wireless
1005003499524883
301102 239213593 5MP 2MP Wireless 4G Wifi Securi
1005004168062786
301102 239213593 Wireless IP Camera Outdoor 4G Si
Product Information Product Information
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
Product Information Product Information
[Link] [Link]
[Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
Product Information Product Information
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
[Link] [Link]
Product Information Product Information Product Information
1080P(Full-HD) No
2.0 Megapixels No
1080P(Full-HD) No
Property Information Property Information Property Information
Side
Side 0.05Lux
Side
Property Information Property Information Property Information
2MP
5MP
64G H.264,H.265
128G
128G
128G H.264,H.265
128G H.264,H.265
Property Information Property Information
IR Distance(m) Certification
15 CE,FCC
10M CE
5-8m CE,FCC,UL,NONE
8-10m CE,FCC,UL
0-30M CE
20M CE
Property Information Property Information Property Information
WHITE
Yes
Yes
No
Yes
Property Information Property Information
Android,IOS other
Google Assistant
Android,IOS other
Android,IOS other
Property Information Property Information
AI Functions IP Rating
DC5V
2X
DC12V 2A
NONE DC5V
Property Information Property Information
1CH RCA
1CH RCA
8W CMOS
CMOS
5V
2.5-4.5W CMOS
10W CMOS
Property Information Property Information
Omnivision -10°-60°
-10°-60°
Sony/索尼
-10°-70°
Property Information Property Information
Normal
Plastic Normal
Normal
Metal Normal
Property Information Property Information
360°
360°
180°
360°
360° NONE
Property Information Property Information
0°-360°
0°-360°
other 10W
Property Information After-Sales and other information
by orders paid
by orders paid
by orders paid
7 1.980
7 0.800
7 0.800
7 0.960
3 1.980
After-Sales and other information
After-Sales and other information
35 23
20 10
18 15
21 20
20 30
After-Sales and other information
After-Sales and other information
15
4000337832481
200004336 239213593 Smart home video doorbell wireless
1005003515199516
200004336 239213593 New Video Doorbell Smart Home 108
1005002584885335
200004336 239213593 Self Power Wireless Doorbell Kineti
Product Information Product Information
[Link] [Link]
[Link] [Link]
[Link] [Link]
Product Information Product Information
[Link] [Link]
[Link] [Link]
[Link] [Link]
Product Information Product Information
[Link] [Link]
[Link] [Link]
[Link] [Link]
Product Information Product Information Product Information
Alarm Certification
Yes CE
Yes CE,EPA,FCC
Yes CE,FCC
Yes CE,RoHS
Property Information After-Sales and other information
by orders paid
After-Sales and other information
After-Sales and other information
7 0.330
7 1.000
7 0.300
After-Sales and other information
After-Sales and other information
19 10
15 17
15 12
After-Sales and other information
After-Sales and other information
*Service template
Service Template for New Sellers
Product Information
Product Information
Product Information
Product Information
Service and logistics templates are vital in e-commerce as they standardize procedures for consistent customer service and logistics handling. Setting multiple or default templates allows for flexibility in logistics services to cater to different product requirements while maintaining operational efficiency. They enhance sellers' ability to provide reliable, timely delivery and customer service .
When setting appropriate shipping lead times, consider order receipt confirmation, payment auditing time, delivery delays, internal processing efficiency, product type logistics needs, and customer expectations. Additionally, ensure that shipment commitments factor in non-working days to avoid unfulfilled orders and customer dissatisfaction .
The 'By_Order' method ensures consistent product availability by deducting stock as soon as an order is placed, preventing cancellations due to unavailable stock. However, it may falsely show zero availability even if unpaid orders exist. The 'By_Payments' method, meanwhile, deducts stock only after payment completion, showing accurate stock levels for sales, but it risks overselling and resultant cancellations if stock is not managed carefully .
To optimize product titles and avoid penalties in search rankings, ensure that the titles are accurate, clear, and concise without repeating words or using synonyms unnecessarily. Avoid phrases like 'free shipping' unless assured, as failing to meet this promise can result in penalization. Follow a pattern including sales mode, product features/material, and product name while optionally adding brand, status, color, and type .
In setting retail prices, avoid extremely low or high product prices, or very low prices paired with high shipping costs, as these practices are considered cheating and are disallowed. Set prices thoughtfully to reflect fair market value and include transaction fees to ensure profitability while maintaining compliance .
Product groups help by organizing similar products together, which streamlines both the management process and assists buyers in finding related products more easily. This categorization supports operational efficiency and enhances the shopping experience, potentially increasing sales .
Accurate specification of package size and weight is crucial to avoid errors in shipping cost calculations and prevent potential business losses due to misquoted logistics expenses. It ensures fair charges for shipping services and helps maintain customer satisfaction by preventing unexpected charges or delays .
Using restricted product images or those that violate others' intellectual property rights can lead to significant penalties on online sales platforms. This practice may result in product delisting or bans, which can negatively impact sales and reputation. It's critical to adhere to image use guidelines to maintain compliance and ensure fair representation and promotion of products .
A maximized consumer interest through detailed product descriptions involves including primary metrics and functions, offering a size chart for apparel, and model or configuration specs for electronics. Additionally, it should feature at least five diverse images and information on after-sales service, creating a comprehensive insight into the product for potential buyers .
Incomplete SKU combinations in product listings can hinder the product posting process, as all SKU variations (like color and size) need full representation. Missing combinations will prevent system acceptance, and hence listing, of the product. If certain combinations are unavailable, setting the stock to zero is necessary to enable listing without actual availability .