[Skip to main content](#vessel-content) # Issue when importing ## - **[protorob](/forum/user/5729-protorob "View protorob's Profile")** - [![protorob's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5729.png)](/forum/user/5729-protorob "View protorob's Profile") Topic Author - [ Offline](/forum/user/5729-protorob) Less More - Posts: 96 - Thank you received: 14 - - - - [](http://www.euromarnautica.com) - 14 years 2 months ago [\#61585](#61585) by [protorob](/forum/user/5729-protorob "View protorob's Profile") *[Issue when importing](/forum/2-general-talk-about-hikashop/61585-issue-when-importing#61585 "As you know, in my latest posts i've been talking about an installation of hikashop with something about 10k products, ok, actually i'm working on it actively, and i'm working veeeery hard on the csv...")* was created by *[protorob](/forum/user/5729-protorob "View protorob's Profile")* As you know, in my latest posts i've been talking about an installation of hikashop with something about 10k products, ok, actually i'm working on it actively, and i'm working veeeery hard on the csv structure and all this mass import of products, images, etc. being the main interest in doing all this the idea to connect Hikashop to some kind ofPOS system. I know that this is not an easy road but i'm very happy i'm working on that. I want to share information about the troubles i find while working on this. My integration is as simple as possible, i will only, in this first phase, put a lot of products with just one characteristic in a lot of different categories and i hope to be able to update just the product price and product quantity based on the product id and product code on the ****_hikashop_product table, i'll be talking about this in the future, by now i'm just importing all the products and automating the characteristics creation as i explained before in [ this post](http://www.hikashop.com/en/forum/2-general-talk-about-hikashop/40333-csv-import-of-custom-product-characteristics.html#40402) and making a lot of csv's Whatever, i want to report that there is an extrange behavior when importing your products with variants with the csv import. My case was this, i have imported a product with a csv like this: "product_id","product_parent_id","product_name","product_quantity","product_code","product_type","categories","price_value","price_currency_id","images","Dim. Base" 599,0,"CANDELIERE CENTRALE 60 Gradi INOX ",-1,,"main",18,10,"EUR","prodotti/ancoraggio/basi/EUH0221A.jpg","7/8 in." 600,599,,-1,"EUH0221A ","main",,10,"EUR",,"7/8 in." 601,599,,-1,"EUH0223A ","variant",,20,"EUR",,"1 in. " 602,599,,-1,"EUM0221A ","variant",,30,"EUR",,"22mm " 603,599,,-1,"EUM0223A ","variant",,40,"EUR",,"25mm " as you see there are 2 "main" products that will crash everything when you import, the fact is that it actually writes that data in the database and if you change that problem in the csv and reimport this: "product_id","product_parent_id","product_name","product_quantity","product_code","product_type","categories","price_value","price_currency_id","images","Dim. Base" 599,0,"CANDELIERE CENTRALE 60 Gradi INOX ",-1,,"main",18,10,"EUR","prodotti/ancoraggio/basi/EUH0221A.jpg","7/8 in." 600,599,,-1,"EUH0221A ","variant",,10,"EUR",,"7/8 in." 601,599,,-1,"EUH0223A ","variant",,20,"EUR",,"1 in. " 602,599,,-1,"EUM0221A ","variant",,30,"EUR",,"22mm " 603,599,,-1,"EUM0223A ","variant",,40,"EUR",,"25mm " It won't accept the change... you need to go directly to the database and remove the product manually from the ****_hikashop_product table and then reimport everything, no matter if you cancel the product from the listing in the hikashop backend I hope HS team works a little bit on the import/export zone of the program. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYxNTg1LWlzc3VlLXdoZW4taW1wb3J0aW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 2 months ago [\#61739](#61739) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Issue when importing](/forum/2-general-talk-about-hikashop/61585-issue-when-importing#61739 "As you know, in my latest posts i've been talking about an installation of hikashop with something about 10k products, ok, actually i'm working on it actively, and i'm working veeeery hard on the csv...")* Hi, When I import your first CSV, I don't have any crash. I have the error message: The product EUH0221A should have an empty value instead of the value 599 in the field product_parent_id as it is a main product (not a variant) and thus doesn't have any parent. Also, when I import the second CSV after deleting the product EUH0221A via the products listing, it imports the CSV just fine. So as far as I can see, everything is working as expected. Maybe you have an old version of HikaShop and that's why these edge cases are not handled properly ? I did my tests with the 1.5.9 release. The following user(s) said Thank You: [protorob](/forum/user/5729-protorob "View protorob's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYxNTg1LWlzc3VlLXdoZW4taW1wb3J0aW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[protorob](/forum/user/5729-protorob "View protorob's Profile")** - [![protorob's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar5729.png)](/forum/user/5729-protorob "View protorob's Profile") Topic Author - [ Offline](/forum/user/5729-protorob) Less More - Posts: 96 - Thank you received: 14 - - - - [](http://www.euromarnautica.com) - 14 years 2 months ago [\#61743](#61743) by [protorob](/forum/user/5729-protorob "View protorob's Profile") Replied by *[protorob](/forum/user/5729-protorob "View protorob's Profile")* on topic *[Re: Issue when importing](/forum/2-general-talk-about-hikashop/61585-issue-when-importing#61743 "As you know, in my latest posts i've been talking about an installation of hikashop with something about 10k products, ok, actually i'm working on it actively, and i'm working veeeery hard on the csv...")* mmm, i'm on 1.5.8, i hope everything goes ok when upgrading. Thanks in advance Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYxNTg1LWlzc3VlLXdoZW4taW1wb3J0aW5nP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 2 months ago [\#61745](#61745) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Issue when importing](/forum/2-general-talk-about-hikashop/61585-issue-when-importing#61745 "As you know, in my latest posts i've been talking about an installation of hikashop with something about 10k products, ok, actually i'm working on it actively, and i'm working veeeery hard on the csv...")* There are some issues with the current release and we are working on a new release for the end of the week in order to fix all that. I would recommend to wait for now. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzYxNTg1LWlzc3VlLXdoZW4taW1wb3J0aW5nP3RtcGw9bWFya2Rvd24=) 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.065 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)