Import manufacturer names and assign to products ?

  • Posts: 45
  • Thank you received: 0
13 years 3 months ago #24121

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.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
13 years 3 months ago #24137

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.

  • Posts: 45
  • Thank you received: 0
13 years 3 months ago #24176

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.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
13 years 3 months ago #24178

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.

  • Posts: 45
  • Thank you received: 0
13 years 3 months ago #24182

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.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
13 years 3 months ago #24184

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.053 seconds
Powered by Kunena Forum