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 ...
    • 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 ...
    • Add a Product

      Add a Product Proceed to https://my.franpos.com/Product page. Click the ( + ) at top right Enter the following Name Category Cost Price Stock quantity Change SKU (optional) Brand Show on SmartShelf toggle on to view the product on the register Show ...
    • Master Product Editor

      This tool is built for making changes to products across multiple locations at once. Only shared products will be displayed in the Master Product Editor. Catalog>> Inventory management >> Master product editor You can run filter of the locations and ...
    • Retail - Add product categories

      In this training, you will learn how to add a category to your store. Catalog >> Product & Service >> Category Select ‘+’ icon Name the category, Upload image if you prefer and Make sure location is selected Click ‘Save’ Video Tutorial