Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2008
    Location
    Georgia
    Posts
    68
    Plugin Contributions
    0

    Default I emptied Orders but Numbers didn't reset

    I emptied my Orders Tables and then went in and placed a test order. The number didn't reset -- I had previously reset (before emptying the table) my start Order ID to 2800 and the new order got 2801. Where is this stored? Can I reset to zero? Maybe by deleting the entire table Orders and copying over a new copy?

    Re: test orders -- how can I test with just cc payment? I currently have COD avail for testing but will deactivate that soon.

    Thanks.

  2. #2
    Join Date
    Oct 2007
    Location
    Fairbanks, Alaska
    Posts
    426
    Plugin Contributions
    0

    Default Re: I emptied Orders but Numbers didn't reset

    admin-tools-store manager "reset current order id" old order id 2801 new order id 0

    you could use the zen-cart free charge card to test cc

    you could look the order id up in the admin-tools-developers tool kit
    Last edited by colemanpa; 15 Apr 2008 at 06:30 PM. Reason: changed something

  3. #3
    Join Date
    Mar 2008
    Location
    Cape Town & London (depends on the season)
    Posts
    2,975
    Plugin Contributions
    0

    Default Re: I emptied Orders but Numbers didn't reset

    Quote Originally Posted by colemanpa View Post
    admin-tools-store manager "reset current order id" old order id 2801 new order id
    I don't think it's possible to decrement the number... (unless you hack the dbase, possibly).

  4. #4
    Join Date
    Oct 2007
    Location
    Fairbanks, Alaska
    Posts
    426
    Plugin Contributions
    0

    Default Re: I emptied Orders but Numbers didn't reset

    you said you emptied the Orders Tables so there should not be any thing to stop you from resetting that value, i would think! try it.

  5. #5
    Join Date
    Jan 2008
    Location
    Georgia
    Posts
    68
    Plugin Contributions
    0

    Default Re: I emptied Orders but Numbers didn't reset

    Uh, oh. I've just made another test purchase. The order shows up in my database (viewing via phpMyAdmin) but not in my order history on the the site (after logging as the customer) nor does it appear under Admin/Orders.

    I want to resolve the renumbering issue but at this point want to see the order first!

    Any ideas?

  6. #6
    Join Date
    May 2005
    Posts
    110
    Plugin Contributions
    0

    Default Re: I emptied Orders but Numbers didn't reset

    I have the same issue, did you figure out what it is?
    See here: http://www.zen-cart.com/forum/showthread.php?t=96110

  7. #7
    Join Date
    Jan 2008
    Location
    Georgia
    Posts
    68
    Plugin Contributions
    0

    Default Re: I emptied Orders but Numbers didn't reset

    I saw on your other post that you resolved the issue -- same resolution on my end too. Phew.

  8. #8
    Join Date
    Jan 2006
    Posts
    16
    Plugin Contributions
    0

    Default Re: I emptied Orders but Numbers didn't reset

    hi
    i have problem
    i empty my orders
    i reset current order id" old order id 25 new order id 0
    i press install

    then i try make a new order expecting order1
    but i get order26

    i noticed
    in shopmanager if i install for example the first one
    i get message on top
    De volgorde van rangschikken voor opties is met succes gewijzigd.
    (means its been succesfull)

    but after resetting orders and press install
    i get no message?
    thanks

  9. #9
    Join Date
    Jan 2006
    Location
    Downunder - QLD - Gold Coast
    Posts
    964
    Plugin Contributions
    0

    Idea or Suggestion Can I use aphanumeric ordering numbers?

    I need to identify my resellers/distributors. So I need to know where the ordrs are coming from so to speak.

    Is it possible to change the ordrer numbers to following then let zen cart to increment ?

    Old Order ID: 3
    New Order ID : JUST-01001 (or similar ) so that newxt order number can be JUST-01002 etc

    Thank you
    Downunder QLD

 

 

Similar Threads

  1. USPS just stopped working on both my sites, but i didn't change anything
    By patrioticflags in forum Addon Shipping Modules
    Replies: 3
    Last Post: 9 Mar 2014, 07:30 AM
  2. paypal sent payment but zen cart didn't record order
    By sheila123 in forum Managing Customers and Orders
    Replies: 21
    Last Post: 11 Dec 2009, 12:21 AM
  3. Wish I'd Installed Demo Data But Didn't
    By chopbox in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 2 Sep 2008, 10:07 PM
  4. Orders not showing up - orders_status emptied
    By jaydee98273 in forum Managing Customers and Orders
    Replies: 2
    Last Post: 22 Jul 2008, 11:00 PM
  5. Reset order numbers, now I'm not getting orders!!
    By khadijaorta in forum Managing Customers and Orders
    Replies: 0
    Last Post: 28 Dec 2006, 10:44 AM

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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR