We are looking for someone with experience in Oscommerce to carry out our project for our wholesale jewellery Website.
We have hundreds of products which will grow to over one thousand and more.
Each product will have one to 12 of the following options :
9K Yellow gold
9K Rose Gold
9K White Gold
10K Yellow gold
10K Rose Gold
10K White Gold
14K Yellow gold
14K Rose Gold
14K White Gold
18K Yellow gold
18K Rose Gold
18K White Gold
Some items may have all the options while others may have only one.
Our products' price will need to be updated easily on the fly daily according to the gold fix.
Each option will have a different price which will need to be changed when gold fix changes on a daily basis. We need the gold fix price to be in the admin / back end somewhere where we can change the gold fix price each day and at the touch of a button all prices and options will be changed accordingly.
The selling price is based on a formula where the only variable is the gold fix, however, another element of the formula is the gold weight of the article which varies for the different colours and carats of gold.
We need the base price to default to the 9K Yellow Gold Price, but if a customer chooses another option for the option price to replace the price instead of adding an amount to the base price which is what happens at the moment. We already have installed Product Attributes and Attribute Sets.
In order for us to quickly and easily change the price of every item on our website we will need every item price and option price to be formula based.
Other elements of the formula are : the weight of the item, other fixed manufacturing costs, fixed gemstones cost and our profit margin % which will allow us to arrive at a selling price.
We need to be able to easily change the fixed costs within the formula from time to time.
If you do not understand all the requirements please PM me.