[Skip to main content](#vessel-content) # How to switch to Production environement ? ## - **[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")** - [![codewarrior's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4710-codewarrior "View codewarrior's Profile") Topic Author - [ Offline](/forum/user/4710-codewarrior) Less More - Posts: 190 - Thank you received: 0 - - 14 years 6 months ago [\#46334](#46334) by [codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile") *[How to switch to Production environement ?](/forum/2-general-talk-about-hikashop/46334-how-to-switch-to-production-environement#46334 "Hi, my project is quite ready and tested, and I would like to go in Production. If I copy my site from Dev to Prod (with Akeeba) I will have : - Products ID not starting at 0 - Commands ID deleted... ... and so on Is there a way to clear Products and Commands in database, not loosing global configurations ? Or do I need to completely remove HikaShop and re-install / re-configure it ? Thanks for your answer. Regards")* was created by *[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")* Hi, my project is quite ready and tested, and I would like to go in Production. If I copy my site from Dev to Prod (with Akeeba) I will have : - Products ID not starting at 0 - Commands ID deleted... ... and so on Is there a way to clear Products and Commands in database, not loosing global configurations ? Or do I need to completely remove HikaShop and re-install / re-configure it ? Thanks for your answer. Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ2MzM0LWhvdy10by1zd2l0Y2gtdG8tcHJvZHVjdGlvbi1lbnZpcm9uZW1lbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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: 86322 - Thank you received: 14281 - - 14 years 6 months ago [\#46449](#46449) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: How to switch to Production environement ?](/forum/2-general-talk-about-hikashop/46334-how-to-switch-to-production-environement#46449 "Hi, my project is quite ready and tested, and I would like to go in Production. If I copy my site from Dev to Prod (with Akeeba) I will have : - Products ID not starting at 0 - Commands ID deleted... ... and so on Is there a way to clear Products and Commands in database, not loosing global configurations ? Or do I need to completely remove HikaShop and re-install / re-configure it ? Thanks for your answer. Regards")* In phpmyadmin, you should flush the tables hikashop_variant hikashop_product hikashop_product_category hikashop_order hikashop_order_product hikashop_product_related hikashop_price hikashop_file and that will reset all the data for products and orders. The following user(s) said Thank You: [codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ2MzM0LWhvdy10by1zd2l0Y2gtdG8tcHJvZHVjdGlvbi1lbnZpcm9uZW1lbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")** - [![codewarrior's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4710-codewarrior "View codewarrior's Profile") Topic Author - [ Offline](/forum/user/4710-codewarrior) Less More - Posts: 190 - Thank you received: 0 - - 14 years 6 months ago [\#46856](#46856) by [codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile") Replied by *[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")* on topic *[Re: How to switch to Production environement ?](/forum/2-general-talk-about-hikashop/46334-how-to-switch-to-production-environement#46856 "Hi, my project is quite ready and tested, and I would like to go in Production. If I copy my site from Dev to Prod (with Akeeba) I will have : - Products ID not starting at 0 - Commands ID deleted... ... and so on Is there a way to clear Products and Commands in database, not loosing global configurations ? Or do I need to completely remove HikaShop and re-install / re-configure it ? Thanks for your answer. Regards")* Thanks Nicolas, it's perfect with a TRUNCATE TABLE on these tables. Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQ2MzM0LWhvdy10by1zd2l0Y2gtdG8tcHJvZHVjdGlvbi1lbnZpcm9uZW1lbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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.123 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)