Exporting products Follow
The uAccept product export allows you to easily create a backup of your products or edit your products in bulk and re-import them. 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.
In This Article:
Exporting Products with CSV
To export your products to a CSV spreadsheet, follow these steps:
1. From the Products tab, click Product List.
2. From the Tasks tab, click Export Products.
Note: By default, a list of your Active products will display. You can select to export a list of products based on the following filters:
- Active —Active products in your product list.
- Archived —Products with an Archived status.
- Tracking —Products for which you are tracking inventory.
- Alerts —Products for which you have low-level inventory alerts set.
- All—Active, Archived, Tracking, and Alerts products.
There are many different columns in the product export spreadsheet. To view an explanation of each column, see Product Export Details.
If you wish to modify your product data and re-import your product list, see Importing Products.
Exporting Products with Excel
To export your products to an XLSX spreadsheet, follow these steps:
1. Navigate to your Product List.
2. From the Tasks drop-down, hover over Export Products and then click Export Excel.
3. When the software prompts you, save your product list export to a location of your choice.
To view an explanation of the data in each column of your export spreadsheet, see Product Export Details.
Product Export Details
There are a number of different columns in your product export. Continue reading below for an explanation of each.
Product Name—the name of your product.
Category—the category to which your product is 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.
Comments
0 comments
Article is closed for comments.