import product with serial column

-- Joomla version -- : 2.5.22
-- PHP version -- : 5.3.9

Hi
If i have many product that share use the same Hikaserial Name pack ( ID) Can i put this information in the CSV file before import .

regard's

Hi,

For your HikaSerial questions, please use the HikaSerial forum section.

HikaShop does not handle import of HikaSerial content, so it's not possible in an HikaShop import to put a column for the pack association.
But HikaSerial have his own import system (and the documentation is not very.. documented about that, sorry).

You can create a CSV file (or use the textarea) with two (or three) columns : "pack_id", "product_id" and "pack_quantity".
By importing such data, HikaSerial will create the associations between the product and the pack.
You can also use "product_code" or "pack_name" to find a product by his code or to find a pack by his name.
If the pack_quantity is not specified, the default value "1" will be use.

Regards,

hi
how is named labeled the product_id when edit product item in the joomla HSK BackEnd ?
in MysqL database ( table name hikashop_product) product_id is increment value . Could we use product_name or product_code instead product_id even with an ETL manage all this stuff ( relation beetween column value) could be an easy task.

regard's

Hi,

I wrote in my previous message:

You can also use "product_code" or "pack_name" to find a product by his code or to find a pack by his name.

So I don't understand your question

Regards,

Hi
when i import this data
pack_name,serial_data,product_code
"License Pack 2","00000001","product2"

i don't see the serial_data in hikaserial -> serial ( sub mennu item)
or when
click on [see list ] ( available in pack -> packname )

is it the way it must work ?

Hi,

The HikaSerial import hasn't been implement to import the pack association and the serial in the same time (in the same line).
So with the current version you can use:
Or you can edit the file "administrator/components/com_hikaserial/helpers/import.php" and replace By
Regards,

Hi
so in line 244 i add "//" in the beginning of the line to add comment //$serial=array();
it is working thank's
regard's