we use [login to view URL] to update our oscommerce database and and have added some new fields to the database.
to match our spreadsheet we need
$col1="Manufacturer Name";
$col2="Manufacturer Image";
$col3="Main Category";
$col4="Sub Categories";
$col5="Sub Sub Categories";
$col6="Product Model";
$col7="Product Image";
$col8="Product Price";
$col9="Product Weight";
$col10="Product Name";
$col11="Product Description";
$col13="products_price1";
$col14="products_price2";
$col15="products_price3";
$col16="products_price4";
$col17="products_price5";
$col18="products_price6";
$col19="products_price7";
$col19="products_price8";
$col20="products_sizechart";
the new fields are all in the products table attached is the forst few lines of our products table