I am looking to have the following changes made to CubeCart (current version):
1) Wholesale Price stored on the product table.
2) Currency of Origin stored on the product table.
Many of our products are imported directly from international manufacturers. I want to store the wholesale cost in the supplier's currency rather than the store currency. Currency is stored even if the product is locally sourced.
3) Inbound Delivery Cost stored on the product table.
Where products are imported I want to be able to store the cost of importation. Where products ae manufactured this will be set to zero.
4) Retail Pricing changes on the product table.
The retail price of most products is calculated by adding a percentage to the landed price (wholesale cost + inbound delivery cost) of the product. Some products though have a specific retail price. On the product table I want a flag that determines whether the product's Retail Price is calculated or whether it is stored on the product table. On the product table I want the Retail Percentage to be stored.
5) Changes to the displayed price of products on the website.
Retail prices are now dynamic and must be calculated when a product price is displayed on a page. The retail price is now calculated as:
If Percentage Pricing = True:
(Wholesale Price + Inbound Delivery Cost) * Retail Percentage * (1 / Currency of Origin)
If Percentage Pricing = False:
Retail Price * (1 / Currency of Origin)
Outbound Postage and Taxes are in the store currency (local currency) and thus are not affected by these changes.
6) Paypal
All prices displayed to the customer are in AUD.
Paypal must receive the transaction in AUD.
I am happy to answer any questions should the detail here be insufficient to provide a reasonable quote.