Set the Next Order Number

Overview

• Stone Edge assigns a unique Order Number to every order, including:
  • Imported from a shopping cart
  • Manually entered orders
  • Point-of-sale orders
• By Default, Stone Edge gives the first order: Order Number 1001 -> number increments by one as orders are added.
• You should never change Order Numbers manually
  • Numbers are used in numerous tables to tie information together
  • Changing numbers can lead to errors or data corruption
• Follow the steps to reset the order number to a HIGHER number
  • Do NOT choose a lower number, as it is probably already used and will create data conflicts
  • Highly recommended to back up the store database beforehand
    • Backup MS Access Data File – Stone Edge Order Manager
    • Backing up SQL Server – Stone Edge Order Manager

Creating a Dummy Order

1. Start at the Main Menu.
2. Press F11 -> left-hand “Navigation Page” opens.
3. At the top of the navigation page, search for the Orders table.
   Note: The search bar may need to be enabled by right-clicking the down arrow at the top of the navigation page.
   
4. Open the “Orders” table (double-click)
5. Scroll to the bottom of the table
6. Select a cell in the “OrderNumber” column in the last empty row
   
7. Create Dummy Order
   1. Ordernumber (usually first column) -> Enter number one before number orders should start with
      ex. Choose 2000 if you want to start with order #2001.
      
8. Close table
   NOTE: if asked to save changes to the design of the table, click “No”
9. Import or create a manual order. It will start with the new order number
10. Click < to the right of the “Navigation Page” title to close the list
    NOTE: Will not be shown when reopening Stone Edge

Deleting the Dummy Order

1. At the Main Menu > Press F11 > on the left-hand side, the  “Navigation Page” opens.
2. Search “Orders”
   NOTE: The search bar may need to be enabled by right-clicking the down arrow at the top (See screenshot above for reference).
3. Open the “Orders” table (double-click).
4. Find the dummy order you created in the table OR search for it.
   1. Click a number in the “OrderNumber” column
   2. Number Filters -> Equals…
   3. Enter the dummy order number.
5. Highlight the row of information with the dummy order.
   
6. Delete Order (pick one of the following).
   1. Click CTRL + [ – ]
   2. Click [DELETE]
   3. Right-click “Delete Record.”
7. A pop-up for confirmation of deletion will appear.
   
8. Click “Yes”
9. Close the table.
   NOTE: if asked to save changes to the design of the table, click “No.”
10. Click < to the right of the “Navigation Page” title to close the list.
    NOTE: Will not be shown when reopening Stone Edge.