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

#   Failed to import category\_id

##

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

Less More

- Posts: 14
- Thank you received: 0
-
-

13 years 3 months ago -  13 years 3 months ago [\#115764](#115764) by [dedyandy](/forum/user/25295-dedyandy "View dedyandy's Profile")  *[Failed to import category\_id](/forum/4-how-to/85778-failed-to-import-category-id#115764 "Hi,  I failed to import category&#95;id.  I have the following csv file:  product&#95;name,price&#95;value,price&#95;currency&#95;id,category&#95;id,product&#95;code,Images Bordir Kuning,150000,75,12,1018,IMG-20130425-00097.jpg;IMG-20130425-00098.jpg  and attached is the parameter settings.  After importing, I had the following messages:  Error The column 'category&#95;id' is not in the list of possible columns : product&#95;parent&#95;id | product&#95;name | product&#95;description | product&#95;quantity | product&#95;code | product&#95;published | product&#95;hit | product&#95;created | product&#95;sale&#95;start | product&#95;sale&#95;end | product&#95;delay&#95;id | product&#95;tax&#95;id | product&#95;type | product&#95;vendor&#95;id | product&#95;manufacturer&#95;id | product&#95;url | product&#95;weight | product&#95;keywords | product&#95;weight&#95;unit | product&#95;modified | product&#95;meta&#95;description | product&#95;dimension&#95;unit | product&#95;width | product&#95;length | product&#95;height | product&#95;max&#95;per&#95;order | product&#95;access | product&#95;group&#95;after&#95;purchase | product&#95;min&#95;per&#95;order | product&#95;contact | product&#95;last&#95;seen&#95;date | product&#95;sales | product&#95;waitlist | product&#95;layout | product&#95;average&#95;score | product&#95;total&#95;vote | product&#95;page&#95;title | product&#95;alias | product&#95;price&#95;percentage | product&#95;msrp | product&#95;canonical | price&#95;value | price&#95;value&#95;with&#95;tax | price&#95;currency&#95;id | price&#95;min&#95;quantity | price&#95;access | files | images | parent&#95;category | categories&#95;namekey | categories&#95;image | categories&#95;ordering | categories | related | options | warna. The column data was ignored  Message 1 products found : 1 new products imported, 0 invalid product code, 0 already existing products.  The product was successfully imported, but HikaShop created another category for it.  I checked the category&#95;id did exist in the database, but it seemed HikaShop didn't recognise its own database field.  Could anyone help how to solve this problem.  Thanks, Andy.")* was created by *[dedyandy](/forum/user/25295-dedyandy "View dedyandy's Profile")*

Hi,

I failed to import category_id.

I have the following csv file:

product_name,price_value,price_currency_id,category_id,product_code,Images
Bordir Kuning,150000,75,12,1018,IMG-20130425-00097.jpg;IMG-20130425-00098.jpg

and attached is the parameter settings.

After importing, I had the following messages:

Error
The column 'category_id' is not in the list of possible columns : product_parent_id &#124; product_name &#124; product_description &#124; product_quantity &#124; product_code &#124; product_published &#124; product_hit &#124; product_created &#124; product_sale_start &#124; product_sale_end &#124; product_delay_id &#124; product_tax_id &#124; product_type &#124; product_vendor_id &#124; product_manufacturer_id &#124; product_url &#124; product_weight &#124; product_keywords &#124; product_weight_unit &#124; product_modified &#124; product_meta_description &#124; product_dimension_unit &#124; product_width &#124; product_length &#124; product_height &#124; product_max_per_order &#124; product_access &#124; product_group_after_purchase &#124; product_min_per_order &#124; product_contact &#124; product_last_seen_date &#124; product_sales &#124; product_waitlist &#124; product_layout &#124; product_average_score &#124; product_total_vote &#124; product_page_title &#124; product_alias &#124; product_price_percentage &#124; product_msrp &#124; product_canonical &#124; price_value &#124; price_value_with_tax &#124; price_currency_id &#124; price_min_quantity &#124; price_access &#124; files &#124; images &#124; parent_category &#124; categories_namekey &#124; categories_image &#124; categories_ordering &#124; categories &#124; related &#124; options &#124; warna. The column data was ignored

Message
1 products found : 1 new products imported, 0 invalid product code, 0 already existing products.

The product was successfully imported, but HikaShop created another category for it.

I checked the category_id did exist in the database, but it seemed HikaShop didn't recognise its own database field.

Could anyone help how to solve this problem.

Thanks,
Andy.

- [ ![dev01&#95;&#95;&#95;Administration&#95;&#95;&#95;Import.png](/forum/attachment/11355) ](/forum/attachment/11355 "...n&#95;&#95;&#95;Import.png") [ ](/forum/attachment/11355?download=1 "...n&#95;&#95;&#95;Import.png")

Last edit: 13 years 3 months ago by [dedyandy](/forum/user/25295-dedyandy "View dedyandy's Profile"). Reason: Failed to attach the file

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg1Nzc4LWZhaWxlZC10by1pbXBvcnQtY2F0ZWdvcnktaWQ/dG1wbD1tYXJrZG93bg==) 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 3 months ago [\#115782](#115782) 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 *[Failed to import category\_id](/forum/4-how-to/85778-failed-to-import-category-id#115782 "Hi,  I failed to import category&#95;id.  I have the following csv file:  product&#95;name,price&#95;value,price&#95;currency&#95;id,category&#95;id,product&#95;code,Images Bordir Kuning,150000,75,12,1018,IMG-20130425-00097.jpg;IMG-20130425-00098.jpg  and attached is the parameter settings.  After importing, I had the following messages:  Error The column 'category&#95;id' is not in the list of possible columns : product&#95;parent&#95;id | product&#95;name | product&#95;description | product&#95;quantity | product&#95;code | product&#95;published | product&#95;hit | product&#95;created | product&#95;sale&#95;start | product&#95;sale&#95;end | product&#95;delay&#95;id | product&#95;tax&#95;id | product&#95;type | product&#95;vendor&#95;id | product&#95;manufacturer&#95;id | product&#95;url | product&#95;weight | product&#95;keywords | product&#95;weight&#95;unit | product&#95;modified | product&#95;meta&#95;description | product&#95;dimension&#95;unit | product&#95;width | product&#95;length | product&#95;height | product&#95;max&#95;per&#95;order | product&#95;access | product&#95;group&#95;after&#95;purchase | product&#95;min&#95;per&#95;order | product&#95;contact | product&#95;last&#95;seen&#95;date | product&#95;sales | product&#95;waitlist | product&#95;layout | product&#95;average&#95;score | product&#95;total&#95;vote | product&#95;page&#95;title | product&#95;alias | product&#95;price&#95;percentage | product&#95;msrp | product&#95;canonical | price&#95;value | price&#95;value&#95;with&#95;tax | price&#95;currency&#95;id | price&#95;min&#95;quantity | price&#95;access | files | images | parent&#95;category | categories&#95;namekey | categories&#95;image | categories&#95;ordering | categories | related | options | warna. The column data was ignored  Message 1 products found : 1 new products imported, 0 invalid product code, 0 already existing products.  The product was successfully imported, but HikaShop created another category for it.  I checked the category&#95;id did exist in the database, but it seemed HikaShop didn't recognise its own database field.  Could anyone help how to solve this problem.  Thanks, Andy.")*

Hi Andy,
I think that the best solution will be to create manualy some products and categories, then export them, edit the exported CSV file with your values, and finally import it again.

The following user(s) said Thank You: [dedyandy](/forum/user/25295-dedyandy "View dedyandy's Profile")

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

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

Less More

- Posts: 14
- Thank you received: 0
-
-

13 years 3 months ago [\#115809](#115809) by [dedyandy](/forum/user/25295-dedyandy "View dedyandy's Profile")  Replied by *[dedyandy](/forum/user/25295-dedyandy "View dedyandy's Profile")* on topic *[Failed to import category\_id](/forum/4-how-to/85778-failed-to-import-category-id#115809 "Hi,  I failed to import category&#95;id.  I have the following csv file:  product&#95;name,price&#95;value,price&#95;currency&#95;id,category&#95;id,product&#95;code,Images Bordir Kuning,150000,75,12,1018,IMG-20130425-00097.jpg;IMG-20130425-00098.jpg  and attached is the parameter settings.  After importing, I had the following messages:  Error The column 'category&#95;id' is not in the list of possible columns : product&#95;parent&#95;id | product&#95;name | product&#95;description | product&#95;quantity | product&#95;code | product&#95;published | product&#95;hit | product&#95;created | product&#95;sale&#95;start | product&#95;sale&#95;end | product&#95;delay&#95;id | product&#95;tax&#95;id | product&#95;type | product&#95;vendor&#95;id | product&#95;manufacturer&#95;id | product&#95;url | product&#95;weight | product&#95;keywords | product&#95;weight&#95;unit | product&#95;modified | product&#95;meta&#95;description | product&#95;dimension&#95;unit | product&#95;width | product&#95;length | product&#95;height | product&#95;max&#95;per&#95;order | product&#95;access | product&#95;group&#95;after&#95;purchase | product&#95;min&#95;per&#95;order | product&#95;contact | product&#95;last&#95;seen&#95;date | product&#95;sales | product&#95;waitlist | product&#95;layout | product&#95;average&#95;score | product&#95;total&#95;vote | product&#95;page&#95;title | product&#95;alias | product&#95;price&#95;percentage | product&#95;msrp | product&#95;canonical | price&#95;value | price&#95;value&#95;with&#95;tax | price&#95;currency&#95;id | price&#95;min&#95;quantity | price&#95;access | files | images | parent&#95;category | categories&#95;namekey | categories&#95;image | categories&#95;ordering | categories | related | options | warna. The column data was ignored  Message 1 products found : 1 new products imported, 0 invalid product code, 0 already existing products.  The product was successfully imported, but HikaShop created another category for it.  I checked the category&#95;id did exist in the database, but it seemed HikaShop didn't recognise its own database field.  Could anyone help how to solve this problem.  Thanks, Andy.")*

Hi Mohamed,

Can you tell me how do I export from HikaShop?

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

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

13 years 3 months ago [\#115824](#115824) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Failed to import category\_id](/forum/4-how-to/85778-failed-to-import-category-id#115824 "Hi,  I failed to import category&#95;id.  I have the following csv file:  product&#95;name,price&#95;value,price&#95;currency&#95;id,category&#95;id,product&#95;code,Images Bordir Kuning,150000,75,12,1018,IMG-20130425-00097.jpg;IMG-20130425-00098.jpg  and attached is the parameter settings.  After importing, I had the following messages:  Error The column 'category&#95;id' is not in the list of possible columns : product&#95;parent&#95;id | product&#95;name | product&#95;description | product&#95;quantity | product&#95;code | product&#95;published | product&#95;hit | product&#95;created | product&#95;sale&#95;start | product&#95;sale&#95;end | product&#95;delay&#95;id | product&#95;tax&#95;id | product&#95;type | product&#95;vendor&#95;id | product&#95;manufacturer&#95;id | product&#95;url | product&#95;weight | product&#95;keywords | product&#95;weight&#95;unit | product&#95;modified | product&#95;meta&#95;description | product&#95;dimension&#95;unit | product&#95;width | product&#95;length | product&#95;height | product&#95;max&#95;per&#95;order | product&#95;access | product&#95;group&#95;after&#95;purchase | product&#95;min&#95;per&#95;order | product&#95;contact | product&#95;last&#95;seen&#95;date | product&#95;sales | product&#95;waitlist | product&#95;layout | product&#95;average&#95;score | product&#95;total&#95;vote | product&#95;page&#95;title | product&#95;alias | product&#95;price&#95;percentage | product&#95;msrp | product&#95;canonical | price&#95;value | price&#95;value&#95;with&#95;tax | price&#95;currency&#95;id | price&#95;min&#95;quantity | price&#95;access | files | images | parent&#95;category | categories&#95;namekey | categories&#95;image | categories&#95;ordering | categories | related | options | warna. The column data was ignored  Message 1 products found : 1 new products imported, 0 invalid product code, 0 already existing products.  The product was successfully imported, but HikaShop created another category for it.  I checked the category&#95;id did exist in the database, but it seemed HikaShop didn't recognise its own database field.  Could anyone help how to solve this problem.  Thanks, Andy.")*

Hi Andy,

Just go in your product listing (in the backend), select some products and click on the "export" at the top of the page ![;)](/media/kunena/emoticons/24.png ";)")

The following user(s) said Thank You: [dedyandy](/forum/user/25295-dedyandy "View dedyandy's Profile")

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

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

Less More

- Posts: 14
- Thank you received: 0
-
-

13 years 3 months ago [\#115863](#115863) by [dedyandy](/forum/user/25295-dedyandy "View dedyandy's Profile")  Replied by *[dedyandy](/forum/user/25295-dedyandy "View dedyandy's Profile")* on topic *[Failed to import category\_id](/forum/4-how-to/85778-failed-to-import-category-id#115863 "Hi,  I failed to import category&#95;id.  I have the following csv file:  product&#95;name,price&#95;value,price&#95;currency&#95;id,category&#95;id,product&#95;code,Images Bordir Kuning,150000,75,12,1018,IMG-20130425-00097.jpg;IMG-20130425-00098.jpg  and attached is the parameter settings.  After importing, I had the following messages:  Error The column 'category&#95;id' is not in the list of possible columns : product&#95;parent&#95;id | product&#95;name | product&#95;description | product&#95;quantity | product&#95;code | product&#95;published | product&#95;hit | product&#95;created | product&#95;sale&#95;start | product&#95;sale&#95;end | product&#95;delay&#95;id | product&#95;tax&#95;id | product&#95;type | product&#95;vendor&#95;id | product&#95;manufacturer&#95;id | product&#95;url | product&#95;weight | product&#95;keywords | product&#95;weight&#95;unit | product&#95;modified | product&#95;meta&#95;description | product&#95;dimension&#95;unit | product&#95;width | product&#95;length | product&#95;height | product&#95;max&#95;per&#95;order | product&#95;access | product&#95;group&#95;after&#95;purchase | product&#95;min&#95;per&#95;order | product&#95;contact | product&#95;last&#95;seen&#95;date | product&#95;sales | product&#95;waitlist | product&#95;layout | product&#95;average&#95;score | product&#95;total&#95;vote | product&#95;page&#95;title | product&#95;alias | product&#95;price&#95;percentage | product&#95;msrp | product&#95;canonical | price&#95;value | price&#95;value&#95;with&#95;tax | price&#95;currency&#95;id | price&#95;min&#95;quantity | price&#95;access | files | images | parent&#95;category | categories&#95;namekey | categories&#95;image | categories&#95;ordering | categories | related | options | warna. The column data was ignored  Message 1 products found : 1 new products imported, 0 invalid product code, 0 already existing products.  The product was successfully imported, but HikaShop created another category for it.  I checked the category&#95;id did exist in the database, but it seemed HikaShop didn't recognise its own database field.  Could anyone help how to solve this problem.  Thanks, Andy.")*

Hi Eliot,

Oh yes, sorry I missed it.

Thanks.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg1Nzc4LWZhaWxlZC10by1pbXBvcnQtY2F0ZWdvcnktaWQ/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.066 seconds

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