Pricing Rules

[kastnerd]

Is there an easy way to edit allot of pricing rules? I want t o have 3 rules per product, I can do it manually but i was wondering if there is some way to use DataPort or connect directly to the database.

[mazhar]

If many products will share similar pricing rules then one way could be to first create the pricing rules for a product and then for each new product that will have similar pricing rules create a duplicate of the that product and change its info.

[heinscott]

Not sure if this would work, but, if you are trying to update existing products, you might be able to first find the productId in question, load that product, and then just add the special pricing rule(s) to your other products. For instance, if you wanted to add the same pricing rule to ALL products, you could run (assuming your product id in question is 123):

Code: Select all

    Product p = ProductDataSource.Load(123);
    SpecialCollection sc = p.Specials;
    ProductCollection AllProducts = ProductDataSource.LoadForStore();
    foreach (Product _Product in AllProducts)
    {
        if (_Product.ProductId != p.ProductId)
        {
            foreach (Special s in sc)
                _Product.Specials.Add(s);
            _Product.Save();
        }
    }

Maybe mazhar could tell whether or not this would work before you try it live.
Hope this helps.

Scott

[paularonw]

Has any progress been made on this topic? I've been using Data Port successfully to upload/modify products, categories and users, but I can't see a way to update pricing rules for products other than manually changing it on each of (over 200) products...

[kastnerd]

I have not found a good way to edit pricing rules. Any suggestion would be nice.

[Alan Rich]

I am using MS Access (2007) with an ODBC link to the SQL database to update the ac_Specials table directly. I am still testing, but so far it appears to provide the "batch" update functionality that I will need.

[kastnerd]

I am using MS Access (2007) with an ODBC link to the SQL database to update the ac_Specials table directly. I am still testing, but so far it appears to provide the "batch" update functionality that I will need.

How did this work for you? Any other idea's to batch update pricing rules?

[kastnerd]

I Am able to open up and edit the "ac7_ac_Specials" Table using Access, This works good, But it only list the products that have speshals allready. Is there a good way to bulk add pricing rules to every product?

[relish1227]

Has anyone used this? http://www.web2market.com/Bulk-Specials ... 38C78.aspx

I just came across it today.

[jmestep]

Yes, I wrote the code and the merchants have been happy with it. For that price, you can hardly go wrong.