Home of Baylister, an auction listing aid.

Home  |   Support  |   Download  |   Donate  

"eBay and the eBay Logo are trademarks of eBay Inc."

Getting started.

When you start BayLister for the very first time, it will create a blank, MS Access97 database for you. If you wish to use Access2000, or another SQL database, use the "F5" key to bring up the "Startup Options" screen and select a database type. Then exit the program and restart. The desired database type will be created for you. Notice that the Startup Options screen also allows other program variables to be selected.

If you are running the Vista operating system, we'd advise against changing the locations of the Html folder or the Helpfiles folder. Also, if you encounter any problems using Vista, let us know. Due to the many security problems in Vista, it is hard to cover everyones particular setup.

While you're in the Startup Options screen it would be a good idea to set up a Host and Default Picture Directories. The Host directory is a place where all self hosted pictures from a listing will be kept for uploading. The Default Picture Directory will be used as the source for your pictures unless you override it on the Current Item screen.

If you don't already have a seller's account on eBay, this would be a good time to create one. If BayLister is running, merely click on the eBay button at the top of the screen and your browser will start and take you to the eBay sign-in/register page. You can do the same to set up an account with Paypal if you desire.

Now - before you do anything else, start up BayLister and press the "F7" key.
Then modify your preset file for your useage of eBay.

In particular:

  • Site = (Select the site you will be posting to)
  • Currency = (Select the currency you wish to use)
  • Location - Country = (Select the country in which your items are located)
  • Postal Code = (enter your Zip code)
  • Location - City/State = eg. Mytown, Mystate
  • PayPal Email Address = eg. me@comcast.net
  • Zip = (The Zip code from which you will ship your items)

    To modify these merely click on the line to change, and then type the new value in the "Your value" box above the list (or select from the drop-down list). Make sure you press the tab key after changing the value. Then save your changes.

    Note: Site should be selected as the primary site on which you want to list. You may select a currency that is different than what would normally be used on that site (so that you may work in your native currency), but the country you select must match the site (eBay won't accept listings otherwise). Unfortunately, eBay will only accept shipping services from the country/site you've selected, so if you want to list on the UK site and ship from the US, you'll have to declare shipping services and costs in your descriptions.

    Now you're ready to create a new listing, or import some from Turbo Lister. If you choose to import, run your TL program (either TL1 or TL2), select the listings to export and then choose "File:Export Selected Items". Now select Turbo Lister Format (CSV file) and click on Options. Make sure that "All" is selected, click on Export, select a folder and filename, and then Save as a .csv file. This will be the file that you then "Import" into BayLister.

    The first screen you see upon starting up BayLister, is the main Inventory screen.

    For the purposes of this tutorial, I've created 2 folders named Apples and Oranges. This was done by right-clicking on the "All Folders" tab and selecting "Add Folder" from the drop-down list. This is how you manage folders also. You may rename or delete folders, but you need to empty a folder of all listings prior to deleting it. on the Inventory tab.

    All listings to be uploaded to eBay must be put in the Pending Group to "Verify" or "Upload". The same holds true for any listing (that has already been uploaded) that you want to modify. After "Upload", you can (and should) move them to another Group such as "Active". Each Folder will contain the same 5 Groups. When All Folders is selected, each Group will display all the listings from that Group for the entire database.

    Note: When "All folders" is selected, right-clicking on a title, while holding down the SHIFT key,will show you what folder that listing is in as well as which user it belongs to (if you are currently the default user). If you are not the default user, only your listings will be displayed (see the F2 key).

    Screen shot showing the Pending Group of the Apples Folder tutor11b (10K)

    (truncated view)

    This is where all of your item data will be listed, categorized, summarized and managed. We will return to this tab later, after an auction listing has been created. Notice that this screen shows that there are 11 listings (All), with 2 in the Pending Group, 4 in the Didn't Sell Group, and 5 in the Misc Group. Notice that the 2nd line is high-lighted in blue. This indicates it is selected. If you double-click on it, or just click on the Current Item tab, the Current Item screen will appear.

    Before you can create a listing, you need to load the pre-defined categories from eBay. Just click on the categories button and the latest version will be downloaded. If you have a store, and you've already registered BayLister with eBay, the store categories will also be downloaded. A drop-down list will then appear on the Current Item screen just under the auction categories. If you haven't already registered BayLister with eBay, and you have a store, don't forget to Get Categories again after you register Baylister.

    The second tab, Current Item, is where all of the eBay item specific data will be entered.

    If you are creating a listing from scratch, this is where you want to start. In the following series of images, I'll show some partial screen shots of various features that may be used to generate the listing data. The description section of your listing will be covered on subsequent screens pertaining to the "Preview" screen and entering data on it. With nothing selected on the Inventory screen, clicking on the Current Item tab will show the following screen.

    Screen shot showing the Current Item screen with no data entered yet.

    tutor12b (10K)

    Most of the item's data will be entered here. Many of the fields have dropdown buttons to aid in entering data. For example, the buttons next to Title and Sub Title will show you a list of previously used entries to select from or modify. You don't have to do this, you can just type away to enter the new information, or if you just type a couple of letters and then click the button, you will be presented with a drop-down of previously used titles starting with those letters. The same holds true for Sub-Titles.

    The Category button will show the available categories in each category group until you've reached the lowest sub-group. If the drop-down is empty when you click on it, you probably need to download the categories first. Use the category button. Also take note that any green shaded entries will probably incur additional eBay fees.

    Notice that near the bottom is a list of the Groups. The listing that is prepared here will be put in the designated Group (Pending) and the folder that was selected on the Inventory screen (All). For this example I'll add a title and select a category.

    Note the Pre button to the right of the Category button. This will allow you to type in a UPC code for your item and have eBay create your listing using pre-filled information they maintain on their servers. The same holds true for ISBN numbers for books.

    For most entry boxes and buttons on this page, you can "park" the cursor over the item and a "hint" box will pop up showing a brief explanation. Press the F1 key to then bring up a help window showing more detailed information on the item of interest.

    The URL box allows you to define the web location for your pictures, most probably a website/folder on your web space. eg. Comcast users have space allocated in the form http://MyWebPages.comcast/userid whereas Verizon users have http://Mysite.verizon.net/userid. You can log into your space and create folders, such as MyPics, and then upload your pictures there to be used in your listings. ALL self-hosted picture for a single listing must be located in a single directory located at this URL.

    Similarly, the field marked Disk allows you to set a directory on your local hard disk that will contain the original pictures used by this listing. The program will prefix the proper path to the picture name when it is viewed in the Preview tab or uploaded to eBay. This will become clearer when we set up the description, pictures, etc. later. As above, ALL pictures on your local disk, for this listing, must be in the disk directory you specify.

    Notice there is a new data entry area at the lower right. You can now set a date & time at which you want your listing uploaded. As long as your computer is on and BayLister is running, any scheduled listings will be Uploaded and/or updated at those times. These fields will only be visible when the listing is in the Pending Group. By right-clicking on the Start field on the Inventory/Pending Group, you can also schedule a listing (or modify the date/time).

    If you only want a single picture added to your item listing, enter it into the Picture 1 box or use the button to the right of the box to browse for the picture. If you want a second picture then enter it's name into the Picture 2 box. If you select to show a Gallery picture, the picture in the Picture 1 box will be the one shown in the gallery and in the listing. The gallery and second picture always have an extra cost associated with them, which is why they are green, whereas the Picture 1 hosted by eBay, is free. Don't forget to choose the Gallery picture option in the dropdown box.

    If you check the EPS checkbox, your pictures will be hosted by eBay, else they will be hosted by you, on your web space at the URL you have specified. Don't let this scare you, it's simple to do and we'll be more than happy to give you the information you need to do it.

    The Group radio buttons allow you to direct the listing to show in the proper Group on the Inventory tab. Duration, start price, etc. should be self explanatory, Again, the green shading implies extra insertion fees.


    We've recently (Jan 2008) upgraded our shipping options to allow both domestic and international shipping services with both calculated and multiple flat rate options. You may also choose to use Digital Download for electronically transmitted data (eBay has restrictions on who may use this and ownership requirements for the data you are selling. Check with them for details).


    By choosing the different tabs - Domestic and International, you can set your services, costs, etc for each.
    At the top of the shipping area, you may choose your overall International shipping destinations, or by clicking on the elipsis button (the 3 little dots) you can specify distinct destinations for each shipping service you choose.

    If you choose Flat shipping, you may still enter the item weight for your records. I find it particularly helpful at shipping time. If you choose Flat shipping and enter 0.00 for the cost, your listing will show "Free Shipping".

    For those in the UK, Australia, and Canada, your shipping options will be shown in the dropdowns and there is a preset (set via the F7 key) to allow weights in kilograms and grams. For UK users, eBay only allows flat rate shipping to be used. If you try to use calculated, you will get error messages from eBay at Upload time.

    BayLister does not do consistency checks on most of the data from this sheet, eBay is too inconsistent to keep track of. Instead we let eBay do the checking upon upload. If they don't approve of the data sent to them, they return an error code which we put in the "hint" field of the Title on the Inventory/Pending screen, and also mark it in red (by "hint" field, I'm refering to a hidden text box underneath the Title of the listing. When you move your mouse pointer over the Title, the hint will appear). If you get an Item ID back, the listing has been accepted by eBay. It may still have problems, either minor or warning (check the hint box if the Title has turned reddish). We recommend checking the Verify box (located in the Title column) and submit your listings first. This will check them and return the listing fees for each item without actually uploading them.

    Any of the data on the Current tab can be selected and then saved as a preset. After entering the data you deem common to many listings, merely type in a reference name in the Preset box at the top and click SavePreset. Now when you come to the Current screen to prepare a new listing, merely select your preset template then add the additional unique item data and save. Multiple presets can be used on a single item. e.g. You may use a preset to set your standard shipping preferences, another one for your standard payment types and maybe another one to set your default directories.

    The completed screen for this example should look like this:

    After saving the item, the Inventory screen looks like this:

    Now lets add the description, and any other self hosted pictures you may want.