Easy populate upload problem

[dan_daa_man]

Hi guys, Iv read through a few posts and i cant seem to find what im looking for. I download a full csv and edit it and upload, even if i just add in product model numbers or delete products it doesnt work and i get this error. Please Help

 

File uploaded.
Temporary filename: C:\Windows\Temp\php7187.tmp
User filename: pk.csv
Size: 13698
| 1 | Amazon Lev | Amazon Lev | amazon 60. | 12.45 | 1000 | | USWest | | HC ladder | | Amazon | | | | | | | | | 8 | Waypoints | 17 | Major Wayp | 2.5 | 19 | All Waypoi | 4 | 21 | None | 0 | 9 | Quests | 16 | Skill Ques | 2.5 | 18 | All Quests | 4 | 20 | None | 0 !New Product!
1366 - Incorrect integer value: '' for column 'products_tax_class_id' at row 1

INSERT INTO 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 ( 'amazon 60.jpg', '1', '12.45', '1', '2009-12-09 22:12:28', '2009-12-09 22:12:28', NULL, '', '', '1000', NULL) 

 

Settings & Info

 

EP vers: 2.76h-MS2

osCommerce Online Merchant v2.2 RC2a

OS:

HTTP: Microsoft-IIS/7.0

DB: MySQL 5.0.67-community-nt

PHP: 5.2.6 (Zend: 2.2.0)

 

Temp Directory:

//10.0.3.22/home/d2levelservices.com/public_html/OSC/catalog/temp/

Temp Dir is Writable

Magic Quotes is: off

register_globals is: off

Split files on: 300 records

Model Num Size: 12

Price with tax: false

Calc Precision: 2

Replace quotes: false

Field seperator: comma

Excel safe output: true

Preserve tab/cr/lf: false

Category depth: 7

Enable attributes: true

SEF Froogle URLS: false

More Pics: false

Unknown Pics: false

HTC: false

SPPC: false

Extra Fields: false

 

Many Thanks

[dan_daa_man]

Sorry Fixed. Thanks. silly mistake by myself