trouble parsing "kind of" comma-delimited text

I need to process a text file of product data that's supplied to me by a vendor. This data is "kind of" comma-delimited.... some of the rows contain commas within the "description" field, and in these cases (and only in these cases) that field's data is enclosed by double quotes. Here is some sample data: