[Skip to main content](#vessel-content) # Adding catagories via csv ## - **[ssaxton](/forum/user/4642-ssaxton "View ssaxton's Profile")** - [![ssaxton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4642-ssaxton "View ssaxton's Profile") Topic Author - [ Offline](/forum/user/4642-ssaxton) Less More - Posts: 19 - Thank you received: 0 - - 14 years 7 months ago [\#42049](#42049) by [ssaxton](/forum/user/4642-ssaxton "View ssaxton's Profile") *[Adding catagories via csv](/forum/4-how-to/42049-adding-catagories-via-csv#42049 "HI, I've just bought Hikashop Essential and need to add some categories in order to assign discounts on certain items within certain price ranges. My question is this: I have over 1,100 items and therefore would like to do a csv upload. How do I add a category to an item which is already assigned to a few different categories. In other words; I wish to add a category without deleting the existing ones via csv import. Thanks, Steve")* was created by *[ssaxton](/forum/user/4642-ssaxton "View ssaxton's Profile")* HI, I've just bought Hikashop Essential and need to add some categories in order to assign discounts on certain items within certain price ranges. My question is this: I have over 1,100 items and therefore would like to do a csv upload. How do I add a category to an item which is already assigned to a few different categories. In other words; I wish to add a category without deleting the existing ones via csv import. Thanks, Steve Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDQ5LWFkZGluZy1jYXRhZ29yaWVzLXZpYS1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")** - [![tony@10uk.net's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") - [ Offline](/forum/user/6276-tony-10uk-net) Less More - Posts: 127 - Thank you received: 12 - - 14 years 7 months ago [\#42052](#42052) by [tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile") Replied by *[tony@10uk.net](/forum/user/6276-tony-10uk-net "View tony@10uk.net's Profile")* on topic *[Re: Adding catagories via csv](/forum/4-how-to/42049-adding-catagories-via-csv#42052 "HI, I've just bought Hikashop Essential and need to add some categories in order to assign discounts on certain items within certain price ranges. My question is this: I have over 1,100 items and therefore would like to do a csv upload. How do I add a category to an item which is already assigned to a few different categories. In other words; I wish to add a category without deleting the existing ones via csv import. Thanks, Steve")* I've been playing with this to do something similar. My understanding is that if a product already exists then deltas on the import are applied. So if you do an export file, add the new category to the product line in the file and then import, the new category is just applied to the changed products. I'll know in the next couple of days if this is true but that's my understanding from the documentation. I've also read that you can use the category ID or the name on the import - I prefer the ID as it helps prevent typos on big files. Again not tried yet. Tony Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDQ5LWFkZGluZy1jYXRhZ29yaWVzLXZpYS1jc3Y/dG1wbD1tYXJrZG93bg==) 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 7 months ago [\#42209](#42209) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Adding catagories via csv](/forum/4-how-to/42049-adding-catagories-via-csv#42209 "HI, I've just bought Hikashop Essential and need to add some categories in order to assign discounts on certain items within certain price ranges. My question is this: I have over 1,100 items and therefore would like to do a csv upload. How do I add a category to an item which is already assigned to a few different categories. In other words; I wish to add a category without deleting the existing ones via csv import. Thanks, Steve")* The best is to export your products, open the CSV in Excel, add your additional categories where you need them and import it back. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDQ5LWFkZGluZy1jYXRhZ29yaWVzLXZpYS1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[ssaxton](/forum/user/4642-ssaxton "View ssaxton's Profile")** - [![ssaxton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4642-ssaxton "View ssaxton's Profile") Topic Author - [ Offline](/forum/user/4642-ssaxton) Less More - Posts: 19 - Thank you received: 0 - - 14 years 7 months ago [\#42287](#42287) by [ssaxton](/forum/user/4642-ssaxton "View ssaxton's Profile") Replied by *[ssaxton](/forum/user/4642-ssaxton "View ssaxton's Profile")* on topic *[Re: Adding catagories via csv](/forum/4-how-to/42049-adding-catagories-via-csv#42287 "HI, I've just bought Hikashop Essential and need to add some categories in order to assign discounts on certain items within certain price ranges. My question is this: I have over 1,100 items and therefore would like to do a csv upload. How do I add a category to an item which is already assigned to a few different categories. In other words; I wish to add a category without deleting the existing ones via csv import. Thanks, Steve")* Well I tried a test csv import . It certainly imports and updates prices but places them in the new category BUT, it takes them out of the old ones. As for exporting from Hikashop and then opening in excel; that doesn't seem to work in 2007 on my Vista machine. All I get is this (see attached) [ ![screen.jpg](/forum/attachment/3039) ](/forum/attachment/3039 "screen.jpg") Any ideas? I'd really, really hate to have to do 1150 items by hand ![:(](/media/kunena/emoticons/22.png ":(") Thanks, Steve - [ ![screen.jpg](/forum/attachment/3039) ](/forum/attachment/3039 "screen.jpg") [ ](/forum/attachment/3039?download=1 "screen.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDQ5LWFkZGluZy1jYXRhZ29yaWVzLXZpYS1jc3Y/dG1wbD1tYXJrZG93bg==) 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 7 months ago - 14 years 7 months ago [\#42291](#42291) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Adding catagories via csv](/forum/4-how-to/42049-adding-catagories-via-csv#42291 "HI, I've just bought Hikashop Essential and need to add some categories in order to assign discounts on certain items within certain price ranges. My question is this: I have over 1,100 items and therefore would like to do a csv upload. How do I add a category to an item which is already assigned to a few different categories. In other words; I wish to add a category without deleting the existing ones via csv import. Thanks, Steve")* That's because your version of Excel prefers the comma instead of the semi colon as separator. Just change the CSV separator accordingly in the Files tab of the configuration and try again. Last edit: 14 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDQ5LWFkZGluZy1jYXRhZ29yaWVzLXZpYS1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[ssaxton](/forum/user/4642-ssaxton "View ssaxton's Profile")** - [![ssaxton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4642-ssaxton "View ssaxton's Profile") Topic Author - [ Offline](/forum/user/4642-ssaxton) Less More - Posts: 19 - Thank you received: 0 - - 14 years 7 months ago [\#42299](#42299) by [ssaxton](/forum/user/4642-ssaxton "View ssaxton's Profile") Replied by *[ssaxton](/forum/user/4642-ssaxton "View ssaxton's Profile")* on topic *[Re: Adding catagories via csv](/forum/4-how-to/42049-adding-catagories-via-csv#42299 "HI, I've just bought Hikashop Essential and need to add some categories in order to assign discounts on certain items within certain price ranges. My question is this: I have over 1,100 items and therefore would like to do a csv upload. How do I add a category to an item which is already assigned to a few different categories. In other words; I wish to add a category without deleting the existing ones via csv import. Thanks, Steve")* Brilliant! Thank you!! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzQyMDQ5LWFkZGluZy1jYXRhZ29yaWVzLXZpYS1jc3Y/dG1wbD1tYXJrZG93bg==) 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.068 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)