import product with serial column

  • Posts: 846
  • Thank you received: 92
9 years 7 months ago #169406

-- 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

Last edit: 9 years 7 months ago by lionel75.

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

  • Posts: 26007
  • Thank you received: 4004
  • MODERATOR
9 years 7 months ago #169413

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,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: lionel75

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

  • Posts: 846
  • Thank you received: 92
9 years 7 months ago #169518

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

Last edit: 9 years 7 months ago by lionel75.

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

  • Posts: 26007
  • Thank you received: 4004
  • MODERATOR
9 years 7 months ago #169521

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,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 846
  • Thank you received: 92
9 years 7 months ago #169939

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 ?

Last edit: 9 years 7 months ago by lionel75.

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

  • Posts: 26007
  • Thank you received: 4004
  • MODERATOR
9 years 7 months ago #169984

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:

pack_name,serial_data,product_code
"License Pack 2","00000001",""
"License Pack 2","","product2"

Or you can edit the file "administrator/components/com_hikaserial/helpers/import.php" and replace
	if(!empty($productsAssociations['insert']) && count($productsAssociations['insert']) >= $this->perBatch) {
		$this->productCounter = $this->processPackAssociation($productsAssociations['insert']);
	}

	$serial = array();
By
	if(!empty($productsAssociations['insert']) && count($productsAssociations['insert']) >= $this->perBatch) {
		$this->productCounter = $this->processPackAssociation($productsAssociations['insert']);
	}

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 846
  • Thank you received: 92
9 years 7 months ago #169995

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

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

Time to create page: 0.065 seconds
Powered by Kunena Forum