If you subscribe to the Customer/SKU tier, Strategic Pricing Associates determines a net price for products for each customer based on the customer's sensitivity to pricing changes. After exporting your data and working directly with Strategic Pricing Associates on your pricing analysis, Strategic Pricing Associates sends you a Customer/Product Assignments file that contains a net price suggestion for each customer and product that were included in your export, including the following data.
|
Excel Column |
Column Name |
Description |
|
A |
Import Set Number |
The unique identifier for the row of data. |
|
B |
Company ID |
All. Indicates all territories and branches. |
|
C |
Customer ID |
Eclipse customer ID as defined in Customer Maintenance. |
|
D |
Item ID |
Eclipse product ID as defined in Product Maintenance. The product ID must match that of one in Eclipse to create the matrix cell. |
|
E |
Core Status |
Core A, Core B, Non-Core C, or Non-Core D. The core status is included for your reference only and is not included in the upload. |
|
F |
Price |
The net price for the product for the customer. |
Uploading the contents of this file creates or updates customer to product matrix cells with a net price for each of your customers included in the export. The pricing basis for all uploaded cells from this file default to Strgc List.
See Also: