[Skip to main content](#vessel-content) # Produkt name translation in invoices ## - **[Rokell](/forum/user/32710-rokell "View Rokell's Profile")** - [![Rokell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32710-rokell "View Rokell's Profile") Topic Author - [ Offline](/forum/user/32710-rokell) Less More - Posts: 159 - Thank you received: 2 - - 12 years 4 months ago [\#160467](#160467) by [Rokell](/forum/user/32710-rokell "View Rokell's Profile") *[Produkt name translation in invoices](/forum/10-translation/869048-produkt-name-translation-in-invoices#160467 "Hi, I'm trying to find a way to change the language of the product name. All other information are changing when I switch to another language. Only the product name stays in the language of the order. I understood that the name is stored in the database, but there must be a way to show the translated product name, because it is also in the data base. Unfortunately my php skills are very limited and I need some help here. Thanks Roger")* was created by *[Rokell](/forum/user/32710-rokell "View Rokell's Profile")* Hi, I'm trying to find a way to change the language of the product name. All other information are changing when I switch to another language. Only the product name stays in the language of the order. I understood that the name is stored in the database, but there must be a way to show the translated product name, because it is also in the data base. Unfortunately my php skills are very limited and I need some help here. Thanks Roger Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzEwLXRyYW5zbGF0aW9uLzg2OTA0OC1wcm9kdWt0LW5hbWUtdHJhbnNsYXRpb24taW4taW52b2ljZXM/dG1wbD1tYXJrZG93bg==) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 12 years 4 months ago [\#160543](#160543) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Produkt name translation in invoices](/forum/10-translation/869048-produkt-name-translation-in-invoices#160543 "Hi, I'm trying to find a way to change the language of the product name. All other information are changing when I switch to another language. Only the product name stays in the language of the order. I understood that the name is stored in the database, but there must be a way to show the translated product name, because it is also in the data base. Unfortunately my php skills are very limited and I need some help here. Thanks Roger")* Hi, That's not easy. You need to edit the file "invoice" of the view "order" of your backend template via the menu Display>Views and chagne the display of the product name to : 1. load the translation data from the Falang/Joomfish table with a query to the jf_content or falang_content table where the reference_id correspond to the product id of the current product, with the reference_table being hikashop_product and the reference_column being product_name for the language_id you want. 2. display that the value from the result of that query instead of the order_product_name if you find a result. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzEwLXRyYW5zbGF0aW9uLzg2OTA0OC1wcm9kdWt0LW5hbWUtdHJhbnNsYXRpb24taW4taW52b2ljZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Rokell](/forum/user/32710-rokell "View Rokell's Profile")** - [![Rokell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32710-rokell "View Rokell's Profile") Topic Author - [ Offline](/forum/user/32710-rokell) Less More - Posts: 159 - Thank you received: 2 - - 12 years 4 months ago [\#160553](#160553) by [Rokell](/forum/user/32710-rokell "View Rokell's Profile") Replied by *[Rokell](/forum/user/32710-rokell "View Rokell's Profile")* on topic *[Produkt name translation in invoices](/forum/10-translation/869048-produkt-name-translation-in-invoices#160553 "Hi, I'm trying to find a way to change the language of the product name. All other information are changing when I switch to another language. Only the product name stays in the language of the order. I understood that the name is stored in the database, but there must be a way to show the translated product name, because it is also in the data base. Unfortunately my php skills are very limited and I need some help here. Thanks Roger")* Hi Nicolas, I don't use Falang or Joomfish. Why is there a possibility to translate the product names, if I can't use this translation in an invoice? Anyway, nothing is easy in Hikashop unless you are pretty good in programming which I'm not. I just learned that guest checkout is not working with downloadable products. That would make the whole HikaShop unusable for me, because I imported over 4000 customers from Virtuemart and they won't be able to use their mail address anymore for new orders. I tried for three weeks, but I'll give up now and go for your money back guarantee. It's a shame because I already put so much work in designing my website around HikaShop, but this is a deadend... Sorry and thanks for the effort Roger Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzEwLXRyYW5zbGF0aW9uLzg2OTA0OC1wcm9kdWt0LW5hbWUtdHJhbnNsYXRpb24taW4taW52b2ljZXM/dG1wbD1tYXJrZG93bg==) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 12 years 4 months ago [\#160661](#160661) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Produkt name translation in invoices](/forum/10-translation/869048-produkt-name-translation-in-invoices#160661 "Hi, I'm trying to find a way to change the language of the product name. All other information are changing when I switch to another language. Only the product name stays in the language of the order. I understood that the name is stored in the database, but there must be a way to show the translated product name, because it is also in the data base. Unfortunately my php skills are very limited and I need some help here. Thanks Roger")* Hi, Translation of the product names allow you to have different product names for different languages on the frontend so that each user sees the products in its own language. HikaShop guest checkout IS working with download products since a few releases. What you have read about that must be outdated. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzEwLXRyYW5zbGF0aW9uLzg2OTA0OC1wcm9kdWt0LW5hbWUtdHJhbnNsYXRpb24taW4taW52b2ljZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Rokell](/forum/user/32710-rokell "View Rokell's Profile")** - [![Rokell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32710-rokell "View Rokell's Profile") Topic Author - [ Offline](/forum/user/32710-rokell) Less More - Posts: 159 - Thank you received: 2 - - 12 years 4 months ago [\#160686](#160686) by [Rokell](/forum/user/32710-rokell "View Rokell's Profile") Replied by *[Rokell](/forum/user/32710-rokell "View Rokell's Profile")* on topic *[Produkt name translation in invoices](/forum/10-translation/869048-produkt-name-translation-in-invoices#160686 "Hi, I'm trying to find a way to change the language of the product name. All other information are changing when I switch to another language. Only the product name stays in the language of the order. I understood that the name is stored in the database, but there must be a way to show the translated product name, because it is also in the data base. Unfortunately my php skills are very limited and I need some help here. Thanks Roger")* Hi, yes, that is clear, but why can't I use the translation for the invoices as well? I don't understand why I have to install Falang/Joomfish to translate it, if a translation is already there. I tried guest check out with downloadable products. It works until the client tries to download the file. He has to login to download, but as a guest, he doesn't have an account to login. How can a customer download without logging in? I searched the forum and found this information from last November: [ www.hikashop.com/forum/customers/863840-...r-guests.html#133825](http://www.hikashop.com/forum/customers/863840-download-link-for-guests.html#133825) Now you say it is possible, but how? Thanks Roger Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzEwLXRyYW5zbGF0aW9uLzg2OTA0OC1wcm9kdWt0LW5hbWUtdHJhbnNsYXRpb24taW4taW52b2ljZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Rokell](/forum/user/32710-rokell "View Rokell's Profile")** - [![Rokell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32710-rokell "View Rokell's Profile") Topic Author - [ Offline](/forum/user/32710-rokell) Less More - Posts: 159 - Thank you received: 2 - - 12 years 4 months ago - 12 years 4 months ago [\#160723](#160723) by [Rokell](/forum/user/32710-rokell "View Rokell's Profile") Replied by *[Rokell](/forum/user/32710-rokell "View Rokell's Profile")* on topic *[Produkt name translation in invoices](/forum/10-translation/869048-produkt-name-translation-in-invoices#160723 "Hi, I'm trying to find a way to change the language of the product name. All other information are changing when I switch to another language. Only the product name stays in the language of the order. I understood that the name is stored in the database, but there must be a way to show the translated product name, because it is also in the data base. Unfortunately my php skills are very limited and I need some help here. Thanks Roger")* Hi, I spent another two hours of trying. Once the link in the status mail worked and I could download the product. But then I tried again and it didn't work anymore. Always sent me to a page that says 'Order not found'. Here is the link: Last edit: 12 years 4 months ago by [Rokell](/forum/user/32710-rokell "View Rokell's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzEwLXRyYW5zbGF0aW9uLzg2OTA0OC1wcm9kdWt0LW5hbWUtdHJhbnNsYXRpb24taW4taW52b2ljZXM/dG1wbD1tYXJrZG93bg==) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 12 years 4 months ago [\#161058](#161058) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Produkt name translation in invoices](/forum/10-translation/869048-produkt-name-translation-in-invoices#161058 "Hi, I'm trying to find a way to change the language of the product name. All other information are changing when I switch to another language. Only the product name stays in the language of the order. I understood that the name is stored in the database, but there must be a way to show the translated product name, because it is also in the data base. Unfortunately my php skills are very limited and I need some help here. Thanks Roger")* Hi, Your link is working fine. I was able to get your PDF just by clicking on it. So as you can see, the guest checkout and the download system are working fine together. There is nothing specific to do for that to work. The customer can just click on the download link of the notification email. I'm not following you regarding the translation. You say that you already have the translation without falang/joomfish ? How do you have it then ? Did you duplicate your products, one per language ? If that's the case, installing falang/joomfish won't help you and it would be quite hard to have a different translation display on the invoice in that case. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzEwLXRyYW5zbGF0aW9uLzg2OTA0OC1wcm9kdWt0LW5hbWUtdHJhbnNsYXRpb24taW4taW52b2ljZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Rokell](/forum/user/32710-rokell "View Rokell's Profile")** - [![Rokell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32710-rokell "View Rokell's Profile") Topic Author - [ Offline](/forum/user/32710-rokell) Less More - Posts: 159 - Thank you received: 2 - - 12 years 4 months ago [\#161074](#161074) by [Rokell](/forum/user/32710-rokell "View Rokell's Profile") Replied by *[Rokell](/forum/user/32710-rokell "View Rokell's Profile")* on topic *[Produkt name translation in invoices](/forum/10-translation/869048-produkt-name-translation-in-invoices#161074 "Hi, I'm trying to find a way to change the language of the product name. All other information are changing when I switch to another language. Only the product name stays in the language of the order. I understood that the name is stored in the database, but there must be a way to show the translated product name, because it is also in the data base. Unfortunately my php skills are very limited and I need some help here. Thanks Roger")* Hi, indeed the like is working now. Maybe my computer cache stored something from my previous test orders that blocked the download... Anyway, the translation I'm talking about is in HikaShop/Products. If I click on one of the language flags a pop up opens. There you can translate the name, description and meta data etc. for each product. So why do I need a third party component like Falang or Joomfish? [ ![h9896a8a.png](/forum/attachment/18013) ](/forum/attachment/18013 "h9896a8a.png") - [ ![h9896a8a.png](/forum/attachment/18013) ](/forum/attachment/18013 "h9896a8a.png") [ ](/forum/attachment/18013?download=1 "h9896a8a.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzEwLXRyYW5zbGF0aW9uLzg2OTA0OC1wcm9kdWt0LW5hbWUtdHJhbnNsYXRpb24taW4taW52b2ljZXM/dG1wbD1tYXJrZG93bg==) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 12 years 4 months ago [\#161168](#161168) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Produkt name translation in invoices](/forum/10-translation/869048-produkt-name-translation-in-invoices#161168 "Hi, I'm trying to find a way to change the language of the product name. All other information are changing when I switch to another language. Only the product name stays in the language of the order. I understood that the name is stored in the database, but there must be a way to show the translated product name, because it is also in the data base. Unfortunately my php skills are very limited and I need some help here. Thanks Roger")* Hi, The interface to add the translations via the HikaShop product edition page is indeed inside HikaShop. However, HikaShop stores that data in the JoomFish/Falang table so that the JoomFish/Falang system can then handle the translations replacing on the frontend (which is quite complex to do). If you don't have Falang/JoomFish on your website, you won't see this interface so I presume that you either have one of these installed, or you had one of these before you uninstalled it (but you still have the tables of JoomFish/Falang in your database and thus HikaShop believes that you still have Falang/JoomFish installed). But for the translations to be replaced on the frontend Falang/JoomFish needs to be installed and activated. Otherwise, you might get the data of translations stored in the JoomFish/Falang table, but there will be no replacing on the frontend and you'll always see the same text. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzEwLXRyYW5zbGF0aW9uLzg2OTA0OC1wcm9kdWt0LW5hbWUtdHJhbnNsYXRpb24taW4taW52b2ljZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Rokell](/forum/user/32710-rokell "View Rokell's Profile")** - [![Rokell's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32710-rokell "View Rokell's Profile") Topic Author - [ Offline](/forum/user/32710-rokell) Less More - Posts: 159 - Thank you received: 2 - - 12 years 4 months ago [\#161293](#161293) by [Rokell](/forum/user/32710-rokell "View Rokell's Profile") Replied by *[Rokell](/forum/user/32710-rokell "View Rokell's Profile")* on topic *[Produkt name translation in invoices](/forum/10-translation/869048-produkt-name-translation-in-invoices#161293 "Hi, I'm trying to find a way to change the language of the product name. All other information are changing when I switch to another language. Only the product name stays in the language of the order. I understood that the name is stored in the database, but there must be a way to show the translated product name, because it is also in the data base. Unfortunately my php skills are very limited and I need some help here. Thanks Roger")* Hi, alright, that explains a lot! I updated my website from 1.5 where I used Joomfish to 2.5 and then to 3.3. I don't have Joomfish installed, but you assumed right and the tables are still in the database. I would like to use the Joomla translating system and no Joomfish. So far Joomfish doesn't support Joomla 3. Does that mean I have to install Falang to get translations for the shop? And what about the rest of my website? Do have to do the translation through Falang because of HikaShop or can I use the Joomla build in translations for articles and menus? In that case I would need two modules for the translation flags... Best Roger Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzEwLXRyYW5zbGF0aW9uLzg2OTA0OC1wcm9kdWt0LW5hbWUtdHJhbnNsYXRpb24taW4taW52b2ljZXM/dG1wbD1tYXJrZG93bg==) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 12 years 4 months ago [\#161299](#161299) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Produkt name translation in invoices](/forum/10-translation/869048-produkt-name-translation-in-invoices#161299 "Hi, I'm trying to find a way to change the language of the product name. All other information are changing when I switch to another language. Only the product name stays in the language of the order. I understood that the name is stored in the database, but there must be a way to show the translated product name, because it is also in the data base. Unfortunately my php skills are very limited and I need some help here. Thanks Roger")* Hi, JoomFish doesn't work on Joomla 3.x but Falang does. You don't necessarily have to have JoomFish/Falang to translate products but we recommend you do. Without JoomFish/Falang, you could do like you do for Joomla articles: having one product/category per language. However, products often handle stock and there are some other particular cases which doesn't work great that way, and thus, it is not a practical solution compared to what can be done with JoomFish/Falang. Of course, you can still handle translations with the Joomla system and use JoomFish/Falang only for HikaShop. Both systems can work together. And you won't have two modules since JoomFish/Falang are compatible with the language selection module of Joomla. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzEwLXRyYW5zbGF0aW9uLzg2OTA0OC1wcm9kdWt0LW5hbWUtdHJhbnNsYXRpb24taW4taW52b2ljZXM/dG1wbD1tYXJrZG93bg==) 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.073 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)