There are a number of different columns in your product export. Continue reading below for an explanation of each.
Once the export is complete, you can modify your product data and re-import your product list. To re-import your updated data, see our article on Importing Products.
Product Name—the name of your product.
Category—the category to which your product assigned.
Subcategory—the subcategory to which your product is assigned.
Retail Price—the price your customer pays for the product.
Display Name—the product name that will appear on the POS.
Description—a description of the product.
Brand—the brand of the product.
Manufacturer—the manufacturer of the product.
Vendor—the vendor of the product.
Age Requirement—yes or no; this option determines whether the customer is required to be a minimum age to purchase the product.
Minimum Age—the minimum age required, if any, to purchase the product.
UPC—the Universal Product Code for the product.
SKU/PLU—the SKU (stock keeping unit) or PLU (price look-up) code.
Cost—the price you pay for the product.
Price at time of sale—yes or no; this option determines if the price of the product can be modified on the POS at the time of purchase.
Current Qty—the current inventory quantity you have on hand.
Alert Qty—the low-level inventory alert threshold. When an item reaches this quantity, it will appear in the Critical Inventory report.
Background Color—the hex color code for the product icon background color.
Note: This field cannot be mapped in the current Product Import. Mapping this field in Product Import is not available until a future release date. If you wish to re-import this file, please ignore or delete this column before importing.
Text Color—the hex color code for the product icon text color.
Note: This field cannot be mapped in the current Product Import. Mapping this field in Product Import is not available until a future release date. If you wish to re-import this file, please ignore or delete this column before importing.
Display Text—the text that displays in the product icon.
Note: This field cannot be mapped in the current Product Import. Mapping this field in Product Import is not available until a future release date. If you wish to re-import this file, please ignore or delete this column before importing.
Size Modifier(s)—the size modifier group(s) assigned to the product. Multiple groups are separated by comma.
Component Modifier(s)—the component modifier group(s) assigned to the product. Multiple groups are separated by comma.
Add-on Modifier(s)—the size modifier group(s) assigned to the product. Multiple groups are separated by comma.
Tax Rules(s)—the tax rule(s) assigned to the product. Multiple rules are separated by comma.
Special Fee Rule(s)—the special fee rule(s) assigned to the product. Multiple rules are separated by comma.
Status—active or archived; this option determines the status of the product.
