Resolved Duplicate entry '' for key 'slug'

Hello Dennis,
You did not paste the complete error. Slug field is a unique field and duplicate slug error means there is already an entry in database for slug with the same name as you are importing. If you want CSVI to generate unique slug field for you, you can set Recreate alias to Yes in your template settings and on Options tab and then run the import.

Thanks Tharuna.

I'll do that and get back to you.

Sorry for bugging you with questions all the time ;-)

Hi Tharuna,

Recreate Alias didn't work but here's what worked:

For some reason, inside the manufactuers table there was an entry with ID 0, empty name and empty slug. Deleting this allowed the import to proceed correctly both with and without the Recreate Alias option.

Thanks for your time and help once again!

Dennis

Hello Dennis,
Glad that you found it out. Yes those empty entries should not be there in database tables.

Hi i join this thread because i have similar error
Duplicate entry 'matrix-proforma-high-amplify-extra-silny-lak-400ml-1' for key 'slug'

in template settings i have recreate alias ON, so where is is mistake, after several attempts i erase whole tables in DB with manufacturer data, but error appears again!

com_csvi.log.24647.zip

Hello,
First thing i noticed in your debug log is that you have set import based on field to be product_name in your template settings and on Options tab. The idea of having the import based on field is that CSVI checks for a row in database with this field value, if the row exists the record is updated and if the row does not exist a new row is inserted. We would suggest to use unique fields like product_sku or product_gtin in import based on field instead of product name where duplicate product names are possible. Try import by changing this import based on field. If you still have any issues post your latest debug log along with your import file.

yes, change to product_sku helped
thx