Multiple Prices

[bmartinho]

Hello to all.

I need to have different prices based on customer address. The address can be linked to zones but I'm not finding anywhere to store different prices based on address.

Any ideas how it can be achieved?

Thanks and best regards,

Bruno Martinho

[david-ebt]

What is the reason for the address-based pricing? How many different prices do you have? Does you site require users to login or register before you display product pricing? Are the price differences a percentage of one price or extremely variable per product?

Some sites have used shipping rates to adjust the total cost. Would that work?

Knowing those answers can help suggest a solution.

[bmartinho]

The problem is that the price for the islands is different than the mainland.

In some cases they are the same, others they aren't. Prices for region are given by the company's ERP so we can't have that business rule in ablecommerce. Users will login and see prices according their address.

The requirement is to be possible changing thoses prices in ablecommerce after the ERP integration.

Any ideas?

Thanks,

Bruno Martinho

[david-ebt]

We had a situation that needed dynamic pricing based on the customer. That pricing was only found on a remote system and could change at any time. The site also displayed pricing on the search results and category results pages. So we had to modify the pricing function to make a webservice call to the external system with the customer info, the address and a list of products. The webservice returned the pricing for those products for that customer. The site has several thousand products so we limited the number of products on the results pages so we could limit the load on the external ERP system.

It sounds like your situation may be a bit less complex but the basic solution will be similar. You may be able to store the pricing in a new table in AbleCommerce SQL Server database and update it nightly from your ERP system. You'll need to modify any page that displays pricing so that it gets the price from your new tables. We also had to set every product to use variable pricing so that we could insert the correct price into the ac_BasketItems table instead of having Able use the standard price. We turned off the normal CONLIB interface that asks the user for a price when variable pricing is turned on.

I hope this gives you some ideas. Maybe someone else has found a simpler approach.