[Skip to main content](#vessel-content) # Variants import leads to blank product page. ## - **[ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile")** - [![ydingilski's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar37980.png)](/forum/user/37980-ydingilski "View ydingilski's Profile") Topic Author - [ Offline](/forum/user/37980-ydingilski) Less More - Posts: 52 - Thank you received: 0 - - - - [](http://www.filkab.solar) - 11 years 3 months ago [\#210893](#210893) by [ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile") *[Variants import leads to blank product page.](/forum/37-import-export-csv-xls/878628-variants-import-leads-to-blank-product-page#210893 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.3.15 I have about 380 products added so far - both main and variants. Main product #381 has a total of 175 variants. If I add the variants manually in the back-end then everything is OK. If I choose not to add the variants manually but rather import a CSV file then the front-end product #381 page is blank, i.e. when I load the product page nothing is displayed. If I delete about 2/3 of the imported variants then the front-end product page displays normally. Some additional info: I have about 50 custom product fields. Part of the fields are associated with some of the products, others are associated with other products. One thing I've noticed: When I add the variants manually, all the custom fields in the table hikashop_product that are not related to product #381 are NULL, i.e. the table is normalized in that part - I'm not database pro so I'm not quite sure about the right definition. If I import a CSV file these custom fields are just blank. Could that be the issue or something else? How do I import CSV in order to fill in NULL where necessary.")* was created by *[ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile")* -- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.3.15 I have about 380 products added so far - both main and variants. Main product #381 has a total of 175 variants. If I add the variants manually in the back-end then everything is OK. If I choose not to add the variants manually but rather import a CSV file then the front-end product #381 page is blank, i.e. when I load the product page nothing is displayed. If I delete about 2/3 of the imported variants then the front-end product page displays normally. Some additional info: I have about 50 custom product fields. Part of the fields are associated with some of the products, others are associated with other products. One thing I've noticed: When I add the variants manually, all the custom fields in the table **hikashop\_product** that are not related to product #381 are *NULL*, i.e. the table is normalized in that part - I'm not database pro so I'm not quite sure about the right definition. If I import a CSV file these custom fields are just blank. Could that be the issue or something else? How do I import CSV in order to fill in *NULL* where necessary. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84Nzg2MjgtdmFyaWFudHMtaW1wb3J0LWxlYWRzLXRvLWJsYW5rLXByb2R1Y3QtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile")** - [![ydingilski's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar37980.png)](/forum/user/37980-ydingilski "View ydingilski's Profile") Topic Author - [ Offline](/forum/user/37980-ydingilski) Less More - Posts: 52 - Thank you received: 0 - - - - [](http://www.filkab.solar) - 11 years 3 months ago - 11 years 3 months ago [\#210894](#210894) by [ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile") Replied by *[ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile")* on topic *[Variants import leads to blank product page.](/forum/37-import-export-csv-xls/878628-variants-import-leads-to-blank-product-page#210894 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.3.15 I have about 380 products added so far - both main and variants. Main product #381 has a total of 175 variants. If I add the variants manually in the back-end then everything is OK. If I choose not to add the variants manually but rather import a CSV file then the front-end product #381 page is blank, i.e. when I load the product page nothing is displayed. If I delete about 2/3 of the imported variants then the front-end product page displays normally. Some additional info: I have about 50 custom product fields. Part of the fields are associated with some of the products, others are associated with other products. One thing I've noticed: When I add the variants manually, all the custom fields in the table hikashop_product that are not related to product #381 are NULL, i.e. the table is normalized in that part - I'm not database pro so I'm not quite sure about the right definition. If I import a CSV file these custom fields are just blank. Could that be the issue or something else? How do I import CSV in order to fill in NULL where necessary.")* When I import a CSV file with the variants everything in the back-end looks fine. All the info is correct and the variants are associated with the main product. Last edit: 11 years 3 months ago by [ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84Nzg2MjgtdmFyaWFudHMtaW1wb3J0LWxlYWRzLXRvLWJsYW5rLXByb2R1Y3QtcGFnZT90bXBsPW1hcmtkb3du) 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: 86541 - Thank you received: 14304 - - 11 years 3 months ago [\#210940](#210940) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Variants import leads to blank product page.](/forum/37-import-export-csv-xls/878628-variants-import-leads-to-blank-product-page#210940 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.3.15 I have about 380 products added so far - both main and variants. Main product #381 has a total of 175 variants. If I add the variants manually in the back-end then everything is OK. If I choose not to add the variants manually but rather import a CSV file then the front-end product #381 page is blank, i.e. when I load the product page nothing is displayed. If I delete about 2/3 of the imported variants then the front-end product page displays normally. Some additional info: I have about 50 custom product fields. Part of the fields are associated with some of the products, others are associated with other products. One thing I've noticed: When I add the variants manually, all the custom fields in the table hikashop_product that are not related to product #381 are NULL, i.e. the table is normalized in that part - I'm not database pro so I'm not quite sure about the right definition. If I import a CSV file these custom fields are just blank. Could that be the issue or something else? How do I import CSV in order to fill in NULL where necessary.")* Hi, NULL or blank, that's the same for custom fields so no problem on that. So you said that you have a blank page on the product page. Is the page completely blank with nothing on it ? If you turn on the "error reporting" and "debug mode" settings of the Joomla configuration, do you get any error message on the product page ? In that case, what is the exact message ? If there is a difference, it must come of the way the CSV is done so a small version of the CSV with one or two products and their variants would be great for us to understand the issue. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84Nzg2MjgtdmFyaWFudHMtaW1wb3J0LWxlYWRzLXRvLWJsYW5rLXByb2R1Y3QtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile")** - [![ydingilski's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar37980.png)](/forum/user/37980-ydingilski "View ydingilski's Profile") Topic Author - [ Offline](/forum/user/37980-ydingilski) Less More - Posts: 52 - Thank you received: 0 - - - - [](http://www.filkab.solar) - 11 years 3 months ago [\#211122](#211122) by [ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile") Replied by *[ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile")* on topic *[Variants import leads to blank product page.](/forum/37-import-export-csv-xls/878628-variants-import-leads-to-blank-product-page#211122 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.3.15 I have about 380 products added so far - both main and variants. Main product #381 has a total of 175 variants. If I add the variants manually in the back-end then everything is OK. If I choose not to add the variants manually but rather import a CSV file then the front-end product #381 page is blank, i.e. when I load the product page nothing is displayed. If I delete about 2/3 of the imported variants then the front-end product page displays normally. Some additional info: I have about 50 custom product fields. Part of the fields are associated with some of the products, others are associated with other products. One thing I've noticed: When I add the variants manually, all the custom fields in the table hikashop_product that are not related to product #381 are NULL, i.e. the table is normalized in that part - I'm not database pro so I'm not quite sure about the right definition. If I import a CSV file these custom fields are just blank. Could that be the issue or something else? How do I import CSV in order to fill in NULL where necessary.")* Hi nicolas, The page is completely blank. You can see the attached screenshot (in fact the main product with problematic variants is #378). I've enabled Joomla Debug System = YES and Error Reporting = Development, but you can't even see the debug console on the bottom. Attached are two more files: 1. The CSV file I have imported the variants; 2. Part of the products export after that - you can see main product #378, two more and their variants. Here is a link to the website: [ ](http://filkab.solar/index.php/bg/hikashop-menu-for-products-listing/product/378-extended-warranty)[ filkab.solar/index.php/bg/hikashop-menu-...78-extended-warranty](http://filkab.solar/index.php/bg/hikashop-menu-for-products-listing/product/378-extended-warranty) Login: guest Password: guest Product #378 is the very last on my listing - it's called EXTENDED WARRANTY. Please let me know if you need anything else and I'll provide it ASAP. If you need admin rights I'll send you the credentials on a private message. - [ ![Main_product_378_blank_page.png](/forum/attachment/25902) ](/forum/attachment/25902 "...blank_page.png") [ ](/forum/attachment/25902?download=1 "...blank_page.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84Nzg2MjgtdmFyaWFudHMtaW1wb3J0LWxlYWRzLXRvLWJsYW5rLXByb2R1Y3QtcGFnZT90bXBsPW1hcmtkb3du) 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: 86541 - Thank you received: 14304 - - 11 years 3 months ago [\#211161](#211161) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Variants import leads to blank product page.](/forum/37-import-export-csv-xls/878628-variants-import-leads-to-blank-product-page#211161 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.3.15 I have about 380 products added so far - both main and variants. Main product #381 has a total of 175 variants. If I add the variants manually in the back-end then everything is OK. If I choose not to add the variants manually but rather import a CSV file then the front-end product #381 page is blank, i.e. when I load the product page nothing is displayed. If I delete about 2/3 of the imported variants then the front-end product page displays normally. Some additional info: I have about 50 custom product fields. Part of the fields are associated with some of the products, others are associated with other products. One thing I've noticed: When I add the variants manually, all the custom fields in the table hikashop_product that are not related to product #381 are NULL, i.e. the table is normalized in that part - I'm not database pro so I'm not quite sure about the right definition. If I import a CSV file these custom fields are just blank. Could that be the issue or something else? How do I import CSV in order to fill in NULL where necessary.")* Hi, You're missing a row for the main product in your CSV. It is necessary for the system to properly import the variant. It should be placed on a row before the variants in your CSV and the product_parent_id column of the variants should correspond to the product_code value of the main product. Then it should hopefully work correctly. Otherwise, it should be great to get the error message on the white page. If you don't see it with the debug mode activated, then it means that your web server is configured to force them to not display. In that case, the error messages should be logged in the PHP error log of your web server. So please search there for it. If you don't know where your PHP error log is, you might need to contact your system administrator or hosting company for help accessing it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84Nzg2MjgtdmFyaWFudHMtaW1wb3J0LWxlYWRzLXRvLWJsYW5rLXByb2R1Y3QtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile")** - [![ydingilski's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar37980.png)](/forum/user/37980-ydingilski "View ydingilski's Profile") Topic Author - [ Offline](/forum/user/37980-ydingilski) Less More - Posts: 52 - Thank you received: 0 - - - - [](http://www.filkab.solar) - 11 years 3 months ago [\#211164](#211164) by [ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile") Replied by *[ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile")* on topic *[Variants import leads to blank product page.](/forum/37-import-export-csv-xls/878628-variants-import-leads-to-blank-product-page#211164 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.3.15 I have about 380 products added so far - both main and variants. Main product #381 has a total of 175 variants. If I add the variants manually in the back-end then everything is OK. If I choose not to add the variants manually but rather import a CSV file then the front-end product #381 page is blank, i.e. when I load the product page nothing is displayed. If I delete about 2/3 of the imported variants then the front-end product page displays normally. Some additional info: I have about 50 custom product fields. Part of the fields are associated with some of the products, others are associated with other products. One thing I've noticed: When I add the variants manually, all the custom fields in the table hikashop_product that are not related to product #381 are NULL, i.e. the table is normalized in that part - I'm not database pro so I'm not quite sure about the right definition. If I import a CSV file these custom fields are just blank. Could that be the issue or something else? How do I import CSV in order to fill in NULL where necessary.")* I created the main product manually before importing the variants so that shouldn't be the problem. I'll check what's in the php log and post it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84Nzg2MjgtdmFyaWFudHMtaW1wb3J0LWxlYWRzLXRvLWJsYW5rLXByb2R1Y3QtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile")** - [![ydingilski's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar37980.png)](/forum/user/37980-ydingilski "View ydingilski's Profile") Topic Author - [ Offline](/forum/user/37980-ydingilski) Less More - Posts: 52 - Thank you received: 0 - - - - [](http://www.filkab.solar) - 11 years 3 months ago [\#211166](#211166) by [ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile") Replied by *[ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile")* on topic *[Variants import leads to blank product page.](/forum/37-import-export-csv-xls/878628-variants-import-leads-to-blank-product-page#211166 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.3.15 I have about 380 products added so far - both main and variants. Main product #381 has a total of 175 variants. If I add the variants manually in the back-end then everything is OK. If I choose not to add the variants manually but rather import a CSV file then the front-end product #381 page is blank, i.e. when I load the product page nothing is displayed. If I delete about 2/3 of the imported variants then the front-end product page displays normally. Some additional info: I have about 50 custom product fields. Part of the fields are associated with some of the products, others are associated with other products. One thing I've noticed: When I add the variants manually, all the custom fields in the table hikashop_product that are not related to product #381 are NULL, i.e. the table is normalized in that part - I'm not database pro so I'm not quite sure about the right definition. If I import a CSV file these custom fields are just blank. Could that be the issue or something else? How do I import CSV in order to fill in NULL where necessary.")* Here is the error from the *error\_log* file: [10-Aug-2015 12:48:18 UTC] PHP Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 655361 bytes) in /home/filkabso/public_html/components/com_hikashop/views/product/tmpl/show.php on line 299 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84Nzg2MjgtdmFyaWFudHMtaW1wb3J0LWxlYWRzLXRvLWJsYW5rLXByb2R1Y3QtcGFnZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile")** - [![ydingilski's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar37980.png)](/forum/user/37980-ydingilski "View ydingilski's Profile") Topic Author - [ Offline](/forum/user/37980-ydingilski) Less More - Posts: 52 - Thank you received: 0 - - - - [](http://www.filkab.solar) - 11 years 3 months ago [\#211170](#211170) by [ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile") Replied by *[ydingilski](/forum/user/37980-ydingilski "View ydingilski's Profile")* on topic *[Variants import leads to blank product page.](/forum/37-import-export-csv-xls/878628-variants-import-leads-to-blank-product-page#211170 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.3.15 I have about 380 products added so far - both main and variants. Main product #381 has a total of 175 variants. If I add the variants manually in the back-end then everything is OK. If I choose not to add the variants manually but rather import a CSV file then the front-end product #381 page is blank, i.e. when I load the product page nothing is displayed. If I delete about 2/3 of the imported variants then the front-end product page displays normally. Some additional info: I have about 50 custom product fields. Part of the fields are associated with some of the products, others are associated with other products. One thing I've noticed: When I add the variants manually, all the custom fields in the table hikashop_product that are not related to product #381 are NULL, i.e. the table is normalized in that part - I'm not database pro so I'm not quite sure about the right definition. If I import a CSV file these custom fields are just blank. Could that be the issue or something else? How do I import CSV in order to fill in NULL where necessary.")* The problem appeared to be low memory limit. I've increased it and now the page is correctly displayed ![:)](/media/kunena/emoticons/3.png ":)") ![:)](/media/kunena/emoticons/3.png ":)") ![:)](/media/kunena/emoticons/3.png ":)") Apparently 175 variants are a bit more than normal. PROBLEM SOLVED. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84Nzg2MjgtdmFyaWFudHMtaW1wb3J0LWxlYWRzLXRvLWJsYW5rLXByb2R1Y3QtcGFnZT90bXBsPW1hcmtkb3du) 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: 4079 - - [](http://obsi.dev) - 11 years 3 months ago [\#211173](#211173) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Variants import leads to blank product page.](/forum/37-import-export-csv-xls/878628-variants-import-leads-to-blank-product-page#211173 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : 5.3.15 I have about 380 products added so far - both main and variants. Main product #381 has a total of 175 variants. If I add the variants manually in the back-end then everything is OK. If I choose not to add the variants manually but rather import a CSV file then the front-end product #381 page is blank, i.e. when I load the product page nothing is displayed. If I delete about 2/3 of the imported variants then the front-end product page displays normally. Some additional info: I have about 50 custom product fields. Part of the fields are associated with some of the products, others are associated with other products. One thing I've noticed: When I add the variants manually, all the custom fields in the table hikashop_product that are not related to product #381 are NULL, i.e. the table is normalized in that part - I'm not database pro so I'm not quite sure about the right definition. If I import a CSV file these custom fields are just blank. Could that be the issue or something else? How do I import CSV in order to fill in NULL where necessary.")* Hi, Yes, 175 variants is becoming important ; generally it's around 10-20 variants. Because HikaShop needs to load all variants while displaying the page, it requires more memory than usual. If you have more than 50 variants you might need to see if custom fields or options are a better solution. And managing all these variants might not be easy in the backend. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84Nzg2MjgtdmFyaWFudHMtaW1wb3J0LWxlYWRzLXRvLWJsYW5rLXByb2R1Y3QtcGFnZT90bXBsPW1hcmtkb3du) 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.072 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)