Looking for a little advice on the available systems that people may have already implemented.
We (business x) are currently in the process of creating a new website on the web platform 'Magento'.
We are a business that sells items with a minimum number per product and as a result the more items a customer buys the less they pay per item.
So you have an idea for the amount of variables in the business. We buy the stock, then we also decorate the stock.
Variables effecting the cost include, the product type, the product, supplier, freight (supplier, supplier location, customer location, amount of boxes, weight of boxes, express/regular, fragile etc..),
internal freight, branding, method of branding, screen printing (positions, colours, heavy print, time of print, number of print, set up costs etc..)
Some of our products are purchased in australia, some outside of, we have variables for duty rate, international freight, taxes etc.
At the moment we have several price calculators developed through excel that when the product code is typed in will show the default product price per 25, 50, 100 units etc.
However we are only able to list a limited amount of product codes per spreadsheet due to the amount of variables. As a result we have many different spreadsheets.
Take for example, customer A wants a quote on 50 T-Shirts and 100 Engraved pens.
Our salesperson then brings up the price calculator for T-Shirts and types in the product code 'TS31' This then shows the sales person the amounts 25.50.100.etc.
The sales person then looks under the '50' column and gets this price for the customer. However rather than changing the product code to 'EP31' they have to open the price calculator folder,
Find the pens calculator,open it, type in 'EP31' and find the 100 column.
If you see the links below you can see that the sales person can then go in and change the price which will then show them the percentages of profit etc.
NOTE: Top link is blank, Bottom link has product inserted.