[Skip to main content](#vessel-content) # characteristics exists in database type variant! ## - **[mici](/forum/user/33257-mici "View mici's Profile")** - [![mici's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33257-mici "View mici's Profile") Topic Author - [ Offline](/forum/user/33257-mici) Less More - Posts: 16 - Thank you received: 0 - - 11 years 9 months ago [\#186538](#186538) by [mici](/forum/user/33257-mici "View mici's Profile") *[characteristics exists in database type variant!](/forum/37-import-export-csv-xls/874237-characteristics-exists-in-database-type-variant#186538 "-- url of the page with the problem -- : 5.10.105.46/~yamity3c/ -- HikaShop version -- : HikaShop Business: 2.3.5 -- Joomla version -- : Joomla! 3.3.0 Stable -- PHP version -- : 5.3.29 -- Error-message(debug-mod must be tuned on) -- : The product PROWAVE_142 is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it. When trying to import .csv with characteristics it does NOT recognized the products id with the characteristics I get an error: The product ..... is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it. Even after I reimport it via the mass action or the import product I still get the same error please help! M")* was created by *[mici](/forum/user/33257-mici "View mici's Profile")* -- url of the page with the problem -- : 5.10.105.46/~yamity3c/ -- HikaShop version -- : HikaShop Business: 2.3.5 -- Joomla version -- : Joomla! 3.3.0 Stable -- PHP version -- : 5.3.29 -- Error-message(debug-mod must be tuned on) -- : The product PROWAVE_142 is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it. When trying to import .csv with characteristics it does NOT recognized the products id with the characteristics I get an error: The product ..... is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it. Even after I reimport it via the mass action or the import product I still get the same error please help! M Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzQyMzctY2hhcmFjdGVyaXN0aWNzLWV4aXN0cy1pbi1kYXRhYmFzZS10eXBlLXZhcmlhbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 9 months ago [\#186549](#186549) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[characteristics exists in database type variant!](/forum/37-import-export-csv-xls/874237-characteristics-exists-in-database-type-variant#186549 "-- url of the page with the problem -- : 5.10.105.46/~yamity3c/ -- HikaShop version -- : HikaShop Business: 2.3.5 -- Joomla version -- : Joomla! 3.3.0 Stable -- PHP version -- : 5.3.29 -- Error-message(debug-mod must be tuned on) -- : The product PROWAVE_142 is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it. When trying to import .csv with characteristics it does NOT recognized the products id with the characteristics I get an error: The product ..... is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it. Even after I reimport it via the mass action or the import product I still get the same error please help! M")* Hi, The message is saying that the product with the product code "PROWAVE_142" is already existing in your database as a product code of a variant. Because you're trying to import such product as a main product, you want to change the type of the product so the import refuse that. So please - correct your database by changing the product type. OR - correct your database by changing the product code. OR - correct your CSV by using another product code. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzQyMzctY2hhcmFjdGVyaXN0aWNzLWV4aXN0cy1pbi1kYXRhYmFzZS10eXBlLXZhcmlhbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mici](/forum/user/33257-mici "View mici's Profile")** - [![mici's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33257-mici "View mici's Profile") Topic Author - [ Offline](/forum/user/33257-mici) Less More - Posts: 16 - Thank you received: 0 - - 11 years 9 months ago - 11 years 9 months ago [\#187174](#187174) by [mici](/forum/user/33257-mici "View mici's Profile") Replied by *[mici](/forum/user/33257-mici "View mici's Profile")* on topic *[Change a product with Characteristics via cvs](/forum/37-import-export-csv-xls/874237-characteristics-exists-in-database-type-variant#187174 "-- url of the page with the problem -- : 5.10.105.46/~yamity3c/ -- HikaShop version -- : HikaShop Business: 2.3.5 -- Joomla version -- : Joomla! 3.3.0 Stable -- PHP version -- : 5.3.29 -- Error-message(debug-mod must be tuned on) -- : The product PROWAVE_142 is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it. When trying to import .csv with characteristics it does NOT recognized the products id with the characteristics I get an error: The product ..... is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it. Even after I reimport it via the mass action or the import product I still get the same error please help! M")* -- url of the page with the problem -- : 5.10.105.46/~yamity3c/ -- HikaShop version -- : HikaShop Business: 2.3.5 -- Joomla version -- : Joomla! 3.3.0 Stable -- PHP version -- : 5.3.29 -- Error-message(debug-mod must be tuned on) -- : The product mhTop_2643 is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it. I try to change a price of a product with Characteristics via .csv or mass action (see attached csv file) product_id | product_name | price_value | mhbot1 4229 | Name1 | 2222 | Value1 Via: import - Error - The product mhTop_2643 is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it. Via - mass Action - Error - Notice The line '' could not be imported Product not found. I have change: 1. the product type - I have change to main but is not what I need. I need it to be a variant (or what other type a product with Characteristics can be?) 2. Changing the product code. (did not work) 3. Correct your CSV by using another product code. (did not work) Please assist on how can I change a price value of a product with Characteristics via .csv or mass action M --- I have export a product with Characteristics via cvs with product code. (Attached is an screen shoot image with the way i am exporting the product via mass action.) Here is the text result (attached a csv too) "product_id";"product_name";"product_description";"product_code";"catlog_number";"price_id";"price_value" 4229;"Name1";"";"mhTop_2643";"";16590;40.00000 I still can not change the price within a product with Characteristics Please advise Thanks M - [ ![Screen_Shot_2015-01-18_at_6_52_44_PM.png](/forum/attachment/21791) ](/forum/attachment/21791 "...6_52_44_PM.png") [ ](/forum/attachment/21791?download=1 "...6_52_44_PM.png") Last edit: 11 years 9 months ago by [mici](/forum/user/33257-mici "View mici's Profile"). Reason: Change a product with Characteristics via cvs with product code NOT working Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzQyMzctY2hhcmFjdGVyaXN0aWNzLWV4aXN0cy1pbi1kYXRhYmFzZS10eXBlLXZhcmlhbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 9 months ago [\#187179](#187179) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Change a product with Characteristics via cvs](/forum/37-import-export-csv-xls/874237-characteristics-exists-in-database-type-variant#187179 "-- url of the page with the problem -- : 5.10.105.46/~yamity3c/ -- HikaShop version -- : HikaShop Business: 2.3.5 -- Joomla version -- : Joomla! 3.3.0 Stable -- PHP version -- : 5.3.29 -- Error-message(debug-mod must be tuned on) -- : The product PROWAVE_142 is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it. When trying to import .csv with characteristics it does NOT recognized the products id with the characteristics I get an error: The product ..... is of the type main but it already exists in the database and is of the type variant. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it. Even after I reimport it via the mass action or the import product I still get the same error please help! M")* Hi, Please do not create a new thread for the exact same problem. I already gave you an explanations for the error message ; if you do not understand it you can just say and we will reformulate it. 1. If you need the product to be a variant so ; don't try to replace an existing product which is a "main" one. 2. ok 3. There is no product code in your CSV ; how did you changed it ? I can only recommend you to use a mass action and not use the import system. The import system has been made to import ALL information of a product ; it means that you need to import a complete and full CSV containing ALL columns of a product ; the kind of CSV you can retrieve by performing an export. The CSV you're trying to import is highly uncompleted ; it can't be imported due to the too many missing data. Please use a CSV in a correct formating, using coma or semi colon as separator and using double quotes for string encapsulation. So, you need to use a mass action. [ www.hikashop.com/support/support/documen...massaction-form.html](http://www.hikashop.com/support/support/documentation/167-massaction-form.html) Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzQyMzctY2hhcmFjdGVyaXN0aWNzLWV4aXN0cy1pbi1kYXRhYmFzZS10eXBlLXZhcmlhbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.157 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)