{"id":127,"date":"2023-03-17T11:31:27","date_gmt":"2023-03-17T11:31:27","guid":{"rendered":"https:\/\/stoneedge.com\/kb\/?post_type=ht_kb&#038;p=127"},"modified":"2025-06-09T13:56:52","modified_gmt":"2025-06-09T13:56:52","slug":"set-the-next-order-number","status":"publish","type":"ht_kb","link":"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/","title":{"rendered":"Set the Next Order Number"},"content":{"rendered":"<h2>Overview<\/h2>\n<ul>\n<li>Stone Edge assigns a unique Order Number to every order, including:\n<ul>\n<li>Imported from a shopping cart<\/li>\n<li>Manually entered orders<\/li>\n<li>Point-of-sale orders<\/li>\n<\/ul>\n<\/li>\n<li>By Default, Stone Edge gives the first order: Order Number 1001 -&gt; number increments by one as orders are added.<\/li>\n<li>You should never change Order Numbers manually\n<ul>\n<li>Numbers are used in numerous tables to tie information together<\/li>\n<li>Changing numbers can lead to errors or data corruption<\/li>\n<\/ul>\n<\/li>\n<li>Follow the steps to reset the order number to a HIGHER number\n<ul>\n<li>Do NOT choose a lower number, as it is probably already used and will create data conflicts<\/li>\n<li>Highly recommended to back up the store database beforehand\n<ul>\n<li><a href=\"https:\/\/stoneedge.com\/kb\/articles\/backup-ms-access-data-file\/\">Backup MS Access Data File &#8211; Stone Edge Order Manager<\/a><\/li>\n<li><a href=\"https:\/\/stoneedge.com\/kb\/articles\/backing-up-sql-server\/\">Backing up SQL Server &#8211; Stone Edge Order Manager<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>Creating a Dummy Order<\/h2>\n<ol>\n<li>Start at the Main Menu.<\/li>\n<li>Press F11 -&gt; left-hand \u201cNavigation Page\u201d opens.<\/li>\n<li>At the top of the navigation page, search for the Orders table.<br \/>\n<strong>Note:<\/strong> The search bar may need to be enabled by right-clicking the down arrow at the top of the navigation page.<br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3038\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Navigation_Page_Access.png\" alt=\"\" width=\"497\" height=\"241\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Navigation_Page_Access.png 497w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Navigation_Page_Access-300x145.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Navigation_Page_Access-50x24.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Navigation_Page_Access-60x29.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Navigation_Page_Access-100x48.png 100w\" sizes=\"(max-width: 497px) 100vw, 497px\" \/><\/li>\n<li>Open the \u201cOrders\u201d table (double-click)<\/li>\n<li>Scroll to the bottom of the table<\/li>\n<li>Select a cell in the \u201cOrderNumber\u201d column in the last empty row<br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3039\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table.png\" alt=\"\" width=\"2149\" height=\"881\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table.png 2149w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table-300x123.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table-1024x420.png 1024w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table-768x315.png 768w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table-50x20.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table-1536x630.png 1536w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table-2048x840.png 2048w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table-60x25.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table-100x41.png 100w\" sizes=\"(max-width: 2149px) 100vw, 2149px\" \/><\/li>\n<li>Create Dummy Order\n<ol>\n<li>Ordernumber (usually first column) -&gt; Enter number one before number orders should start with<br \/>\n<strong>ex.<\/strong> Choose 2000 if you want to start with order #2001.<br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3040\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Column_Names.png\" alt=\"\" width=\"2129\" height=\"1218\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Column_Names.png 2129w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Column_Names-300x172.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Column_Names-1024x586.png 1024w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Column_Names-768x439.png 768w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Column_Names-50x29.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Column_Names-1536x879.png 1536w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Column_Names-2048x1172.png 2048w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Column_Names-60x34.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Column_Names-100x57.png 100w\" sizes=\"(max-width: 2129px) 100vw, 2129px\" \/><\/li>\n<\/ol>\n<\/li>\n<li>Close table<br \/>\n<strong>NOTE<\/strong>: if asked to save changes to the design of the table, click \u201cNo\u201d<\/li>\n<li>Import or create a manual order. It will start with the new order number<\/li>\n<li>Click &lt; to the right of the \u201cNavigation Page\u201d title to close the list<br \/>\n<strong>NOTE<\/strong>: Will not be shown when reopening Stone Edge<\/li>\n<\/ol>\n<h2>Deleting the Dummy Order<\/h2>\n<ol>\n<li>At the Main Menu &gt; Press F11 &gt; on the left-hand side, the\u00a0 \u201cNavigation Page\u201d opens.<\/li>\n<li>Search \u201cOrders\u201d<br \/>\n<strong>NOTE<\/strong>: The search bar may need to be enabled by right-clicking the down arrow at the top (See screenshot above for reference).<\/li>\n<li>Open the \u201cOrders\u201d table (double-click).<\/li>\n<li>Find the dummy order you created in the table OR search for it.\n<ol>\n<li>Click a number in the \u201cOrderNumber\u201d column<\/li>\n<li>Number Filters -&gt; Equals\u2026<\/li>\n<li>Enter the dummy order number.<\/li>\n<\/ol>\n<\/li>\n<li>Highlight the row of information with the dummy order.<br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3041\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Deleting_an_Order.png\" alt=\"\" width=\"2119\" height=\"984\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Deleting_an_Order.png 2119w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Deleting_an_Order-300x139.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Deleting_an_Order-1024x476.png 1024w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Deleting_an_Order-768x357.png 768w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Deleting_an_Order-50x23.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Deleting_an_Order-1536x713.png 1536w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Deleting_an_Order-2048x951.png 2048w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Deleting_an_Order-60x28.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Orders_Table_Deleting_an_Order-100x46.png 100w\" sizes=\"(max-width: 2119px) 100vw, 2119px\" \/><\/li>\n<li>Delete Order (pick one of the following).\n<ol>\n<li>Click CTRL + [ &#8211; ]<\/li>\n<li>Click [DELETE]<\/li>\n<li>Right-click \u201cDelete Record.\u201d<\/li>\n<\/ol>\n<\/li>\n<li>A pop-up for confirmation of deletion will appear.<br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-3710 size-full\" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2023\/03\/0033.png\" alt=\"\" width=\"408\" height=\"129\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2023\/03\/0033.png 408w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2023\/03\/0033-300x95.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2023\/03\/0033-50x16.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2023\/03\/0033-60x19.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2023\/03\/0033-100x32.png 100w\" sizes=\"(max-width: 408px) 100vw, 408px\" \/><\/li>\n<li>Click \u201cYes\u201d<\/li>\n<li>Close the table.<br \/>\n<strong>NOTE<\/strong>: if asked to save changes to the design of the table, click \u201cNo.\u201d<\/li>\n<li>Click &lt; to the right of the \u201cNavigation Page\u201d title to close the list.<br \/>\n<strong>NOTE:<\/strong> Will not be shown when reopening Stone Edge.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>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 -&gt; number increments by one as orders are added. You should never change Order Numbers manually Numbers&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[22],"ht-kb-tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Set the Next Order Number - Stone Edge Order Manager<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Set the Next Order Number - Stone Edge Order Manager\" \/>\n<meta property=\"og:description\" content=\"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 -&gt; number increments by one as orders are added. You should never change Order Numbers manually Numbers...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/\" \/>\n<meta property=\"og:site_name\" content=\"Stone Edge Order Manager\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-09T13:56:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Navigation_Page_Access.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/\",\"url\":\"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/\",\"name\":\"Set the Next Order Number - Stone Edge Order Manager\",\"isPartOf\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\"},\"datePublished\":\"2023-03-17T11:31:27+00:00\",\"dateModified\":\"2025-06-09T13:56:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/stoneedge.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Set the Next Order Number\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\",\"url\":\"https:\/\/stoneedge.com\/kb\/\",\"name\":\"Stone Edge Order Manager\",\"description\":\"Documentation for the Stone Edge Order Manager\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/stoneedge.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Set the Next Order Number - Stone Edge Order Manager","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/","og_locale":"en_US","og_type":"article","og_title":"Set the Next Order Number - Stone Edge Order Manager","og_description":"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 -&gt; number increments by one as orders are added. You should never change Order Numbers manually Numbers...","og_url":"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/","og_site_name":"Stone Edge Order Manager","article_modified_time":"2025-06-09T13:56:52+00:00","og_image":[{"url":"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Navigation_Page_Access.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/","url":"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/","name":"Set the Next Order Number - Stone Edge Order Manager","isPartOf":{"@id":"https:\/\/stoneedge.com\/kb\/#website"},"datePublished":"2023-03-17T11:31:27+00:00","dateModified":"2025-06-09T13:56:52+00:00","breadcrumb":{"@id":"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/stoneedge.com\/kb\/articles\/set-the-next-order-number\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/stoneedge.com\/kb\/"},{"@type":"ListItem","position":2,"name":"Set the Next Order Number"}]},{"@type":"WebSite","@id":"https:\/\/stoneedge.com\/kb\/#website","url":"https:\/\/stoneedge.com\/kb\/","name":"Stone Edge Order Manager","description":"Documentation for the Stone Edge Order Manager","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/stoneedge.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/127"}],"collection":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/comments?post=127"}],"version-history":[{"count":7,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/127\/revisions"}],"predecessor-version":[{"id":3712,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/127\/revisions\/3712"}],"wp:attachment":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/media?parent=127"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=127"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}