Skip to main content

Import manufacturer names and assign to products ?

More
15 years 1 month ago #24121 by Karloz
Is there any way how to import manufacturer names and assign them to the products please ?

I tried to do that via product import & manufacturer_id column, but without success

thank you very much,
Karloz

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

More
15 years 1 month ago #24137 by nicolas
Yes, you can have your manufacturers in the product_manufacturer_id column of your CSV and they will be imported.

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

More
15 years 1 month ago #24176 by Karloz
hi yep i tried to import:

product_id, product_code, product_manufacturer_id
or only
product_id, product_manufacturer_id

and no product has been assign to a manufacturer (product_manufacturer_id was text)
also no manufacturer appears in manufacturers back-end
then i exported all products and the manufacturers are shown in categories column at the beginning, with null parent_category column

i would like to import products with a manufacturer name to be able to browse products by manufacturers...is it possible ?
thank you,
karloz

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

More
15 years 1 month ago #24178 by nicolas
Please change the code:
$id = $this->_createCategory($product->product_manufacturer_id,'manufacturer');

to:
$id = $this->_createCategory($product->product_manufacturer_id,0,'manufacturer');

in the file administrator/components/com_hikashop/helpers/import.php

and import the CSV:

product_code,product_manufacturer_id
my_prod,my manufacturer

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

More
15 years 1 month ago #24182 by Karloz
Yep it works very well thank you very much, but there is one more issue .. i imported:

product_code, product_manufacturer_id

manufacter name correctly assigned to the product,
but product_quantity changed to unlimited on all products, i think it should keep the previous quantity

also is it possible to set UTF-8 coding as default for import please ?

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

More
15 years 1 month ago #24184 by nicolas
for the quantity, removing the code
else{
$product->product_quantity=-1;
}
from that same file will solve that problem.


The unknown format should use UTF8 or another format based on what the system detects so it should work in most cases.

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

Time to create page: 0.296 seconds
Powered by Kunena Forum