[Skip to main content](#vessel-content) # Products not showing up after import ## - **[war relics](/forum/user/8166-war-relics "View war relics's Profile")** - [![war relics's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8166-war-relics "View war relics's Profile") Topic Author - [ Offline](/forum/user/8166-war-relics) Less More - Posts: 34 - Thank you received: 0 - - 4 years 9 months ago [\#338336](#338336) by [war relics](/forum/user/8166-war-relics "View war relics's Profile") *[Products not showing up after import](/forum/37-import-export-csv-xls/903757-products-not-showing-up-after-import#338336 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 3.10.4 -- PHP version -- : 8.0 Hi Team, after a import of an older Hikashop version, a lot of products are not showing up in the front-end of the webshop. Only when I open a product and hit the save button, then the product is showing up in the front of the webshop. I also tried to change the canonical URLs, but unfortunately without any success. I currently have more than 2500 products active, so checking it manually isn't really an option. Can you help me save these articles as a bulk action? Or do you have an PHP code that I can use within Products > Actions > Run PHP code ? Thanks!")* was created by *[war relics](/forum/user/8166-war-relics "View war relics's Profile")* -- HikaShop version -- : 4.4.5 -- Joomla version -- : 3.10.4 -- PHP version -- : 8.0 Hi Team, after a import of an older Hikashop version, a lot of products are not showing up in the front-end of the webshop. Only when I open a product and hit the save button, then the product is showing up in the front of the webshop. I also tried to change the canonical URLs, but unfortunately without any success. I currently have more than 2500 products active, so checking it manually isn't really an option. Can you help me save these articles as a bulk action? Or do you have an PHP code that I can use within Products > Actions > Run PHP code ? Thanks! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDM3NTctcHJvZHVjdHMtbm90LXNob3dpbmctdXAtYWZ0ZXItaW1wb3J0P3RtcGw9bWFya2Rvd24=) 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: 86320 - Thank you received: 14279 - - 4 years 9 months ago [\#338337](#338337) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Products not showing up after import](/forum/37-import-export-csv-xls/903757-products-not-showing-up-after-import#338337 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 3.10.4 -- PHP version -- : 8.0 Hi Team, after a import of an older Hikashop version, a lot of products are not showing up in the front-end of the webshop. Only when I open a product and hit the save button, then the product is showing up in the front of the webshop. I also tried to change the canonical URLs, but unfortunately without any success. I currently have more than 2500 products active, so checking it manually isn't really an option. Can you help me save these articles as a bulk action? Or do you have an PHP code that I can use within Products > Actions > Run PHP code ? Thanks!")* Hi, Well, a bulk action can be done with a mass action in System>Mass actions. But before doing that, we need to understand why the products are not being displayed on the frontend. For that, please check the hikashop_product table via your PHPMyAdmin and look at a product entry before and after you save it to see what is different. From what you're saying, there is a chance that the issue comes from the product_type column not having the correct value (which should be "main") and saving the product via the interface would force that value again. And in that case, a mass action with an action "update the values" on the column "product_type" with the "string" mode and the "main" text will solve the issue. But without checking the data in the database, it's hard to say if it's really that or not. The following user(s) said Thank You: [war relics](/forum/user/8166-war-relics "View war relics's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDM3NTctcHJvZHVjdHMtbm90LXNob3dpbmctdXAtYWZ0ZXItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[war relics](/forum/user/8166-war-relics "View war relics's Profile")** - [![war relics's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8166-war-relics "View war relics's Profile") Topic Author - [ Offline](/forum/user/8166-war-relics) Less More - Posts: 34 - Thank you received: 0 - - 4 years 9 months ago [\#338355](#338355) by [war relics](/forum/user/8166-war-relics "View war relics's Profile") Replied by *[war relics](/forum/user/8166-war-relics "View war relics's Profile")* on topic *[Products not showing up after import](/forum/37-import-export-csv-xls/903757-products-not-showing-up-after-import#338355 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 3.10.4 -- PHP version -- : 8.0 Hi Team, after a import of an older Hikashop version, a lot of products are not showing up in the front-end of the webshop. Only when I open a product and hit the save button, then the product is showing up in the front of the webshop. I also tried to change the canonical URLs, but unfortunately without any success. I currently have more than 2500 products active, so checking it manually isn't really an option. Can you help me save these articles as a bulk action? Or do you have an PHP code that I can use within Products > Actions > Run PHP code ? Thanks!")* Hi Nicolas, Thanks for your explanation. I have looked at the database and the column "product_type" was neatly filled with "main" (this also with the products that are not being displayed on the frontend). So to be sure I still did the Mass Action, but unfortunately this too was unsuccessful. Now I have compared the products in the database that are and are not visible in the frontend. And what is striking is that the products where a save action still has to be performed, lack the "product_alias". So is there a Mass Action that can be performed to fix this? Thanks! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDM3NTctcHJvZHVjdHMtbm90LXNob3dpbmctdXAtYWZ0ZXItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Philip](/forum/user/34318-philip "View Philip's Profile")** - [![Philip's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34318_2015-11-18-2.png)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 654 - - 4 years 9 months ago - 4 years 9 months ago [\#338361](#338361) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Products not showing up after import](/forum/37-import-export-csv-xls/903757-products-not-showing-up-after-import#338361 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 3.10.4 -- PHP version -- : 8.0 Hi Team, after a import of an older Hikashop version, a lot of products are not showing up in the front-end of the webshop. Only when I open a product and hit the save button, then the product is showing up in the front of the webshop. I also tried to change the canonical URLs, but unfortunately without any success. I currently have more than 2500 products active, so checking it manually isn't really an option. Can you help me save these articles as a bulk action? Or do you have an PHP code that I can use within Products > Actions > Run PHP code ? Thanks!")* Hello, Can you process this test in order to check an idea, for us your current issue **isn't linked to the product\_alias**, but in order to be sure : Try to fulfill a **product\_alias** in the **hikashop\_product** table (via your phpmyadmin) in a **non-worked product**, and process a new test. If your issue is still here, we will need to examinate a non-worked product datas, and so can you provide a products datas screenshot (always in your phpmyadmin). Awaiting your elements to progress on your issue. Regards Last edit: 4 years 9 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile"). The following user(s) said Thank You: [war relics](/forum/user/8166-war-relics "View war relics's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDM3NTctcHJvZHVjdHMtbm90LXNob3dpbmctdXAtYWZ0ZXItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[war relics](/forum/user/8166-war-relics "View war relics's Profile")** - [![war relics's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8166-war-relics "View war relics's Profile") Topic Author - [ Offline](/forum/user/8166-war-relics) Less More - Posts: 34 - Thank you received: 0 - - 4 years 9 months ago [\#338396](#338396) by [war relics](/forum/user/8166-war-relics "View war relics's Profile") Replied by *[war relics](/forum/user/8166-war-relics "View war relics's Profile")* on topic *[Products not showing up after import](/forum/37-import-export-csv-xls/903757-products-not-showing-up-after-import#338396 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 3.10.4 -- PHP version -- : 8.0 Hi Team, after a import of an older Hikashop version, a lot of products are not showing up in the front-end of the webshop. Only when I open a product and hit the save button, then the product is showing up in the front of the webshop. I also tried to change the canonical URLs, but unfortunately without any success. I currently have more than 2500 products active, so checking it manually isn't really an option. Can you help me save these articles as a bulk action? Or do you have an PHP code that I can use within Products > Actions > Run PHP code ? Thanks!")* Hi Philip, I just ran the test, adding the **product\_alias** directly in the database (via phpmyadmin) to a **non-worked product**. This has been successful! After adding a **product\_alias** to a **non-working product**, it is immediately visible in the frontend of the website, and works perfectly! So I still need something like a Mass Action to fix this problem. I've added a screenshot of the product details. This from a few even products. Thanks! Regards - [ ![002_2022-01-06.jpg](/forum/attachment/54132) ](/forum/attachment/54132 "...2022-01-06.jpg") [ ](/forum/attachment/54132?download=1 "...2022-01-06.jpg") - [ ![005.jpg](/forum/attachment/54133) ](/forum/attachment/54133 "005.jpg") [ ](/forum/attachment/54133?download=1 "005.jpg") - [ ![003_2022-01-06.jpg](/forum/attachment/54134) ](/forum/attachment/54134 "...2022-01-06.jpg") [ ](/forum/attachment/54134?download=1 "...2022-01-06.jpg") - [ ![004.jpg](/forum/attachment/54135) ](/forum/attachment/54135 "004.jpg") [ ](/forum/attachment/54135?download=1 "004.jpg") - [ ![001_2022-01-06.jpg](/forum/attachment/54136) ](/forum/attachment/54136 "...2022-01-06.jpg") [ ](/forum/attachment/54136?download=1 "...2022-01-06.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDM3NTctcHJvZHVjdHMtbm90LXNob3dpbmctdXAtYWZ0ZXItaW1wb3J0P3RtcGw9bWFya2Rvd24=) 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: 86320 - Thank you received: 14279 - - 4 years 9 months ago [\#338404](#338404) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Products not showing up after import](/forum/37-import-export-csv-xls/903757-products-not-showing-up-after-import#338404 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 3.10.4 -- PHP version -- : 8.0 Hi Team, after a import of an older Hikashop version, a lot of products are not showing up in the front-end of the webshop. Only when I open a product and hit the save button, then the product is showing up in the front of the webshop. I also tried to change the canonical URLs, but unfortunately without any success. I currently have more than 2500 products active, so checking it manually isn't really an option. Can you help me save these articles as a bulk action? Or do you have an PHP code that I can use within Products > Actions > Run PHP code ? Thanks!")* Hi, In that case, you can run a mass action with a filter on the product column "product_alias" = (empty input field), a second filter on "product_type" = "main", and an action "run PHP code" with the code: Code: $productClass = hikashop_get('class.product'); $product = $productClass->get({product_id}); $product->product_alias = $product->alias; unset($product->alias); $productClass->saveRaw($product); That will add the correct alias in each product. The following user(s) said Thank You: [war relics](/forum/user/8166-war-relics "View war relics's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDM3NTctcHJvZHVjdHMtbm90LXNob3dpbmctdXAtYWZ0ZXItaW1wb3J0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[war relics](/forum/user/8166-war-relics "View war relics's Profile")** - [![war relics's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8166-war-relics "View war relics's Profile") Topic Author - [ Offline](/forum/user/8166-war-relics) Less More - Posts: 34 - Thank you received: 0 - - 4 years 9 months ago [\#338417](#338417) by [war relics](/forum/user/8166-war-relics "View war relics's Profile") Replied by *[war relics](/forum/user/8166-war-relics "View war relics's Profile")* on topic *[Products not showing up after import](/forum/37-import-export-csv-xls/903757-products-not-showing-up-after-import#338417 "-- HikaShop version -- : 4.4.5 -- Joomla version -- : 3.10.4 -- PHP version -- : 8.0 Hi Team, after a import of an older Hikashop version, a lot of products are not showing up in the front-end of the webshop. Only when I open a product and hit the save button, then the product is showing up in the front of the webshop. I also tried to change the canonical URLs, but unfortunately without any success. I currently have more than 2500 products active, so checking it manually isn't really an option. Can you help me save these articles as a bulk action? Or do you have an PHP code that I can use within Products > Actions > Run PHP code ? Thanks!")* Hi Nicolas, Thanks for the help! The Mass Action with the php code did the job! :lol: The database table product_alias was nicely filled, and everything works like it should be. Thanks agian for all the help! Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy85MDM3NTctcHJvZHVjdHMtbm90LXNob3dpbmctdXAtYWZ0ZXItaW1wb3J0P3RtcGw9bWFya2Rvd24=) 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.134 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)