Brand Manager Processes - Gibbys Brand Pricing Folders
Every Brand will have a folder that contains Pricelists and/or Promo Planners from the Vendor and Duane’s price grid and this is how we know what to price each product at.
Promo Planner – If your brand has regular price changes, they will be found in the promo planner.
Price Grid – Duane makes these to show us what can be put as the flash price, shipping fees and lowest amount he wants to go on 3rd party sites.
Keeping these Folders Organized
It is important that all Folders are in the same organized fashion. When opening the Folder you should only see the Price Grid for that Brand.
Then you should have 2 Sub-folders. One being for Master Price Lists/ Monthly Sales Planner and another Folder called OTHER.
In the Master Price List Folder you will have the current price list and/ or promo pricing, and you will have a few sub-folders if needed like OLD Price Lists, OLD Promo Planners. You can add additional Folders if needed but keep it clean and consistent.
In the OTHER Folder, it is needed to have a Word document outlining the allowances for that brand, Authorized Dealers list and any important notes that the next brand manager for that brand will need to know.
In the Master Price List Folder you will have the current price list and/ or promo pricing, and you will have a few sub-folders if needed like OLD Price Lists, OLD Promo Planners. You can add additional Folders if needed but keep it clean and consistent.
In the OTHER Folder, it is needed to have a Word document outlining the allowances for that brand, Authorized Dealers list and any important notes that the next brand manager for that brand will need to know.
Upkeeping the Grid
As the Brand Manager it is your responsibility to update Sale Price on the Grid. This is because all Bundles are linked to these grids if it is not updated on the grid it will not update the bundle price. Duane will update these occasionally and it is your responsibility to take the changes he has made to the grid and update them online, once the change has been made online turn the cells from green back to white. You can also view any changes made by selecting Last edit was… beside help.
Do not add or remove any columns across the top as this will make all bundles be incorrectly priced.
With your brands you should set a notification rule so when a change is made you will get an e-mail notification and know that an adjustment has been made and in turn you must update online. Go to tools then notification rules and select any changes are made and to notify you in a daily digest.
Updating Grid Weekly
You will update the grid 1 of 2 ways.
1.Your brand will have the promo planner copied on a tab called “Brand weekly pricing paste” and it will be linked to the sale column of the Duane/Sales grid tab, each week you will update that tab for that weeks pricing. Which in turn will update the sale column on Duane/ Sales.
2. You will manual update the sale price on the grid if that sku is on sale. (all cells should be filled out whether it is on sale or not, if it is not on sale put in MSRP price in the sale column only on the grid for bundles not on the front end of Gibbys – if it is not on sale then the front shows no sale price in the sale column)
After your sale column has been successfully updated. You will then have another tab on the grid named “Upload Sheet”
On this sheet you will have the same look as if you downloaded a spreadsheet off of our website
On the tab GIBBYS UPLOAD SHEET there may be an extra column next to sale price this column just lets us know if the sale column is different from the msrp column by using this formula =IF(C2=D2,” “,D2)
We use this because the sale and msrp column can not be the same. This formula will let us know if the item is on sale or not. If it is not on sale it will show blank, if it is on sale it will show the sale price.
On the Upload sheet each cell will have a VLOOKUP formula to find the information from Duane / Sales
Once everything is linked properly, double check all cells are correct, Once you have checked all are correct, get someone else to confirm all is correct.
Once you have confirmed all is correct you can use this as an upload template for your weekly/monthly pricing.
Always save the original download sheet for the brand you are about to upload just in case something goes wrong we have a backup.
Sale Price
On Special promo days (Black Friday, Prime Day, Boxing Day etc) you are to use the sale price countdown
This will show the sale countdown timer.
