[Skip to main content](#vessel-content) # Uploading CSVs ## - **[tkassim](/forum/user/7430-tkassim "View tkassim's Profile")** - [![tkassim's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7430-tkassim "View tkassim's Profile") Topic Author - [ Offline](/forum/user/7430-tkassim) Less More - Posts: 12 - Thank you received: 0 - - 13 years 10 months ago [\#79936](#79936) by [tkassim](/forum/user/7430-tkassim "View tkassim's Profile") *[Uploading CSVs](/forum/2-general-talk-about-hikashop/76367-uploading-csvs#79936 "I had a live site and unfortunately a program corrupted the site and I have had to start all over. I have all the previous information saved to the database and need to load the prices,...")* was created by *[tkassim](/forum/user/7430-tkassim "View tkassim's Profile")* I had a live site and unfortunately a program corrupted the site and I have had to start all over. I have all the previous information saved to the database and need to load the prices, characteristics, and descriptions for my 600 products. I loaded the products but there was no images. I finally was able to load the images, now there are no descriptions. In addition, I had over 1,000 variations with different prices for each variation for the product. I really need to be able to load the information. I have the information saved in database 4 and I am using database 3. I have the SQL, and CSV. I have tried to transfer the information via hikashop import, cyberduck, SQL, and file manager and nothing happens. How can I get my products back on?[ website ](http://elitehair-fashion.com) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MzY3LXVwbG9hZGluZy1jc3ZzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 13 years 10 months ago [\#79937](#79937) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Uploading CSVs](/forum/2-general-talk-about-hikashop/76367-uploading-csvs#79937 "I had a live site and unfortunately a program corrupted the site and I have had to start all over. I have all the previous information saved to the database and need to load the prices,...")* Hi, Can you show me the csv file that you are using, and the hikashop error when you're importing this csv (if there is an error)? Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MzY3LXVwbG9hZGluZy1jc3ZzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[tkassim](/forum/user/7430-tkassim "View tkassim's Profile")** - [![tkassim's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7430-tkassim "View tkassim's Profile") Topic Author - [ Offline](/forum/user/7430-tkassim) Less More - Posts: 12 - Thank you received: 0 - - 13 years 10 months ago [\#80028](#80028) by [tkassim](/forum/user/7430-tkassim "View tkassim's Profile") Replied by *[tkassim](/forum/user/7430-tkassim "View tkassim's Profile")* on topic *[Uploading CSVs](/forum/2-general-talk-about-hikashop/76367-uploading-csvs#80028 "I had a live site and unfortunately a program corrupted the site and I have had to start all over. I have all the previous information saved to the database and need to load the prices,...")* The CSV that I am using is the CSV created from the database in the component/hikashop/characteristics that list the data tables and I exported it to a CSV. *This attachment is hidden for guests. Please log in or register to see it.* *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MzY3LXVwbG9hZGluZy1jc3ZzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 10 months ago [\#80063](#80063) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Uploading CSVs](/forum/2-general-talk-about-hikashop/76367-uploading-csvs#80063 "I had a live site and unfortunately a program corrupted the site and I have had to start all over. I have all the previous information saved to the database and need to load the prices,...")* Hi, You can't import only the characteristics, you have to import the products and the variants. When importing products and variants, the characteristic will be automatically created. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MzY3LXVwbG9hZGluZy1jc3ZzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[tkassim](/forum/user/7430-tkassim "View tkassim's Profile")** - [![tkassim's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7430-tkassim "View tkassim's Profile") Topic Author - [ Offline](/forum/user/7430-tkassim) Less More - Posts: 12 - Thank you received: 0 - - 13 years 10 months ago [\#80122](#80122) by [tkassim](/forum/user/7430-tkassim "View tkassim's Profile") Replied by *[tkassim](/forum/user/7430-tkassim "View tkassim's Profile")* on topic *[Uploading CSVs](/forum/2-general-talk-about-hikashop/76367-uploading-csvs#80122 "I had a live site and unfortunately a program corrupted the site and I have had to start all over. I have all the previous information saved to the database and need to load the prices,...")* I get the same message with the variants. Do I put the variants and the products on the same csv? The products are already on the site. The images are already on the site without the description. This is what I get: *This attachment is hidden for guests. Please log in or register to see it.* *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MzY3LXVwbG9hZGluZy1jc3ZzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 10 months ago [\#80171](#80171) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Uploading CSVs](/forum/2-general-talk-about-hikashop/76367-uploading-csvs#80171 "I had a live site and unfortunately a program corrupted the site and I have had to start all over. I have all the previous information saved to the database and need to load the prices,...")* Hi, Yes you have to put your products and your variants on the same file. Look at the import documentation here: [ www.hikashop.com/en/support/documentatio...shop-import.html#csv](http://www.hikashop.com/en/support/documentation/73-hikashop-import.html#csv) > product\_code,product\_parent\_id,size > > main\_product,,big > > first\_variant,main\_product,big > > second\_variant,main\_product,small Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MzY3LXVwbG9hZGluZy1jc3ZzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[tkassim](/forum/user/7430-tkassim "View tkassim's Profile")** - [![tkassim's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7430-tkassim "View tkassim's Profile") Topic Author - [ Offline](/forum/user/7430-tkassim) Less More - Posts: 12 - Thank you received: 0 - - 13 years 10 months ago [\#80212](#80212) by [tkassim](/forum/user/7430-tkassim "View tkassim's Profile") Replied by *[tkassim](/forum/user/7430-tkassim "View tkassim's Profile")* on topic *[Uploading CSVs](/forum/2-general-talk-about-hikashop/76367-uploading-csvs#80212 "I had a live site and unfortunately a program corrupted the site and I have had to start all over. I have all the previous information saved to the database and need to load the prices,...")* Do you know where I can find someone who specialize in Hika to do it for me? I have about 50 variations for one product and different prices and this seems complex. Should I also put the images csv on the same csv file because the images I inserted created another product without the description. The CSV I loaded seems to go to the products with no images, which I now have over 1,000 products instead of 600. I am beyond frustrated. The directions seem foreign to me.![:(](/media/kunena/emoticons/5.png ":(") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MzY3LXVwbG9hZGluZy1jc3ZzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 10 months ago [\#80233](#80233) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Uploading CSVs](/forum/2-general-talk-about-hikashop/76367-uploading-csvs#80233 "I had a live site and unfortunately a program corrupted the site and I have had to start all over. I have all the previous information saved to the database and need to load the prices,...")* You can maybe post your request in the commercial jobs section of this forum. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc2MzY3LXVwbG9hZGluZy1jc3ZzP3RtcGw9bWFya2Rvd24=) 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.350 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)