Supplier price files
Bring in a wholesaler's prices for your account, keep your costs up to date, and quote from their whole range.
Most wholesalers will send you a price file: their whole range with the prices on your account. Bring it into Crewzy and two things happen. The parts on your price list that you buy from them get the new cost. And their whole range is kept, so you can add any of their parts to a quote, invoice or job without typing it in.
Ask your branch or your account manager for a price file for your account. A CSV or a spreadsheet (Excel or OpenDocument) both work.
Bring in a price file
- Go to Resources, Suppliers, open the supplier and press Price file.
- Drop the file on the page or press Choose a file.
- Crewzy reads it and shows what it would change. Nothing is saved yet.
The figures across the top count the supplier's codes: New ones, those that are Dearer or Cheaper than last time, and those Gone from their range since the last file. Left out counts rows that could not be read, such as a part priced on application; each one is listed with its row number in the spreadsheet.
Your price list shows each item whose cost would change. An item you have not linked to a supplier yet is linked when its code on your price list is the supplier's code; it shows as new under Link.
Check the columns
Crewzy works out which column holds the supplier's code, the description, the unit and your price from the column names, even when the file starts with a title or your account details. If a column is wrong, choose the right one under Columns and the figures are worked out again. Your choices are remembered for that supplier's next file.
Prices are taken as before GST, the way wholesalers quote trade prices.
Apply it
Under Apply, choose what happens to your sell prices:
- Keep my sell prices: only the cost changes, so you see the new margin on each item.
- Set them from the cost with a markup: enter the markup, such as 35, and each sell price becomes the cost plus that much.
Press Apply these prices. Only the owner can apply a price file; the office can bring one in and check it. Each file applied is listed under Price files applied, with who applied it and what it changed.
Quote from a supplier's range
When you add a part to a quote, invoice, job or project, search as usual. Below your own price list you will see parts from your suppliers' price files that are not on it yet, with the supplier, their code and your cost. Pick one and it goes onto your price list, linked to that supplier, at the markup you last chose for them (30% if you have not chosen one), and onto what you are working on.
Crew on their phones see only your price list, never your costs.
Good to know
- A newer file replaces the older one. A part that is no longer in the supplier's range stays on your price list, but is not offered from their range any more.
- Changing an item's cost by hand is fine; the supplier's next price file sets it again.
- Price files up to 40 MB and 200,000 rows can be brought in. For a bigger one, ask the supplier to split it.