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 |
||
|
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 |
Required, can't be blank or missing |
|
Item SKU |
||
|
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 |