Resetting the orders counter

eCommerce
1

Hi all, I’m migrating from development server to life server now and have to reset the orders counter. Can anyone give me a direction where and what to look for please?
Thank you
Stephan

2

There are some CLI commands that might be useful:
https://concrete5-community-store.github.io/community_store/developers/cli-commands.html

From memory though, these commands only delete the orders, not reset the count.
But that’s easy to do, once the CommunityStoreOrders table is empty, it’s a case of running the SQL command:

ALTER TABLE CommunityStoreOrders AUTO_INCREMENT = 1;

1 Like
3

Thx mesuva that worked fine and I can even ajust the order counter!
Brilliant!