[Skip to main content](#vessel-content) # Import export issues after upgrade ## - **[MatterofTrust](/forum/user/15198-matteroftrust "View MatterofTrust's Profile")** - [![MatterofTrust's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15198-matteroftrust "View MatterofTrust's Profile") Topic Author - [ Offline](/forum/user/15198-matteroftrust) Less More - Posts: 3 - Thank you received: 0 - - 12 years 2 weeks ago [\#175774](#175774) by [MatterofTrust](/forum/user/15198-matteroftrust "View MatterofTrust's Profile") *[Import export issues after upgrade](/forum/25-install-update/872356-import-export-issues-after-upgrade#175774 "-- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.6 We just upgraded and running into a couple of issues. when we do a product export all categories get exported - please take a look at the attached file (98). we have removed all products before the export, but the result is the same with products added to hika shop. The second issue we are having is the following error message when we upload the second attached file (92), which is an export from our old installation.")* was created by *[MatterofTrust](/forum/user/15198-matteroftrust "View MatterofTrust's Profile")* -- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.6 We just upgraded and running into a couple of issues. when we do a product export all categories get exported - please take a look at the attached file (98). we have removed all products before the export, but the result is the same with products added to hika shop. The second issue we are having is the following error message when we upload the second attached file (92), which is an export from our old installation. The column '' is not in the list of possible columns : product\_parent\_id \| product\_name \| product\_description \| product\_quantity \| product\_code \| product\_published \| product\_hit \| product\_created \| product\_sale\_start \| product\_sale\_end \| product\_delay\_id \| product\_tax\_id \| product\_type \| product\_vendor\_id \| product\_manufacturer\_id \| product\_url \| product\_weight \| product\_keywords \| product\_weight\_unit \| product\_modified \| product\_meta\_description \| product\_dimension\_unit \| product\_width \| product\_length \| product\_height \| product\_max\_per\_order \| product\_access \| product\_group\_after\_purchase \| product\_min\_per\_order \| product\_contact \| product\_last\_seen\_date \| product\_sales \| product\_waitlist \| product\_layout \| product\_average\_score \| product\_total\_vote \| product\_page\_title \| product\_alias \| product\_price\_percentage \| product\_canonical \| product\_msrp \| product\_display\_quantity\_field \| product\_warehouse\_id \| product\_quantity\_layout \| price\_value \| price\_value\_with\_tax \| price\_currency\_id \| price\_min\_quantity \| price\_access \| files \| files\_name \| files\_description \| files\_limit \| files\_ordering \| files\_free\_download \| images \| images\_name \| images\_description \| images\_limit \| images\_ordering \| images\_free\_download \| parent\_category \| categories\_namekey \| categories\_image \| categories\_ordering \| categories \| related \| options \| configuval \| handling \| size \| color. The column data was ignored Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MjM1Ni1pbXBvcnQtZXhwb3J0LWlzc3Vlcy1hZnRlci11cGdyYWRlP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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) - 12 years 2 weeks ago [\#175874](#175874) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Import export issues after upgrade](/forum/25-install-update/872356-import-export-issues-after-upgrade#175874 "-- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.6 We just upgraded and running into a couple of issues. when we do a product export all categories get exported - please take a look at the attached file (98). we have removed all products before the export, but the result is the same with products added to hika shop. The second issue we are having is the following error message when we upload the second attached file (92), which is an export from our old installation.")* Hi, You'll see that in the file "_92" you have a coma at the end of all lines. It is not in the specifications of the CSV format ; HikaShop understand that by an empty column which does not have a name, so it result the error you got. Please fix your CSV file and in our side, we will see to improve the import in order to handle this particular element. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MjM1Ni1pbXBvcnQtZXhwb3J0LWlzc3Vlcy1hZnRlci11cGdyYWRlP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[MatterofTrust](/forum/user/15198-matteroftrust "View MatterofTrust's Profile")** - [![MatterofTrust's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/15198-matteroftrust "View MatterofTrust's Profile") Topic Author - [ Offline](/forum/user/15198-matteroftrust) Less More - Posts: 3 - Thank you received: 0 - - 12 years 2 weeks ago - 11 years 11 months ago [\#175886](#175886) by [MatterofTrust](/forum/user/15198-matteroftrust "View MatterofTrust's Profile") Replied by *[MatterofTrust](/forum/user/15198-matteroftrust "View MatterofTrust's Profile")* on topic *[Import export issues after upgrade](/forum/25-install-update/872356-import-export-issues-after-upgrade#175886 "-- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.6 We just upgraded and running into a couple of issues. when we do a product export all categories get exported - please take a look at the attached file (98). we have removed all products before the export, but the result is the same with products added to hika shop. The second issue we are having is the following error message when we upload the second attached file (92), which is an export from our old installation.")* Thank you Jerome, The export came directly from another hika shop installation - we did not modify the file (92) Also did you had a chance to look at the second export which is from the latest version of hika on our staging site? Edit: I just did an export - deleted all products - imported the export from step 1 Code: Notice The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Online Store & Credit Card Donations","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Online Store & Credit Card Donations",""," ","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Online Store & Credit Card Donations","","Worm Poop","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Online Store & Credit Card Donations","","Booms and Mats","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Online Store & Credit Card Donations","ealogo.png","Gift Shop","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Gift Shop","","Books","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Gift Shop","","Posters","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Gift Shop","chkn.jpg","Toys","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Gift Shop","accessoriescategory.jpg","Accessories","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Accessories","accessories_ladies.png","Womens","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Accessories","accessorycategorymens-unisex.png","Mens","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Accessories","kidsaccessoriescategory.jpg","Kids","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Gift Shop","snacks_thoughtfulfood_granola_1225366933.png","Food","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Food","twodegrees_bars_applepecan_159114910.png","Bars","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Food","teatulia_greentea_1234695772.png","Tea","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Food","sweetsandchocolate_jadechocolates_48assorted_917069032.png","Sweets","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Food","snacks_ccmade_carmelpopcorn_672848496.png","Snacks","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Food","","Soups","","","","","","","","","","","",""' could not be imported Product not found The line '"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Food","","Chocolate","","","","","","","","","","","",""' could not be imported Product not found ... Last edit: 11 years 11 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MjM1Ni1pbXBvcnQtZXhwb3J0LWlzc3Vlcy1hZnRlci11cGdyYWRlP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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 11 months ago [\#178428](#178428) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Import export issues after upgrade](/forum/25-install-update/872356-import-export-issues-after-upgrade#178428 "-- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.3.6 We just upgraded and running into a couple of issues. when we do a product export all categories get exported - please take a look at the attached file (98). we have removed all products before the export, but the result is the same with products added to hika shop. The second issue we are having is the following error message when we upload the second attached file (92), which is an export from our old installation.")* Hi, For what I read in the HikaShop import helper ; the import is not designed to create the categories, just the products. If I understand the global algorithm right ; When you put such empty lines in the CSV ; there are by default "skipped" and stored in a cache variable. When you have a full product line, if the product use one of the categories, the import will be able to link them if the category does not exist. It means that you can't have a CSV to just import categories, it has to contains some products too. Nicolas will be a better interlocutor than me for this part ; he wrote the import system so he know exactly how it is working. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3MjM1Ni1pbXBvcnQtZXhwb3J0LWlzc3Vlcy1hZnRlci11cGdyYWRlP3RtcGw9bWFya2Rvd24=) 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.067 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)