I have 3 pricelists for a company as follows:
- Wholesale bulk (Whole cases are sold to large retailers)
- Wholesale less than a case( Cases are broken up for smaller retailers)
- Retail (price direct to consumer)
My question is this, how do I define the different price lists as I have to do a CSV import of over 2400 items? Normally pricelists have rules that define the markup as a formula from the cost or the previous pricelist. The problem is that the difference in pricing does not follow a fixed markup across the entire product range. For eg. lists will have the following price structure:
- Item A- Cost $1.00 Price 1: $1.50 Price 2: $1.75 Price 3: $2.25
- Item B- Cost $2.00 Price 1: $2.50 Price 2: $2.75 Price 3: $3.25
- Item C- Cost $6.00 Price 1: $8.50 Price 2: $9.75 Price 3: $12.25
- Item D- Cost $4.00 Price 1: $5.50 Price 2: $6.75 Price 3: $8.25
As you can see there is no fixed %markup. Pricing is done according to market dictates. It is a competitive market with price fluctuations according to supply and demand.