Adding (updating) a new price for an existing pricing coefficient
- Alex Morrisson
In this scenario, we have a product that has a price co-efficient attached to it. Now, we want to update the price.
Option 1 - Adding a Price Co-efficient to a single Inventory Item
You can easily do this from the inventory page if you are updating one inventory item.
Press the “+Add Price button.
Enter the date you want to price change to occur. Remember, if you choose a date in the past, orders with this product may be affected.
Enter the amounts in the relevant fields. You can have values in multiple areas if needed.
Save
Option 2 - Multiple Items to be updated
If you are updating multiple items simultaneously, I recommend this method.
Let's find the price coefficient area.
Settings → Inventory Settings → Price coefficient Tab → Import/export → Download current layouts → select the group/s
For your information
You may notice the Green and White rows once you have downloaded the Price Coefficient table.
If the row is Green, this means that a price has not been added to the item previously.
White rows mean that a price has been added. To update these rows, you will still need to add a new price, as there is a unique date that this price will be effective from.
Now that you have downloaded the Excel Template.
Add a new date that the pricing is effective from into column E. Note if you backdate this, any orders/sales in the system will have the new price applied.
Add the new pricing details into the relevant columns, don't forget you can add cost values too.
Input A in the operation column.
Upload the file to BUZ.
Price History
You can view the price co-efficient history by going to the inventory item area.
Settings → Inventory Items → Search the item you want to see the history for.
Once you select an item, you can see prices in the bottom section.
Example of an inventory item with multiple prices over a period of time
An example can be seen In the picture below.
You can see that by adding a new price, we do not affect the previous prices
In this example, between
25/02 to 17/03, the price was $2
18/03 - 19/03 = $3
20/03 - 23/06 = $4
24/06 - Present = $5
If I edit one of these lines, it will change all the orders in that period, which can be problematic.
In the example below, I changed the date of the highlighted line
From this
To this
Any orders placed between 01/01 and 24/02 will now be charged $4
and any orders placed between 20/03-24/03 (previously charged $4) will now be charged $3
Example 2
On the 18th Mar, I added a $5 sell each to the Standard Chain
A few months later, I edited the price to $10 but didn't change the date
All of the orders in the system that have not been accepted will now charge an extra $5