[Skip to main content](#vessel-content)

#   Import into the wrong categories

##

- **[mair](/forum/user/9742-mair "View mair's Profile")**
- [![mair's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9742-mair "View mair's Profile") Topic Author
- [ Offline](/forum/user/9742-mair)

Less More

- Posts: 46
- Thank you received: 2
-
- [](http://www.workwearandsports.co.uk/)
-

14 years 1 month ago [\#70488](#70488) by [mair](/forum/user/9742-mair "View mair's Profile")  *[Import into the wrong categories](/forum/3-bug-report/70488-import-into-the-wrong-categories#70488 "When trying to import into predefined categories, products go into the wrong categories.  If the structure is: product category &gt; Towels &gt; Towels  Products instead go into Accessories &gt; Towels  This is even if a sample product is put in manually into product category &gt; Towels &gt; Towels The sample product is then exported and the category path is then put into the new CSV , in exactly the same way, however after the import again they are in the wrong category.  Also when one product is in two separate categories this does not show in the exported file.")* was created by *[mair](/forum/user/9742-mair "View mair's Profile")*

When trying to import into predefined categories, products go into the wrong categories.

If the structure is:
product category &gt; Towels &gt; Towels

Products instead go into Accessories &gt; Towels

This is even if a sample product is put in manually into
product category &gt; Towels &gt; Towels
The sample product is then exported and the category path is then put into the new CSV , in exactly the same way, however after the import again they are in the wrong category.

Also when one product is in two separate categories this does not show in the exported file.

---

[ Workwear Suppliers in the UK](http://www.workwearandsports.co.uk)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MDQ4OC1pbXBvcnQtaW50by10aGUtd3JvbmctY2F0ZWdvcmllcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[mair](/forum/user/9742-mair "View mair's Profile")**
- [![mair's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9742-mair "View mair's Profile") Topic Author
- [ Offline](/forum/user/9742-mair)

Less More

- Posts: 46
- Thank you received: 2
-
- [](http://www.workwearandsports.co.uk/)
-

14 years 1 month ago [\#70506](#70506) by [mair](/forum/user/9742-mair "View mair's Profile")  Replied by *[mair](/forum/user/9742-mair "View mair's Profile")* on topic *[Re: Import into the wrong categories](/forum/3-bug-report/70488-import-into-the-wrong-categories#70506 "When trying to import into predefined categories, products go into the wrong categories.  If the structure is: product category &gt; Towels &gt; Towels  Products instead go into Accessories &gt; Towels  This is even if a sample product is put in manually into product category &gt; Towels &gt; Towels The sample product is then exported and the category path is then put into the new CSV , in exactly the same way, however after the import again they are in the wrong category.  Also when one product is in two separate categories this does not show in the exported file.")*

I have figured this out, the best way to do this is, is rather than use column names, column ids should be used.
These can be found in category explorer.

e.g. 2,230,229 is Product Categories &gt; Trousers &amp; Jogpants &gt; Mens Trousers And Jog Pants
If you want your products to appear in root categories remember to add the relevant column names.

This is a good piece of software

---

[ Workwear Suppliers in the UK](http://www.workwearandsports.co.uk)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83MDQ4OC1pbXBvcnQtaW50by10aGUtd3JvbmctY2F0ZWdvcmllcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.041 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
