Skip to main content

Reset Shop information

More
6 years 2 months ago #322774 by srtdesigns
-- HikaShop version -- : 4.3.0
-- Joomla version -- : 3.9.20
-- PHP version -- : 7.3.20

I have finished testing my hikashop so I would like to reset / clear all test orders etc. before going live. Could you please advise me if there is a routine to follow or script. Many thanks.

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

More
6 years 1 month ago #322786 by nicolas
Replied by nicolas on topic Reset Shop information
Hi,

Well, you can just empty the tables you want to reset in your database via phpmyadmin.
What table to empty will depend on what you mean by "etc" but it's basically among the tables prefixed with "hikashop_"

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

More
6 years 1 month ago #322802 by srtdesigns
Replied by srtdesigns on topic Reset Shop information

nicolas wrote: Hi,

Well, you can just empty the tables you want to reset in your database via phpmyadmin.
What table to empty will depend on what you mean by "etc" but it's basically among the tables prefixed with "hikashop_"


Thank you for the reply. I have had a look at phpmyadmin. The ones I believe need to be emptied are:
hikashop_cart, cart_product, email_log, history, order, order_status, order_product.

Do I go to each one, check all and delete or is there more to it?

Many thanks.

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

More
6 years 1 month ago #322806 by nicolas
Replied by nicolas on topic Reset Shop information
Hi,

You want to keep order_status. For the others you can empty them yes.
You can empty the tables with one click. You don't need to select the elements in the table and delete them.
wordpress.org/support/article/emptying-a-database-table/
www.hostknox.com/knowledgebase/292/How-t...with-phpMyAdmin.html
The following user(s) said Thank You: srtdesigns

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

More
6 years 1 month ago #322838 by srtdesigns
Replied by srtdesigns on topic Reset Shop information

nicolas wrote: Hi,

You want to keep order_status. For the others you can empty them yes.
You can empty the tables with one click. You don't need to select the elements in the table and delete them.
wordpress.org/support/article/emptying-a-database-table/
www.hostknox.com/knowledgebase/292/How-t...with-phpMyAdmin.html


Perfect, many thanks for your advise.

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

Time to create page: 0.202 seconds
Powered by Kunena Forum