[Skip to main content](#vessel-content) # When trying to import 400 products hikashop dies ## - **[linorabolini](/forum/user/6530-linorabolini "View linorabolini's Profile")** - [![linorabolini's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6530-linorabolini "View linorabolini's Profile") Topic Author - [ Offline](/forum/user/6530-linorabolini) Less More - Posts: 5 - Thank you received: 0 - - 14 years 8 months ago [\#42593](#42593) by [linorabolini](/forum/user/6530-linorabolini "View linorabolini's Profile") *[When trying to import 400 products hikashop dies](/forum/3-bug-report/42593-when-trying-to-import-400-products-hikashop-dies#42593 "Hi guys, I've sorted diversity of problems configuring hikashop but unfortunately I'm facing another one: I'm trying to import more than 400 products into hikashop and it consumes a lot of RAM and it breaks up. Just because of RAM or timeout. The problem is that I have more than 100.000 products to import, and I can't figure out a way to do it without hundreds of import cycles. If you guys know a solution , please let me know Thanks for your help")* was created by *[linorabolini](/forum/user/6530-linorabolini "View linorabolini's Profile")* Hi guys, I've sorted diversity of problems configuring hikashop but unfortunately I'm facing another one: I'm trying to import more than 400 products into hikashop and it consumes a lot of RAM and it breaks up. Just because of RAM or timeout. The problem is that I have more than 100.000 products to import, and I can't figure out a way to do it without hundreds of import cycles. If you guys know a solution , please let me know Thanks for your help Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MjU5My13aGVuLXRyeWluZy10by1pbXBvcnQtNDAwLXByb2R1Y3RzLWhpa2FzaG9wLWRpZXM/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: 86555 - Thank you received: 14304 - - 14 years 8 months ago [\#42729](#42729) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: When trying to import 400 products hikashop dies](/forum/3-bug-report/42593-when-trying-to-import-400-products-hikashop-dies#42729 "Hi guys, I've sorted diversity of problems configuring hikashop but unfortunately I'm facing another one: I'm trying to import more than 400 products into hikashop and it consumes a lot of RAM and it breaks up. Just because of RAM or timeout. The problem is that I have more than 100.000 products to import, and I can't figure out a way to do it without hundreds of import cycles. If you guys know a solution , please let me know Thanks for your help")* You could increase the max_execution_timeout and memory_limit options of your PHP temporarily in order to import all your products. If you can't do that on your online website, you can always do it on your local computer and export export/import the hikashop product/price/category... tables back on your online website. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MjU5My13aGVuLXRyeWluZy10by1pbXBvcnQtNDAwLXByb2R1Y3RzLWhpa2FzaG9wLWRpZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sharq](/forum/user/6679-sharq "View sharq's Profile")** - [![sharq's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6679-sharq "View sharq's Profile") - [ Offline](/forum/user/6679-sharq) Less More - Posts: 20 - Thank you received: 0 - - 14 years 7 months ago - 14 years 7 months ago [\#43313](#43313) by [sharq](/forum/user/6679-sharq "View sharq's Profile") Replied by *[sharq](/forum/user/6679-sharq "View sharq's Profile")* on topic *[Re: When trying to import 400 products hikashop dies](/forum/3-bug-report/42593-when-trying-to-import-400-products-hikashop-dies#43313 "Hi guys, I've sorted diversity of problems configuring hikashop but unfortunately I'm facing another one: I'm trying to import more than 400 products into hikashop and it consumes a lot of RAM and it breaks up. Just because of RAM or timeout. The problem is that I have more than 100.000 products to import, and I can't figure out a way to do it without hundreds of import cycles. If you guys know a solution , please let me know Thanks for your help")* My default memory limit in PHP is 128M. I changed it 1128M and tried to import the exported file from the demo site: Allowed memory size of 1.283.457.024 bytes exhausted (tried to allocate 261.904 bytes) in... More then 1 Gigabyte is not enough?? It's not a memory leak?? How can I import then? :SSS I dont have more space on localhost :OOO Is there any other solution? Thanks SQ Last edit: 14 years 7 months ago by [sharq](/forum/user/6679-sharq "View sharq's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MjU5My13aGVuLXRyeWluZy10by1pbXBvcnQtNDAwLXByb2R1Y3RzLWhpa2FzaG9wLWRpZXM/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: 86555 - Thank you received: 14304 - - 14 years 7 months ago [\#43482](#43482) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: When trying to import 400 products hikashop dies](/forum/3-bug-report/42593-when-trying-to-import-400-products-hikashop-dies#43482 "Hi guys, I've sorted diversity of problems configuring hikashop but unfortunately I'm facing another one: I'm trying to import more than 400 products into hikashop and it consumes a lot of RAM and it breaks up. Just because of RAM or timeout. The problem is that I have more than 100.000 products to import, and I can't figure out a way to do it without hundreds of import cycles. If you guys know a solution , please let me know Thanks for your help")* No, 128M should be more than enough. The problem must come from the CSV. The format must not be compatible with what HikaShop expects and thus it loops on something and eat up all the resources allocated. You should check your CSV against an exported CSV of HikaShop to make sure that the column names are correct and that the data is too. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MjU5My13aGVuLXRyeWluZy10by1pbXBvcnQtNDAwLXByb2R1Y3RzLWhpa2FzaG9wLWRpZXM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[sharq](/forum/user/6679-sharq "View sharq's Profile")** - [![sharq's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6679-sharq "View sharq's Profile") - [ Offline](/forum/user/6679-sharq) Less More - Posts: 20 - Thank you received: 0 - - 14 years 7 months ago - 14 years 3 months ago [\#43492](#43492) by [sharq](/forum/user/6679-sharq "View sharq's Profile") Replied by *[sharq](/forum/user/6679-sharq "View sharq's Profile")* on topic *[Re: When trying to import 400 products hikashop dies](/forum/3-bug-report/42593-when-trying-to-import-400-products-hikashop-dies#43492 "Hi guys, I've sorted diversity of problems configuring hikashop but unfortunately I'm facing another one: I'm trying to import more than 400 products into hikashop and it consumes a lot of RAM and it breaks up. Just because of RAM or timeout. The problem is that I have more than 100.000 products to import, and I can't figure out a way to do it without hundreds of import cycles. If you guys know a solution , please let me know Thanks for your help")* Thanks your answer, i will try soon! ![:)](/media/kunena/emoticons/3.png ":)") (Sorted.: There was syntax error in the code ![:)](/media/kunena/emoticons/3.png ":)")) Last edit: 14 years 3 months ago by [sharq](/forum/user/6679-sharq "View sharq's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MjU5My13aGVuLXRyeWluZy10by1pbXBvcnQtNDAwLXByb2R1Y3RzLWhpa2FzaG9wLWRpZXM/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.063 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)