Android OCR Plus Inventory Import/Export

This screen is used to import an item master or to export your inventory data.
At the top you have a message box that will show information or errors.
File Name field is where you type the name of file that you want to save when exporting your data.

Below the file name, you can combine Detailed/Summarized buttons with the type of file you want to export.
Clicking the and buttons will save the file as JSON. This file can be sent thru WI-FI to your computer by clicking , but it is also saved on the folder you have granted access.
Clicking the and buttons will save the file on your device's folder.
The folder can only be used when clicking Detailed/JSON combination.

The is used to download the ITEM_MASTER.CSV file from your computer or my website.

Import File field is where you type a file name that matches a file that you have placed on the device's folder to which you granted access on this app Settings screen.
For example, I created ponce folder on my device. I can place ITEM_MASTER1.CSV in the ponce folder then type ITEM_MASTER1.CSV on the Import File field then click

There are specific formats that can be loaded as item master.
These are fields that you can import:
upc
description
quantity_on_hand
retail
department
department_description
sku
cost
single_count
single_upc

Your file can have from one to 10 fields separated by commas(,)
For example, you can a file as follows: ITEM_MASTER1.CSV
upc
000000100014
000000100014
000000301008
000000400404
000000400411
000000461917
000001976892
000002621975
000004606321
000005076512
  
ITEM_MASTER2.CSV
upc,description
000000100014,40SQ FT(30X16)TRADITIO
000000301008,30IN 100SQ FT CHRISTMA
000000400404,40 SQ FT 40IN XMAS WRA
000000400411,40IN CHRISTMAS GIFTWRA
000000461917,flexSPCHERIS FEUR DELS
000001976892,ASSORTED THROW PILLOW 
000002621975,4.99 PET BED 
000004606321,CO COVER GIRL NAIL POL
000005076512,STEVENS SMK TURKEY DRU
  
ITEM_MASTER10.CSV
upc,description,quantity_on_hand,retail,department,department_description,sku,cost,single_count,single_upc
000000100014,40SQ FT(30X16)TRADITIO,0,0.01,084,Department 084,407477,0,0,
000000301008,30IN 100SQ FT CHRISTMA,0,0.01,084,Department 084,407478,0,0,
000000400404,40 SQ FT 40IN XMAS WRA,0,0.01,084,Department 084,474444,0,0,
000000400411,40IN CHRISTMAS GIFTWRA,0,0.01,084,Department 084,355575,0,0,
000000461917,flexSPCHERIS FEUR DELS,3,1,017,Department 017,487130,0,0,
000001976892,ASSORTED THROW PILLOW ,2,4.99,017,Department 017,197689,0,0,
000002621975,4.99 PET BED ,4,4.99,019,Department 019,262197,0,0,
000004606321,CO COVER GIRL NAIL POL,0,1,093,Department 093,645483,0,0,
000005076512,STEVENS SMK TURKEY DRU,0,2.59,074,Department 074,394377,0,0,
012000103131,Mocha 15 Pk,0,25.9,074,Department 074,,0,15,012000004100
  

As you can see you can have the file with one field or 10 fields. As you increase the number of fields, they need to be increased in the following order:
upc
description
quantity_on_hand
retail
department
department_description
sku
cost
single_count
single_upc
If one field is not needed, it can be left blank. For example in the following file, department, department_description, and sku are left blank ITEM_MASTER10.CSV
upc,description,quantity_on_hand,retail,department,department_description,sku,cost,single_count,single_upc
012000103131,Mocha 15 Pk,0,25.9,,,,0,15,012000004100
  
The following are link to files that can be used as templates:
ITEM_MASTER10.CSV
ITEM_MASTER9.CSV
ITEM_MASTER8.CSV
ITEM_MASTER7.CSV
ITEM_MASTER6.CSV
ITEM_MASTER5.CSV
ITEM_MASTER4.CSV
ITEM_MASTER3.CSV
ITEM_MASTER2.CSV
ITEM_MASTER1.CSV

Grant acces to folder