[Skip to main content](#vessel-content) # importing problems ## - **[Awards4u](/forum/user/5319-awards4u "View Awards4u's Profile")** - [![Awards4u's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5319-awards4u "View Awards4u's Profile") Topic Author - [ Offline](/forum/user/5319-awards4u) Less More - Posts: 89 - Thank you received: 1 - - 14 years 8 months ago [\#39727](#39727) by [Awards4u](/forum/user/5319-awards4u "View Awards4u's Profile") *[importing problems](/forum/2-general-talk-about-hikashop/39727-importing-problems#39727 "Hi, When I use import csv excel file. I have 2 problems. 1. The price won't show up on the front page. I have to go in the back end and save each product again and the price then will show up. I don't have to enter the price again it's there in the back end but I just have to save it. Any idea why? 2. Let say I have products already and I upload new products. Some of my old products are getting deleted. Any idea why? 2 more question: 3. Is there a way only to export one category? 4. Whenever, I export it looks funny in excel. Let say I want to export it as backup and than import it again, how would I do this. Thanks for all your help! Hikashop is Excellent!")* was created by *[Awards4u](/forum/user/5319-awards4u "View Awards4u's Profile")* Hi, When I use import csv excel file. I have 2 problems. 1. The price won't show up on the front page. I have to go in the back end and save each product again and the price then will show up. I don't have to enter the price again it's there in the back end but I just have to save it. Any idea why? 2. Let say I have products already and I upload new products. Some of my old products are getting deleted. Any idea why? 2 more question: 3. Is there a way only to export one category? 4. Whenever, I export it looks funny in excel. Let say I want to export it as backup and than import it again, how would I do this. Thanks for all your help! Hikashop is Excellent! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM5NzI3LWltcG9ydGluZy1wcm9ibGVtcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[Awards4u](/forum/user/5319-awards4u "View Awards4u's Profile")** - [![Awards4u's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5319-awards4u "View Awards4u's Profile") Topic Author - [ Offline](/forum/user/5319-awards4u) Less More - Posts: 89 - Thank you received: 1 - - 14 years 8 months ago [\#39794](#39794) by [Awards4u](/forum/user/5319-awards4u "View Awards4u's Profile") Replied by *[Awards4u](/forum/user/5319-awards4u "View Awards4u's Profile")* on topic *[Re: importing problems](/forum/2-general-talk-about-hikashop/39727-importing-problems#39794 "Hi, When I use import csv excel file. I have 2 problems. 1. The price won't show up on the front page. I have to go in the back end and save each product again and the price then will show up. I don't have to enter the price again it's there in the back end but I just have to save it. Any idea why? 2. Let say I have products already and I upload new products. Some of my old products are getting deleted. Any idea why? 2 more question: 3. Is there a way only to export one category? 4. Whenever, I export it looks funny in excel. Let say I want to export it as backup and than import it again, how would I do this. Thanks for all your help! Hikashop is Excellent!")* *This attachment is hidden for guests. Please log in or register to see it.* I lost products from 2 catagories. Here is the excel file that I exported that still have the products in the export excel file. Is it possible to upload this file again and it will restore my products. I have the excel files as well but I made some changes to the products from the back end. Let me know if it's possible and how would I go about doing this. Thanks in advance. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM5NzI3LWltcG9ydGluZy1wcm9ibGVtcz90bXBsPW1hcmtkb3du) 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 - - 14 years 8 months ago [\#39867](#39867) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: importing problems](/forum/2-general-talk-about-hikashop/39727-importing-problems#39867 "Hi, When I use import csv excel file. I have 2 problems. 1. The price won't show up on the front page. I have to go in the back end and save each product again and the price then will show up. I don't have to enter the price again it's there in the back end but I just have to save it. Any idea why? 2. Let say I have products already and I upload new products. Some of my old products are getting deleted. Any idea why? 2 more question: 3. Is there a way only to export one category? 4. Whenever, I export it looks funny in excel. Let say I want to export it as backup and than import it again, how would I do this. Thanks for all your help! Hikashop is Excellent!")* Hi, You can import the exported CSV file via the menu Products->Import in HikaShop. I can see that your would CSV file has been corrupted in some way. The double quotes are doubled. You will have to open your CSV with notepad++ and do a search&replace on "" to replace it with " Then it should work better when importing the file. What do you mean by the file look "funny" ? HikaShop never delete a product. However, if you have a product already in the database and that you have it in the CSV, its information will be updated. That way, you could remove the product from all the categories for example. The problem would look like it disappeared even though it is just not assigned to any category. Also, for your first point, that means that your CSV is not valid. You can export only some products by selecting them in the products listing with the checkboxes available and then by clicking on export. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM5NzI3LWltcG9ydGluZy1wcm9ibGVtcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[Awards4u](/forum/user/5319-awards4u "View Awards4u's Profile")** - [![Awards4u's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5319-awards4u "View Awards4u's Profile") Topic Author - [ Offline](/forum/user/5319-awards4u) Less More - Posts: 89 - Thank you received: 1 - - 14 years 8 months ago [\#39932](#39932) by [Awards4u](/forum/user/5319-awards4u "View Awards4u's Profile") Replied by *[Awards4u](/forum/user/5319-awards4u "View Awards4u's Profile")* on topic *[Re: importing problems](/forum/2-general-talk-about-hikashop/39727-importing-problems#39932 "Hi, When I use import csv excel file. I have 2 problems. 1. The price won't show up on the front page. I have to go in the back end and save each product again and the price then will show up. I don't have to enter the price again it's there in the back end but I just have to save it. Any idea why? 2. Let say I have products already and I upload new products. Some of my old products are getting deleted. Any idea why? 2 more question: 3. Is there a way only to export one category? 4. Whenever, I export it looks funny in excel. Let say I want to export it as backup and than import it again, how would I do this. Thanks for all your help! Hikashop is Excellent!")* Thanks for your help. Any idea why my file is corrupted? How does the database know that I already have the product? What field does it go by (example product code, or which is the unique key)? Here is the file I import. Any idea why the price won't show up? It will say free in the front end. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM5NzI3LWltcG9ydGluZy1wcm9ibGVtcz90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[wildfire](/forum/user/4403-wildfire "View wildfire's Profile")** - [![wildfire's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4403.jpg)](/forum/user/4403-wildfire "View wildfire's Profile") - [ Offline](/forum/user/4403-wildfire) - eCommerce Maven Less More - Posts: 60 - Thank you received: 9 - - - - [](http://www.davekarlsven.com) - 14 years 8 months ago [\#39948](#39948) by [wildfire](/forum/user/4403-wildfire "View wildfire's Profile") Replied by *[wildfire](/forum/user/4403-wildfire "View wildfire's Profile")* on topic *[Re: importing problems](/forum/2-general-talk-about-hikashop/39727-importing-problems#39948 "Hi, When I use import csv excel file. I have 2 problems. 1. The price won't show up on the front page. I have to go in the back end and save each product again and the price then will show up. I don't have to enter the price again it's there in the back end but I just have to save it. Any idea why? 2. Let say I have products already and I upload new products. Some of my old products are getting deleted. Any idea why? 2 more question: 3. Is there a way only to export one category? 4. Whenever, I export it looks funny in excel. Let say I want to export it as backup and than import it again, how would I do this. Thanks for all your help! Hikashop is Excellent!")* We love the product export / import feature of hikashop. It goes off of the product_code field. We use Excel to manage all our products and to do mass updates. Our strategy that works really well is to do the following: 1. Export all products from Hikashop to CSV file that we open in Excel. 2. Change all the Product prices within the excel file. 3. Save the excel file as a CSV file. 4. Import the csv file to Hikashop Often when we are just changing prices on our products, we remove all the columns in our spreadsheet except the product_code column and the price_value column. That way we can make sure that we are only updating the prices and don't have other stuff in the csv file causing issues with the import. --- Ecommerce expert for hire. [ DaveKarlsven.com](http://www.davekarlsven.com) I love helping businesses make lots of money online. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM5NzI3LWltcG9ydGluZy1wcm9ibGVtcz90bXBsPW1hcmtkb3du) 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 - - 14 years 8 months ago [\#40138](#40138) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: importing problems](/forum/2-general-talk-about-hikashop/39727-importing-problems#40138 "Hi, When I use import csv excel file. I have 2 problems. 1. The price won't show up on the front page. I have to go in the back end and save each product again and the price then will show up. I don't have to enter the price again it's there in the back end but I just have to save it. Any idea why? 2. Let say I have products already and I upload new products. Some of my old products are getting deleted. Any idea why? 2 more question: 3. Is there a way only to export one category? 4. Whenever, I export it looks funny in excel. Let say I want to export it as backup and than import it again, how would I do this. Thanks for all your help! Hikashop is Excellent!")* I don't remember why double double quotes can happen in CSV files. But I remember see that in a CSv file before after some manipulation. Regarding the price being free, your CSV is fine. It must be because of a display option in hikaShop. Could you give a link to the page where you don't have the price ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM5NzI3LWltcG9ydGluZy1wcm9ibGVtcz90bXBsPW1hcmtkb3du) 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)