| Print Open PDF Version of Online Help

##### Special Pricing Product Fields: Import Preparation 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. NOTE: The Default Field column in this table only contains the initial (default) name for each field. It does not contain any names that have been changed for your company in Oracle CRM On Demand. Therefore, if you do not see a specific field when you try to import your data, check with your administrator to determine the new name for the field.
Default Special Pricing Product Field Name | Data Type | Maximum Length | Comments
--- | --- | --- | ---
Authorised 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.
#### Related Topics See the following topics for related information: Field Type Guidelines for Importing Data Importing Your Data

Published August 2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.