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 = No

1 = 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