Skip to main content

Reset product ID to 0

More
15 years 1 month ago #24664 by plantpotphil
Reset product ID to 0 was created by plantpotphil
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 online

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago - 14 years 7 months ago #24671 by nicolas
Replied by nicolas on topic Re: Reset product ID to 0
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 7 months ago by nicolas.

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #24674 by plantpotphil
Replied by plantpotphil on topic Re: Reset product ID to 0
Thanks Nicolas
Create your own style of luxury bespoke furniture online

Please Log in or Create an account to join the conversation.

More
14 years 7 months ago #40819 by plantpotphil
Replied by plantpotphil on topic Re: Reset product ID to 0
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 online

Please Log in or Create an account to join the conversation.

More
14 years 7 months ago - 14 years 7 months ago #41027 by nicolas
Replied by nicolas on topic Re: Reset product ID to 0
It's the table hikashop_product. Sorry for the typo.
Last edit: 14 years 7 months ago by nicolas.

Please Log in or Create an account to join the conversation.

More
14 years 7 months ago #41213 by plantpotphil
Replied by plantpotphil on topic Re: Reset product ID to 0
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 online

Please Log in or Create an account to join the conversation.

More
14 years 7 months ago #41215 by plantpotphil
Replied by plantpotphil on topic Re: Reset product ID to 0
Sorry ignore my last comment, got it working now!
Create your own style of luxury bespoke furniture online

Please Log in or Create an account to join the conversation.

More
14 years 3 days ago #68845 by rusil
Replied by rusil on topic Re: Reset product ID to 0
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 or Create an account to join the conversation.

More
14 years 2 days ago #68956 by nicolas
Replied by nicolas on topic Re: Reset product ID to 0
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 or Create an account to join the conversation.

Time to create page: 0.207 seconds
Powered by Kunena Forum