sixfive

I've a need to know the config option price on a product where it is charged based on a quantity. In our case it's number of seats @$9.40/seat/month. The Data Feeds return a $0 value for us, because the pricing table has no values https://docs.whmcs.com/system/data-feeds/#Product_Pricing_and_Currency so I am working through how to get this in our own module. What I have so far, by passing in the productID is this: SELECT tblproductconfigoptions.id AS configoptionid, tblproductconfigoptions.optionname, tblpricing.monthly AS monthly_price FROM tblproductconfigoptions JOIN tblproductconfiglinks ON tblproductconfigoptions.gid = tblproductconfiglinks.gid JOIN tblpricing ON tblproductconfigoptions.id = tblpricing.relid WHERE tblproductconfiglinks.pid = 62 AND tblpricing.currency = 1 AND tblpricing.type = 'configoptions'; This is returning 0 in monthly, because the rows returned are NOT the rows where I can see 9.40. When I look for the 9.40 monthly as follows SELECT currency,id,relid,monthly FROM `tblpricing` where monthly = 9.40; It shows me the rows are actually id's that are very different, and the relid is nothing like what I am expecting. The relid = 17 on the admin UI (or cid) The naming matches on cid = 17 in tblproductconfigoptions (see the URL in the popup) But the pricing shows up in relid = 85 What's going on here?

Hi @sol2010 I've started using this module, and the fees show up in the invoice no issues. However when the Daily automations send the invoice for payment in Stripe, the fee added by the module is not being charged. This means we are getting every invoice paid, but it's missing the stripe fee. Super odd that the Stripe Gateway is not getting the invoice totel, including the fee. WHMCS v8.6.1 on PHP 8.1 if that may make a difference. We are in Australia and are allowed to on charge fees. Can you help me work out why that would be please?