Multiple price per products

[Andrew J]

It is possible to assign multiple prices to one product.

 

Pe:

 

SOFTWARE BLAH-BLAH

Full price:

Upgrade:

Educational:

[GNA]

I have the same problem:

 

Deposit

Balance

add ons etc.

 

There is a contribution to change the product attributes, but it also means setting the item price to zero then pricing using the product attributes - not ideal.

 

G

[godsilla]

I have a similar problem. I need my store to have different prices depending on which affiliate refers the customer to the store. Any ideas?

 

Landon

[GNA]

Anyone?

[gooofygrl9]

I need the same thing for my cart!

 

I have product that comes in different sizes which would need different prices plus I have combos that may have up to 3 items that the customer would need to choose attributes for!

 

Help!! :blink:

[Guest]

You guys could try the Master Products contribution - there are threads in the Contributions forum channels.

 

Matti

[GNA]

Eventually sorted it !

 

heres what I did:

 

1) downloaded the actual attributes price contribution.

 

2) Changed the attributes ordering code from a contribution I found in a forum as reproduced below:

 

- all my product attributes are displayed in the correct order. Here is the ONLY change required, in the file catalog/product_info.php :

 

Change this code:

 

 

CODE

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . $products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'");

 

 

to this (change is at the very end of the last line, an additional bit of code):

 

 

CODE

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . $products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "' order by pa.options_values_id");

 

 

All the other stuff seems like overkill to me. All you have to do is make this change and then make sure you create (or recreate) your attribute values in the order you want them to appear. (Or, edit their ID numbers in the database if they're already created and in the wrong order.) If you wanted to sort by something else you can do that too, just change the field that it's sorted by, the other choices would be alphabetical by the value name or sorted by the attribute price.

 

After reading many posts on this problem I think this is a quick and simple solution that doesn't run the risk of messing up the files or causing bugs.

[GNA]

Next bit:

 

Now I started to add the attributes - the first one having the value "please select" with a value cost of zero.

 

Then add your other attributes (without the + sign) and hey presto - it works!

 

G