Adding Inventory Item/s
- Alex Morrisson
- Shonal Singh
Adding Inventory Items
To watch the video on How to add new Inventory Items click here.
Purpose
The purpose of this page is to explain the various different methods to add inventory items and other factors you need to know to help you with this experience
Execution
Before adding inventory items you need to have setup a group for the inventory items to live.
If you think of a Group as a folder, the inventory items would be files that are in the folders.
Ensure you setup the Group correctly as there are a 2 types of groups, components and Fabric
Click here for more information about groups
Select the option
Add inventory via BUZ (Individual items only)
Explanation of Inventory item spreadsheet
Field | Details | Notes |
|---|---|---|
PKID | This is the Primary Unique Identifier for the row in the database | BUZ creates this for you, leave this field blank |
Code | Your Code for the item. Once a code is saved in BUZ, it cannot be changed. | If this is in a main inventory group and has an * in the heading BUZ will auto generate this for you |
Description | Item Description | If this is in a main inventory group and has an * in the heading BUZ will auto generate this for you |
DescnPart1 (Material) | Description Part 1 | in most cases used for Material |
DescnPart2 (Material Types) | Description Part 2 | in most cases used for Material type (Blockout / Translucent) |
DescnPart3 (Colour) | Description Part 3 | in most cases used for Material Colour |
Price Grid Code | Price grid code that this inventory items relates to | |
Cost Grid Code | Cost grid code that this inventory items relates to | |
Discount Group Code | Discount group code that this inventory items relates to | |
Last Purchase Price | The price you last purchased it for | |
Standard Cost | The suppliers normal sell price | |
Tax Rate | Your tax rate | |
Units Purchase | What unit do you purchase in IE: BX is Box (These units of measure can be edited in inventory settings Purchase Orders ) | use the unit of measure code not description |
Stocking Multiplier | Multiple "Unit Stock" by "Units purchased" | |
Units Stock | What unit do you stock in IE: BX is Box | use the unit of measure code not description |
Selling Multiplier | Multiple "Unit Sell" by "Units purchased" | |
Units Sell | What unit do you sell in IE: BX is Box | use the unit of measure code not description |
Cost Method | What cost do you want to default to | |
Product Size | ||
Product Type | Component = "C", Service = "S", Manufactured = "M" | Use only the first letter in the column |
Supplier | Enter your Supplier here | use supplier code which is setup in BUZ contacts→ Suppliers |
Supplier Code | Enter the Code your Supplier provides you for the inventory item, used for purchase orders | |
Supplier Description | Suppliers Description of goods, used for purchase orders | |
Length | ||
Maximum Width | Maximum width this item is available in | |
Extra Time to Fit | Extra time in minutes to fit this item (additional to the inventory group) | |
Customer Var 1 (Pack Size) | Pattern Repeats in millimetres. used for Curtain pricing script | |
Custom Var 2 (PackOpt) | Fabric Width in millimetres. used for Curtain pricing script | |
Custom Var 3 (PackType) | Y or N | Continuous /Railroad Y or N |
Warning | Warning flag to appear when item is selected in cart | |
RptCat | Report Categroy | used to group items in a category for reporting |
Operation | If this is a new item then the operation is A, E is to edit and existing item and D in to Deactivate |