Freelance
$100
TBD
Sep 14, 2016
upload a spreadsheet to a mysql database (we will do this weekly) that will replace the old database
the columns are Shape, Weight, Color, Clarity, Cut, Price per Carat, Stone Price, and a link to Buy, the rest of the columns will be ignored.
Two columns (stone price and price per carat) will be multiplied by 1.33 or 1.5, selected in the cpanel for this function
when the website user selects multiple attributes (corresponding to column data values) by clicking check-boxes, and then clicks the submit button, a table of diamonds from the database will display matching user's criteria, which can then be sorted by any column. For example, they may check for the "size" 3.00-3.99 carats and check for "color" which can be a range such as D-F and so on.
before the check-boxes appear, they will click on the diamond shape such as "Princess" or "Round" so that their further choices (filters) only apply to that shape
each item will link to our 1shoppingcart.com account where they can purchase. when they successfully purchase, the item should be flagged for deletion.
we need a cpanel thing for manually adding, deleting, or editing and item (row in the database)