I just had 2500 items on a price list spread sheet (excel)

I saved the spreadsheet as a tab delimited text file

I got the format that the BVC Import tool requires to do an import, by getting an export from the new site where I had 1 or 2 test product in place.

I wrote a VB app to open the text file from the price list, re-map the columns to the format required by the import tool and then I had it make

a new output txt file.

Then I used the BV Commerce Import tool to read my newest text file and push the data into the web site data base.

It took a couple of days and late nights.

---

You cant just do it using SQL because you need to be able to create bvins and links to other tables ( if any).

Somewhere else of the forum, I read that you could call the APIs that come with BV Commerce, but I have not seen these yet. SO Much To Learn, so little time.