Page 1 of 1
Pricing Rules
Posted: Fri Dec 12, 2008 6:31 pm
by BBHartley
I have 5 prices for each of 1,000 products. I have 5 Groups with one price for each group. The pricing rules feature work exactly as advertised for one part manually edited in the user interface. I am routinely uploading my catalog with DataPort; however, I can not find where the pricing rules are stored nor a way to upload them. Maintaining these manually is not an option.
Thank you for any guidance.
Re: Pricing Rules
Posted: Mon Dec 15, 2008 6:23 am
by mazhar
Pricing rules are imported/exported under the product data. These rules are stored in ac_Specials database table.
Re: Pricing Rules
Posted: Wed Dec 17, 2008 10:44 am
by mazhar
In order to check the pricing rule data for a product, first create a pricing rule for some product and then export that product into XML. You will found the pricing rule information under
Specials tag in exported product XML, for example
Code: Select all
<Specials>
<Special>
<SpecialId>1</SpecialId>
<ProductId>203</ProductId>
<Price>10.00</Price>
<StartDate>2008-12-18T00:00:00</StartDate>
<EndDate>2008-12-31T23:59:59</EndDate>
<SpecialGroups />
</Special>
</Specials>
Re: Pricing Rules
Posted: Fri Dec 19, 2008 10:25 am
by BBHartley
I am assuming that the <SpecialId>1</SpecialId> must be unique. Is this the case? Is it unique by <ProductID> or for all?
Re: Pricing Rules
Posted: Fri Dec 19, 2008 12:35 pm
by mazhar
Yes SpecialId will be unique.