Hi,

Getting the below when trying to import after modifying the various lines per your instruction. The first record will update correctly but the others will not (the subsequent records were new items). I have triple checked the mods and they are correct. Downloading the file gives me the correct columns I want.
They are "products_sort_order" and "default_subcontractor" (from another mod). Tried it also with just "products_sort_order"
and same problem. Below is the error log.

Thanks for any help!

Art

MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'no_picture.gif','3R1919-14B-CW',
'349.99',
'1',
CURRENT_TIMESTAMP,
"2009-01-09 13:59",
NULL,
'1',
'28',
'20',
'',
'0',
'13')