Pricing Rules

[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.

[mazhar]

Pricing rules are imported/exported under the product data. These rules are stored in ac_Specials database table.

[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>

[BBHartley]

I am assuming that the <SpecialId>1</SpecialId> must be unique. Is this the case? Is it unique by <ProductID> or for all?

[mazhar]

Yes SpecialId will be unique.