Import products to categories with duplicate names

Hello,

I am importing products from an external warehouse and billing system, and my customer use the same category names many places in the category tree.

The problem is that parent category and categories for a product is referenced by name. If you use the same parent-child naming more than one place in the category tree, it is not possible to ensure import to the correct category.

I would prefer a new custom_id field to the categories, much like product code for products, so that I can use parent_category_code when creating new categories to avoid this problem.

Is it possible to get this implemented as soon as possible?

Michael

Hi Nicolas,

The thing is that my customer use an external system for managing their product catalogue and product categories, which is imported into Hikashop at regular intervals.

I cannot rely on existing categories in Hikashop since my customer may decide to reorganize their entire product catalogue into new categories.

Is it possible to set the category_code field for categories during CSV import, and reference this category_code when importing products?

CSV could look something like this:

parent_category,parent_category_code,categories
product category,,Coffee machines|cm;Spare parts|sp;Accessories|acc,Water Coolers|wc
Coffee machines,cm,Whole bean machines|cm_wb;Filter machines|cm_fm,Instant machines|cm_im
Spare parts,sp,Coffee machines|sp_wc;Water Coolers|sp_wc
Accessories,acc,Coffee machines|acc_wc;Water Coolers|acc_wc
Water Coolers,wc,Cold water|wc_cw;Cold and sparkling water|wc_cwsw


This is part of the actual categories that my customer use. Without the category code reference, the problem is that when creating categories from the last line the parent category could be either (product category->)Water Coolers, Accessories->Water Coolers or Spare parts->Water Coolers. I guess it will just choose the first one from the database lookup...

Michael

This does not appear to be working in the current version and the changes noted above don't seem to fit into the current code. Or maybe I am looking in the wrong place.

Could you please clarify where these changes go and whether they apply to 2.0? I would really like to get this working.

Thanks!

Thanks. It is working. I discovered it is a different issue. Apparently importing categories that have numeric names causes problems. The following appears to do nothing.

parent_category,categories,categories_ordering,categories_namekey
Top,44,,catkey_44

Hi,

You can add it manually in the backend, or try to add quotes:

parent_category,categories,categories_ordering,categories_namekey
Top,'44',,catkey_44

Unfortunately, neither single or double quotes work.

I have thousands of categories to import, so using the backend isn't a good option.

Thanks for the guidance. I made a slightly different change which might make sense to incorporate into the code base.

  if(!is_numeric($v) || !empty($product->categories_namekey)){

Hi,

I am using HikaShop 2.3.3. All the categories already exist in the database and I know the category namekey for each category. I would like to specify the namekey of the category in the import for the product to go into that category. The namekey is an integer value. Is there a way to do this?