Remove/modify display of PRICE_PREFIX?

[crosswraith]

Seems like nobody has asked about this before, so I started a new thread, which I is posted in the right place (hmm, maybe a "coding customizations-forum" would be more relevant ).

I'm trying to modify/remove the display of PRICE_PREFIX. When you create menu's using for example radio buttons (which involves attributes), the parenthesis and +"price" is automatically added to every attribute-menu-choice. I'd like to remove the parenthesis, display some other "symbols" and remove the +sign.
Now PRICE_PREFIX has a functionality as well, and especially important is that I don't mess up with the database entries when doing this customization. Therefore the + has to be added into the database when new attributes are made. So I was wondering what file to edit (avoiding DB trouble ), and where that line of code can be found.

Thanks in advance!

[Kim]

Peek in the attributes template and module.

[crosswraith]

Peek in the attributes template and module.

hmm couldn't see the + and/or the parenthesis in that file. But maybe I've misunderstood what PRICE_PREFIX really is. Ok whatever this + sign and parenthesis is called, where is it located (where can I remove it from displaying completely on the "product info pages" that the customers see when looking at single 1 product).

[Ajeh]

If you don't want to see the + on the price ... then just do not add it to the Attribute ...

+ and blank are Adding to the price
- is subtracting from the price

[crosswraith]

If you don't want to see the + on the price ... then just do not add it to the Attribute ...

+ and blank are Adding to the price
- is subtracting from the price

Allright, that means it's added into the database. And with that + would be the same as no symbol at all?

[Ajeh]

That is correct ...

Product Price 15.00
Price Prefix +
Price 10.00

Price would be $25.00

Product Price 15.00
Price Prefix (blank)
Price 10.00

Price would be $25.00

Product Price 15.00
Price Prefix -
Price 10.00

Price would be $5.00

[crosswraith]

Yup I just found it :

the + sign is stored in the table called: zen_products_attributes
In the column called: price_prefix

Now I was wondering if I can just do a massupdate (I know how to do this massupdate, but is it safe to only change this value, or more values in other places have to be changed as well) in the database, by simply replacing all the + in that column (price_prefix)? Would I have to remove the + in any other place inside the database?

[Ajeh]

You can replace all the price_prefix with blank where price_prefix = +

UPDATE products_attributes SET price_prefix = '' WHERE price_prefix = '+'; 

Then if you use any Priced by Attribute products, you would want to run the Tools ... Store Manager ... Update Product Price Sorter ...

[crosswraith]

You can replace all the price_prefix with blank where price_prefix = +

UPDATE products_attributes SET price_prefix = '' WHERE price_prefix = '+'; 

Then if you use any Priced by Attribute products, you would want to run the Tools ... Store Manager ... Update Product Price Sorter ...

Thank you , but with this do you mean that this is the only place in the DB where the update is needed (just want to make sure so I avoid DB problems later on )?

Where can I remove that parenthesis that is displayed, see example (+$5.00).
Doing a search through all files, looking for "()" is not possible since there is the price in between . And "(" will be encountered in almost every PHP-file since the "()" is a very common part of the PHP coding-itself.

[Ajeh]

You would need to edit the module for the attributes ...
/includes/modules/attributes.php

and copy to your templates and overrides directory:
/includes/modules/your_template_dir/attributes.php

Searching on:
' (
) '

should help you locate where those are set on the price ...