ItemID: Unique item ID should be entered here, which are alphanumeric characters (do not use special characters or spaces). (Max Length 15 characters)
UPC: Unique UPC is entered here with alphanumeric characters (do not use special characters or spaces). The UPC can be an extension of the Item ID or completely different. But it should be unique. (Max Length 15 characters). If not entered, the default value is ItemID.
Item Name: Unique name for the item should be entered (no special characters such as -, *, &, etc) (Max Length 50 characters)
Cost Price: The cost price of the item is entered here, if it's left empty then it's taken as zero by the system. If not entered, the default value is 0.
Selling Price: The selling price for the items should be entered.
Department ID: The ID of the department in which the item belongs should be entered here. ID is available only if you have already created a department.
Department: The department to which the item belongs should be entered (This is the name of the department, not the ID). If creating a new department, enter in a department that does not exist and the Import will automatically create it. (Max Length 50 characters). If not entered, the default value is Default
Category ID: The ID of the category in which the item belongs should be entered here. ID is available only if you have already created a category.
Category: The category to which the item belongs should be entered (This is the name of the category, not the ID). If creating a new category, enter a category that does not exist, the import will automatically create it. (Max Length 50 characters) If not entered, the default value is Default
SubCategory ID: The ID of the subcategory in which the item belongs should be entered here. ID is available only if you have already created a subcategory.
SubCategory: The subcategory to which the item belongs should be entered (This is the name of the subcategory, not the ID). If creating a new subcategory that does not already exist, the import will automatically create it. (Max Length 50 characters) If not entered, the default value is Default
Size ID: The ID of the size to which the item belongs should be entered here. ID is available only if you have already created a size.
Size: The Size of the item is entered here (This is the name for the size, not the ID). (Max Length 50 characters). If not entered, the default value is blank.
Brand ID: The ID of the brand to which the item belongs should be entered here. ID is available only if you have already created a brand.
Brand: The brand of the item is entered here (This is the name for the brand, not the ID) (Max Length 50 characters). If not entered, the default value is blank
Season ID: The ID of the season in which the item belongs should be entered here. ID is available only if you have already created a season.
Season: The season of the item is entered here (This is the name for the season, not the ID) (Max Length 50 characters). If not entered, the default value is blank
Color ID: The ID of the color in which the item belongs should be entered here. ID is available only if you have already created a color.
Color: The color of the item is entered here (This is the name for the color, not the ID) (Max Length 50 characters). If not entered, the default value is blank
Style ID: The ID of the style in which the item belongs should be entered here. ID is available only if you have already created a style.
Style: The style of the item is entered here (This is the name for the style, not the ID) (Max Length 50 characters). If not entered, the default value is blank
Item Type ID: Identifier for the item type. If the item is a store item the ID is 1, if it's a service item it's 2, if it's a package item it's 3, if it's a prepaid item it's 4, if it's a modifier item it's 5, if it's a variant item it's 6, if it's a CTO item it's 7 (NOTE: If creating a package (type 3) Status should be set to Inactive - as the package becomes active once items are added to the package). If not entered, the default value is 1.
Item Type: Items type can be entered here (Prepaid Items, Store Items, Package Items, Service Items, and Modifier Items.)
Status: Enter the word "Active" or "Inactive", depending on what the user wants as the status of the item. If not entered, the default value is Active.
TaxID: The tax ID associated with the item is entered here. This tax will be processed during sales transactions. The default tax is TaxID 1
Tax: The tax of the item is entered here (This is the name for the tax, not the ID) (Max Length 50 characters). If not entered, the default value is blank
Vendor ID: The ID of the vendor in which the item belongs should be entered here. ID is available only if you have already created a vendor.
Vendor Code: Unique code to identify the vendor. The vendor code is used to identify the vendor when an item is created using the item import.
Vendor Name: The Vendor Name associated with the item should be entered. If not entered, the default value is Unassigned
Discount ID: The discount ID attached to the item is entered here. This discount will be processed during sales transactions. If not entered, the default value is blank
Master SKU: Enter the Master SKU under which multiple SKU’s can be linked. Used when you have multiple items that you want to treat as one item (same item with different Item ID's such as every season the same item SKU changes)
Tax Inclusive: The tax-inclusive item is indicated by filling this field with 1 or left blank for tax exclusive. If not entered, the default value is blank
Serialization Level: If an item has serial numbers associated with it "Always" enter 1, "Sometimes" enter 2. If the serial number will not be added to the item left blank.
RoyaltyLevel: The royalty ID associated with the item is entered here. (Not utilized option)
eCommerce Name: The alternative name for the e-commerce site.
Product ID: Identifier for the product related to the item.
Consignment Flag: A flag indicating whether the item is on consignment.
Licensee Flag: A flag indicating whether the item is associated with a licensee.
eCommerce Enabled Flag: A flag indicating whether the item is enabled for eCommerce.
Course ID: The ID of the course in which the item belongs should be entered here. ID is available only if you have already created a course.
Course Name: The course of the item is entered here (This is the name for the course, not the ID) (Max Length 50 characters). If not entered, the default value is blank
Is Expiry Item: Indicates whether the item has an expiration date.
Vendor Alias: Enter another descriptor for a vendor. The descriptor is shown on the Purchase Order.
SKU Type ID: The ID of the SKU Type in which the item belongs should be entered here.
SKU Type: Enter the SKU type when using a scale or reading barcodes with embedded information.
Image URL: Enter the URL for the image. If not entered, the default value is blank
Fee ID: The ID of the Fee which can be attached to an item/sale should be entered here. ID is available only if you have already created a fee.
Tags: Relevant keywords or tags associated with the item.
Meta Data: Additional metadata or information about the item.
Enhanced Description: Detailed description or additional information about the item.
Minimum Order Level: The minimum quantity required when ordering the item.
Maximum Order Level: The maximum quantity allowed when ordering the item.
Reorder Level: The inventory level at which the item should be reordered.
Reorder Quantity: The quantity to reorder when the inventory reaches the reorder level.
Team: If applicable, the sports team associated with the item.
Player: If applicable, the player associated with the item.
Collection: If applicable, the collection or series of the item.
Play Off: If applicable, indicates whether the item is related to playoffs.
Outerwear Style: The style or design specifically for outerwear items.
Product Name: The name or title of the product.
Sales Channel: The channel or platform through which the item is sold.
UOM: Unit of measurement for the item (e.g., piece, pack, set).
Enable Auto Replenishment: Indicates whether auto-replenishment is enabled for the item.
Articles in this section
- Item Import Field Descriptions
- Overview
- Merchant Onboarding
- Navigation Bar
- Reports
- Items
- Settings
- Dashboard Overview
- Company
- Register
Comments
Please sign in to leave a comment.