Product Core Status Assignments File for Strategic Pricing

The Core Status Assignments file provided from Strategic Pricing Associates for upload contains core status assignments for your products. Your service tier determines which data from the Core Status Assignments file is included in the upload, and also determines the refinement of your Strategic Pricing calculations. If your Data Services data has expired, the system uses Core A for all products, regardless of what you upload from the file.

Note: Core statuses per product are included with any Strategic Pricing service tier.

You can change the status assignments in Microsoft Excel before uploading the pricing components into the system, allowing you to review and potentially change any of the data and core status determinations before updating prices. To update product core statuses after you upload the file, you can process another upload, or change the core statuses in Strategic Pricing Maintenance if you are assigned the SPRC.CORE.STATUS.EDIT authorization key, and your data services expiration date has not passed..

Data Services Tier(Silver) - Your upload includes core statuses at the product level. Core statuses apply at the product level only, the customer category does not apply. The upload processes only rows in the file with data in the Item ID and Core Status columns and updates the product to have the core status in the file. See example.

Data Services Tier(Gold) - Your upload includes core statuses by product per customer category. The core statuses apply to all customers assigned a particular customer category (OEM, Reseller, Contractor). The upload processes rows in the file with data in the Item ID, Core Status, and Customer Category columns and updates the product for the customer category to have the core status in the file. The upload also includes these rows if you have the Platinum service. See example.

Data Services Tier(Platinum) - Your upload includes core statuses by product per customer. The core statuses apply to each individual customer. The upload processes rows in the file with data in the Item ID and Customer columns and updates the product for the individual customer to have the core status in the file. See example.

The Core Status Assignments file contains the following data:

Excel Column	Column Name	Description
A	Import Set Number	Unique identifier for the row of data.
B	Item ID	Eclipse product ID, as defined in Product Maintenance.
C	Customer Category	The group the customer belongs to, such as reseller or contractor, as assigned in Customer Maintenance.
D	Company ID	All. Indicates all territories and branches.
E	Customer ID	Eclipse customer ID, as defined in Customer Maintenance.
F	Core Status	Core A, Core B, Non-Core C, or Non-Core D.
G	Core Status Data Expiration Date	Date your Strategic Pricing service contract expires. After your contract expires, all core statuses in the system change to Core A. You can import this file again, however, the core statuses remain Core A.