Go to Bottom

Set the Next Order Number

In this Topic: Show


The Order Manager assigns a unique Order Number to every order, including orders imported from a shopping cart, manually entered orders and point-of-sale orders. (This is in addition to the "Web order number" that is assigned by shopping carts to Web orders.) Normally, the Order Manager give the first order Order Number 1, then assigns 2, 3, etc. as orders are added to the system.

You should never change those order numbers manually, since they are used in numerous tables to tie information together.


If you want to reset the next order number to a new higher number, here's what you should do:

  1. Back up your data file in case you make a mistake!

  2. Go to the Order Manager's Main Menu.

  3. Press the F11 Function Key on your keyboard to open the "database window".

  4. Microsoft Access has buttons down the left-hand side of the window. Click the tab or button labeled "Tables".

  5. Locate the Orders table. You may have to scroll left or right in the window to see it.

  6. Select the Orders table and click the Open button.

  7. Scroll to the bottom of the table. On the blank line at the bottom of the table, click in the Order Number column (usually the first column) and enter a new order number. If you want your next order to be order number 2001, enter the number 2000. This creates a "dummy" order with that order number.

  8. Close the table.

  9. Minimize the database window to return to the Main Menu.


The next order that you import or enter manually will be given an order number 1 higher than the number you entered in step #7.


After you have entered or imported some orders, you should delete the "dummy" order:

  1. Repeat steps 1 thru 6 in the list above.

  2. Locate the "dummy" order.

  3. Click the small gray rectangle to the left of the order to select the order.

  4. Press the Delete key on your keyboard to delete the order.

  5. Close the table.

  6. Minimize the database window to return to the Main Menu.



Created: 1/17/12

Go to Top