Wrong number of fields detected (x instead y)

Your Yahoo Store might give you a message that says, "WARNING: Wrong number of fields detected(6 instead 7)" when you upload a CSV file from Excel into your Yahoo Store Editor or Catalog Manager via Database Upload.

This is an Excel problem. Sometimes, Excel does not put trailing commas if the last few fields in a row are blank. In that case, Yahoo thinks the field is missing. As a workaround, just rearrange the columns so that a column with full data is the right-most column. For example, you can just move the 'id' column to the end.

An example is below.

Tue May 1 10:40:10 2011
Database upload	default-table Uploaded
Field names=(:ID :MANUFACTURER-PART-NUMBER :BRAND :GOOGLE-PRODUCT-TYPE
:UPC :NAME :MANUFACTURER)
600 records are loaded for add.

Warnings and Errors
Record	Detail
16 [Show]	WARNING: Wrong number of fields detected(6 instead 7)
17 [Show]	WARNING: Wrong number of fields detected(6 instead 7)
18 [Show]	WARNING: Wrong number of fields detected(6 instead 7)
19 [Show]	WARNING: Wrong number of fields detected(6 instead 7)
20 [Show]	WARNING: Wrong number of fields detected(6 instead 7)