Product price based on excel table virtuemart

In Progress

Description

I have a jewellery website which sells wedding rings, I have a table with all the weights, widths and finger sizes. I need to have a system similar to a competitors site where the price is calculated based on a few factors mentioned above. The site that I am basing it on is

[url removed, login to view]

I am attaching a sample for the table. i want to be able to upload a excel file which can then have a global setting for a per gram price for each metal ie platinum, 18ct white gold and 18 carat yellow gold.

The website will need 3 attributes to enable it to calculate a price so the customer must choose if they want a light,medium or heavy weight ring,

then they must choose a width ie 2mm, [url removed, login to view], 3mm, 4mm, 5mm,6mm, 7mm or 8mm

then they must choose a finger size this will run from h, i, j, k, l, m, etc

once all these have been input they will correspond to a gram weight within the table the gram weight will be a number ie 4.4 (4.4 grams) some rings will not display a weight this is because they are not available in the selection they have choosen.

For an example look at the table attached

I choose Platinum

profile D

Medium Weight

3mm width (this is the left column)

now I choose my finger size P

so the gram weight for this particular ring is 5.9

this [url removed, login to view] must now be multiplied by the gram weight within the global settings ie £90 per gram which would equal £531 then I want to add a discount for the online price so need it to take off a % that can be changed on a daily basis.

Skills: AJAX, Excel, Javascript, PHP, Virtuemart

See more: virtuemart product price table, excel table virtuemart, www excel, will price, table customer, setting profile, sample product profile, price file, my excel online, global p, customer table, carat, $50 k, excel display price based product, table virtuemart, customer profile example, wedding table, take off, table, shape file, ring gold, price excel, price category, online excel, excel table

Project ID: #949348

1 freelancer is bidding on average $80 for this job

gracebasilior

Hi, I can do this for you!

$80 USD in 1 day
(71 Reviews)
5.5