[Skip to main content](#vessel-content) # Another strange importing error ## - **[Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas_Sweden's Profile")** - [![Andreas_Sweden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1399-andreas-sweden "View Andreas_Sweden's Profile") Topic Author - [ Offline](/forum/user/1399-andreas-sweden) Less More - Posts: 51 - Thank you received: 0 - - 15 years 2 months ago [\#23932](#23932) by [Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas_Sweden's Profile") *[Another strange importing error](/forum/3-bug-report/23932-another-strange-importing-error#23932 "Here we go again with my CSV importing errors, we imported a file that was not correct and now when I try to re-import I get: "The product is of the type but it already exists in the database and is of the type main. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it." I have deleted the old products with the same code but still get the message, the CSV looks as follows: product_name;product_description;product_code;product_parent_id;product_weight;product_keywords;product_meta_description;price_value;storlek;images;categories;price_currency_id Hollister T-shirt Dam;Hollister T-shirt Dam;447917;;1;Hollister Dam;Hollister Dam;149;m;447917.jpg;2,16,983,984,15,831,672,985,;150 ;;447917 s;447917;;;;;s;;; ;;447917 m;447917;;;;;m;;; ;;447917 l;447917;;;;;l;;;")* was created by *[Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas_Sweden's Profile")* Here we go again with my CSV importing errors, we imported a file that was not correct and now when I try to re-import I get: "The product is of the type but it already exists in the database and is of the type main. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it." I have deleted the old products with the same code but still get the message, the CSV looks as follows: product_name;product_description;product_code;product_parent_id;product_weight;product_keywords;product_meta_description;price_value;storlek;images;categories;price_currency_id Hollister T-shirt Dam;Hollister T-shirt Dam;447917;;1;Hollister Dam;Hollister Dam;149;m;447917.jpg;2,16,983,984,15,831,672,985,;150 ;;447917 s;447917;;;;;s;;; ;;447917 m;447917;;;;;m;;; ;;447917 l;447917;;;;;l;;; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzkzMi1hbm90aGVyLXN0cmFuZ2UtaW1wb3J0aW5nLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 15 years 2 months ago [\#23938](#23938) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Another strange importing error](/forum/3-bug-report/23932-another-strange-importing-error#23938 "Here we go again with my CSV importing errors, we imported a file that was not correct and now when I try to re-import I get: "The product is of the type but it already exists in the database and is of the type main. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it." I have deleted the old products with the same code but still get the message, the CSV looks as follows: product_name;product_description;product_code;product_parent_id;product_weight;product_keywords;product_meta_description;price_value;storlek;images;categories;price_currency_id Hollister T-shirt Dam;Hollister T-shirt Dam;447917;;1;Hollister Dam;Hollister Dam;149;m;447917.jpg;2,16,983,984,15,831,672,985,;150 ;;447917 s;447917;;;;;s;;; ;;447917 m;447917;;;;;m;;; ;;447917 l;447917;;;;;l;;;")* The problem apparently comes from one of your variants, not the main product. You must have a product with the code 447917 s or 447917 m or 447917 l in your database. But since you use that code as a variant in your CSV, it warns you that it's not ok. You should first check on that. Then you could add the column product_type in your CSV to force the type like that: product_type;product_name;product_description;product_code;product_parent_id;product_weight;product_keywords;product_meta_description;price_value;storlek;images;categories;price_currency_id main;Hollister T-shirt Dam;Hollister T-shirt Dam;447917;;1;Hollister Dam;Hollister Dam;149;m;447917.jpg;2,16,983,984,15,831,672,985,;150 variant;;;447917 s;447917;;;;;s;;; variant;;;447917 m;447917;;;;;m;;; variant;;;447917 l;447917;;;;;l;;; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzkzMi1hbm90aGVyLXN0cmFuZ2UtaW1wb3J0aW5nLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas_Sweden's Profile")** - [![Andreas_Sweden's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1399-andreas-sweden "View Andreas_Sweden's Profile") Topic Author - [ Offline](/forum/user/1399-andreas-sweden) Less More - Posts: 51 - Thank you received: 0 - - 15 years 2 months ago [\#23940](#23940) by [Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas_Sweden's Profile") Replied by *[Andreas\_Sweden](/forum/user/1399-andreas-sweden "View Andreas_Sweden's Profile")* on topic *[Re: Another strange importing error](/forum/3-bug-report/23932-another-strange-importing-error#23940 "Here we go again with my CSV importing errors, we imported a file that was not correct and now when I try to re-import I get: "The product is of the type but it already exists in the database and is of the type main. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it." I have deleted the old products with the same code but still get the message, the CSV looks as follows: product_name;product_description;product_code;product_parent_id;product_weight;product_keywords;product_meta_description;price_value;storlek;images;categories;price_currency_id Hollister T-shirt Dam;Hollister T-shirt Dam;447917;;1;Hollister Dam;Hollister Dam;149;m;447917.jpg;2,16,983,984,15,831,672,985,;150 ;;447917 s;447917;;;;;s;;; ;;447917 m;447917;;;;;m;;; ;;447917 l;447917;;;;;l;;;")* I see the problem is that one of my co-workers imported a file with two colums "product_code" do we have to delete these in the DB? I can't find them in the back end. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzkzMi1hbm90aGVyLXN0cmFuZ2UtaW1wb3J0aW5nLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 15 years 2 months ago [\#23944](#23944) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Another strange importing error](/forum/3-bug-report/23932-another-strange-importing-error#23944 "Here we go again with my CSV importing errors, we imported a file that was not correct and now when I try to re-import I get: "The product is of the type but it already exists in the database and is of the type main. In order to avoid any problem the product insertion process has been skipped. Please correct its type before trying to reimport it." I have deleted the old products with the same code but still get the message, the CSV looks as follows: product_name;product_description;product_code;product_parent_id;product_weight;product_keywords;product_meta_description;price_value;storlek;images;categories;price_currency_id Hollister T-shirt Dam;Hollister T-shirt Dam;447917;;1;Hollister Dam;Hollister Dam;149;m;447917.jpg;2,16,983,984,15,831,672,985,;150 ;;447917 s;447917;;;;;s;;; ;;447917 m;447917;;;;;m;;; ;;447917 l;447917;;;;;l;;;")* Yes. You should try that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yMzkzMi1hbm90aGVyLXN0cmFuZ2UtaW1wb3J0aW5nLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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.065 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)