Sample data> Sample spreadsheet 1> Sample spreadsheet 2 InstructionStep 1) New spreadsheetGo 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. 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. |
Help >