Whenever a record is written to the database, for example when you add a product or an order is taken, a unique transaction ID is recorded which automatically increments by one as each new record is added.


This program gives you the ability to set the next usable ID at a higher start value.


This is useful if you have changed from another e-commerce program as you can continue your previous order numbering from without any duplication and ensure good auditability. This is also recommended because your payment processor may detect you have already used a transaction ID previously and therefore stops you posting the same transaction number twice, effectively rejecting the new transaction from this system.


WARNING! DO NOT SET THE AUTO INCREMENT ID TO A NUMBER BELOW THE ONES YOU HAVE ALREADY USED IN THIS SYSTEM AS IT WILL CAUSE ERRORS.

 

Step 1: Select the table to apply this to from:

  • Orders
  • Products
  • Invoice Number 

Step 2: Set new auto inc id value.