CSV Requirements for Adding Custom Products

Requirements for the CSV file process to process multiple items on one upload for Custom Products

Product

Column

Description

Data Requirements

Name

Product Name on the site 

Required, can't be blank or missing

Sauder Cinnamon Cherry 3-Shelf Bookcase

Short Description

Usually a summarized description of the product (2)

Required, can't be blank or missing

3-Shelf Bookcase

Page Content

This is a description of the product

Required, can't be blank or missing

Finished in a handsome Cinnamon Cherry, this versatile
library will look great in your living room, office,
or even your bedroom.

Page name (url)

Auto-created by name of product. Leave blank

Leave blank

Page title

Leave blank or use Product Name for this

Not Required

Page keywords

Leave Blank or Use Short Description or Page Keyword

Not Required

Page descriptions

Leave Blank or Use Short Description or Page Keyword

Not Required

Attributes - Color

Attribute #1 of Product - Example Color. Change in the column  Will affect filters

See DiB Catalog category for examples

Not Required

Attributes - Weight

Attribute #2 of Product - Example Weight. Will affect filters

See DiB Catalog category for examples

Not Required

Attributes - Power Type

Attribute #3 of Product - Example: power type. Will affect filters

See DiB Catalog category for examples

Not Required

Attributes - Wheel Size

Attribute #4 of Product - Example wheel size. Will affect filters

See DiB Catalog category for examples

Not Required

Attributes -  Height

Attribute #5 of Product - Example Height. Will affect filters

See DiB Catalog category for examples

Not Required

Categories Assignment

Example: Housewares > Furniture > Tables, Chairs, Benches

Required, can't be blank or missing

Select a category the product should live under from the DiB catalog at www.doitbest.com. 

Must match exactly

Images

The first image will be the product items on the listing and the first one to show.

Required for an image to show in catalog

You can add additional images to the product by adding another column called "Images".

Optional process to upload images: If images will be uploaded, a Dropbox folder will be assigned.

Image size must be ------ 

Image can be manually uploaded later

 

Reference to item

Example: Sauder Cinnamon Cherry 3-Shelf Bookcase

Leave Blank

Item

Name

Important: Needs to be the same as the Product Name

Required, can't be blank or missing

SKU

Example 403193

Item SKU

Required, can't be blank or missing

DIB ITEM#

DiB Item Number

Leave Blank

UPC

Item UPC - 12 - 14 Digit Assigned UPC 

Required, can't be blank or missing

This is how the item matches to POS

Short Description

Suggestion: Use Product Short Description for this

Not Required

Example: 3-Shelf Bookcase

Not Required

Details

Suggestion: Use Product Page Content for this

Required, can't be blank or missing

Unit Type

Example: Ea.

Not Required

Package Qty

Example: 1

Not Required

Shipping

Leave blank

Leave Blank

Pricing

Normal Retail Price

Example 34.99

Required, can't be blank or missing

Prop65Warning

Text of the Prop65 Warning, leave blank if one doesn't exist

Not Required