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

#   How do I Import into categories?

##

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

Less More

- Posts: 17
- Thank you received: 0
-
-

15 years 7 months ago [\#13731](#13731) by [jstvnson](/forum/user/1707-jstvnson "View jstvnson's Profile")  *[How do I Import into categories?](/forum/4-how-to/13731-how-do-i-import-into-categories#13731 "I have a csv spreadsheet (attached with 1545 products, prices, quantities, and descriptions that I want to import into the already setup categories and sub-categories.  When I try to import them, I get an error message and it imports just 732 of products, prices and quantities...but does not import the descriptions nor puts them in the categories.  What am I doing wrong? Please help.  Thank you,  John  &#91;file&#93;")* was created by *[jstvnson](/forum/user/1707-jstvnson "View jstvnson's Profile")*

I have a csv spreadsheet (attached with 1545 products, prices, quantities, and descriptions that I want to import into the already setup categories and sub-categories.

When I try to import them, I get an error message and it imports just 732 of products, prices and quantities...but does not import the descriptions nor puts them in the categories.

What am I doing wrong? Please help.

Thank you,

John

####  *This attachment is hidden for guests.
Please log in or register to see it.*

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNzMxLWhvdy1kby1pLWltcG9ydC1pbnRvLWNhdGVnb3JpZXM/dG1wbD1tYXJrZG93bg==) 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: 86561
- Thank you received: 14307
-
-

15 years 7 months ago [\#13744](#13744) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: How do I Import into categories?](/forum/4-how-to/13731-how-do-i-import-into-categories#13744 "I have a csv spreadsheet (attached with 1545 products, prices, quantities, and descriptions that I want to import into the already setup categories and sub-categories.  When I try to import them, I get an error message and it imports just 732 of products, prices and quantities...but does not import the descriptions nor puts them in the categories.  What am I doing wrong? Please help.  Thank you,  John  &#91;file&#93;")*

Your columns headers are wrong.
It's "categories" and not "category_id" and it's "product_description" and not "description".
Also, I see that you have a lot of double quotes in your product descriptions and names. Looking at the code of the import, the three double quotes at the end of the fields are probably why you're not getting all your products. You should try to replace the """ by "" " in your file. That will help the system.

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

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

Less More

- Posts: 17
- Thank you received: 0
-
-

15 years 7 months ago [\#13764](#13764) by [jstvnson](/forum/user/1707-jstvnson "View jstvnson's Profile")  Replied by *[jstvnson](/forum/user/1707-jstvnson "View jstvnson's Profile")* on topic *[Re: How do I Import into categories?](/forum/4-how-to/13731-how-do-i-import-into-categories#13764 "I have a csv spreadsheet (attached with 1545 products, prices, quantities, and descriptions that I want to import into the already setup categories and sub-categories.  When I try to import them, I get an error message and it imports just 732 of products, prices and quantities...but does not import the descriptions nor puts them in the categories.  What am I doing wrong? Please help.  Thank you,  John  &#91;file&#93;")*

Thank you Nicolas!!

Worked like a charm!

I replaced " with two ' and renamed category_id with categories and description with product_description.

It imported all 1543 items and put them in their respective categories.

This is the BEST e-commerce system!!!

I will be demonstrating this system to our Joomla Meetup Group in Atlanta next week. Watch out VM!

John Stevenson

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNzMxLWhvdy1kby1pLWltcG9ydC1pbnRvLWNhdGVnb3JpZXM/dG1wbD1tYXJrZG93bg==) 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: 86561
- Thank you received: 14307
-
-

15 years 7 months ago [\#13772](#13772) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: How do I Import into categories?](/forum/4-how-to/13731-how-do-i-import-into-categories#13772 "I have a csv spreadsheet (attached with 1545 products, prices, quantities, and descriptions that I want to import into the already setup categories and sub-categories.  When I try to import them, I get an error message and it imports just 732 of products, prices and quantities...but does not import the descriptions nor puts them in the categories.  What am I doing wrong? Please help.  Thank you,  John  &#91;file&#93;")*

Great ! ![:)](/media/kunena/emoticons/3.png ":)")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzEzNzMxLWhvdy1kby1pLWltcG9ydC1pbnRvLWNhdGVnb3JpZXM/dG1wbD1tYXJrZG93bg==) 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.083 seconds

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