hi,
I am using the commerce server 2007. When I run the pipeline, CSF loads all the discounts irrespective of Customer and Campaign of the marketing system. I want to load only the discounts which has only specific customer and campaign. Is it possible in commerce server?
Firstly, the discounts are not reloaded when you run the pipeline. they are loaded once and cached (for the duration specified in your web.config).
That said, if you just want to load a particular customer/campaign's discounts into the cache, you can do this using a custom discount load procedure.
The stored procedure mktg_spRuntimeLoadDiscounts is used by default to load the discounts cache (look up this procedure in the marketing database to see how it loads all customer and campaigns).
You configure the discount system to use your customized stored proc by setting the "LoadDiscountsProcedure" custom property for the discounts cache in the web.config.
Do this by adding a <config> element to the <cache>:
<config><key="LoadDiscountsProcedure" value="myProcedure"/></config>
Note that myprocedure should have the same signature as the default mktg_spRuntimeLoadDiscounts procedure.
Hope that helps,
madhur
