Step 1 → Price Grid Description/code
You need to create the code and description for the price grid.
Go to Settings → Inventory settings → Price Grids → +New Grid (button)
Enter your price grid description and code → Save
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 Price Grid Descriptions and Export
→ Enter your Code for the Price Grid in the Column headed Code IE: ROLL-7
→ Enter the Description of the Price Grid in the column headed Description IE: Rollers Category 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 → Price Grid Template
Once the Price Grid code/description has been created download your Price Grid template.
Settings → Inventory Settings → Price Grids → Import/Export Prices
Download current layouts
.
Select the required Price Grid → Export
Step 3 → Price Grid
Add your pricing to your Price Grid
Importing pricing "Inc" or "Exc" GST depends on what is setup as the tax rate for you inventory group/inventory items. Check the tax rate before updating pricing
Width/Length → Across x
Height/Drop → Down left side
Depth/Thickness → Down very right column
Save and import your file
Settings → Inventory Settings → Price Grids → Import/Export Prices → Select File
Upload
Select the required Price Grids to be imported
Select the date you required the Price Grid to start from (This means that you can get ready for a Price increase before it happens and BUZ will automatically change to your new prices 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 → Price Grid Link to Inventory Item
Download your Inventory Items and add the required Price Grid Code to Inventory Items excel file and import as per the Inventory Items help