Product Priced by Attributes - how to set all products to "no"?

[elegantgowns]

I've had my zen cart store for a few years & my husband does the programming for me. When first starting out, I mistakenly thought that in the product page, "Product Priced by Attributes" should be marked yes if there are price differences for certain attributes. I just noticed last night that on SOME products (not all) in the store it is showing the price as the base price + $10 (the added amount from the attribute options). On others, it is not doing this.

For Example:
http://www.elegantgowns.com/store/ca...-veil-7-251-ct
On the above product, I have the base price set as $20.00, 2 attributes (White, Ivory) add no cost, but the rest add $10.00. The price is showing on the website as $30.00. When you add to the cart, it shows $20.00 if you choose white or ivory. Other attributes it shows $30.00. (so the shopping cart end is correct, product page is wrong).

versus:
http://www.elegantgowns.com/store/ca...ding-veil-2834
Base price is accurately showing as $62.00 & shopping cart price is correct too regardless of choosing attributes that change the price or not. I'm not sure why the pricing is working in this category and not the veils as shown in the first example.

Okay, getting to the point here is my question:
Is there a way to set all the products back to "NO" for Product Priced by Attributes........or will I have to go in, one by one, and change each product? I have over 900 active products (with many more out of stock) so I am hoping there is a relatively quick fix.

Thanks in advance.

[Ajeh]

If you want to make it so that ALL Products are set to:
Priced By Attribute: NO

you can backup your database, then run this command in the Tools ... Install SQL Patches ...

UPDATE products SET products_priced_by_attribute= 0;

[Ajeh]

Just peeking at your site ... I see you have the price prefix of + or - or nothing ...

Now, as the - subtracts from the Product Price and the + or blank add to the Product Price ... do you also need a magical method to update all of the price_prefixes to + for adding where they are NOT already set to - to subtract?

[elegantgowns]

Re: first post, will hand that off to hubby to work on, thanks for the quick reply.
Re: second post:

Just peeking at your site ... I see you have the price prefix of + or - or nothing ...

Now, as the - subtracts from the Product Price and the + or blank add to the Product Price ... do you also need a magical method to update all of the price_prefixes to + for adding where they are NOT already set to - to subtract?

what would it do to update all the price prefixes with +?
.....
I just checked and the attributes that do NOT add/subtract from the cost show +0.00 (looks like that is the default?)

Sorry, I'm a little confused about what this would do.

[Ajeh]

On the links you posted, if you look at the Attributes some are -$X.XX some are +$X.XX and some are $X.XX ...

All of the ones set to either + or blank on the prefix are adding to the Product Price ...

For clarity, shouldn't the ones that read $X.XX really be +$X.XX so the customer knows the amount is being added to the Product Price?

[elegantgowns]

ding ding ding, light goes off -- that must be what the issue is! I was telling my husband that I had just checked the prices in December & they were right & I couldn't figure out why all of a sudden they were wrong. This week I added 10 new colors & must have not had the + pre-filled, so that is what messed it up. Thank you for catching that as I think that will be the fix. I'll figure that out next (aggrivating to have to go back & figure out adding the + to all those attributes, but at least now I know I'm not going crazy).

Thanks again for your support!

[Ajeh]

The Prefix is more of a visual thing ... the Price by Attribute can mess up the pricing ...

+ or blank prefix will add a value to the Product Price ...

- prefix will subtract a value from the Product Price ...

This is also a good time to review the Known Bug Fixes at:
http://www.zen-cart.com/forum/showthread.php?t=82619

as well as the Security Patches and Updates at:
http://www.zen-cart.com/forum/showthread.php?t=131115