Full service web hosting, great prices and support. Starts at $1.99/month!
Results 1 to 3 of 3

Thread: How to set new order number

  1. #1
    adam71o
    Guest


    Default How to set new order number

    By default the system begins order numbers at 1. I am updating from an older oscommerce install and want to continue with the same number where I left off. How does one set it so that the next order number would be 2117, for example?

    Any input is appreciated.

  2. #2
    BlueBunyip
    Guest


    1 out of 1 members found this post helpful.

    Default Re: How to set new order number

    Quote Originally Posted by adam71o View Post
    By default the system begins order numbers at 1. I am updating from an older oscommerce install and want to continue with the same number where I left off. How does one set it so that the next order number would be 2117, for example?

    Any input is appreciated.
    Use this SQL Replacing XXXX with the next order number you want to use.

    alter table orders auto_increment = XXXX;

  3. #3
    markcm
    Guest


    Default Re: How to set new order number

    Are you trying to import your previous osC data as well, or just start fresh in your new store picking up the order numbers where you left off?

    If you want to import your old data, you might be interested in this thread. I chose to retain all my database ID number so that all of my organic links across the internet would still be good, plus I still have all my previous customer/order/ and product information intact.

    If you just want to start fresh yet resume order numbers, you can use mySql to edit the order number as mentioned in the previous post.

Similar Threads

  1. [Admin Issue] Order & Packing Order Form PDF's not showing Model Number
    By giga009 in forum Installation/Setup
    Replies: 6
    Last Post: 08-01-2012, 02:54 PM
  2. Order Editor / Unique Order Number / Manual Order Maker Combo
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 11-16-2008, 04:01 PM
  3. Order Editor / Unique Order Number / Manual Order Maker Combo
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 11-16-2008, 09:13 AM
  4. Add Order Number to Customer Order Emails v 1.0
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 03-23-2008, 12:22 PM
  5. Add Order Number to Customer Order Emails v 1.0
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 02-19-2008, 10:11 AM

Bookmarks

Bookmarks

Posting Permissions

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