[Skip to main content](#vessel-content) # Show the progress of the import of products. ## - **[Ronon](/forum/user/16953-ronon "View Ronon's Profile")** - [![Ronon's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-04-25.jpg)](/forum/user/16953-ronon "View Ronon's Profile") Topic Author - [ Offline](/forum/user/16953-ronon) Less More - Posts: 107 - Thank you received: 1 - - - - 12 years 9 months ago - 12 years 9 months ago [\#140874](#140874) by [Ronon](/forum/user/16953-ronon "View Ronon's Profile") *[Show the progress of the import of products.](/forum/37-import-export-csv-xls/865265-show-the-progress-of-the-import-of-products#140874 "-- url of the page with the problem -- : www.tengoqueprobarlo.com -- HikaShop version -- : 2.2.3 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.23 Hello, I currently have installed the virtual store on a VPS server. Do not know if it is the subject of Apache, PHP or what will be, if for example I have to upload (import) 4900 products with a CSV file, the process is done well , but when the product number 4899 , apparently the website is blocked arrives. The only way I can know if the products have been fully or not into the database is to enter PHP My Admin , empty tables " hikashop_price ", " hikashop_product " and " hikashop_product_category " before performing the import , then making the importation of data from HikaShop and occasionally be updated in view of the database in PHP My Admin, until you see the tables " hikashop_product " and " hikashop_product_category " that 4899 products have been introduced ( as the last curiously never entered) . So the problem causing me is that I have to disable the web in Joomla every time I want to update the products (so that users can not access the virtual store) , delete the tables in the database, import and reactivate the eShop. I wanted to know if it is possible to put a progress bar in HikaShop > Products > Import , it is not necessary to have to empty tables in the database every time I want to import products to know where the product will load .. . If not, I would not be forced to continue doing so, or calculate about 40 minutes to import everything and close the import window, praying that have been imported all the data ... Is it possible to add a progress bar to indicate what the status of the import? Do you know any way to configure Apache or PHP or whatever so that the load of 4000 products do not take but about 40 minutes less time? Thanks for your help, greetings.")* was created by *[Ronon](/forum/user/16953-ronon "View Ronon's Profile")* -- url of the page with the problem -- : [ www.tengoqueprobarlo.com](http://www.tengoqueprobarlo.com) -- HikaShop version -- : 2.2.3 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.23 Hello, I currently have installed the virtual store on a VPS server. Do not know if it is the subject of Apache, PHP or what will be, if for example I have to upload (import) 4900 products with a CSV file, the process is done well , but when the product number 4899 , apparently the website is blocked arrives. The only way I can know if the products have been fully or not into the database is to enter PHP My Admin , empty tables " hikashop_price ", " hikashop_product " and " hikashop_product_category " before performing the import , then making the importation of data from HikaShop and occasionally be updated in view of the database in PHP My Admin, until you see the tables " hikashop_product " and " hikashop_product_category " that 4899 products have been introduced ( as the last curiously never entered) . So the problem causing me is that I have to disable the web in Joomla every time I want to update the products (so that users can not access the virtual store) , delete the tables in the database, import and reactivate the eShop. I wanted to know if it is possible to put a progress bar in HikaShop > Products > Import , it is not necessary to have to empty tables in the database every time I want to import products to know where the product will load .. . If not, I would not be forced to continue doing so, or calculate about 40 minutes to import everything and close the import window, praying that have been imported all the data ... Is it possible to add a progress bar to indicate what the status of the import? Do you know any way to configure Apache or PHP or whatever so that the load of 4000 products do not take but about 40 minutes less time? Thanks for your help, greetings. Last edit: 12 years 9 months ago by [Ronon](/forum/user/16953-ronon "View Ronon's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjUyNjUtc2hvdy10aGUtcHJvZ3Jlc3Mtb2YtdGhlLWltcG9ydC1vZi1wcm9kdWN0cz90bXBsPW1hcmtkb3du) 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: 14276 - - 12 years 9 months ago [\#140902](#140902) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Show the progress of the import of products.](/forum/37-import-export-csv-xls/865265-show-the-progress-of-the-import-of-products#140902 "-- url of the page with the problem -- : www.tengoqueprobarlo.com -- HikaShop version -- : 2.2.3 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.23 Hello, I currently have installed the virtual store on a VPS server. Do not know if it is the subject of Apache, PHP or what will be, if for example I have to upload (import) 4900 products with a CSV file, the process is done well , but when the product number 4899 , apparently the website is blocked arrives. The only way I can know if the products have been fully or not into the database is to enter PHP My Admin , empty tables " hikashop_price ", " hikashop_product " and " hikashop_product_category " before performing the import , then making the importation of data from HikaShop and occasionally be updated in view of the database in PHP My Admin, until you see the tables " hikashop_product " and " hikashop_product_category " that 4899 products have been introduced ( as the last curiously never entered) . So the problem causing me is that I have to disable the web in Joomla every time I want to update the products (so that users can not access the virtual store) , delete the tables in the database, import and reactivate the eShop. I wanted to know if it is possible to put a progress bar in HikaShop > Products > Import , it is not necessary to have to empty tables in the database every time I want to import products to know where the product will load .. . If not, I would not be forced to continue doing so, or calculate about 40 minutes to import everything and close the import window, praying that have been imported all the data ... Is it possible to add a progress bar to indicate what the status of the import? Do you know any way to configure Apache or PHP or whatever so that the load of 4000 products do not take but about 40 minutes less time? Thanks for your help, greetings.")* Hi, Adding a progress bar is not possible easily. If the import takes 40 minutes, the issue is probably with your CSV which can probably be simplified. The more you remove in it the faster it will get. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjUyNjUtc2hvdy10aGUtcHJvZ3Jlc3Mtb2YtdGhlLWltcG9ydC1vZi1wcm9kdWN0cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Ronon](/forum/user/16953-ronon "View Ronon's Profile")** - [![Ronon's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-04-25.jpg)](/forum/user/16953-ronon "View Ronon's Profile") Topic Author - [ Offline](/forum/user/16953-ronon) Less More - Posts: 107 - Thank you received: 1 - - - - 12 years 9 months ago [\#140905](#140905) by [Ronon](/forum/user/16953-ronon "View Ronon's Profile") Replied by *[Ronon](/forum/user/16953-ronon "View Ronon's Profile")* on topic *[Show the progress of the import of products.](/forum/37-import-export-csv-xls/865265-show-the-progress-of-the-import-of-products#140905 "-- url of the page with the problem -- : www.tengoqueprobarlo.com -- HikaShop version -- : 2.2.3 -- Joomla version -- : 3.2.1 -- PHP version -- : 5.4.23 Hello, I currently have installed the virtual store on a VPS server. Do not know if it is the subject of Apache, PHP or what will be, if for example I have to upload (import) 4900 products with a CSV file, the process is done well , but when the product number 4899 , apparently the website is blocked arrives. The only way I can know if the products have been fully or not into the database is to enter PHP My Admin , empty tables " hikashop_price ", " hikashop_product " and " hikashop_product_category " before performing the import , then making the importation of data from HikaShop and occasionally be updated in view of the database in PHP My Admin, until you see the tables " hikashop_product " and " hikashop_product_category " that 4899 products have been introduced ( as the last curiously never entered) . So the problem causing me is that I have to disable the web in Joomla every time I want to update the products (so that users can not access the virtual store) , delete the tables in the database, import and reactivate the eShop. I wanted to know if it is possible to put a progress bar in HikaShop > Products > Import , it is not necessary to have to empty tables in the database every time I want to import products to know where the product will load .. . If not, I would not be forced to continue doing so, or calculate about 40 minutes to import everything and close the import window, praying that have been imported all the data ... Is it possible to add a progress bar to indicate what the status of the import? Do you know any way to configure Apache or PHP or whatever so that the load of 4000 products do not take but about 40 minutes less time? Thanks for your help, greetings.")* Okay, try to split the file into several pieces (eg 2,000 in 2,000 rows) to see if the website is not blocked and I can tell when I've finished uploading all the data. Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NjUyNjUtc2hvdy10aGUtcHJvZ3Jlc3Mtb2YtdGhlLWltcG9ydC1vZi1wcm9kdWN0cz90bXBsPW1hcmtkb3du) 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.049 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)