[Skip to main content](#vessel-content) # Reset product ID to 0 ## - **[plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile")** - [![plantpotphil's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2189-plantpotphil "View plantpotphil's Profile") Topic Author - [ Offline](/forum/user/2189-plantpotphil) Less More - Posts: 152 - Thank you received: 0 - - - 15 years 2 months ago [\#24664](#24664) by [plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile") *[Reset product ID to 0](/forum/4-how-to/24664-reset-product-id-to-0#24664 "Hi, Is it possible to reset the product ID to start at zero again? I assume this would need to be reset in the database? Thanks for any tips! Phil")* was created by *[plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile")* Hi, Is it possible to reset the product ID to start at zero again? I assume this would need to be reset in the database? Thanks for any tips! Phil --- Create your own style of luxury [ bespoke furniture](http://www.clothierjones.com) online Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI0NjY0LXJlc2V0LXByb2R1Y3QtaWQtdG8tMD90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14284 - - 15 years 2 months ago - 14 years 8 months ago [\#24671](#24671) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Reset product ID to 0](/forum/4-how-to/24664-reset-product-id-to-0#24671 "Hi, Is it possible to reset the product ID to start at zero again? I assume this would need to be reset in the database? Thanks for any tips! Phil")* Hi, Indeed. First, you should delete all your products in HikaShop. Then, in your phpmyadmin, you can edit the table hikashop_product table and "truncate" it. That will reset the auto increment value to 0. Last edit: 14 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI0NjY0LXJlc2V0LXByb2R1Y3QtaWQtdG8tMD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile")** - [![plantpotphil's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2189-plantpotphil "View plantpotphil's Profile") Topic Author - [ Offline](/forum/user/2189-plantpotphil) Less More - Posts: 152 - Thank you received: 0 - - - 15 years 2 months ago [\#24674](#24674) by [plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile") Replied by *[plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile")* on topic *[Re: Reset product ID to 0](/forum/4-how-to/24664-reset-product-id-to-0#24674 "Hi, Is it possible to reset the product ID to start at zero again? I assume this would need to be reset in the database? Thanks for any tips! Phil")* Thanks Nicolas --- Create your own style of luxury [ bespoke furniture](http://www.clothierjones.com) online Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI0NjY0LXJlc2V0LXByb2R1Y3QtaWQtdG8tMD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile")** - [![plantpotphil's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2189-plantpotphil "View plantpotphil's Profile") Topic Author - [ Offline](/forum/user/2189-plantpotphil) Less More - Posts: 152 - Thank you received: 0 - - - 14 years 8 months ago [\#40819](#40819) by [plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile") Replied by *[plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile")* on topic *[Re: Reset product ID to 0](/forum/4-how-to/24664-reset-product-id-to-0#40819 "Hi, Is it possible to reset the product ID to start at zero again? I assume this would need to be reset in the database? Thanks for any tips! Phil")* Hi Nicolas, Just trying this and i can't see hikashop_table anywhere in phpmyadmin? Has this changed? Thanks, Phil --- Create your own style of luxury [ bespoke furniture](http://www.clothierjones.com) online Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI0NjY0LXJlc2V0LXByb2R1Y3QtaWQtdG8tMD90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14284 - - 14 years 8 months ago - 14 years 8 months ago [\#41027](#41027) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Reset product ID to 0](/forum/4-how-to/24664-reset-product-id-to-0#41027 "Hi, Is it possible to reset the product ID to start at zero again? I assume this would need to be reset in the database? Thanks for any tips! Phil")* It's the table hikashop_product. Sorry for the typo. Last edit: 14 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI0NjY0LXJlc2V0LXByb2R1Y3QtaWQtdG8tMD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile")** - [![plantpotphil's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2189-plantpotphil "View plantpotphil's Profile") Topic Author - [ Offline](/forum/user/2189-plantpotphil) Less More - Posts: 152 - Thank you received: 0 - - - 14 years 8 months ago [\#41213](#41213) by [plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile") Replied by *[plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile")* on topic *[Re: Reset product ID to 0](/forum/4-how-to/24664-reset-product-id-to-0#41213 "Hi, Is it possible to reset the product ID to start at zero again? I assume this would need to be reset in the database? Thanks for any tips! Phil")* Hi Nicolas, Just tried this and new products still continue to increment their product ID from the original number. Any ideas? Phil --- Create your own style of luxury [ bespoke furniture](http://www.clothierjones.com) online Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI0NjY0LXJlc2V0LXByb2R1Y3QtaWQtdG8tMD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile")** - [![plantpotphil's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2189-plantpotphil "View plantpotphil's Profile") Topic Author - [ Offline](/forum/user/2189-plantpotphil) Less More - Posts: 152 - Thank you received: 0 - - - 14 years 8 months ago [\#41215](#41215) by [plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile") Replied by *[plantpotphil](/forum/user/2189-plantpotphil "View plantpotphil's Profile")* on topic *[Re: Reset product ID to 0](/forum/4-how-to/24664-reset-product-id-to-0#41215 "Hi, Is it possible to reset the product ID to start at zero again? I assume this would need to be reset in the database? Thanks for any tips! Phil")* Sorry ignore my last comment, got it working now! --- Create your own style of luxury [ bespoke furniture](http://www.clothierjones.com) online Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI0NjY0LXJlc2V0LXByb2R1Y3QtaWQtdG8tMD90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[rusil](/forum/user/9563-rusil "View rusil's Profile")** - [![rusil's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9563-rusil "View rusil's Profile") - [ Offline](/forum/user/9563-rusil) Less More - Posts: 14 - Thank you received: 0 - - 14 years 4 weeks ago [\#68845](#68845) by [rusil](/forum/user/9563-rusil "View rusil's Profile") Replied by *[rusil](/forum/user/9563-rusil "View rusil's Profile")* on topic *[Re: Reset product ID to 0](/forum/4-how-to/24664-reset-product-id-to-0#68845 "Hi, Is it possible to reset the product ID to start at zero again? I assume this would need to be reset in the database? Thanks for any tips! Phil")* not to start a new topic i'll just ask my question here If i need to delete all the products from hikashop through phpmyadmin is it enough just to clean hikashop_product table or do i need to clean any other tables? Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI0NjY0LXJlc2V0LXByb2R1Y3QtaWQtdG8tMD90bXBsPW1hcmtkb3du) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14284 - - 14 years 4 weeks ago [\#68956](#68956) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Reset product ID to 0](/forum/4-how-to/24664-reset-product-id-to-0#68956 "Hi, Is it possible to reset the product ID to start at zero again? I assume this would need to be reset in the database? Thanks for any tips! Phil")* You should also clean the product_category, product_related, variant, and price tables. The file table would have to be deleted for the images but it also contains the images of the categories so you might not want to clear it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzI0NjY0LXJlc2V0LXByb2R1Y3QtaWQtdG8tMD90bXBsPW1hcmtkb3du) 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.073 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)