Create Customer Pricing file

<< Click to Display Table of Contents >>

Navigation:  Process > Customer Functions > Customer Pricing :: Discount Levels >

Create Customer Pricing file

This process will create a file containing the customer-specific prices for the given customer account range and customer levels.  The file created is a simple CSV (Comma-separated values) file containing the customer account number, item code, discount percentage, exclusive and inclusive pricing and the expiry date of the price (as shown below). In some cases, this has been used for uploading to a website storefront that requires customer-specific pricing.

 

customer_pricing_File

 

"Account","Item_Code","Discount_%","Discounted_Excl","Discounted_Incl","Expire_Date"

"ABB029","ACC/LOC",5.0000,2850.0000,3249.0000,20120418

"ABB029","SOHO/200",5.0000,4626.5000,5274.2100,20120418

"ABB029","VEC/400",5.0000,3633.7500,4142.4800,20120418