![doba-logo-flat-small.png]](https://knowledge.dobasuccess.com/hs-fs/hubfs/doba-logo-flat-small.png?height=40&name=doba-logo-flat-small.png){kind=logo}
Product Comma Delimited Export Explanation
Header |
Required? |
Description |
Example |
Data Type |
supplier_id |
yes |
Internal Supplier identifying number |
1000001533
|
integer |
drop_ship_fee |
yes |
What the supplier charges to dropship the item(s) |
5.95 |
currency |
supplier_name |
yes |
Name of the supplier in doba |
UNFI |
string |
product_id |
yes |
Internal Product identifying number |
13549795 |
integer |
product_sku |
yes |
Unique identifier for the product |
EFL1011 |
string |
title |
yes |
Name of the item |
Measuring Cup |
string |
warranty |
no |
Issued to the purchaser of an article by its manufacturer, promising to repair or replace it if necessary within a specified period of time |
TV comes with a one-year warranty |
string |
description |
yes |
Description of the item |
This oil diffuser is handmade in ceramic by the artisans of India and features beautiful leaf cutout that reflects a beautiful aura. |
string |
condition |
yes |
Condition of the item |
New |
string |
details |
no |
Supplemental description field from the spplier about the product |
Batteries Included |
string |
manufacturer |
no |
Manufacturer of the product |
Microsoft |
string |
brand_name |
no |
Brand name of the product |
Xbox |
string |
case_pack_quantity |
yes |
The amount of items in a case pack |
6 |
integer |
country_of_origin |
no |
Country the item originated from |
China |
string |
product_last_update |
yes |
Last updated date/time of the item |
2020-01-20 07:10:06.0 |
integer |
item_id |
yes |
Internal Item identifying number |
44601054 |
integer |
item_sku |
yes |
Unique identifier for the item |
BM102589 |
integer |
mpn |
yes |
Manufacturer Part Number. This field is for the exact MPN as provided by the manufacturer including all dashes, spaces, and underscores |
123456 |
integer |
upc |
yes |
Universal product code |
842822184007 |
integer |
item_name |
yes |
The name of the specific item. If there are no options (i.e. colors, sizes, etc) - may be the same as the title or be left empty (but is a required header). If there are options, then this would be the option title. |
Size - x-small |
string |
item_weight |
yes |
Weight of the item |
12.76 |
decimal |
ship_alone |
yes |
Does the supplier ship each item separately?0 = No1 = Yes |
0 |
boolean |
ship_freight |
yes |
Does the supplier ship item via freight carrier? |
0 |
boolean |
ship_weight |
yes |
The item's shipping weight |
12.76 |
integer |
ship_cost |
yes |
The item's expected shipping cost in a single item order. |
4.99 |
currency |
max_ship_single_box |
yes |
The maximum number that can be combined in one box for shipping |
1 |
integer |
map |
yes |
Minimum Advertising Price set by the Manufacturer |
220.00 |
currency |
price |
yes |
Price of the item |
223.58 |
currency |
custom_price |
no |
The price the retailer sets for the item |
240.99 |
currency |
prepay_price |
yes |
Price of the item if ordered using Doba PrePay |
217.19 |
currency |
min_street_price |
no |
The price most people retail the item for |
245.00 |
currency |
msrp |
yes |
Manufacturer Suggested Retail Price |
20.99 |
currency |
qty_avail |
yes |
Quantity available on the item |
20 |
integer |
stock |
yes |
Stock of the item (in-stock, out-of-stock, discontinued) |
in-stock |
string |
est_avail |
no |
The date more quantity of the item is estimated to be available |
2021-01-20 |
integer |
pending_order_quantity |
no |
How many of this item have already been ordered from supplier, but not yet shipped |
4 |
integer |
qty_on_order |
no |
The quantity ordered by other retailers that are pending—as in not yet processed by the supplier |
4 |
integer |
item_last_update |
yes |
last date item was updated |
2021-01-20 |
date |
item_discontinued_date |
no |
date when item was discontinued |
2021-01-20 |
date |
categories |
yes |
item's category |
Apparel, shoes & jewelry||Apparel||Women||Outerwear |
string |
attributes |
yes |
key/value pairs of attributes of product |
Bottom All Around::=X-Small - 32"Small - 34"Medium - 36"Large - 38"Xlarge - 40"2XLarge - 42"||Chest All Around |
string |
image_file |
yes |
image urls |
https://d10ppjronk6up.cloudfront.net/products/10000000889/029_0_7622161_il_fullxfull_647857408_qy19.jpg |
string |
image_width |
yes |
The width of the image (pixels) |
806 |
integer |
image_height |
yes |
The height of the image (pixels) |
640 |
integer |
additional_images |
no |
list of additional image urls |
https://d10ppjronk6up.cloudfront.net/products/10007498889/029_0_7622161_il_fullxfull_647857708_qy19_front.jpg|https://d10ppjronk6up.cloudfront.net/products/10007498889/029_0_7622161_il_fullxfull_647857708_qy19_back.jpg |
string |
folder_paths |
yes |
What inventory list the item is located in |
Womens Clothing |
string |
is_customized |
no |
indicates whether any data has been edited internally by Doba |
0 |
boolean |