Uploading Gear

James White -

To use the gear upload feature, you will need to provide a 'delimited' file containing the new inventory. Delimited implies that the different columns in the file (model, make, color, etc) are separated by a single character, usually a comma. You can create these files in applications like Excel, or Access and then export them as 'CSV' which is the acronym for 'comma separated values'. Once you have that file, you can upload it here and enter all your new inventory in just one step.

Quotes - In standard CSV all text fields (description, etc) must be surrounded by quotes and any quotes inside a text field should be doubled up, like "This is my description with ""quotes"" inside of it".

The list below shows the basic columns that your file can have. The first row of the file should contain the "Fieldname" to help identify what that column contains. If you do not have a header row, Gbase will try to guess based on the old ordering. Below this table you can also find links to the type, case, condition values Gbase understands.


* Unique Id

A text or numeric identifier unique to this item and consistent over time

1 Type Type Name or Id (Click for list) "Guitars : Electric Solid Body" or 8
2 Make Text "Fender"
3 Model Text "Stratocaster"
4 Year 4 Digit Number 2005
5 Color Text "Blue"
6 Condition Text matching Condition List "Brand New"
7 Case Text matching Case List "Original Hard"
8 Price Number 1995.00
9 Description Text "An excellent new fender with 12"" stock."
10 Picture #1 URL "http://www.mysite.com/images/newfender.jpg"
11 Picture #2 URL "http://www.mysite.com/images/newfender.jpg"
12 Picture #3 URL "http://www.mysite.com/images/newfender.jpg"
13 Picture #4 URL "http://www.mysite.com/images/newfender.jpg"
14 Picture #5 URL "http://www.mysite.com/images/newfender.jpg"
15 Picture #6 URL "http://www.mysite.com/images/newfender.jpg"
16 Dealer Key Text "Inventory #13123231"
17 Dealer Notes Text "Received guitar through trade"
18 Offsite Link #1 Label Text "Buy Now"
19 Offsite Link #1 Url URL "http://www.yahoo.com/mystore"
20 Offsite Link #2 Label Text "See Video"
21 Offsite Link #2 Url URL "http://www.youtube.com/newfender.html"

* New fields are located by the names in the first row of the file (the "header").

Lists of type, condition, case choices

Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk