The Inventory Dataset has 4 sheets within the single spreadsheet. Its used to collect your inventory data from item details to variants, inventory counts, and more.
| All Items | ||||
| Column Name | Required | Value Type | Description | Example Value |
| Item Number | Yes | Text | Unique identifier for the item | ABC01 |
| ItemType | Yes | Text | Category that defines how the item is used. | Available Options for this field:
|
| Vendor Item Number | Yes | Number | The item number used by the vendor or supplier | K500 |
| Customer Number | No | Number | Unique identifier for the customer associated with the item | 100101 |
| Item Name | Yes | Text | Short, recognizable name of the item | Polo T |
| Item Description | No | Text | Detailed description of the item | Cotton polo with V neck |
| Warehouse | Yes | Text | The warehouse or location where the item is stocked or fulfilled | Cotton polo with V neck |
| Vendor Number | Yes | Number | Unique identifier for the vendor supplying the item | 400101 |
| Decorator Number | No | Number | Unique identifier for the decorator responsible for item customization | 400102 |
| AttributeLabel1 | No | Text | Custom attribute used to further describe the item | Color |
| AttributeLabel2 | No | Text | Additional custom attribute for item details | Size |
| AttributeLabel3 | No | Text | Additional custom attribute for item details | Material |
| AttributeLabel4 | No | Text | Additional custom attribute for item details | Style |
| Imprint Name | No | Text | Name for the imprint or decoration | Bear Logo |
| Imprint Type | No | Text | Method used for the imprint | Screen Print |
| Imprint Colors | No | Text | Colors used in the imprint design | PMS 299 C |
| Imprint Position | No | Text | Location of the imprint on the item | Left Chest |
| Imprint Size | No | Text | Dimensions or size of the imprint | 2x2 |
| Deco Comments | No | Text | Additional notes or instructions related to the decoration | Ref# 12345 |
| Deco Cost | No | Number | Cost charged by the decorator for the imprint | 1 |
| Deco Sell | No | Number | Price charged to the customer for the imprint | 0 |
| All Items SKUs & Variants | ||||
| Aturian will generate SKUs for each attribute combination available for an item using the information provided in this spreadsheet. | ||||
| Column Name | Required | Value Type | Description | Example Value |
| Item Number | Yes | Text | Unique identifier for the item | ABC01 |
| Attribute1 | No | Text | The value for Attribute 1 (specific to this item) as defined in the "All Items" sheet. Example: If this item's Attribute 1 is “Color”, then this field may be “Black” | Black |
| Attribute2 | No | Text | The value for Attribute 2 (specific to this item) as defined in the "All Items" sheet, if applicable. Example: If this item's Attribute 2 is “Size”, then this field may be “Small” | Small |
| Attribute3 | No | Text | The value for Attribute 3 (specific to this item) as defined in the "All Items" sheet, if applicable. Example: If this item's Attribute 3 is “Material”, then this field may be “Cotton" | Cotton |
| Attribute4 | No | Text | The value for Attribute 4 (specific to this item) as defined in the "All Items" sheet, if applicable. Example: If this item's Attribute 4 is “Style”, then this field may be “V-Neck" | V-Neck |
Note: You'll add a new row for each of this item's possible attribute combinations. | ||||
| Cost | No | Number | The internal cost for the item with this specific attribute combination | 2.99 |
| Sell Price | No | Number | The price charged to the customer for the item with this specific attribute combination | 12.00 |