Quickbooks Import QBI

[adam5532]

Hi Adam,

Notice: Query failed: Unknown column 'qbi_imported' in 'where clause' SQL: SELECT COUNT(*), MIN(products_id), MAX(products_id), MIN(UNIX_TIMESTAMP(products_date_added)) as date_min, MAX(UNIX_TIMESTAMP(products_date_added)) as date_max FROM products WHERE qbi_imported='0'

These warnings show up on the products import.

QBI adds a column "qbi_imported" to the PRODUCTS table. Something happened to the table and apparently that column got removed. You say you modified the database, so I assume that's where it went wrong. You can add it back by running this SQL statement:

ALTER TABLE `products` ADD `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL;

Thanks,
Adam