Help‎ > ‎

1. Import from Google Drive?

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.