Providing solutions in an ever-changing world Import Data

To quickly create a delivery list without scanning each item you receive, use the electronic version of your grocery delivery. The electronic version of a delivery is set up and sent to you by your grocery vendor, usually via e-mail. The data contained in this electronic delivery file works with the vendor number field in the UPC/PLU item information screen in Backroom for Windows. The following instructions detail how to import the data from your grocery vendor into Backroom for Windows.

	Note:	If, during the import procedure, Backroom for Windows finds a vendor number or an item not previously programmed in the software, you will be prompted for bar code and UPC/PLU item information on that item.

Import Vendor Delivery Files: Locate the file you would like to import, then click OK. As you close the import window you will be prompted to save your changes to the database. If your import data is correct, click Yes to save your delivery data. All rejected data will be placed in a log file called "import.log". The format is provided by your grocery vendor and setup in the main ini file.

Import UPC/PLU Items: Locate the file you would like to import and click OK. The file must be in the format specified below, otherwise it may not import properly. All rejected data will be placed in a log file called "import.log". Confirm file format prior to importing any changes to your database. After the procedure is complete, a message stating "Your Data has Been Imported" will appear. Click OK.

The file format is as follows:

Column     Description                Field Width     Notes   
A          Product Name               20   
B          Department                 2               1-30   
C          Quantity on Hand           7   
D          Reorder Level              5   
E          Vendor ID                  3               1-200   
F          Vendor Number              15              Vendor ID Required   
G          Average Cost               15              >=0 and <1000   
H          Base Item PLU              5               1-9999   
I          Base Item UPC              12   
J          Base Item Package Size     2               Must be 1   
K          Base Item POS Name         10   
L          Base Item Retail           8               >0 and <1000   
M          Base Item Cost             15              >=0 and <1000   
N          Base Item Price Group      3               1-200   
O          Base Item Inventory Value  2               Must be 1   
P          2nd Item PLU               5               1-9999   
Q          2nd Item UPC               12   
R          2nd Item Package Size      2               1-99   
S          2nd Item POS Name          10   
T          2nd Item Retail            8               >0 and <1000   
U          2nd Item Cost              15              >=0 and <1000   
V          2nd Item Price Group       3               1-200   
W          2nd Item Inventory Value   2               1-99   
X          3rd Item PLU               5               1-9999   
Y          3rd Item UPC               12   
Z          3rd Item Package Size      2               1-99   
AA         3rd Item POS Name          10   
AB         3rd Item Retail            8               >0 and <1000   
AC         3rd Item Cost              15              >=0 and <1000   
AD         3rd Item Price Group       3               1-200   
AE         3rd Item Inventory Value   2               1-99   

Import Departments: Locate the file you would like to import and click OK. The file must be in the format specified below, otherwise it may not import properly. All rejected data will be placed in a log file called "import.log". After the procedure is complete, a message stating "Your Data has Been Imported" will appear. Click OK.

The file format is as follows:
Column     Description                Field Width     Notes   
A          Department Number          3               Must be 1-30   
B          Department Name            6   
C          Default Price              8               Must be within range High Price - Low Price or 0.00   
D          Default Quantity           2               Must be 1-99   
E          High Price                 8               Must be 0.00-1000.00   
F          Low Price                  8               Must be 0.00-1000.00   
G          Allow Direct Sales         1               (Y or N) or (1 or 0)   
H          Tax Rate 1                 1               (Y or N) or (1 or 0)   
I          Tax Rate 2                 1               (Y or N) or (1 or 0)   
J          Tax Rate 3                 1               (Y or N) or (1 or 0)   
K          Tax Table 1                1               (Y or N) or (1 or 0)   
L          Tax Table 2                1               (Y or N) or (1 or 0)   
M          Tax Table 3                1               (Y or N) or (1 or 0)   
Import Price Groups: Locate the file you would like to import and click OK. The file must be in the format specified below, otherwise it may not import properly. All rejected data will be placed in a log file called "import.log". After the procedure is complete, a message stating "Your Data has Been Imported" will appear. Click OK.

The file format is as follows:
Column     Description                Field Width     Notes   
A          Price Group Number         3               1-200   
B          Price Group Name           15      
Import Vendors: Locate the file you would like to import and click OK. The file must be in the format specified below, otherwise it may not import properly. All rejected data will be placed in a log file called "import.log". After the procedure is complete, a message stating "Your Data has Been Imported" will appear. Click OK.

The file format is as follows:
Column     Description                Field Width     Notes   
A          Vendor ID                  3               1-200   
B          Vendor Name                15