Click here to watch a video on how to configure Cost Grids
How Cost Grids (Buy) are used by BUZ
...
Add/ Edit Cost Grid Description
Step 1 → Cost Grid Description/code
You need to create the code and description for the cost grid.
Go to Settings → Inventory settings → Cost Grids → +New Grid (button)
...
Enter your price grid description and code → Save
...
Note the Price grid code can only contain letters and numbers, no spaces or special characters (!@#,.-_ etc)
The code should be 4-8 characters long
OR you can create multiple price grids at once using excel (import/export feature)
Go to Settings → Inventory Settings → Import Export Inventory Settings → Download Current Layouts
→ Select Cost Grid Descriptions and Export
...
→ Enter your Code for the Cost Grid in the Column headed Code IE: ROLL-7CROLL7C
→ Enter the Description of the Cost Grid in the column headed Description IE: Rollers Cost Cat 7
→ Enter an A in the column headed Operation (to add)
→ Once done Save a copy of the file then Import
Go to Settings→ Inventory settings→ Import Export Inventory settings → Select file
→ Upload
→ Select the spreadsheets to upload → Import
When successful a message will appear at the bottom of the screen
Step 2 → Cost Grid Template
...
Settings → Inventory Settings → Cost Grids → Import/Export Prices
Download current layouts
.
Select the required Cost Grid → Export
Step 3 → Cost Grid
...
- Width/Length → Across x
- Height/Drop → Down left side
- Depth/Thickness → Down very right column
Click +Add to add a new Cost Grid Description
Select correct Code and Description, then attach Price Grids with a Start From date. The date can be a future date so that planned price changes can be loaded prior to the change and will be activated by an order date in that period.
Prices can be imported with or with decimal places, this can be set in step 4. when importing the price grids
...
Save and import your file
Settings → Inventory Settings → Cost Grids → Import/Export Prices → Select File
Upload
Select the required Price Grids to be imported
Select the date you required the Cost Grid to start from (This means that you can get ready for a Cost increase before it happens and BUZ will automatically change to your new costs on your selected date)
Select how many decimals places to round the cost to → Import
When the Import button is used you will receive a Save Successful message.
Step 4 → Cost Grid Link to Inventory Item
Download your Inventory Items and add the required Cost Grid Code to Inventory Items excel file and import as per the Inventory Items help
Example of Cost Grids
It is important that the right most column be the Depth. If depth is not being used then 0 (zero) should be entered on each row. See example below.
...