Multiple Quantity Price Table Display

[ojhernandez]

Hello,

I know that I can set different prices depending on the quantity however one thing still puzzles me.

Is there a way to do a "x+" type of pricing. x being the price.

Right now the last tier of pricing for my product is:

11 - 999999 $61.90

I would like to know how to do this without having "999999" in there.

How do I do this?

Thanks,

ojhernandez

[PRO]

Maybe you can do it in the database.

See picture attached. NOW I AM NOT AN SQL GUY, BUT JUST A GUESS.



[attachment cleanup by admin]

[ojhernandez]

I have no such table with that name.

[PRO]

vm_price

[ojhernandez]

I tried this and it didn't work. It just made the new pricing structure:

11-0.

[PRO]

what did you put?

[rb]

This may be a solution.  I tested it a little and it worked for me, but you should test it some more to see if it works in your situation.  Make a copy of, then edit this file:

components/com_virtuemart/themes/default/templates/common/price.tpl.php

Then, just prior to the line:

Code: [Select]

echo $price_table;
insert the following lines so it looks like this:

Code: [Select]

// Change the last row of the quantity pricing from, for example, "10 - 99" to "10+"
$price_table = strrev($price_table);
$price_table = preg_replace( "|>dt<>dt/<\d* - (\d*>dt<.*)|", '>dt<>dt/<+$1', $price_table );
$price_table = strrev($price_table);
//
echo $price_table;

Be sure to put that change to the database table jos_vm_table that you made above back to its original value. Let me know if this template change solves your issue.

[ojhernandez]

This may be a solution.  I tested it a little and it worked for me, but you should test it some more to see if it works in your situation.  Make a copy of, then edit this file:

components/com_virtuemart/themes/default/templates/common/price.tpl.php

Then, just prior to the line:

Code: [Select]

echo $price_table;
insert the following lines so it looks like this:

Code: [Select]

// Change the last row of the quantity pricing from, for example, "10 - 99" to "10+"
$price_table = strrev($price_table);
$price_table = preg_replace( "|>dt<>dt/<\d* - (\d*>dt<.*)|", '>dt<>dt/<+$1', $price_table );
$price_table = strrev($price_table);
//
echo $price_table;

Be sure to put that change to the database table jos_vm_table that you made above back to its original value. Let me know if this template change solves your issue.

rb,

I am sorry that it has taken me so long to reply to your post. This is because I have been very busy and have not had the time to implement you solution.

After doing what you said to do, everything appears to work as expected.

Thank you so much. I greatly appreciate what you have told me.

With Great Thanks,

Ojhernandez