IPrice minimart
powerfull & flexible online Store, price-lists and catalogs for Joomla
Welcome, Guest
Username: Password: Remember me
You can ask about IPrice calculator in this thread before buy a subscription. Please login or register to post message.

TOPIC: Spit out price based on select fields?

Spit out price based on select fields? 2 years 7 months ago #3693

  • mtspinto
  • mtspinto's Avatar
Hi there...Would like to know if possible to do this with the current system you have.

FORM HAS
TYPE (SELECT - 2 products // Individual // Family)
AGE (SELECT - 6 options // <22 // 22-29 // 29-39...)
COVER (SELECT - 5 options // $1000 // $1500 // $2000...)
PREMIUM (text box / div area - displays PREMIUM per month based on selects)

then - would you like to add a family member (extended)
YES // NO

if yes (3rd product will only be available if FAMILY is selected)
AGE (SELECT - 6 options // <29 // 29-39 // 39-49...)
COVER ( SELECT - 5 options // R10000 // R15000 // R20000...)

Possible to add 2 members
AGE (SELECT - 6 options // <29 // 29-39 // 39-49...)
COVER ( SELECT - 4 options // R10000 // R15000 // R20000...)

then ADD premium of prod 2 (family) to prod 3 (family extended)

I have a CSV with all the values hard-coded (no calculations) based on the fields selected.

There are 85 but here's a rundown
TYPE			AGE		COVER		PREMIUM
INDIVIDUAL		<22		10000		40
INDIVIDUAL		22-29		10000		45
INDIVIDUAL		29-39		10000		49
INDIVIDUAL		39-49		10000		51
INDIVIDUAL		49-59		10000		63
INDIVIDUAL		59-69		10000		103
FAMILY			22-29		15000		81
FAMILY			29-39		15000		86
FAMILY			39-49		15000		95
FAMILY			49-59		15000		117
FAMILY			59-69		15000		212
EXTENDED		<22		25000		26
EXTENDED		22-29		25000		58
EXTENDED		29-39		25000		72
EXTENDED		39-49		25000		95...
all i want is to

select individual, 39-49, R10000 and it must show R(51)p/m

OR

select family, 29-39, R15000 and it must show R(86)p/m
AND if i want to add family (EXT)
select <22, R25000 and it must show R(26)p/m
then ADD the family amounts... 86+26 = R(112)p/m
Last Edit: 2 years 7 months ago by mtspinto.
Login or register to post message.
Moderators: support

Subscribe



Subscribe to our newsletter and social networks to be updated with the latest updates.

Login