Huge eBay store with Turbo Lister 2

If you are working with eBay and creating an eBay store, consider the free eBay Turbo Lister 2.

Download the software, create a sample listing, export the file. Then, on Excel, open the .csv file you exported, insert all your database on this file.

But there comes a problem - Turbo Lister 2 does not import file with line break. You have to remove all line breaks. And replace them with HTML break.

Bellow is a formula, just copy and past this formula on the Macro (under tools, on excel 2003). Where you see the number 9, substitute that for the column number where your description is (A=1, B=2, etc).



Sub line_break()
Dim TheCell As Range
Dim myReplaceWith$
myReplaceWith = "" (insite this brackets you put html br or p for paragraph - with <>)
For Each TheCell In ActiveSheet.UsedRange.Columns(9).Cells
With TheCell
If .HasFormula = False Then
.Value = Application.WorksheetFunction.Substitute(.Value, Chr(10), myReplaceWith)
.Value = Application.WorksheetFunction.Substitute(.Value, Chr(13), myReplaceWith)
.Value = Application.WorksheetFunction.Clean(.Value)
End If
End With
Next TheCell
End Sub


After you run this formula, save the file as .csv, and import to Turbo Lister. Then, upload all your items directly to eBay.

This is a simple way that will allow you to create an eBay store with information directly from your database in a few hours.

Good luck.


Ricardo Guimaraes
Avatar Interactive
http://www.avatarinteractive.com