Explanation of Product Comma Delimited Expanded & General FTP Files

 
 

Description

Example

Data Type

item_id

Internal Item identifying number

44601054

integer

qty_avail

Quantity available on the item

20

integer

stock

Stock of the item (in-stock, out-of-stock, discontinued)

in-stock

string

product_status

Status of the product on Doba

in-stock, out of stock, discontinued

string

title

Name of the item

Measuring Cup

string

item_name

Name of the item

Measuring Cup

string

drop_ship_fee

What the supplier charges to dropship the item(s)

5.95

currency

ship_cost

The item's expected shipping cost in a single item order.

4.99

currency

map

Minimum Advertising Price set by the Manufacturer

220.00

currency

price

Price of the item

223.58

currency

custom_price

The price the retailer sets for the item

240.99

currency

prepay_price

Price of the item if ordered using Doba PrePay

217.19

currency

min_street_price

The price most people retail the item for 

245.00

currency

msrp

Manufacturer Suggested Retail Price

20.99

currency

supplier_deal_price

Price of a item that currently has a deal on it

Normal Price: 30.00

Deal Price: 12.00

currency

available_from_date

Date the deal on the item begins

5.01.2020

integer

available_to_date

Date the deal on the item ends

5.30.2020

integer

product_sku

Unique identifier for the product

EFL1011

string

item_sku

Unique identifier for the item

BM102589

integer

mpn

Manufacturer Part Number. This field is for the exact MPN as provided by the manufacturer including all dashes, spaces, and underscores

123456

integer

upc

Universal product code

842822184007

integer

isbn

International Standard Book Number

ISBN 817525766-0

integer

asin

Amazon Standard Identification Number

B00NGIXAXW

string

ean

European Article Number

5901234123457

integer

manufacturer

Manufacturer of the product

Microsoft

sting

brand_name

Brand name of the product

Xbox

sting

case_pack_quantity

The amount of items in a case pack

6

integer

supplier_id

Internal Supplier identifying number

1000001533

integer

supplier_name

Name of the supplier in doba

UNFI

string

categories

item's category

Apparel, shoes & jewelry||Apparel||Women||Outerwear

string

images

URLS of the images of the products

https://d1k0ppjronk6up.cloudfront.net/products/1000001001/amazon_hom_gj_hom11625854011_nancy01327.jpg

string

ship_alone

Does the supplier ship each item separately?

0 = No

1 = Yes

0

boolean

ship_freight

Does the supplier ship item via freight carrier?

0

boolean

ship_width

Width of shipping package

5.23

integer

ship_length

Length of shipping package

11.5

integer

ship_height

Height of shipping package

3.5

integer

ship_weight

Weight of shipping package

4

integer

item_dim1

Height of the item

20.5

integer

item_dim2

Width of the item

4.25

integer

item_dim3

Depth (Length) of the item

7.14

integer

"item_weight"

Weight of the item

12.76

decimal

case_pack_dim1

Height of the case pack

15.5

string

case_pack_dim2

Width of the case pack

3.75

integer

case_pack_dim3

Depth (Length) of the case pack

14.31

integer

max_ship_single_box

The maximum number that can be combined in one box for shipping

1

integer

est_avail

The date more quantity of the item is estimated to be available

2021-01-20

integer

qty_on_order

The quantity ordered by other retailers that are pending—as in not yet processed by the supplier

4

integer

shipping_origin_country

Country the item is shipping from

China

string

est_delivery_over_12_days

When item delivery is 12 days or longer

Is over: 1

Is not over: 0

integer

product_data_change_date

Date product data was changed

2.12.18

date

item_info_change_date

Date information on the item was changed

4.15.18

date

product_discontinued_date

Date the product was discontinued?

6.20.2020

date

item_discontinued_date

date when item was discontinued

2021-01-20

date

product_last_update

Last updated date/time of the item

2020-01-20 07:10:06.0

integer

item_last_update

last date item was updated

2021-01-20

date

product_create_date

Date the product was created on Doba

10.12.16

date

item_create_date

Date the item was created on Doba

Womens Clothing

string

item_quantity_change_date

Date the quantity changed

12.14.18

date

item_last_processed_date

Date the item was last processed

5.16.19

date

is_customized

indicates whether any data has been edited internally by Doba

0

boolean

country_of_origin

Country the item originated from

China

string

condition

Condition of the item

New

string

warranty

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

details

Supplemental description field from the supplier about the product

Batteries Included

string

attributes

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

description

Description of the item

This oil diffuser is handmade in ceramic by the artisans of India and features a beautiful leaf cutout that reflects a beautiful aura. 

string

folder_paths

What inventory list the item is located in

Women's Clothing

string