Knowledgebase
Home » Item #920
How do I increase the order number that CactuShop starts numbering from?
Question
My customer wants to start his store running from a higher order number otherwise it may look like the company has only handled a handful of orders. How do I get CactuShop to start order numbers at a higher value than 1?
Answer
This is not strictly a CactuShop issue, it applies to all database applications. The way to do this differs for Access and MS SQL.
In Access, you will need to open up the database and then open the tblCactuShop1Orders (v6) or tblCactuShopOrderNumbers (v5) table. Each time you copy and paste orders to the table, the database allocates an ID number to the record incrementally. If you post enough records and then delete them, the new records will still be given numbers higher than those records you deleted. You may need to do a lot of copying, pasting and deleting to reach the level you want.
This process will fragment the database and increase its size. Before compacting and repairing it, keep the highest one of the posted 'dummy records' - this will ensure the database remembers which point to keep allocating IDs from. Once you have some real orders in the site, you can delete the dummy record if you wish.
With MS SQL, the process is a lot easier. In the tblCactuShop1Orders (v6) or tblCactuShopOrderNumbers (v5) table (design view) just set the seed value for the ID field to the value you wish to number from - the default is 1.