Title: Question about database collisions
Last modified: August 22, 2016

---

# Question about database collisions

 *  Resolved [MDesigner0](https://wordpress.org/support/users/mdesigner0/)
 * (@mdesigner0)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/question-about-database-collisions/)
 * I’m interested in buying the version that lets you reset order numbers, but I’m
   concerned about potential database field collisions. Is this an issue?
 * Let’s say I have some “dead” order IDs (Woocommerce stores orders as posts, if
   I’m not mistaken) hanging around the 3000’s. If I use this plugin to reset my
   order IDs to #1, wouldn’t this collide with abandoned carts in the 3000’s? How
   does this plugin avoid the order IDs being falsely associated with foreign keys
   in other tables?
 * [https://wordpress.org/plugins/woocommerce-sequential-order-numbers/](https://wordpress.org/plugins/woocommerce-sequential-order-numbers/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [SkyVerge](https://wordpress.org/support/users/skyverge/)
 * (@skyverge)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/question-about-database-collisions/#post-5293994)
 * No issues, as this plugin actually is fairly simple and doesn’t support reseting
   order numbers. It will simply take the highest existing order number and start
   from there.
 * Our premium, paid version, Sequential Order Numbers Pro: [http://www.woothemes.com/products/sequential-order-numbers-pro/](http://www.woothemes.com/products/sequential-order-numbers-pro/)
   offers a lot more control over the format of the order numbers, yet still doesn’t
   really allow for resetting (without deleting all previous orders).
 * Back when we developed these plugins it seemed logical that merchants would never
   want to reuse order numbers (seems like it would wreak havoc with accounting)
   but as we’ve gotten occasional requests for this over time, it may be something
   we look into for the premium plugin in the future.
 * Hope that made sense, and thanks for the question!
    Justin
 *  Thread Starter [MDesigner0](https://wordpress.org/support/users/mdesigner0/)
 * (@mdesigner0)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/question-about-database-collisions/#post-5293996)
 * Ah, gotcha. So to reset to order #1, it actually deletes all previous orders.
   That’s fine too. I assume it cleanly deletes all related order info in other 
   tables?
 *  Plugin Author [SkyVerge](https://wordpress.org/support/users/skyverge/)
 * (@skyverge)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/question-about-database-collisions/#post-5293999)
 * > Ah, gotcha. So to reset to order #1, it actually deletes all previous orders.
 * Pretty close, though the sequential order numbers plugins themselves do not ever
   delete an order, that would have to be done manually. You can imagine the outcry
   if the order numbers plugin were to delete a shop’s orders without the merchant
   fully understanding/expecting that behavior… bad scene.
 * Of course this could be somewhat tedious on a shop with a lot of orders, so this
   might actually make a decent how-to article with some code, or perhaps a small
   plugin to purge all orders in one fell swoop. Or maybe even a less drastic measure
   would be some way of “archiving” them.
 * Deleting all orders is definitely in the “with great power, comes great responsibility”
   category, and would require plenty of disclaimers, but thanks for the idea, we’ll
   consider it further!
 * Justin

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Question about database collisions’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce-sequential-order-numbers/assets/icon-256x256.
   png?rev=3472701)
 * [Sequential Order Numbers for WooCommerce](https://wordpress.org/plugins/woocommerce-sequential-order-numbers/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce-sequential-order-numbers/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce-sequential-order-numbers/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce-sequential-order-numbers/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce-sequential-order-numbers/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce-sequential-order-numbers/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [SkyVerge](https://wordpress.org/support/users/skyverge/)
 * Last activity: [11 years, 9 months ago](https://wordpress.org/support/topic/question-about-database-collisions/#post-5293999)
 * Status: resolved