In this training, you will learn more information about the product import file.
|
*Product Name* |
The display name on the POS, required. |
|
SKU |
The main barcode. If you leave this blank, we will auto-generate one for you. |
|
Product Code |
Alternative identification code. Item can be searched on POS via Product Code as well. |
|
*Price* |
Required. |
|
Member Price |
Price for customers who bought membership; not applicable. |
|
Cost |
The cost of buying this item from the vendor. |
|
Stock Quantity |
How many of this item the store has on hand. |
|
Reorder point |
Defines what the system considers a “low stock item” for reordering purposes. |
|
*Category* |
Same as departments. Required. |
|
Vendor name |
Name of vendor this item is ordered from |
|
Vendor Code |
Unique identifier for the vendor, when importing it MUST match vendor code already in the system, or else duplicate vendors will be created. |
|
Tax category |
Which tax category this item belongs to. A single tax category (e.g. Sales Tax) can contain multiple tax lines (e.g. City tax 3%, state tax 4%). |
|
Short Description |
Used in eCommerce pages |
|
Long Description |
Used in eCommerce pages |
|
Keywords |
Used to help search for the product. Comma separated. |
|
Tags |
Used to help categorize and search for the product. Comma separated. |
|
Bin/aisle number |
Used to identify where item must be placed into store after receiving it. |
|
Attribute Type |
Item modifiers, not applicable. |
|
Attribute Name |
Item modifiers, not applicable. |
|
Attribute Additional amount |
Used to create priced modifiers for items. |
|
Ship only |
Indicates that this item cannot be bought and taken from store; it can only be bought and placed for shipping. |
|
Qualified for installment |
Indicates whether the item is qualified for financing. |
|
Price Can be Free |
If false, price of this item cannot be set to zero. |
|
Allow negative quantity in store pickup |
Allows the sale of this item on POS even when stock quantity falls to zero or below. |
|
Not for Sale |
If set to true, this item will exist in system, but not be available to be sold on POS. |
|
Add serial number |
Allows the generation of unique serial number for each sold item. |
|
SKU type |
Affects how long auto-generated SKU will be (if SKU is left to be generated by system). |
|
Add to discount category |
Allows you to import this item already associated with a category-based discount. Enter in discount code of desired discount. |
|
Add to discount by SKU |
Allows you to import this item already associated with a SKU-based discount. Enter in discount code of desired discount. |
|
Sell online |
Affects whether this item will be available for purchase in eCommerce platforms. |
|
Is Matrix |
Indicates whether this item is a “base item” used for generating matrix combinations. |
|
Revenue Account Code |
Used in the General Ledger Report. (if enabled) |
|
Inventory Account Code |
Used in the General Ledger Report. (if enabled) |
|
COGS Account Code |
Used in the General Ledger Report. (if enabled) |
|
EBT qualified |
Indicates if this item can be bought with EBT/SNAP payments (food stamps). |
|
Track Inventory |
If set to false, system will not update stock quantity upon sale of item. |