Weighsoft allows you to import a large number of prices using a spreadsheet template. This is ideal for bulk price creation and updates.
Step 1: Download the Import Template
Hover over Administration.
Click on Lookups.
Select Imports.
Click the Download Template link next to the “Prices” line.
Your browser will download a file named PriceImport.csv.
Step 2: Fill in the Template
The template includes a sample entry in row 1 — delete this before importing.
Required Fields
Field | Description |
Product | Product code in Weighsoft. For weighbridge prices, use the waste product code. For skip prices, use the skip size. |
Price Cash | Price for cash jobs. |
Price Account | Price for account (non-cash) jobs. |
From Date | Start date for the price. |
Unit | Unit of sale (e.g., LOAD, KG). |
Optional Fields
Field | Description |
Price Group | Applies the price to a specific price group. |
Waste Type | Waste type associated with the price. |
Outlet | Specific outlet the price applies to. |
Zone | Zone the price applies to. |
Supplier | Supplier-specific pricing. |
To Date | End date for the price (leave blank for no expiry). |
Account | Account-specific pricing. |
Address | Address-specific pricing. |
Incl Tax | Indicates if the price includes tax. |
Min Price | Minimum charge for the price. |
Max Price | Maximum charge for the price. |
Container | For weighbridge prices, e.g., “General Waste” in an “8-yard skip”. |
Important: If the Account or Address fields contain values that don’t exist in Weighsoft, they will be cleared during import, resulting in a price with no specified account/address.
Step 3: Import the Template
Save the completed spreadsheet to your PC.
Return to the Imports screen in Lookups.
Click Choose File and select your saved CSV.
Click the Process link next to the “Prices” line.
Weighsoft will import the template and create the prices accordingly.