importing product does not add category information

  • Posts: 22
  • Thank you received: 1
  • Hikashop Business
10 months 1 week ago #283857

-- HikaShop version -- : 3.2.1
-- Joomla version -- : Joomla! 3.8.2
-- PHP version -- : PHP Version 5.6.24
-- Browser(s) name and version -- : Firefox Quantum 57.0 (64-bit)
-- Error-message(debug-mod must be tuned on) -- : The column 'category_name' is not in the list of possible columns
The column 'category_published' is not in the list of possible columns
The column 'category_description' is not in the list of possible columns
The column 'category_id' is not in the list of possible columns
The column 'category_parent_id' is not in the list of possible columns
The column 'category_meta_description' is not in the list of possible columns
The column 'category_depth' is not in the list of possible columns
The column 'category_keywords' is not in the list of possible columns

Hi I have exported my CSv and am not attempting to import a large number of items. I tried to use just the column headings and I received the following error messages
The column 'category_name' is not in the list of possible columns
The column 'category_published' is not in the list of possible columns
The column 'category_description' is not in the list of possible columns
The column 'category_id' is not in the list of possible columns
The column 'category_parent_id' is not in the list of possible columns
The column 'category_meta_description' is not in the list of possible columns
The column 'category_depth' is not in the list of possible columns
The column 'category_keywords' is not in the list of possible columns
These categories are already in the site but I need to add the category information along with the product
please can you help, thanks

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

  • Posts: 22
  • Thank you received: 1
  • Hikashop Business
10 months 1 week ago #283868

I have added my headings and a single product which I was using for testing. I hope this helps
Thanks

File Attachment:

File Name: A052-import1.csv
File Size:1 KB

Attachments:

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

  • Posts: 63566
  • Thank you received: 9155
  • MODERATOR
10 months 1 week ago #283858

Hi,

I suppose that you're trying to use the products import system in the menu Products>Import of HikaShop.
Please understand that this is mainly a products import system, not a categories import system.
You can import some of the information of the categories but not everything.
If you want to import the columns as in the dabatase, please use the import system of your PHPMyAdmin.
It can import CSV files too and just requires that your CSV column names matches with the column names of the table in the database.
You can even export a CSV of the data in that table so that you can open it in excel, add the missing data there and import it back.

The products import system can have the category_name in the "categories" column, and category_name of the parent category in the "parent_category" column. It will in that case automatically create published categories based on these, without description, without meta description, etc. The main use though is to link the products you're importing with the categories already there.

Last Edit: 10 months 1 week ago by nicolas.

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

  • Posts: 22
  • Thank you received: 1
  • Hikashop Business
10 months 1 week ago #283897

Thank you Nicolas
from your comments I assume that I can add:
'category_name'
'category_parent'
I have these and have tried this but they are not being added? I'll try again with a smaller list to import.
They exist in the category tree in Hikashop already, I need to associate the product with these as a minimum can this be done?
Also my images are in additional folders within the hikashop 'upload' folder so can I Import the path associated with them for example:
folder/image1
where folder is a product image group name within the 'upload' folder
would the column heading be image?
Many thanks

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

  • Posts: 63566
  • Thank you received: 9155
  • MODERATOR
10 months 1 week ago #283903

Hi,

Please read my message above.
As I said there, for the "category_name" you need to use the column name "categories" and for the category_parent, you need to use the column name "parent_category". If you use another column name it won't work.
The heading for images is "images".

I would recommend to read our tutorial on the import system:
www.hikashop.com/support/documentation/73-hikashop-import.html
Also, you can create one or two products through the interface of HikaShop and use the "export" button of the products listing in order to get a CSV of all the data of the products. The columns and data format are the same than the ones accepted by the import system.

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

Time to create page: 0.080 seconds
Powered by Kunena Forum