Resolved Problem import with related categories

Hello,

This actually does make sense. As you pointed out you have the related_categories field in your import file but this is empty. CSVI just sees the field and wants to process any related categories, however because this field is empty, it doesn't find anything. As such it reports that no related categories are found. This is to be expected in this case because the field is empty.

I also have 3821 in _csvi_related_products should I delete all records as well?

CSVI will empty this table once it is done with the import, same goes for the related products. There is no harm in emptying it as it will be filled during import.

Hello,
In your database, can you look for #__csvi_related_categories table and see if you have any entries for product_sku ACUTEST2? It looks like there is already an entry in this table and the code is reading that related categories. Can you check and confirm?

Hello,
If you are having any difficulty in accessing your database. You can create a custom table export template, set table name to be csvi_related_categories on Options tab, add fields product_sku and related_cat as template fields, do the export and send us the export file. We will check for the entries for product_sku ACUTEST2 from the export file. You can also use the custom export template attached in this post for export.

Yes there is. Should I delete it? But the strange thing I did a complete clean new record, with new SKU and Category, just so to overcome any "old" data.

Hello,

Yes there is. Should I delete it?

Not sure how you have those records because after importing Related categories, CSVI will empty the table. Yes, you can delete those entries and then try the import.

But the strange thing I did a complete clean new record, with new SKU and Category, just so to overcome any "old" data.

In that case we need to confirm if there is already an entry for product_sku ACUTEST2. So before you clean the table, Can you do the custom table export and send the file as requested in my previous post?

btw there is no index of prim key on this table.
So I have multiple double entries some how:
ACU2TXRM Acura[TSX II | 2008-2014
ACU2TXRM Acura[TSX II | 2008-2014
ACU2TXRM Acura[TSX II | 2008-2014
ACU2TXRM Acura[TSX II | 2008-2014
ACU3RXRM Acura[RDX I
ACU3RXRM 2007-2012
ACU4RXRM Acura[RDX II
ACU4RXRM 2012-2018
ALF5STRM Alfa Romeo[Stelvio (949)
ALF5STRM 2017-present
ALF659RM Alfa Romeo[159
ALF659RM 2005-2011
ALF856RM Alfa Romeo[156
ALF856RM 1997-2007
ALF856RM Alfa Romeo[156 | 1997-2007
ALF856RM Alfa Romeo[156 | 1997-2007
ALF856RM Alfa Romeo[156 | 1997-2007

Seems to go wrong already with the category_path, I tried it with related_categories empty
Duplicate entry '2-50605-5336' for key 'opc_unique' again

Hello,
Can you post the latest debug log to check?

although my related_category is empty in csv, it still finds entries?

product_sku^product_gtin^category_path^product_name^product_s_desc^product_desc^product_price^file_title^file_description^file_meta^file_url^file_url_thumb^product_id_tax^product_weight^COM_VIRTUEMART_PRODUCTDETAIL_BODY^COM_VIRTUEMART_PRODUCTDETAIL_DATE^VM_MERK^VM_MODEL^VM_PRODUCTCATEGORIE^VM_MATERIAAL^manufacturer_id^product_mpn^related_categories^customtitle^metadesc^published
ACUTEST2^80031^Testcat1^Acura silver^^"Test description"^100^Menabo Jackson aero roof rack bars^ ^Menabo Jackson aero roof rack bars^menabo-jackson-silver-roof-rack-set-1.jpg^resized/menabo-jackson-silver-roof-rack-set-1.jpg^3^14^MODEL_WAGON^2011-2014^Acura^TSX II | 2008-2014^VM_ROOF_RACK_BARS^VM_ALUMINIUM^42^M000112800000^^Acura TSX II Sport Wagon Menabo Jackson aero roof racks | Car Parts Expert^Acura TSX II Sport Wagon Menabo Jackson aero roof rack set. Top quality aerodynamic roof racks, easy to mount and a fast delivery at Car Parts Expert!^0

Hello,
One reason query is still processed even when related_categories is empty in import file should be because of CSVI is getting the categories from #__csvi_related_categories table. Did you empty the complete table or just few records?

Just a few

deleted 1000+ records, now it finish, only failure on last line:

1 Updated Success Product updated
1 Updated Success Product language updated
1 Updated Success Media file updated
1 Added Success Image added
1 Updated Success Product price updated
1 Updated Success Manufacturer language table updated
1 Added Success Product manufacturer reference added
1 Added Success Product custom field reference added
1 Added Success Product custom field reference added
1 Incorrect Failure COM_CSVI_NO_RELATED_CATEGORIES_FOUND

"1 Incorrect Failure COM_CSVI_NO_RELATED_CATEGORIES_FOUND" Does this make sense?

I also have 3821 in _csvi_related_products should I delete all records as well?