Closed

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
Employer working
Skills Required
Project Budget
N/A
Total Bids
1
Project 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.

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online