...
Click here for more information about groups
Select the option
...
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 | 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 |
|
-A |
- L | ||
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 |