Catalogue Materials: How to Set and Update Price and Units
In this article:
Setting Material Prices and Units
Updating Material Prices and Units
Setting Material Prices and Units
When you are creating catalogue materials via import, you will have several fields to complete in your CSV template, which look like this:
Here is what these fields correlate to when creating a catalogue material manually:
Notes:
- Units per Price and Units per item are the same thing.
- Price per unit is calculated automatically, hence there is no column for this in the import CSV template.
What Do These Terms Mean?
- Price: The amount that you pay your supplier for this item.
Price Unit Id: The unit of measurement in which your supplier provides this item.
Examples: If you buy a pack of 100 screws, the Price Unit Id is "pack". If you buy 50 sheets of white melamine, the Price Unit Id is "sheet". If you pay a service provider for 3 days of labour, the Price Unit Id is "day".
Units per Price / Units per item: The number of individual units you buy at a time.
Examples: If you buy a pack of 100 screws, the Units per Price is 100. If you buy a sheet of white melamine at 2.88m2 per sheet, the Units per Price is 2.88. If you buy 1 tin of paint, the Units per Price is 1.
Price per Unit: This is the Price, divided by the Units per Price.
Examples: If you buy a pack of 100 screws for $5, the Price per Unit is $0.05. If you buy a sheet (2.88m2) of white melamine for $155.40, the Price per Unit (square metre) is $53.96. If the Units per Price is 1, then the Price and Price per Unit will be the same.
Unit Price Unit Id: The unit of measurement which you use for individual units of this item.
Examples: If you buy a pack of 100 screws, the Unit Price Unit Id is "piece" (pce) or "each" (ea). If you buy 50 sheets of white melamine, the Unit Price Unit Id is "square metre" (m2).
- Pricing Strategy: Can either be Variable (recommended), meaning you will sell this item at a price that varies depending on supplier prices and other circumstances; or can be Fixed, meaning you will always sell this item for the same amount, regardless of how much your supplier charges.
Updating Material Prices and Units
In most cases, updating your materials is simple:
Manually update a material by clicking into it from your Catalogue and clicking Update.
- Update multiple materials by exporting your materials, making the necessary edits in the CSV file, then importing your materials.
- Sync your materials to update from your supplier's catalogue (Supplier Integration Feature - Selected Suppliers Only).
However, in some instances you may find that you need to update the Units Per Price, meaning that you will also need to update your Price, and several other fields, and then make any necessary changes in your Inventory and other areas of your software.
Example: Your supplier has previously sold a material for $0.44 each, so you have this material set up as follows:
Your Inventory and Purchase Orders are also set up to handle this material in individual units:
You then find out that your supplier has updated their catalogue so that this item can only be purchased in packs of 100, so the next time they send through a delivery docket, it says you have ordered 2 of 100 (pack), instead of 200 (each), and the Price is now $44 (pack) instead of $0.44 (each).
You will now have to update your catalogue, your inventory, and your existing purchase orders to handle this change.
How to Update Your Materials When the Units Per Price Has Changed
In the example above, you would follow these steps:
- Go to your Catalogue and click into the material you want to update.
Click Update:
Change the Price, Price Unit Id, Units per item, and Unit Price Unit Id (if applicable):
- Save Changes.
- Go to your Inventory and search for the material. (You may have multiple entries in your inventory, depending on how many jobs you have with this material allocated to them.)
Click into each entry for this material and click Update:
As before, update the Price, Price Unit Id, Price per item and Unit Price Unit Id (if applicable), then update the Quantity field up the top so that Quantity = number of items and Units = number of units (multiplied by qty):
8. Your material should now look like this:
Repeat this step for each entry in your inventory.
- If you have purchase orders waiting to be received, or partially received, and you cannot fully receive them because of the changes made to your material, you will need to first manually update the item quantities in your Inventory by clicking into each entry as above, and adjusting the number of units to reflect what has been received.
Then you can manually change the status of your PO to Fully Received by clicking the orange status button at the top of the PO and selecting from the drop-down:
