Product Import File

Product Import File

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.

    • Related Articles

    • Import

      In this training, you will learn how to import your data into FranPOS which makes it easier to set up your company. Settings >> Import/Export >> Import On this page, you will see sections for the following data categories: 1. Products 2. Product ...
    • Create/Attach/Sign/Download Waiver for Product

      Create/Attach/Sign/Download Waiver for Product This article will help you learn how to Create a waiver in back office, Attach the waiver to product from Catalog page in back office, how a customer can sign the waiver on the Customer display and ...
    • Card on File ( Tokenization )

      Card on File ( Tokenization ) This article helps you learn how to Enable Tokenization in back office and how to add card on file under customer profile ( Register application & Back office ). 1. Please login to back office and follow the instructions ...
    • Delete Customers Expired/Incorrect Card on file

      Delete Customers Expired/Incorrect Card on file This article helps you learn how to Delete any of your Customers Expired/Incorrect Card which is on file. 1. Please click on Reports and then go to Manage Credit Card 2. Please type in any of the ...
    • Retail - Add product matrix

      In this training, you will learn how to add matrix product to your store. Catalog > Product & Service > Product Select ‘+’ icon Select Matrix Name the matrix product Fill in the missing fields Press 'Save' Step 2 Select the product you created Select ...