I have a problem with import for products. I get an error but I have no idea where the problem is.
I did some debugging but the column exist.
What is the problem here?
| di, 14 jun 2016 14:00:38 | Starting job - Product Import - 2.Product. | |
| di, 14 jun 2016 14:00:39 | Starting import to temporary table for EcomVariantOptionsProductRelation. | |
| di, 14 jun 2016 14:06:51 | Added 2828 rows to temporary table for EcomVariantOptionsProductRelation. | |
| di, 14 jun 2016 14:06:51 | Finished import to temporary table for EcomVariantOptionsProductRelation. | |
| di, 14 jun 2016 14:06:51 | Starting import to temporary table for EcomVariantgroupProductRelation. | |
| di, 14 jun 2016 14:07:55 | Added 199 rows to temporary table for EcomVariantgroupProductRelation. | |
| di, 14 jun 2016 14:07:55 | Finished import to temporary table for EcomVariantgroupProductRelation. | |
| di, 14 jun 2016 14:07:55 | Starting import to temporary table for EcomProducts. | |
| di, 14 jun 2016 14:09:30 | Added 3027 rows to temporary table for EcomProducts. | |
| di, 14 jun 2016 14:09:30 | Finished import to temporary table for EcomProducts. | |
| di, 14 jun 2016 14:09:30 | Starting import to temporary table for EcomProductCategoryFieldValue. | |
| di, 14 jun 2016 14:09:32 | Added 10000 rows to temporary table for EcomProductCategoryFieldValue. | |
| di, 14 jun 2016 14:09:33 | Added 20000 rows to temporary table for EcomProductCategoryFieldValue. | |
| di, 14 jun 2016 14:09:34 | Added 26721 rows to temporary table for EcomProductCategoryFieldValue. | |
| di, 14 jun 2016 14:09:34 | Finished import to temporary table for EcomProductCategoryFieldValue. | |
| di, 14 jun 2016 14:09:49 | Import job failed: Failed to remove rows from Table [dbo.EcomVariantgroupProductRelation] that where not present in source. Exception message: Invalid column name 'ProductVariantID'. Sql query: Delete from [dbo].[EcomVariantgroupProductRelation] where not exists (select * from [dbo].[EcomVariantgroupProductRelationTempTableForBulkImport] where ([dbo].[EcomVariantgroupProductRelation].[VariantgroupProductRelationID]=[VariantgroupProductRelationID] or ([dbo].[EcomVariantgroupProductRelation].[VariantgroupProductRelationID] is null and [VariantgroupProductRelationID] is null)) ) and ( [ProductVariantID] = @conditional0 ) | |
| di, 14 jun 2016 14:09:54 | Finished job - Product Import - 2.Product. |