Sample data
> Sample spreadsheet 1
> Sample spreadsheet 2
Instruction
Step 1) New spreadsheet
Go to "http://docs.google.com/" and click on "Create new"
Step 2) Header
Create header line in the first row with the titles of each column. Available column titles are as follows.
itemTitle
itemNote
itemCategory
itemLocation
itemTag
itemDateTime
itemPrice1
itemQty
itemPrice2
itemTitle1 ...Title field in Product description section
itemDesc
itemCustomBarcode
itemASIN ...........Amazon ASIN code
itemUPC
itemISBN
itemEAN
itemModel
itemSerial
Step 3) Rows
Enter the the inventory items from the second row.
Each row will become one inventory item and Text in each columns are imported to corresponding fields.
When entering the data, please make sure about the following data format requirements.
1. Date format
All the values in "itemDateTime" should be in "YYYY-MM-DD_HH:MM" 24-hour format.
(i.e. 2011-12-31_23:59, 2012-02-28_10:30, ..)
2. Match the tag
The value in "itemCategory", "itemLocation" and "itemTag" columns should match to the existing label data in Barcode Express. Otherwise, new category, location or tag will be created for the entry.
If the "itemCategory" column is left blank, the entry will be imported into "Imported" category by default.
Step 4) Save
Save the spreadsheet with "save" button.
Before leaving the screen, please make sure which worksheet the data are saved in. The name of worksheet can be found at the bottom of the spreadsheet.
Now, your job is done in Google Docs. Go to Barcode Express and start the import.
Step 5) Import
Go to Google Spreadsheets import screen and press the "Sign in" button.
Step 6) Sign in
Enter Google account email and Password and press "Sign in" button.
Then you will see the list of Spreadsheets in your account.
Step 7) Spreadsheets
Press the spreadsheet you just created.
Now you can see the list of worksheets in the Spreadsheet.
Step 8) Worksheets
Press the worksheet you saved your cards.
Then you will see the list of cards.
Step 9) Import
Press the "Import" Button.
