Duplicate error

-- HikaShop version -- : 264 business
-- Joomla version -- : 365
-- PHP version -- : 7014
-- Error-message(debug-mod must be tuned on) -- : 1062 Duplicate entry '15.09.0004' for key 'product_code' SQL=UPDATE `#__hikashop_product` SET `product_name`='Witte brievenbusdoos - zelfklevend 170*27*255mm',`product_code`='15.09.0004',`product_quantity`='-1',`product_manufacturer_id`='',`product_published`='1',`product_tax_id`='11',`product_msrp`='0.0000000',`product_page_title`='',`product_url`='',`product_meta_description`='',`product_keywords`='',`product_alias`='witte-brievenbusdoos-zelfklevend',`product_canonical`='',`product_min_per_order`='25',`product_max_per_order`='0',`product_sale_start`='',`product_sale_end`='',`product_access`='all',`product_warehouse_id`='',`product_weight`='0.000',`product_weight_unit`='kg',`product_length`='0.000',`product_width`='0.000',`product_height`='0.000',`product_dimension_unit`='m',`product_layout`='',`product_quantity_layout`='',`product_group_after_purchase`='',`product_type`='main',`product_description`='Met de brievenbusdoos zijn uw producten optimaal en professioneel verpakt. Makkelijk op te zetten en snel inpakken door de zelfklevende sluitstrips. Aangezien de brievenbusdoos precies door de brievenbus past, profiteert u van het lage brievenbustarief. Dit brievenbusdoosje is onmisbaar voor webshops en bedrijven die aan e-commerce doen.\r\nProducteigenschappen:•Makkelijk op te zetten verpakking.•Stevige verzendverpakking.•Makkelijk te openen door duimgreep met scheurperforatie.\r\n•Zelfklevende sluitstrips, diefstalveilig verpakken.•Profiteer van een laag posttarief.',`product_modified`='1483089589' WHERE `product_id`='631'

I have imported and deleted the contents of a csv file. Started adding products manually, works like a breeze...
--
However, i noticed that i made an error with the product codes. its a x.xx.xxxx sequence. I entered x.x.xxx so i forgot a zero in the last xxxx. When I alter the product code and add the zero, I get a duplicate product error. Strange thing is, when I search for the product that seems to be there, I cannot find it... Is there a way I can empty trashed items, because they now seem to prevent me from adding...

Hi Nicolas,

My best wishes. I looked ad what you suggested, but we are not there yet. When I search for a product from the main category with all options enabled, it says the product is not there. When I try to save an article I get the error and cannot proceed. Is there a trashbin for products I can look at? And if yes how can I find it?

Hello,

Is there a trashbin for products I can look at? And if yes how can I find it?

The solution will probably just be to directly :
- Use the checkbox of your product through your product listing via "Hikashop->Products"
- Use the "Delete" button

Are you getting an error message when you try to save for each products ?

Started working on this issue again. I will try to explain as well as I can what happens.

On screenshot one you see that I search for products with code 03.03 shop root level, search settings to ' all' as proposed by Nicolas. There is only one product 03.03..0044 this is the wrong code it should be 03.03.0044
--
03.03.0044 is not present in the shop I cannot find it no matter what i try however... when I try to alter the article number and hot save I get the error as in screen shot 2 stating that the article is already present. This happens with 20-25% of all articles.

Old customers abandon their cart as they cannot find the article numbers they are used to.

Thanks for your reply.

Regards,
Pierre

Thank you very much for looking into this matter. You have put me on the right track. I do not know how they got there, have still a lot of tedious work to do but I know now how to fix it. Thanks again!