Creating a Data Source for the Used-Line Robot

Our robot can often spider inventory data from dealer websites, but best results are obtained when you make a download source for our robot. The download source can be an HTML table. If you can not make an online data feed, you can email us an Excel Spreadsheet.

General Specifications for HTML, or Excel:
Here is a list of the data fields that are used in all three formats.

  • MFR - Item Make or Manufacturer

  • Model - Model Number.

  • Desc - Description

  • Price - Price in Dollars, just a number no $ sign Leave it blank and "Call" will be displayed.

  • Picture - Link to Photo. Including entire path to image file. Not required.

  • Link - Link to Item detail page - Used only for premium listings. Leave Empty unless you signed up for the Premium Items service.

  • Options - Options installed

  • Keywords - Keywords used to help our robot determine correct category. Used-Line subcategory names work best. Not required.

  • In_Stock - Include the words 'in stock' for the Used-Line in-stock listings upgrade. Not required.

  • Condition - Item condition, new, used, refurbished etc.

Use any name you want for the files.
Up to 500 on a page to prevent timeouts.
Save your HTML files on your server numbering consecutive pages, for example ; http://www.yourcompany.com/ul01.cfm, http://www.yourcompany.com/ul02.cfm or http://www.yourcompany.com/ul01.asp, http://www.yourcompany.com/ul02.asp.

Excel Specific Instructions:
Keep formatting to a minimum. All the cells in a column should be and all rows should be uniform. There must be one column for each of the data fields in the list above and the columns must be in the order above. Unused fields should be left as an empty column. Click here to download an template.

HTML Specific Instructions:
Keep formatting to a minimum. There must be one column for each of the data fields in the list above and the columns must be in the order above. Unused fields should be left as an empty column.


HTML table


1. MFR 2. Model 3. Descr 4. Price 5. Picture 6. Link 7. Option 8. Category 9. In Stock 10.Condition
ACTiSYS 100 infrared adapter New
Agilent 350 CAT5 cable analyser 500 http://myserver.com/pic_path.jpg cable analyser In Stock
Fluke TTY Q90 phone typer ; Refurbished
Ameritech AM8a PCM/VF call analyser http://myserver.com/item_path.asp 03/04/05 New