- Posts: 14
- Thank you received: 0
Failed to import category_id
13 years 3 months ago - 13 years 3 months ago #115764
by dedyandy
Failed to import category_id was created by dedyandy
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 | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | images | parent_category | categories_namekey | categories_image | categories_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_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.
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 | product_name | product_description | product_quantity | product_code | product_published | product_hit | product_created | product_sale_start | product_sale_end | product_delay_id | product_tax_id | product_type | product_vendor_id | product_manufacturer_id | product_url | product_weight | product_keywords | product_weight_unit | product_modified | product_meta_description | product_dimension_unit | product_width | product_length | product_height | product_max_per_order | product_access | product_group_after_purchase | product_min_per_order | product_contact | product_last_seen_date | product_sales | product_waitlist | product_layout | product_average_score | product_total_vote | product_page_title | product_alias | product_price_percentage | product_msrp | product_canonical | price_value | price_value_with_tax | price_currency_id | price_min_quantity | price_access | files | images | parent_category | categories_namekey | categories_image | categories_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_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.
Last edit: 13 years 3 months ago by dedyandy. Reason: Failed to attach the file
Please Log in or Create an account to join the conversation.
Less
More
- Posts: 12953
- Thank you received: 1778
13 years 3 months ago #115782
by Mohamed Thelji
Replied by Mohamed Thelji on topic Failed to import category_id
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.
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
Please Log in or Create an account to join the conversation.
13 years 3 months ago #115809
by dedyandy
Replied by dedyandy on topic Failed to import category_id
Hi Mohamed,
Can you tell me how do I export from HikaShop?
Can you tell me how do I export from HikaShop?
Please Log in or Create an account to join the conversation.
13 years 3 months ago #115824
by Eliot
Replied by Eliot on topic Failed to import category_id
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
Just go in your product listing (in the backend), select some products and click on the "export" at the top of the page
The following user(s) said Thank You: dedyandy
Please Log in or Create an account to join the conversation.
13 years 3 months ago #115863
by dedyandy
Replied by dedyandy on topic Failed to import category_id
Hi Eliot,
Oh yes, sorry I missed it.
Thanks.
Oh yes, sorry I missed it.
Thanks.
Please Log in or Create an account to join the conversation.
Time to create page: 0.065 seconds