Nov 17 2021 05:09 AM
Hope some one can help please. I have attached a sample spreadsheet.
I have a catalogue of Products from a supplier.
Each product has numerous costs and what I want to achieve is to be able to enter a profit amount for all the products in one cell which will therefore populate the amount throughout the catalogue to all the catalogue.
With doing this the Buy it Now Price will be automatically updated to accommodate the profit.
Products with a Selling Price Less than £9.99 Selling will need an option to include Postage of £3.54 if not the Buy it now will need to be increased to accommodate the profit.
The Fields
Are as follows
Item Name | Sales Description | Selling Price | Postage Cost Under 9.99 | RRP | Sell Price inc VAT | Buy it now | BIN inc ebay fees | Promo Fee | Actual Profit | Products <9.99 With out £3.54 postage | Profit Margin | Category | Package Weight | Package Length | Package Width | Package Height | SKU | EAN | Stock On Hand | Quanity | |
100 Hour Burn Time Pilla r Candle | A white, pillar candle | 3.73 | 3.54 | 9.99 | 4.48 | 9.99 | 1.78 | 0.20 | 3.54 | 0.20 | 1.96% | Candles | 0.8 | 9 | 9 | 18 | S-CD5269 | 5024418717300 | 45 | 3 | |
100 Hour Burn Time Pillar Candle, Vanilla Fragrance | A white, pillar candle with a single wick in white. | 3.86 | 3.54 | 10.99 | 4.63 | 10.99 | 1.93 | 0.22 | 6.36 | 0.89 | 8.11% | Candles | 0.9 | 9 | 9 | 18 | S-CD5386 | 5024418750710 | 42 | 3 | |
10x14cm Tree Life Trinket Dish | This glass trinket dish | 2.9 | 3.54 | 8.99 | 3.48 | 10.99 | 1.93 | 0.22 | 5.51 | 2.04 | 22.73% | Tree Of Life | 0.42 | 12 | 17 | 3 | S-TL0063 | 5024418285069 | 36 | 3 |