[Skip to main content](#vessel-content) # problem importing from a csv from another hikashop ## - **[michaelbuttitta](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile")** - [![michaelbuttitta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1618.jpg)](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile") Topic Author - [ Offline](/forum/user/1618-michaelbuttitta) Less More - Posts: 44 - Thank you received: 0 - - - - 15 years 3 days ago [\#29603](#29603) by [michaelbuttitta](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile") *[problem importing from a csv from another hikashop](/forum/3-bug-report/29603-problem-importing-from-a-csv-from-another-hikashop#29603 "I am trying to export my store into a csv and then import the store into another shop that's exactly the same, but branded differently that I want to run in catalog only mode. The .csv file seems to...")* was created by *[michaelbuttitta](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile")* I am trying to export my store into a csv and then import the store into another shop that's exactly the same, but branded differently that I want to run in catalog only mode. The .csv file seems to partially import because all the categories seem to be there, but none of the products are there, only empty categories. When I try to import the .csv file the screen also goes blank and never shows anything until I click a shortcut to reload the admin home page. Something obviously seems to be halting the import past the categories, but what? Thank you for help with this! I am attaching the .csv file to see if maybe that helps identifying the problem? Perhaps it may indicated a problem with my first shop? I did try to uninstall hikashop (including the DB tables) and re-installing and I get the same results. --- Michael Buttitta Hot Picks USA Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTYwMy1wcm9ibGVtLWltcG9ydGluZy1mcm9tLWEtY3N2LWZyb20tYW5vdGhlci1oaWthc2hvcD90bXBsPW1hcmtkb3du) 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 - - 15 years 3 days ago [\#29634](#29634) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: problem importing from a csv from another hikashop](/forum/3-bug-report/29603-problem-importing-from-a-csv-from-another-hikashop#29634 "I am trying to export my store into a csv and then import the store into another shop that's exactly the same, but branded differently that I want to run in catalog only mode. The .csv file seems to...")* We didn't get any file. If the screen goes blank during the import, it means that there is a problem. The most likely cause is that the file is too big. Is that the case ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTYwMy1wcm9ibGVtLWltcG9ydGluZy1mcm9tLWEtY3N2LWZyb20tYW5vdGhlci1oaWthc2hvcD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[michaelbuttitta](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile")** - [![michaelbuttitta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1618.jpg)](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile") Topic Author - [ Offline](/forum/user/1618-michaelbuttitta) Less More - Posts: 44 - Thank you received: 0 - - - - 15 years 3 days ago [\#29655](#29655) by [michaelbuttitta](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile") Replied by *[michaelbuttitta](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile")* on topic *[Re: problem importing from a csv from another hikashop](/forum/3-bug-report/29603-problem-importing-from-a-csv-from-another-hikashop#29655 "I am trying to export my store into a csv and then import the store into another shop that's exactly the same, but branded differently that I want to run in catalog only mode. The .csv file seems to...")* It shouldn't be too large at 136K? Sorry, last time I attached to the wrong one. Here is the correct file. I'm open to suggestions? #### *This attachment is hidden for guests. Please log in or register to see it.* --- Michael Buttitta Hot Picks USA Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTYwMy1wcm9ibGVtLWltcG9ydGluZy1mcm9tLWEtY3N2LWZyb20tYW5vdGhlci1oaWthc2hvcD90bXBsPW1hcmtkb3du) 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 - - 15 years 3 days ago [\#29671](#29671) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: problem importing from a csv from another hikashop](/forum/3-bug-report/29603-problem-importing-from-a-csv-from-another-hikashop#29671 "I am trying to export my store into a csv and then import the store into another shop that's exactly the same, but branded differently that I want to run in catalog only mode. The .csv file seems to...")* There is an error in your file. All your products lines have 45 columns while there are only 44 headers. Thus, it breaks the export. That happens because there is an extra semi colon at the end of the products information lines. If you open that file with open office calc and save it, that semi colon will be removed from the file and you should be able to import it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTYwMy1wcm9ibGVtLWltcG9ydGluZy1mcm9tLWEtY3N2LWZyb20tYW5vdGhlci1oaWthc2hvcD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[michaelbuttitta](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile")** - [![michaelbuttitta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1618.jpg)](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile") Topic Author - [ Offline](/forum/user/1618-michaelbuttitta) Less More - Posts: 44 - Thank you received: 0 - - - - 15 years 3 days ago [\#29705](#29705) by [michaelbuttitta](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile") Replied by *[michaelbuttitta](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile")* on topic *[Re: problem importing from a csv from another hikashop](/forum/3-bug-report/29603-problem-importing-from-a-csv-from-another-hikashop#29705 "I am trying to export my store into a csv and then import the store into another shop that's exactly the same, but branded differently that I want to run in catalog only mode. The .csv file seems to...")* Would you have any idea why this is happening? I have excel and tried to re-save the file as a csv and it is giving me a lot of errors when importing it after doing that, I'm sure due to the extra semi colon. Is open Office Calc different in how it would treat the file? But all I am doing is exporting this csv from a store that is up and working fine and then trying to import it into a different store and then just set it to catalog mode for now as a preview site. Shouldn't this be a seamless process with no possibility of error? Thank you for your support! --- Michael Buttitta Hot Picks USA Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTYwMy1wcm9ibGVtLWltcG9ydGluZy1mcm9tLWEtY3N2LWZyb20tYW5vdGhlci1oaWthc2hvcD90bXBsPW1hcmtkb3du) 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 - - 15 years 2 days ago [\#29721](#29721) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: problem importing from a csv from another hikashop](/forum/3-bug-report/29603-problem-importing-from-a-csv-from-another-hikashop#29721 "I am trying to export my store into a csv and then import the store into another shop that's exactly the same, but branded differently that I want to run in catalog only mode. The .csv file seems to...")* Looking further into it, that's a problem which happens only when you didn't create any characteristics on the shop where you're exporting. We'll fix that. In the mean time, you should open the CSV in openoffice calc and save it to remove the empty column. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTYwMy1wcm9ibGVtLWltcG9ydGluZy1mcm9tLWEtY3N2LWZyb20tYW5vdGhlci1oaWthc2hvcD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[michaelbuttitta](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile")** - [![michaelbuttitta's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1618.jpg)](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile") Topic Author - [ Offline](/forum/user/1618-michaelbuttitta) Less More - Posts: 44 - Thank you received: 0 - - - - 15 years 2 days ago [\#29724](#29724) by [michaelbuttitta](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile") Replied by *[michaelbuttitta](/forum/user/1618-michaelbuttitta "View michaelbuttitta's Profile")* on topic *[Re: problem importing from a csv from another hikashop](/forum/3-bug-report/29603-problem-importing-from-a-csv-from-another-hikashop#29724 "I am trying to export my store into a csv and then import the store into another shop that's exactly the same, but branded differently that I want to run in catalog only mode. The .csv file seems to...")* Thank you! And for anyone reading this thread, I tried Microsoft Excel to import a csv to re-save it. It did NOT fix this problem. Using Open Office Calc worked by simply opening and saving the file. Made me re-think how far open office has come! --- Michael Buttitta Hot Picks USA Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTYwMy1wcm9ibGVtLWltcG9ydGluZy1mcm9tLWEtY3N2LWZyb20tYW5vdGhlci1oaWthc2hvcD90bXBsPW1hcmtkb3du) 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.063 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)