- Posts: 45
- Thank you received: 0
Import manufacturer names and assign to products ?
15 years 1 month ago #24121
by Karloz
Import manufacturer names and assign to products ? was created 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
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.
15 years 1 month ago #24137
by nicolas
Replied by nicolas on topic Re: Import manufacturer names and assign to products ?
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.
15 years 1 month ago #24176
by Karloz
Replied by Karloz on topic Re: Import manufacturer names and assign to products ?
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
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.
15 years 1 month ago #24178
by nicolas
Replied by nicolas on topic Re: Import manufacturer names and assign to products ?
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
$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.
15 years 1 month ago #24182
by Karloz
Replied by Karloz on topic Re: Import manufacturer names and assign to products ?
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 ?
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.
15 years 1 month ago #24184
by nicolas
Replied by nicolas on topic Re: Import manufacturer names and assign to products ?
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.
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