iVend Retail 6.6 - Management Console - Help Manual > Administration > Application Setup

Import Data

The feature facilitates a quick setup by enabling the user to import data directly through excel. The object types for which the data can be imported are as follows:

Zip Code

Job Code

Department

Employee Position

Product Category

Alternate UPC Code

Sale Attribute

Reason Code

Security User

Employee

Message

Up-sell Product

Fulfillment Plan

Layaway Plan

Retail Profile

Store

Vendor

Customer

POS

LoyaltyPlan

Security Roles

Currency Denomination

Product

Gift Certificate

Customer Address

Vendor Address

Number Series Master

Inventory Item

Event

Price List

Exchange Rate

Special Price List

Tax Condition Setup

Product Group

Country

State

Tax Code

Manufacturer

Surcharge

Alternate Item

Warehouse

Customer Group

Team

Product Class

Vendor Warehouse Item

Accounts Receivable

Product Surcharge

CouponSerialNumber

When importing a data from an excel file into iVend retail system, the progress bar keeps the user updated with the number of records that are imported and its progress in the real time.

To open the window, choose Administration > Application Setup > Import Data.

Setup Screen

Field/Button	Description/Activity
Excel File Path	Displays the path of the Excel File. Select an excel file by clicking on to browse for the file in the machine.
Sheet Name	Enter the name of the sheet in the excel file from which the data is to be imported.
Object Type	Select one of the object for which the data is to be imported. By default, none is displayed.
File has Header	Select the option if the user wants the first row in the excel sheet to be displayed as column name in the Data Mapping Configuration Screen.
[Ok]	When the user clicks the button, the system displays the Data Mapping Configuration screen after filling the values in the above fields.
[Cancel]	The button does not save any changes and closes the screen.