Failed to import category_id

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.

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.

Hi Mohamed,

Can you tell me how do I export from HikaShop?

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

Hi Eliot,

Oh yes, sorry I missed it.

Thanks.