Product price based on excel table virtuemart
This project received 1 bids from talented freelancers with an average bid price of $80 USD.Get free quotes for a project like this
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
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online