Configurable options base price not showing up

[DolphinITS]

Hello all,

 

I am not 100%-sure if this is a bug, but it looks like one to me. I did a search on the forum before posting, but could not find anything about this problem. If I failed to find an already existing post, please let me know.

 

I am refering to the following feature in the version 5 release guide:

 

One of those is with regards to how product options are displayed. Now rather

than just listing the base price of the product (which can often be zero if a price

is based purely on options), it will instead show the total value of all the

default config options being selected. So a product with a $0 base price, and a

$50 minimum configurable option will now show a pricing label of "Starting

from $50.00" indicating a truer reflection of price, and that there are options

to be selected that may increase it.

 

I have set up a product with the following settings:

Setup fee (One time/monthly): 3.90

Price (One time/monthly): 0.00

All other billing cycles set to 0.00 (setup) or -1.00 (recurring)

Payment type set to recurring

 

Then I went ahead and set up configurable options for this product, with the following settings:

Opion type: quantity

Minimum required: 1, Maxmimum: 100

Setup (One time/monthly): 3.90

Pricing (One time/monthly): 3.90

All other billing cycles set to 0.00 (setup) or -1.00 (recurring)

 

What happens now is that when I go to the cart page, I get:

Starting from $0.00 USD Monthly

 

Whatever I do, it does not show the minimum price based on the lowest possible config options price. It always shows 0.

 

Although I did not change the cart I used (tried different ones, to be sure), I also tried it in the demo on the WHMCS page. But it does not work there, too.

 

Question is: am I doing something wrong, or is it really a bug?

 

Thanks in advance. Btw, wonderfull product you got there, saves us a lot of work!

[othellotech]

without "seeing" the product and config options it's difficult to guess if you've simply mis-ticked something rather than it being a bug - there are "issues" with WHMCS interpretation of a from price

 

try running this - replace $period, $currency and $productId ...

 

SELECT p.id, c.prefix, c.suffix,
       IF(a.addon IS NULL, prPR.$period,
          (prPR.".$period." + SUM(a.addon))) as finalprice,
       prPR.currency
FROM tblproducts p
JOIN tblpricing prPR ON
     (prPR.type = 'product' AND prPR.relid = p.id) LEFT JOIN tblproductconfiglinks pcl ON
     pcl.pid = p.id
LEFT JOIN tblproductconfiggroups pcg ON
     pcg.id = pcl.gid
LEFT JOIN (
      SELECT DISTINCT pco.gid, pco.id, min($period) as addon,
                      prCO.currency
      FROM tblproductconfigoptions pco
      JOIN tblproductconfigoptionssub pcos ON
           pco.id = pcos.configid AND pcos.hidden = 0
      JOIN tblpricing prCO ON
           prCO.relid = pcos.id
      WHERE prCO.type = 'configoptions'
      GROUP BY pco.gid, pco.id, prCO.currency
     ) a ON a.gid = pcg.id AND prPR.currency = a.currency JOIN tblcurrencies c ON c.id = prPR.currency WHERE p.id = $productId
AND   prPR.currency = $currency
GROUP BY p.id, prPR.$period

and report what it says

 

*DO IT ON A TEST COPY OF YOUR DB*

[DolphinITS]

Hellp,

 

thanks for your reply. The result shows:

 

id = 65

prefix =

suffix = EUR

finalprice = 3.90

currency = 1

 

So it looks good, just what I need. But it does not show up for the client when he selects the product. Any other ideas?

[othellotech]

ok, so the db sounds setup right, sadly to be more specific I'd need to see a s/shot of the product pricing page - you can email it to me, or open a ticket with whmcs - i wont be offended if you trust them not some randombody on a forum

[DolphinITS]

Sending you message right now, with a link to the site. Thanks a lot for your help.