Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Product Fields: Import Preparation

The following table contains specific information about setting up your CSV file before importing products into Siebel CRM On Demand. This information supersedes the guidelines for field data types, for further information, see Field Type Guidelines for Importing Data. You must review the following import information before performing an import.

NOTE: The Default Field column in this table contains only the initial (default) name for each field. It does not contain any names the user has changed.

Default Product Field Name

Data Type

Maximum Length

Comments

Body

Picklist

30

Specific to Siebel CRM On Demand Automotive Edition.

Default valid values: Coupe, Salon, Cabriolet, Hatchback, Wagon, Sedan

Category

Picklist

30

Default valid values: Clothing, Tractor, SUV, Interior, Heavy Truck, Exterior, Electrical, DriveTrain, Light Truck, Passenger Car

Controlled

Check box

n/a

 

Dealer Invoice Price

Currency

15

Specific to Siebel CRM On Demand Automotive Edition.

Description

Text

250

 

Door

Picklist

30

Specific to Siebel CRM On Demand Automotive Edition.

Default valid values: 3 Door, 2 Door, 4 Door

Engine

Picklist

30

Specific to Siebel CRM On Demand Automotive Edition.

Lot # Tracking

Check box

n/a

 

Make

Picklist

30

Specific to Siebel CRM On Demand Automotive Edition.

Model

 

Picklist

30

Specific to Siebel CRM On Demand Automotive Edition.

Orderable

Check box

n/a

 

Parent Product

Text

100

 

Part #

Text

50

 

Price Type

Picklist

30

 

Product Category

Text

100

 

Product Currency

Currency

15

 

Product Name

Text

100

Required field by default.

Product Type

Picklist

30

 

Revision

Picklist

30

 

Serialized

Check box

n/a

 

Status

Picklist

30

 

Sub Type

Picklist

30

 

Therapeutic Class

Picklist

30

Specific to Siebel CRM On Demand Life Science Edition.

Transmission

Picklist

30

Specific to Siebel CRM On Demand Automotive Edition.

Trim

Picklist

30

Specific to Siebel CRM On Demand Automotive Edition.

Type

Picklist

30

 

Year

Number

50

Specific to Siebel CRM On Demand Automotive Edition.

Related Topics

Field Type Guidelines for Importing Data

Importing Your Data


Published 05/11/2007