In this article:
Update Item Costs and Prices (Video)
Bulk Update Item Costs
-
- Navigate to: Setup > Items > Items
- Apply desired filters
- Select the items you would like to update from the available results
- Note: Select all will select entries on the page displayed. You can update entries shown to 100 at a time if you need to adjust many items.
- Select Edit Margins
Apply: Are you applying an increase or decrease To: Will this update impact costs or prices?
Select Cost
Costs refer to direct costs of an item to your business.By: What percentage increase/decrease will you apply?
Enter percentage value
Example: If item cost is $10 and a 3% increase is applied, the new cost will be $10.30.Round Price to Nearest: Leave Blank - Select Apply
Bulk Update Item Prices
-
- Navigate to: Setup > Items > Items
- Apply desired filters
- Select the items you would like to update from the available results
- Note: Select all will select entries on the page displayed. You can update entries shown to 100 at a time if you need to adjust many items.
- Select Edit Margins
Apply: Are you applying an increase or decrease To: Will this update impact costs or prices?
Select Price
Prices refer to price of an item to charge your customer.By: What percentage increase/decrease will you apply?
Enter percentage valueExample: If item price is $50 and a 3% increase is applied, the new cost will be $51.50.
Round Price to Nearest: Will round up to nearest 5c, 10c, 25c, 50c, dollar or 10 dollars.
See more in table below. - Select Apply
Bulk Update Margins
-
- Navigate to: Setup > Items > Items
- Apply desired filters
- Select the items you would like to update from the available results
- Note: Select all will select entries on the page displayed. You can update entries shown to 100 at a time if you need to adjust many items.
- Select Edit Margins
Apply: Are you applying an increase or decrease To: Will this update impact costs or prices?
Select both Prices and Costs
Costs refer to direct costs of an item to your business.
Prices refer to price of an item to charge your customer.By: What percentage increase/decrease will you apply?
Enter percentage valueExample:
If item cost is $10 and item price is $50 and a 3% increase is applied, the new cost will be $10.30 and the new price will be $51.50
Increasing price and cost by the same % does not increase price and cost by the same dollar amount which will change margins.Round Price to Nearest: Will round up to nearest 5c, 10c, 25c, 50c, dollar or 10 dollars. See more in table below. - Select Apply
Update Item Costs and Prices (Video)
*Note: Some of the content in this video may reflect a previous version of SingleOps. For a more accurate guide, please refer to the steps listed above.
Rounding Options
Option | Example |
Nearest 5 Cents | If the default cost is $12.31, it will be rounded up to $12.35. |
Nearest 10 Cents | If the default cost is $12.38, it will be rounded up to $12.40. |
Nearest 25 Cents | If the default cost is $12.52, it will be rounded up to $12.75. |
Nearest 50 Cents | If the default cost is $12.60, it will be rounded up to $13.00. |
Nearest Dollar | If the default cost is $12.30, it will be rounded up to $13.00. |
Nearest 10 Dollars | If the default cost is $16.30, it will be rounded up to $20.00. |
Common Examples
Scenario | Example |
Annual Price Increases | Filter to 'Service' Category, increase price by 2% before batch renewing jobs. |
Material Cost Updates | Plant list from a vendor was updated. Filter by 'Material' category, and select materials from vendor. Apply increase/decrease to cost. |
Equipment Cost | Paid off a large piece of equipment? Decrease the cost to reflect new, higher margins. |
Comments
Please sign in to leave a comment.