osCommerce Unique Customer Group Pricing
Separate Pricing Per Customer Modification
- Custom Pricing Project
I've been using the Separate Pricing Per Customer (SPPC Contribution #716*) system, and it works great.
However, my site needs to support an unlimited number of custom price groups (100s) and SPPC is not really set up to handle that.
Project Goals: Provide custom pricing and simple administration for an unlimited number of customer groups.
NOTE: I like the SPPC contribution because it carries the custom price through the site.
However, if necessary, we can do a separate modification that only displays the custom prices on one page.
View/Edit custom Prices for a Group
1. Select a Group
2. Group Info appears:
Page Info: Customer Group Name, Customer Name.
Display table of all Custom Priced Products for that group
Table Columns: Product ID, Product Name, Normal price, Custom price, Button-Edit, Button-Remove
Function: Edit Prices
Function: Delete products from table.
Add Products with Custom Price
Function: Select a Product to add to list by product ID or product drop down.
Function: Enter a price
Product is added to above list of products for that group.
When customer logs into site they see a list of their products and special prices with buy-now button.
Unfortunately this issues has just come to the forefront, and is extremely urgent.
If you can't get this done within one week, please don't bid.
*[url removed, login to view],716
**If you have suggestions to improve this modification, I'm open to some project scope expansion.
Please see spec sheets.
One of my clients who needs this mod is a lumber yard. They will be issuing quotes, but they are time sensitive because of changing prices. Someone I need to include a quote number and expiration date into this system....not for all but
IF expiration date and quote number exists show it.
I suppose, ideally, if the quote is expired that it would eliminate the BUY NOW links or something so they can't buy at that price then show instructions to contact their sales rep to get new pricing.
To clarify: I already have a quoting system in place. This mod will enable sales reps to post a list of custom priced products for each customer group. When the customer logs into their account, they will see the list of products and their prices.
mySQL/Linix (Typo in original posting)