I have a spreadsheet of product data from my supplier I need to upload it to WordPress however the data has many variables so I need to find someone to work the formulas within a spreadsheet to prepare the data for upload.
I am a promotional merchandise supplier each product is made up of the following.
1. Product Unit price - (sliding scale depending on how many person buys) 2. Printing Cost - Upto 5 printing methods per product (each has its own price) Each printing method has set up charges 3. Shipping Charges.
All prices are all inclusive of all fees so the formula needs to work everything out.
The next step is once the products price has been calculated our margin needs to go onto it with a pricing matrix (that needs to be created) i.e. Under £400 spend 30% margin added to final product price (inc shipping) £500 - £1,000 spend 27% margin added etc