[Skip to main content](#vessel-content)

#   import product with serial column

##

- **[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")**
- [![lionel75's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11856-lionel75 "View lionel75's Profile") Topic Author
- [ Offline](/forum/user/11856-lionel75)

Less More

- Posts: 846
- Thank you received: 92
-
-

12 years 2 months ago -  12 years 2 months ago [\#169406](#169406) by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")  *[import product with serial column](/forum/37-import-export-csv-xls/870711-import-product-with-serial-column#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")* was created by *[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")*

-- 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: 12 years 2 months ago by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzA3MTEtaW1wb3J0LXByb2R1Y3Qtd2l0aC1zZXJpYWwtY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

12 years 2 months ago [\#169413](#169413) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[import product with serial column](/forum/37-import-export-csv-xls/870711-import-product-with-serial-column#169413 "-- 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,

---

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

The following user(s) said Thank You: [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzA3MTEtaW1wb3J0LXByb2R1Y3Qtd2l0aC1zZXJpYWwtY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")**
- [![lionel75's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11856-lionel75 "View lionel75's Profile") Topic Author
- [ Offline](/forum/user/11856-lionel75)

Less More

- Posts: 846
- Thank you received: 92
-
-

12 years 2 months ago -  12 years 2 months ago [\#169518](#169518) by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")  Replied by *[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")* on topic *[import product with serial column](/forum/37-import-export-csv-xls/870711-import-product-with-serial-column#169518 "-- 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
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: 12 years 2 months ago by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzA3MTEtaW1wb3J0LXByb2R1Y3Qtd2l0aC1zZXJpYWwtY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

12 years 2 months ago [\#169521](#169521) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[import product with serial column](/forum/37-import-export-csv-xls/870711-import-product-with-serial-column#169521 "-- 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,

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 ![:)](/media/kunena/emoticons/3.png ":)")

Regards,

---

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzA3MTEtaW1wb3J0LXByb2R1Y3Qtd2l0aC1zZXJpYWwtY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")**
- [![lionel75's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11856-lionel75 "View lionel75's Profile") Topic Author
- [ Offline](/forum/user/11856-lionel75)

Less More

- Posts: 846
- Thank you received: 92
-
-

12 years 2 months ago -  12 years 2 months ago [\#169939](#169939) by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")  Replied by *[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")* on topic *[import product with serial column](/forum/37-import-export-csv-xls/870711-import-product-with-serial-column#169939 "-- 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
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 -&gt; serial ( sub mennu item)
or when
click on [see list ] ( available in pack -&gt; packname )

is it the way it must work ?

Last edit: 12 years 2 months ago by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzA3MTEtaW1wb3J0LXByb2R1Y3Qtd2l0aC1zZXJpYWwtY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

12 years 2 months ago [\#169984](#169984) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[import product with serial column](/forum/37-import-export-csv-xls/870711-import-product-with-serial-column#169984 "-- 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,

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

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

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

By Code:

if(!empty($productsAssociations['insert']) &amp;&amp; count($productsAssociations['insert']) &gt;= $this-&gt;perBatch) { $this-&gt;productCounter = $this-&gt;processPackAssociation($productsAssociations['insert']); }

Regards,

---

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzA3MTEtaW1wb3J0LXByb2R1Y3Qtd2l0aC1zZXJpYWwtY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")**
- [![lionel75's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/11856-lionel75 "View lionel75's Profile") Topic Author
- [ Offline](/forum/user/11856-lionel75)

Less More

- Posts: 846
- Thank you received: 92
-
-

12 years 2 months ago [\#169995](#169995) by [lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")  Replied by *[lionel75](/forum/user/11856-lionel75 "View lionel75's Profile")* on topic *[import product with serial column](/forum/37-import-export-csv-xls/870711-import-product-with-serial-column#169995 "-- 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
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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzA3MTEtaW1wb3J0LXByb2R1Y3Qtd2l0aC1zZXJpYWwtY29sdW1uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.059 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
