Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 3 of 3

Thread: Custom Pricing unique by customers

  1. 04-15-2009, 11:58 AM #1
    Kirk48906 is offline Member
    Join Date
    Jan 2009
    Posts
    67

    Default Custom Pricing unique by customers

    We want to get our customers to start ordering via the website. We have a standard list price for all our items, but almost every customer has unique pricing for a specific item(s) for them and it is possible that no one else would have that same pricing. IE a bolt could list for $5.00, customer "A" pays $4.25, "B" pays $3.95, and "C" pays $0.50 for that unit. We have over 250,000 items that we currently have in testing on the website * the 8,000 customers we have = a huge databse of specific pricing (no not every item for every customer is priced at a custom level, but it is still big)

    Our AS400 maintains each price for each customer and tracks price changes for us. An account manager for a specific customer might break from MSRP and quote a price based on min quantity, case size, etc.

    We want to push customer info from the AS400 to the website via WSI, creating the account, and then set then set each customer's custom on line price to match the AS400's pricing on a daily, even hourly basis via WSI again.

    How can this be accomplished in 8.0.1.2?
  2. 04-16-2009, 07:59 AM #2
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    You would have to assign each customer that gets special pricing to a customer level and then set up extended pricing for each level.
    ECommerce Shopping Cart
  3. 01-12-2011, 03:01 AM #3
    JustBen is offline Junior Member
    Join Date
    Nov 2008
    Posts
    17

    Default Ideas

    Any one have any better ideas for handling this? We have several thousand customers and several thousand products and eight different base price levels.

    Ideally a customer would belong to one of the eight base customer levels and could also have certain individual products that could also have individual prices.

    Could you perhaps give me a list of the methods and stored procedures that would need to be modified in order to implement this modification?