Price Modifications

Price Modifications

To modify item prices you have a few different options available.

  • Edit the item and click Add/Edit Pricing & Location at the top of the page. Select a Location and click Edit. Set the prices for the different available price levels (Admin -> Inventory -> Price Levels). Click Save if you have made modifications. Click Copy Pricing To All Locations if you have multiple locations and want the pricing the same at each.
  • Modify prices with the Tools -> Export -> Inventory Export/Import Edit Tool, if you would like to use a spreadsheet program to change prices. Click the Export button. Select locations with the Inventory Locations To Export box. Check the box labeled Export Pricing. Mark the Item Code and Description fields and others you would like to have displayed in the export spreadsheet. Click Export. Modify prices in your preferred spreadsheet program, but keep the file format as CSV. Go back to Tools -> Export -> Inventory Export/Import Edit Tool and click Import. Select your Modified Export File and click Import.
  • Adjust prices using Inventory -> Items -> Item Prices - Mass Edit. This will allow you to set pricing for multiple items at once.
  • Use Inventory -> Items -> Items Prices Category Edit to adjust pricing for whole item categories at a time. You can adjust prices by a percentage or by a flat amount, and the changes can be for specific price levels.

If you've created a new inventory location and want to copy pricing for all items to the new location, use Inventory -> Items -> Copy Pricing. Select the location to copy from and the location to copy to.

Standard Markup Sets

Where: Admin -> Inventory -> Standard Markup Sets

Instead of typing a fixed price for every item and price level, an item's location pricing can follow a markup set: a rule that prices the item from its cost. When the cost changes, the selling price follows. Items that should not move with cost simply keep fixed prices.

1) Click Add, enter the Markup Set Description (the name you will pick on items) and choose what the markup is Based On: First Cost (the oldest cost of the stock on hand), Mid Cost (the average) or Last Cost (the most recent purchase).

2) For each Price Level, enter either the Markup % to add on top of cost or the Profit Margin percentage of the selling price you want to keep, and choose Round Price Up To (for example the nearest 5 cents, 99 cents, whole currency unit or 9 whole currency units) so computed prices look like list prices. Click Save.

3) To change a set, pick it from the dropdown and click Edit; the page also lists every set with its price levels and percentages. Delete removes a set that no items use.

4) Apply the set to an item under Add/Edit Pricing & Location on the item, choosing the markup set for that location instead of entering fixed prices.