Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2007
    Posts
    94
    Plugin Contributions
    0

    Default Change the starting "Order Number" Prior to Launch

    ... Title pretty much sums this one up. I want to change the beginning order number so that my customer doesn't get something like "Congratulations, you are Order #1!"

    I'd rather select my own number, such as "0501" or something.

    Anyone know how to do this? Thanks!!!

    Alex

  2. #2
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default Re: Change the starting "Order Number" Prior to Launch

    You will have to mess with mysql database.
    Run this query:
    Code:
    ALTER TABLE tbl AUTO_INCREMENT = 51;
    Where tb1 is the name of the order table (I cant remember its name)
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  3. #3
    Join Date
    Aug 2007
    Posts
    94
    Plugin Contributions
    0

    Default Re: Change the starting "Order Number" Prior to Launch

    Thanks!

  4. #4
    Join Date
    Apr 2009
    Posts
    2
    Plugin Contributions
    0

    Default Re: Change the starting "Order Number" Prior to Launch

    Can someone explain to a non-techie how to do this?

    I had a webdesigner set this up for me and I am now left on my own.

    Is there a web-based solution to this issue, or do I have to buy some kind of software?

    I don't even know where this "database" is stored. With my host?

    ZP
    Last edited by zipperplug; 9 Apr 2009 at 04:47 PM.

  5. #5
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,021
    Plugin Contributions
    3

    Default Re: Change the starting "Order Number" Prior to Launch

    It's easier now. Check Admin - Tools - Store Manager

    And yes, your database is stored on your hosting account.

 

 

Similar Threads

  1. how to change "Price starting at"?
    By tparvaiz in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 14 Aug 2011, 06:25 PM
  2. How to change text in "Order Confirmation" and "Welcome to our Store" page?
    By SandraSD in forum Templates, Stylesheets, Page Layout
    Replies: 9
    Last Post: 15 Mar 2011, 03:59 AM
  3. How can I change the "Order Number" counter?
    By mkalavitz in forum General Questions
    Replies: 3
    Last Post: 10 Feb 2010, 06:00 AM
  4. Arbitrarily setting the "order number" figure
    By zipperplug in forum General Questions
    Replies: 1
    Last Post: 9 Apr 2009, 02:33 PM
  5. Change "Starting At:" to "As Low As:"
    By milobloom in forum General Questions
    Replies: 7
    Last Post: 1 Feb 2008, 03:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg