[Skip to main content](#vessel-content) # How to import product\_layout in csv file? ## - **[Metasoma](/forum/user/17269-metasoma "View Metasoma's Profile")** - [![Metasoma's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/17269-metasoma "View Metasoma's Profile") Topic Author - [ Offline](/forum/user/17269-metasoma) Less More - Posts: 13 - Thank you received: 0 - - 13 years 6 months ago [\#100670](#100670) by [Metasoma](/forum/user/17269-metasoma "View Metasoma's Profile") *[How to import product\_layout in csv file?](/forum/4-how-to/80837-how-to-import-product-layout-in-csv-file#100670 "There is an option on the product page named 'Layout on product page'. The option is 'inherit' by default but I want to change it to my custom layout. I made this custom layout in 'views' and...")* was created by *[Metasoma](/forum/user/17269-metasoma "View Metasoma's Profile")* There is an option on the product page named 'Layout on product page'. The option is 'inherit' by default but I want to change it to my custom layout. I made this custom layout in 'views' and everything is OK when I change it manually but it seems it doesn't work when I try to import csv file. I made a column named 'product_layout' in csv file and placed a value in the column, let's say 'show_default_000'. I imported the file without any problems but the layout didn't change at all, it's still 'inherit' on the product page although in the phpmyadmin it's 'show_default_000'. What I did wrong? Why doesn't import work? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzgwODM3LWhvdy10by1pbXBvcnQtcHJvZHVjdC1sYXlvdXQtaW4tY3N2LWZpbGU/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86359 - Thank you received: 14296 - - 13 years 6 months ago [\#100674](#100674) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to import product\_layout in csv file?](/forum/4-how-to/80837-how-to-import-product-layout-in-csv-file#100674 "There is an option on the product page named 'Layout on product page'. The option is 'inherit' by default but I want to change it to my custom layout. I made this custom layout in 'views' and...")* if it shows the correct value in phpmyadmin then you will have the correct value in HikaShop since hikashop displays the value from the database... I'm guessing that you're not looking at the correct place. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzgwODM3LWhvdy10by1pbXBvcnQtcHJvZHVjdC1sYXlvdXQtaW4tY3N2LWZpbGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Metasoma](/forum/user/17269-metasoma "View Metasoma's Profile")** - [![Metasoma's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/17269-metasoma "View Metasoma's Profile") Topic Author - [ Offline](/forum/user/17269-metasoma) Less More - Posts: 13 - Thank you received: 0 - - 13 years 6 months ago [\#100681](#100681) by [Metasoma](/forum/user/17269-metasoma "View Metasoma's Profile") Replied by *[Metasoma](/forum/user/17269-metasoma "View Metasoma's Profile")* on topic *[How to import product\_layout in csv file?](/forum/4-how-to/80837-how-to-import-product-layout-in-csv-file#100681 "There is an option on the product page named 'Layout on product page'. The option is 'inherit' by default but I want to change it to my custom layout. I made this custom layout in 'views' and...")* I'm looking at the table 'hikashop_product' in the database and at the column 'product_layout'. If it's not the correct place, please, tell me where the correct place is. Also, when I change manually, for example, to 'show_tabular' I can see how it also changes in phpmyadmin, from 'show_default_000' to 'show_tabular'. After that I import my csv file, in phpmyadmin it's 'show_default_000' again but on the product page it's 'inherit'. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzgwODM3LWhvdy10by1pbXBvcnQtcHJvZHVjdC1sYXlvdXQtaW4tY3N2LWZpbGU/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86359 - Thank you received: 14296 - - 13 years 6 months ago [\#100686](#100686) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to import product\_layout in csv file?](/forum/4-how-to/80837-how-to-import-product-layout-in-csv-file#100686 "There is an option on the product page named 'Layout on product page'. The option is 'inherit' by default but I want to change it to my custom layout. I made this custom layout in 'views' and...")* That means that the system couldn't find any view file called show_default_000 and thus discarded your value to use the default one. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzgwODM3LWhvdy10by1pbXBvcnQtcHJvZHVjdC1sYXlvdXQtaW4tY3N2LWZpbGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Metasoma](/forum/user/17269-metasoma "View Metasoma's Profile")** - [![Metasoma's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/17269-metasoma "View Metasoma's Profile") Topic Author - [ Offline](/forum/user/17269-metasoma) Less More - Posts: 13 - Thank you received: 0 - - 13 years 6 months ago [\#100706](#100706) by [Metasoma](/forum/user/17269-metasoma "View Metasoma's Profile") Replied by *[Metasoma](/forum/user/17269-metasoma "View Metasoma's Profile")* on topic *[How to import product\_layout in csv file?](/forum/4-how-to/80837-how-to-import-product-layout-in-csv-file#100706 "There is an option on the product page named 'Layout on product page'. The option is 'inherit' by default but I want to change it to my custom layout. I made this custom layout in 'views' and...")* Well, I do understand that the system couldn't find any view file called show_default_000, I do not understand why. I can change change the view on the product page but can't import it via csv. And I'm absolutely sure that there is no mistake in the name - it's show_default_000, I checked like 10000 times. By the way, I tried to import default Hikashop views, like show_tabular, and it works. But my custom view does not. Can it be somehow connected to a template because on the product page the custom view is under 'from --- template override'? It seems, import works with default views but doesn't with template. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzgwODM3LWhvdy10by1pbXBvcnQtcHJvZHVjdC1sYXlvdXQtaW4tY3N2LWZpbGU/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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86359 - Thank you received: 14296 - - 13 years 6 months ago [\#101170](#101170) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to import product\_layout in csv file?](/forum/4-how-to/80837-how-to-import-product-layout-in-csv-file#101170 "There is an option on the product page named 'Layout on product page'. The option is 'inherit' by default but I want to change it to my custom layout. I made this custom layout in 'views' and...")* I'm sorry but everything is working fine for us. I tried on our end an import of that CSV: Code: product_name,product_layout my_prod_test,show_default_000 and I got the product created with the show_default_000 custom view file attached to it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzgwODM3LWhvdy10by1pbXBvcnQtcHJvZHVjdC1sYXlvdXQtaW4tY3N2LWZpbGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Metasoma](/forum/user/17269-metasoma "View Metasoma's Profile")** - [![Metasoma's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/17269-metasoma "View Metasoma's Profile") Topic Author - [ Offline](/forum/user/17269-metasoma) Less More - Posts: 13 - Thank you received: 0 - - 13 years 6 months ago [\#101252](#101252) by [Metasoma](/forum/user/17269-metasoma "View Metasoma's Profile") Replied by *[Metasoma](/forum/user/17269-metasoma "View Metasoma's Profile")* on topic *[How to import product\_layout in csv file?](/forum/4-how-to/80837-how-to-import-product-layout-in-csv-file#101252 "There is an option on the product page named 'Layout on product page'. The option is 'inherit' by default but I want to change it to my custom layout. I made this custom layout in 'views' and...")* Well, in fact, I solved the problem. I made a new csv file with only 2 columns: product_code and product_layout. And it worked. So, it seems that the problem was with the big csv file that had like 15 or more columns. Something somewhere in the file was the cause of the problem. But what was it I have no idea, need to recreate the file step by step now to find out what information is 'bad'. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzgwODM3LWhvdy10by1pbXBvcnQtcHJvZHVjdC1sYXlvdXQtaW4tY3N2LWZpbGU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[toneee](/forum/user/7304-toneee "View toneee's Profile")** - [![toneee's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/7304-toneee "View toneee's Profile") - [ Offline](/forum/user/7304-toneee) Less More - Posts: 14 - Thank you received: 2 - - 13 years 6 months ago [\#101412](#101412) by [toneee](/forum/user/7304-toneee "View toneee's Profile") Replied by *[toneee](/forum/user/7304-toneee "View toneee's Profile")* on topic *[How to import product\_layout in csv file?](/forum/4-how-to/80837-how-to-import-product-layout-in-csv-file#101412 "There is an option on the product page named 'Layout on product page'. The option is 'inherit' by default but I want to change it to my custom layout. I made this custom layout in 'views' and...")* I'm not sure if this will help, but I've created a [ Microsoft Excel spreadsheet](http://bit.ly/hikashop-csv-import) with probably over 70 columns containing every field possible for a particular product. It comes complete with comments if you hover over many of the column headers and even a [ visual tutorial](http://bit.ly/10mTBeJ) to demonstrate how to export the file as CSV and import into HikaShop 2.x+. The spreadsheet mentions (via comments) that you can either leave the product_layout field blank to set as Inherit, or set as any of the following: - show\_default - show\_reversed - show\_tabular I hope this is helpful to somebody out there needing to import multiple products quickly and efficiently. The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzgwODM3LWhvdy10by1pbXBvcnQtcHJvZHVjdC1sYXlvdXQtaW4tY3N2LWZpbGU/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.056 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)