[Skip to main content](#vessel-content) # Name of variant in db order\_product\_name ## - **[BluepointWebdesign](/forum/user/34929-bluepointwebdesign "View BluepointWebdesign's Profile")** - [![BluepointWebdesign's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34929-bluepointwebdesign "View BluepointWebdesign's Profile") Topic Author - [ Offline](/forum/user/34929-bluepointwebdesign) Less More - Posts: 424 - Thank you received: 11 - - 11 years 2 months ago [\#211263](#211263) by [BluepointWebdesign](/forum/user/34929-bluepointwebdesign "View BluepointWebdesign's Profile") *[Name of variant in db order\_product\_name](/forum/31-development/878711-name-of-variant-in-db-order-product-name#211263 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.x -- PHP version -- : 5.6 -- Error-message(debug-mod must be tuned on) -- : no errors Hello, We have made an soap call to our accounting, it works fine. But however, calling the database field (order_product_name) gives the name of the order, but when ordering a variant we get this information: Visitekaartjes 350 grams mat mc-papier: 500 stuks How can we make it so that we don't have the : 500 stuks shown in the order_product_name. Thanks.")* was created by *[BluepointWebdesign](/forum/user/34929-bluepointwebdesign "View BluepointWebdesign's Profile")* -- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.x -- PHP version -- : 5.6 -- Error-message(debug-mod must be tuned on) -- : no errors Hello, We have made an soap call to our accounting, it works fine. But however, calling the database field (order_product_name) gives the name of the order, but when ordering a variant we get this information: Visitekaartjes 350 grams mat mc-papier<span class="hikashop_product_variant_subname">: 500 stuks</span> How can we make it so that we don't have the <span class="hikashop_product_variant_subname">: 500 stuks</span> shown in the order_product_name. Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg3ODcxMS1uYW1lLW9mLXZhcmlhbnQtaW4tZGItb3JkZXItcHJvZHVjdC1uYW1lP3RtcGw9bWFya2Rvd24=) 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 2 months ago [\#211264](#211264) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Name of variant in db order\_product\_name](/forum/31-development/878711-name-of-variant-in-db-order-product-name#211264 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.x -- PHP version -- : 5.6 -- Error-message(debug-mod must be tuned on) -- : no errors Hello, We have made an soap call to our accounting, it works fine. But however, calling the database field (order_product_name) gives the name of the order, but when ordering a variant we get this information: Visitekaartjes 350 grams mat mc-papier: 500 stuks How can we make it so that we don't have the : 500 stuks shown in the order_product_name. Thanks.")* Hi, The "order_product_name" is the product name of the item when the order has been created. So I'm not sure to follow you for your sentence > calling the database field (order\_product\_name) gives the name of the order About the HTML content added for the variants, the best is to perform a "strip_tags" [ php.net/manual/en/function.strip-tags.php](http://php.net/manual/en/function.strip-tags.php) Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg3ODcxMS1uYW1lLW9mLXZhcmlhbnQtaW4tZGItb3JkZXItcHJvZHVjdC1uYW1lP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[BluepointWebdesign](/forum/user/34929-bluepointwebdesign "View BluepointWebdesign's Profile")** - [![BluepointWebdesign's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34929-bluepointwebdesign "View BluepointWebdesign's Profile") Topic Author - [ Offline](/forum/user/34929-bluepointwebdesign) Less More - Posts: 424 - Thank you received: 11 - - 11 years 2 months ago [\#211387](#211387) by [BluepointWebdesign](/forum/user/34929-bluepointwebdesign "View BluepointWebdesign's Profile") Replied by *[BluepointWebdesign](/forum/user/34929-bluepointwebdesign "View BluepointWebdesign's Profile")* on topic *[Name of variant in db order\_product\_name](/forum/31-development/878711-name-of-variant-in-db-order-product-name#211387 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.x -- PHP version -- : 5.6 -- Error-message(debug-mod must be tuned on) -- : no errors Hello, We have made an soap call to our accounting, it works fine. But however, calling the database field (order_product_name) gives the name of the order, but when ordering a variant we get this information: Visitekaartjes 350 grams mat mc-papier: 500 stuks How can we make it so that we don't have the : 500 stuks shown in the order_product_name. Thanks.")* let me try to explain.. in the order confirmation, see image: confirmationimage.png u see under Omschrijving the name of the product / variant. Product is HIOW Basis Website "Variant" is H003 When a customer have ordered this product it will go to our accounting system via soap call to there api .. But on the invoice created by the accounting we get the following.. see pdf file, this is an order of the product then with variant H001 HIOW basis website<span class="hikashop_product_variant_subname">: H001</span> H001 The data for this we call directly from the database and that is from the hikashop_order table the row order_product_name. The <span class is also in the database.. and we would like to get this out so both the order confirmation mail and the invoice will look neatly. Hope my english is good enough for you to understand. Thanks. - [ ![confirmationimage.png](/forum/attachment/25950) ](/forum/attachment/25950 "...ationimage.png") [ ](/forum/attachment/25950?download=1 "...ationimage.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg3ODcxMS1uYW1lLW9mLXZhcmlhbnQtaW4tZGItb3JkZXItcHJvZHVjdC1uYW1lP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86316 - Thank you received: 14276 - - 11 years 2 months ago [\#211395](#211395) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Name of variant in db order\_product\_name](/forum/31-development/878711-name-of-variant-in-db-order-product-name#211395 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.x -- PHP version -- : 5.6 -- Error-message(debug-mod must be tuned on) -- : no errors Hello, We have made an soap call to our accounting, it works fine. But however, calling the database field (order_product_name) gives the name of the order, but when ordering a variant we get this information: Visitekaartjes 350 grams mat mc-papier: 500 stuks How can we make it so that we don't have the : 500 stuks shown in the order_product_name. Thanks.")* Hi, As Jerome explained, it's normal that you have the HTML tag <span class="hikashop_product_variant_subname">: H001</span> in the order_product_name of the database. You should leave it like that. Instead, when you generate the PDF, you should add a strip_tags on the order_product_name you're using so that it would remove it during the generation of the PDF. That's what HikaShop does when it generates the invoice from the backend of HikaShop, or sends the name of the product to payment gateways, etc. Now if you really want to remove it from the database field, you can alsways hack the code of HikaShop to do it by changing the line: $orderProduct->order_product_name = $product->product_name; to: $orderProduct->order_product_name = strip_tags($product->product_name); in the file components/com_hikashop/controllers/checkout.php but I don't recommend it and rather recommend it doing it when displaying the information in the invoice. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg3ODcxMS1uYW1lLW9mLXZhcmlhbnQtaW4tZGItb3JkZXItcHJvZHVjdC1uYW1lP3RtcGw9bWFya2Rvd24=) 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? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.098 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)