Product Sell Group/Vendor Pricing Structures File for Strategic Pricing

After exporting your data and working directly with Strategic Pricing Associates on your pricing analysis, Strategic Pricing Associates sends you a Product Sell Group/Vendor file that includes the following data. When you upload this file, the system creates and updates customer category/size sell matrix cells.

Note: If you subscribe to any Data Service, you receive this file from Strategic Pricing Associates one time only. Subscribe to the Pricing Service to continue to receive updates to this file.

If you subscribe to the Silver Data Services tier, the system processes only Core A and Core B rows in the file, and skips any Non-Core C and Non-Core D rows. If you subscribe to the Gold or Platinum Data Services tier, the system processes all rows in the file.

Excel Column	Column Name	Description
A	Import Set Number	Unique identifier for the row of data.
B	Company ID	All, to indicate all territories and branches.
C	Product Group ID	Eclipse product sell group to which the product belongs.
D	Supplier ID	Eclipse vendor ID as assigned in Vendor Maintenance for the vendor assigned to the product sell group for Strategic Pricing.
F	Customer Size	The size of the customer: Very Tiny, Tiny, Small, Medium, Large, or Huge.
G	Core/Non-Core	Indication about whether the pricing applies to products with Core A and Core B core statuses, or Non-Core C and Non-Core D statuses. Note: If your Data Services tier is Silver, the import only imports rows for Core products.
H	Factor Type	Pricing factor, which affects the Strategic Pricing calculation and whether the system prices using the Strategic List Price or the Strategic Cost. Possible values include: D - (Discount) The system processes it to use the Strategic List Price minus the value listed in the Factor field. M - (Markup) The system processes it to use the Strategic Cost plus the value listed in the Factor field. G - (Gross Margin) The system processes it to use the Strategic Cost and uses the value in the Factor field as the GP value.
I	Factor	The value to add or subtract as the discount or addition to the calculation.

Uploading the contents of this file creates or updates matrix cells specific to a sell group. The pricing basis used for the cells is determined by the Factor Type in the import. If the Factor Type is D, the system uses Strgc List as the pricing basis. If the Factor Type is M or G, the system uses Strgc Cost as the pricing basis.