[Skip to main content](#vessel-content) # Table to use for Attach Serial \[solved\] ## - **[incode](/forum/user/32027-incode "View incode's Profile")** - [![incode's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32027-incode "View incode's Profile") Topic Author - [ Offline](/forum/user/32027-incode) Less More - Posts: 5 - Thank you received: 1 - - 11 years 6 months ago - 11 years 6 months ago [\#198570](#198570) by [incode](/forum/user/32027-incode "View incode's Profile") *[Table to use for Attach Serial \[solved\]](/forum/15-general-talk-about-hikaserial/876373-table-to-use-for-attach-serial-solved#198570 "-- HikaShop version -- : 2.4.0 -- HikaSerial version -- : 1.9.1 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.39 -- Browser(s) name and version -- : Firefox 37.0.1 Hi, I'm very confused with using the right field with the right name in Attach Serial. {table.name_of_field} * Where can I find database name for each fields? * What type is more appropriate for each fields? Is there an exhaustive documentation about existing table?")* was created by *[incode](/forum/user/32027-incode "View incode's Profile")* -- HikaShop version -- : 2.4.0 -- HikaSerial version -- : 1.9.1 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.39 -- Browser(s) name and version -- : Firefox 37.0.1 Hi, I'm very confused with using the right field with the right name in Attach Serial. {table.name_of_field} 1. Where can I find database name for each fields? 2. What type is more appropriate for each fields? Is there an exhaustive documentation about existing table? Last edit: 11 years 6 months ago by [incode](/forum/user/32027-incode "View incode's Profile"). Reason: solved Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE1LWdlbmVyYWwtdGFsay1hYm91dC1oaWthc2VyaWFsLzg3NjM3My10YWJsZS10by11c2UtZm9yLWF0dGFjaC1zZXJpYWwtc29sdmVkP3RtcGw9bWFya2Rvd24=) 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: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 6 months ago [\#198571](#198571) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Table to use for Attach Serial](/forum/15-general-talk-about-hikaserial/876373-table-to-use-for-attach-serial-solved#198571 "-- HikaShop version -- : 2.4.0 -- HikaSerial version -- : 1.9.1 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.39 -- Browser(s) name and version -- : Firefox 37.0.1 Hi, I'm very confused with using the right field with the right name in Attach Serial. {table.name_of_field} * Where can I find database name for each fields? * What type is more appropriate for each fields? Is there an exhaustive documentation about existing table?")* Hi, In the "attach serial" documentation, we listed as possible the name of the different tables where the plugin can pick up data. [ www.hikashop.com/support/documentation/1...ns-attachserial.html](https://www.hikashop.com/support/documentation/152-hikaserial-plugins-attachserial.html) About the table structure ; you can see directly your database tables thanks to "phpmyadmin" for example. The HikaShop documentation have also a database schema which will give you a lot of information (even if the database has grown and now have more columns, but no column were removed) [ www.hikashop.com/support/support/documen...ocumentation.html#db](https://www.hikashop.com/support/support/documentation/62-hikashop-developer-documentation.html#db) I know that the interface is not fully user-friendly but it's the best interface I found in order to have a huge flexibility. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [incode](/forum/user/32027-incode "View incode's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE1LWdlbmVyYWwtdGFsay1hYm91dC1oaWthc2VyaWFsLzg3NjM3My10YWJsZS10by11c2UtZm9yLWF0dGFjaC1zZXJpYWwtc29sdmVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[incode](/forum/user/32027-incode "View incode's Profile")** - [![incode's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32027-incode "View incode's Profile") Topic Author - [ Offline](/forum/user/32027-incode) Less More - Posts: 5 - Thank you received: 1 - - 11 years 6 months ago [\#198609](#198609) by [incode](/forum/user/32027-incode "View incode's Profile") Replied by *[incode](/forum/user/32027-incode "View incode's Profile")* on topic *[Table to use for Attach Serial](/forum/15-general-talk-about-hikaserial/876373-table-to-use-for-attach-serial-solved#198609 "-- HikaShop version -- : 2.4.0 -- HikaSerial version -- : 1.9.1 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.39 -- Browser(s) name and version -- : Firefox 37.0.1 Hi, I'm very confused with using the right field with the right name in Attach Serial. {table.name_of_field} * Where can I find database name for each fields? * What type is more appropriate for each fields? Is there an exhaustive documentation about existing table?")* Great! It's exactely what I expected. I didn't realise it's a developer level so I didn't look at that suport section ... Thank you very much. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE1LWdlbmVyYWwtdGFsay1hYm91dC1oaWthc2VyaWFsLzg3NjM3My10YWJsZS10by11c2UtZm9yLWF0dGFjaC1zZXJpYWwtc29sdmVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[incode](/forum/user/32027-incode "View incode's Profile")** - [![incode's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32027-incode "View incode's Profile") Topic Author - [ Offline](/forum/user/32027-incode) Less More - Posts: 5 - Thank you received: 1 - - 11 years 6 months ago - 11 years 6 months ago [\#198691](#198691) by [incode](/forum/user/32027-incode "View incode's Profile") Replied by *[incode](/forum/user/32027-incode "View incode's Profile")* on topic *[Table to use for Attach Serial](/forum/15-general-talk-about-hikaserial/876373-table-to-use-for-attach-serial-solved#198691 "-- HikaShop version -- : 2.4.0 -- HikaSerial version -- : 1.9.1 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.39 -- Browser(s) name and version -- : Firefox 37.0.1 Hi, I'm very confused with using the right field with the right name in Attach Serial. {table.name_of_field} * Where can I find database name for each fields? * What type is more appropriate for each fields? Is there an exhaustive documentation about existing table?")* Now if I want to display a characteristic of a product in attach serial. What should I use {product_characteristic.chacteristic_id} in dynamic type ? Last edit: 11 years 6 months ago by [incode](/forum/user/32027-incode "View incode's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE1LWdlbmVyYWwtdGFsay1hYm91dC1oaWthc2VyaWFsLzg3NjM3My10YWJsZS10by11c2UtZm9yLWF0dGFjaC1zZXJpYWwtc29sdmVkP3RtcGw9bWFya2Rvd24=) 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: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 6 months ago [\#198695](#198695) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Table to use for Attach Serial](/forum/15-general-talk-about-hikaserial/876373-table-to-use-for-attach-serial-solved#198695 "-- HikaShop version -- : 2.4.0 -- HikaSerial version -- : 1.9.1 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.39 -- Browser(s) name and version -- : Firefox 37.0.1 Hi, I'm very confused with using the right field with the right name in Attach Serial. {table.name_of_field} * Where can I find database name for each fields? * What type is more appropriate for each fields? Is there an exhaustive documentation about existing table?")* Hi, The plugin "attach serial" does not allow to access to the characteristics but thanks to the "order product / order product name" you can display the full name of the product with the selected characteristics. If you can describe what you want to achieve, it will help us to understand your needs and see how you can realize it. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE1LWdlbmVyYWwtdGFsay1hYm91dC1oaWthc2VyaWFsLzg3NjM3My10YWJsZS10by11c2UtZm9yLWF0dGFjaC1zZXJpYWwtc29sdmVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[incode](/forum/user/32027-incode "View incode's Profile")** - [![incode's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32027-incode "View incode's Profile") Topic Author - [ Offline](/forum/user/32027-incode) Less More - Posts: 5 - Thank you received: 1 - - 11 years 6 months ago - 11 years 6 months ago [\#198825](#198825) by [incode](/forum/user/32027-incode "View incode's Profile") Replied by *[incode](/forum/user/32027-incode "View incode's Profile")* on topic *[Table to use for Attach Serial](/forum/15-general-talk-about-hikaserial/876373-table-to-use-for-attach-serial-solved#198825 "-- HikaShop version -- : 2.4.0 -- HikaSerial version -- : 1.9.1 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.39 -- Browser(s) name and version -- : Firefox 37.0.1 Hi, I'm very confused with using the right field with the right name in Attach Serial. {table.name_of_field} * Where can I find database name for each fields? * What type is more appropriate for each fields? Is there an exhaustive documentation about existing table?")* > If you can describe what you want to achieve, it will help us to understand your needs and see how you can realize it. I created personalized gift coupon with the name of the one receiving it and I would like to display the product characteristic. Our product is called "Dmitri" an I want to display the size: Dmtri 10cm. > thanks to the "order product / order product name" you can display the full name of the product with the selected characteristics. Indeed variants are called "Dmitri cm". How can I get that variant name? [ ![AttachSerialParameter.png](/forum/attachment/23812) ](/forum/attachment/23812 "...lParameter.png") this doesn't work (even with "Dynamic Text ..." type) [ ![AttachSerialParameter-VariantName.png](/forum/attachment/23813) ](/forum/attachment/23813 "...ariantName.png") I tried {order_product.product_name} {order_product.name} {product.product_name} - [ ![AttachSerialParameter.png](/forum/attachment/23812) ](/forum/attachment/23812 "...lParameter.png") [ ](/forum/attachment/23812?download=1 "...lParameter.png") - [ ![AttachSerialParameter-VariantName.png](/forum/attachment/23813) ](/forum/attachment/23813 "...ariantName.png") [ ](/forum/attachment/23813?download=1 "...ariantName.png") Last edit: 11 years 6 months ago by [incode](/forum/user/32027-incode "View incode's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE1LWdlbmVyYWwtdGFsay1hYm91dC1oaWthc2VyaWFsLzg3NjM3My10YWJsZS10by11c2UtZm9yLWF0dGFjaC1zZXJpYWwtc29sdmVkP3RtcGw9bWFya2Rvd24=) 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: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 6 months ago [\#198833](#198833) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Table to use for Attach Serial](/forum/15-general-talk-about-hikaserial/876373-table-to-use-for-attach-serial-solved#198833 "-- HikaShop version -- : 2.4.0 -- HikaSerial version -- : 1.9.1 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.39 -- Browser(s) name and version -- : Firefox 37.0.1 Hi, I'm very confused with using the right field with the right name in Attach Serial. {table.name_of_field} * Where can I find database name for each fields? * What type is more appropriate for each fields? Is there an exhaustive documentation about existing table?")* Hi, If you're using "Order product..." you just have to enter the name of the field in the input box (not in the "dynamic text" format). So you just need to enter "characteristic_taille" if you want to display the custom item field "characteristic_taille". But if you want to display the order product name, you have to enter "order_product_name". Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE1LWdlbmVyYWwtdGFsay1hYm91dC1oaWthc2VyaWFsLzg3NjM3My10YWJsZS10by11c2UtZm9yLWF0dGFjaC1zZXJpYWwtc29sdmVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[incode](/forum/user/32027-incode "View incode's Profile")** - [![incode's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32027-incode "View incode's Profile") Topic Author - [ Offline](/forum/user/32027-incode) Less More - Posts: 5 - Thank you received: 1 - - 11 years 6 months ago [\#198905](#198905) by [incode](/forum/user/32027-incode "View incode's Profile") Replied by *[incode](/forum/user/32027-incode "View incode's Profile")* on topic *[Table to use for Attach Serial](/forum/15-general-talk-about-hikaserial/876373-table-to-use-for-attach-serial-solved#198905 "-- HikaShop version -- : 2.4.0 -- HikaSerial version -- : 1.9.1 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.39 -- Browser(s) name and version -- : Firefox 37.0.1 Hi, I'm very confused with using the right field with the right name in Attach Serial. {table.name_of_field} * Where can I find database name for each fields? * What type is more appropriate for each fields? Is there an exhaustive documentation about existing table?")* Thank you. After testing I understand now very well how it work (also dynamic text ![;)](/media/kunena/emoticons/11.png ";)") who may concat fields ) The following user(s) said Thank You: [Jerome](/forum/user/80-jerome "View Jerome's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE1LWdlbmVyYWwtdGFsay1hYm91dC1oaWthc2VyaWFsLzg3NjM3My10YWJsZS10by11c2UtZm9yLWF0dGFjaC1zZXJpYWwtc29sdmVkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & 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? Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile") [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.314 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)