The following table contains specific information about setting up your CSV file before importing special pricing products into Oracle CRM On Demand. This information supplements the guidelines given in the topic Field Type Guidelines for Importing Data. First, you must review the following import information before performing an import.
Default Special Pricing Product Field Name
|
Data Type
|
Maximum Length
|
Comments
|
Authorized Cost
|
Number
|
22
|
The partner's price that is under negotiation for the special pricing request.
|
Competitor Name
|
Varchar
|
100
|
The name of the competitor for the request.
|
Competitor Partner
|
Varchar
|
100
|
The name of the competing partner.
|
Competitor Product
|
Varchar
|
100
|
The name of the competitor's product.
|
Competitor Product Price
|
Number
|
22
|
The price of the competitor's product.
|
Currency
|
Varchar
|
20
|
None
|
Description
|
Varchar
|
250
|
None
|
MSRP
|
Number
|
22
|
The manufacturer's suggested retail price (MSRP) in the currency used.
|
Other Competitive Information
|
Varchar
|
250
|
Any other information regarding competitive product offerings, for example, special price justification, and so on.
|
Product
|
Varchar
|
15
|
The name of the product for the special pricing request.
|
Purchase Cost
|
Number
|
22
|
The price that the partner originally paid to purchase the product.
|
Quantity
|
Number
|
22
|
The expected quantity of products that will be sold under this request.
|
Requested Cost
|
Number
|
22
|
The reduced price that the partner requested.
|
Requested Resale Price
|
Number
|
22
|
The resale price at which the partner wanted to sell the product.
|
SP Request
|
Varchar
|
15
|
The special pricing request that this special pricing product is associated with.
|
Suggested Resale Price
|
Number
|
22
|
The resale price suggested by the brand owner.
|