The following is a detailed description of the different types of files in data exchange:
Field Name | Required | Data Type | Character Limit | Description | Whether to allow modification when updating the product |
---|---|---|---|---|---|
Category ID | Yes | text | See accepted values | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. You can check the category id online: https://seller.doba.com/ds/goods/category/code/check?siteId=, or download the full category: https://seller.doba.com/dataExchange/download |
No |
SPU Code | Yes | text | 40 | 1. Products with the same SPU Code are regarded as parent-child products, that is, variant products. 2. Please make sure the SPU code is accurate as it's unable to be changed after the product is submitted. |
No |
Product Name | Yes | text | 200 | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. | Yes |
Brand | No | text | 50 | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. | Yes |
Variation Theme 1 | Yes | text | 40 | If a product has multiple parameters, such as Color, Size, etc., you can use Variation to add them. If not, just enter Default. Variants with the same SPU Code must have the same Variation Theme. |
No |
Variation Value 1 | Yes | text | 60 | If a product has multiple parameters, such as Color, Size, etc., you can use Variation to add them. If not, just enter Default. | No |
Variation Theme 2 | No | text | 40 | No | |
Variation Value 2 | No | text | 60 | No | |
SKU Code | Yes | text | 40 | Please make sure the SKU code is accurate as it's unable to be changed after the product is submitted. | No |
Ship from Country/Region | Yes | text | See accepted values | Please make sure the "Ship from Country/Region" is accurate as it's unable to be changed after the product is submitted. Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. A "Ship from Country/Region" field, “Anticipated Income" field, "Inventory Qty" field and "Shipping Fee Template" field must be specified for each SPU added. Accepted values: CN US AU GB CA ES JP IL HK DE |
No |
Anticipated Income (US$) | Yes | decimal | 2 decimal places | Please enter the price of the item without platform commission/markup. | Yes |
Inventory Qty | Yes | integer | 9 | The quantity available/on hand to be shipped that can be Shipped from Country/Region. | Yes |
Shipping Fee Template | Yes | text | See accepted values | Please enter the name of the shipping template Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. You can check the Shipping Fee Template name online: https://seller.doba.com/ds/freight, if there is no template available, please add one first. |
Yes |
MSRP | Yes | decimal | 2 decimal places | Manufacturer Suggested Retail Price. | Yes |
MAP (Minimum Advertised Price) | No | decimal | 2 decimal places | Minimum Advertised Price. | Yes |
Product Images 1 | Yes | text | See accepted values | Use a full image URL to instruct Doba to download the image from a remote location, each SKU requires at least one product image. Supported image types are: JPG, JPEG, PNG and GIF within 15M. |
Yes |
Product Images 2 | No | text | Please fill in a full image URL . Supported image types are: JPG, JPEG, PNG and GIF within 15M. |
Yes | |
Product Images 3 | No | text | Please fill in a full image URL . Supported image types are: JPG, JPEG, PNG and GIF within 15M. |
Yes | |
Product Images 4 | No | text | Please fill in a full image URL . Supported image types are: JPG, JPEG, PNG and GIF within 15M. |
Yes | |
Product Images 5 | No | text | Please fill in a full image URL . Supported image types are: JPG, JPEG, PNG and GIF within 15M. |
Yes | |
Product Images 6 | No | text | Please fill in a full image URL . Supported image types are: JPG, JPEG, PNG and GIF within 15M. |
Yes | |
Additional Product Images | No | text | This field is used to add more images to each SKU, and up to 14 URLs are allowed to be uploaded in this field. 1.Use(; ) to add multiple values. 2.Supported image types are: JPG, JPEG, PNG and GIF within 15M. |
Yes | |
UPC | No | integer | 20 | Universal Product Code/US Based barcode. | Yes |
ASIN | No | text | 20 | Amazon Standard Identification Number | Yes |
Product Details | Yes | text | 40000 | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. Summary of the product information and/or specifications.Valid HTML is allowed, please note: 1. Only support uploading your own pictures. 2. Make sure to close all tags. |
Yes |
Processing Time (business days) | Yes | integer | 1 | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. It is recommended to ship within 2 days (not exceed 15 days). |
Yes |
Shipping Limitations | No | text | See accepted values | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. Accepted values: Unlimited Sensitive Product Self-Defense Weapons Cutting Tools Imitation Gun Accessories Fragile Vulnerable Pure Lithium Ion 965 Lithium Ion 966 Built-In Lithium Ion 967 Pure Lithium Metal 968 Lithium Metal 969 Built-In Lithium Metal 970 Other Pure Batteries Other Built-In Batteries Other Matched Batteries Lead-acid batteries Portable Power Source High Power Batteries (>100 w) Alkaline Batteries Built-in lithium ion with mobile power function With Powder With Cream With Oily With Gas With Liquid With Combustible Solid With Colloidal With Magnetic Pure liquid Woodiness Infringing Product Imitation Brands Imitation Shapes Electronic Cigarette E-Liquid Wire Rod Memory Device Nebulizer MOD Metal Device Laser Sex Toys With weak magnetic Suspected dangerous products Medical equipment Slingshot |
Yes |
Prohibited Marketplace | Yes | text | 200 | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. Accepted value: Unlimited Amazon eBay Newegg Walmart Overstock Wish AliExpress Wayfair Other Use(; ) to add multiple values, eg. Amazon; eBay; Warlmart |
Yes |
Packaging Size-Length | Yes | decimal | 2 decimal places | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. Must be a number between 0.01-999,999.99. |
Yes |
Packaging Size-Width | Yes | decimal | 2 decimal places | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. Must be a number between 0.01-999,999.99. |
Yes |
Packaging Size-Height | Yes | decimal | 2 decimal places | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. Must be a number between 0.01-999,999.99. |
Yes |
Packaging Size Unit | Yes | text | See accepted values | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. If not filled in, the system will default to "in.". Accepted values: in cm |
Yes |
Packaging Weight | Yes | decimal | 4 decimal places | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. Must be a number between 0.0001-999,999,999.9999. |
Yes |
Packaging Weight Unit | Yes | text | See accepted values | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. If not filled in, the system will default to "lbs". Accepted values: lbs kg |
Yes |
Product Size-Length | No | decimal | 2 decimal places | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. Must be a number between 0.01-999,999.99. |
Yes |
Product Size-Width | No | decimal | 2 decimal places | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. Must be a number between 0.01-999,999.99. |
Yes |
Product Size-Height | No | decimal | 2 decimal places | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. Must be a number between 0.01-999,999.99. |
Yes |
Product Size Unit | No | text | See accepted values | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. If not filled in, the system will default to "in.". Accepted values: in cm |
Yes |
Product Weight | No | decimal | 2 decimal places | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. Must be a number between 0.0001-999,999,999.9999. |
Yes |
Product Weight Unit | No | text | See accepted values | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. If not filled in, the system will default to "lbs". Accepted values: lbs kg |
Yes |
Keywords 1 | Yes | text | 50 | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. Keywords for your SKUs search. |
Yes |
Keywords 2 | No | text | 50 | Yes | |
Keywords 3 | No | text | 50 | Yes | |
highlights 1 | No | text | 500 | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. A short description to show the characteristics of this product. |
Yes |
highlights 2 | No | text | 500 | Yes | |
highlights 3 | No | text | 500 | Yes | |
highlights 4 | No | text | 500 | Yes | |
highlights 5 | No | text | 500 | Yes | |
Parameters Name 1 | No | text | 40 | Variants with the same SPU Code must have the same value. If they are different, value of the first item under this SPU will default to the SPU's value. A "Parameters Name" field and "Parameters Value" field must be specified for each attribute added. A maximum of 20 sets of parameters can be added to a product. Example attributes: color, size, material, etc. |
Yes |
Parameters Value 1 | No | text | 60 | Yes | |
Parameters Name 2 | No | text | 40 | Yes | |
Parameters Value 2 | No | text | 60 | Yes | |
Parameters Name … | No | text | 40 | Yes | |
Parameters Value … | No | text | 60 | Yes |
Field Name | Required | Data Type | Character Limit | Description | Example |
---|---|---|---|---|---|
Order ID | Yes | integer | 14 | Doba's supplier order id. | 21080293914099 |
Service Provider | Yes | text | 160 |
Carrier used for shipment.
1. A single service provider is allowed to enter a maximum of 160 characters.
2. If you need to upload multiple service providers, please separate them with (, ). Up to 20 values are allowed.
3. Service Provider and Tracking No. need to be uploaded one to one.
|
Single: UPS Ground Multiple: UPS Ground, UPS Ground |
Tracking No. | Yes | text | 50 |
Tracking number for the package
1. A single tracking No. is allowed to enter a maximum of 50 characters.
2. If you need to upload multiple tracking No., please separate them with (, ). Up to 20 values are allowed.
3. Tracking No. and Service Provider need to be uploaded one to one.
|
Single: 1Z6V540V123456789 Multiple: 1Z6V540V123456789, 1Z6V540V987654321 |
Field Name | Required | Data Type | Character Limit | Description | Example |
---|---|---|---|---|---|
sku | Yes | text | 40 |
Please make sure the SKU code is accurate. Only one valid promotion can be set for a SKU. |
ABC123 |
ship_from | Yes | text | 2 |
Only two-characters national code is allowed, accepted values: CN US AU GB CA ES JP IL HK DE |
US |
anticipated_income_at_sale_price_delivery | Yes | decimal | 2 decimal places |
Special deal price for delivery to be offered during certain timeframe. At least one of anticipated_income_at_sale_price_delivery and anticipated_income_at_sale_price_pick-up must be entered. Please enter the sale price of the item without platform commission/markup. |
14.99 |
anticipated_income_at_sale_price_pick-up | No | decimal | 2 decimal places |
Special deal price for pick-up to be offered during certain timeframe. At least one of anticipated_income_at_sale_price_delivery and anticipated_income_at_sale_price_pick-up. Please enter the sale price of the item without platform commission/markup. |
10.99 |
start_date_PST | Yes | date | See accepted format |
Date the special pricing begins. Accepted format: YYYY/MM/DD. Year-Month-Day with leading zeros (2023/02/05). The sale_price needs to be set 1 day in advance, and the start_date and end_date of all items in a file must be the same. |
2023/02/05 |
end_date_PST | Yes | date | See accepted format |
Date the special pricing ends (goes through 11:59 PM PST that evening). Accepted format: YYYY/MM/DD. Year-Month-Day with leading zeros (2023/03/30). The promotion period needs to be set at least 15 days and at most 180 days. |
2023/03/30 |