products import problem #8318

Hello Kostas,
Your log file is missing in the post. If the file is too big try to compress and post it. Also post the sample import file too

Hello Kostas,
Sorry to say but still your debug is missing in the post :)

Hello Kostas,
So i checked your debug log and your sample file, the product from your sample file has product_sku which is UniqueID as per sample file and is "8932" but it is taken as '0018932' for some reason, have a look at the query below from debug log

SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `jos_virtuemart_products` WHERE `product_sku` = '0018932'

Also, the same field value is used for virtuemart_product_id, check the other query

UPDATE `jos_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='0018932',`product_weight`='0.345',`product_in_stock`='100',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_sales`='0',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`pordering`='0',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='2016-06-02 09:08:41',`modified_by`='153',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_id`='0018932'

There is something not correct with setting up of template fields, Is there any rule set for fields? Can you post screenshot about your template fields and how have you set them?

Hello,

the change from "8932" to '0018932 it's not a problem because I've made it via a Rule.

I understand it is with a rule, but there is a problem here, the product_sku and Virtuemart_product_id has the same value of '0018932' which dont seem correct.

Hello Kostas,
Glad to know that your issue is solved. But I would also like to tell you that the usage of fields ending with _id is not recommended as using them will cause problem with your records in database. These _id fields are unique identifiers of a database table so better not to use them.