Skip to main content

Failed to import category_id

13 years 3 months ago - 13 years 3 months ago #115764 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.
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.

13 years 3 months ago #115782 by Mohamed Thelji
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

Please Log in or Create an account to join the conversation.

13 years 3 months ago #115809 by dedyandy
Hi Mohamed,

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 ;)
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
Hi Eliot,

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
Powered by Kunena Forum