Results 1 to 10 of 22

Hybrid View

  1. #1
    Join Date
    Jan 2008
    Posts
    1,700
    Plugin Contributions
    6

    Default Re: Customer Order Ids

    I've seen a few requests for this in the past. Sadly there is no option in admin to do what you want. As far as I'm aware, there's no contribution available either. I think you might have to make do with the current approach which is to increment the ID by 1 each time. You can always change the ID to start at a higher number, e.g. 60548. This can be done in admin>tools>store manager.

  2. #2
    Join Date
    May 2005
    Location
    Western MA, USA
    Posts
    604
    Plugin Contributions
    6

    Default Re: Customer Order Ids

    please explain the algorithm that you want to use for order ID's, so we may see if it is possible.

  3. #3
    Join Date
    Mar 2008
    Posts
    2
    Plugin Contributions
    0

    Default Re: Customer Order Ids

    I want the order id's to be something like CR999999. Just need to append "CR" to the order id really.

  4. #4
    Join Date
    May 2005
    Location
    Western MA, USA
    Posts
    604
    Plugin Contributions
    6

    Default Re: Customer Order Ids

    there are 2 ways of going about this., (that I can think of at the moment).
    the easier i think would be to modify the code to display the added cr to the id number every where you want the cr to be displayed.
    This way you will not have to mess w/ the database.
    The other thing to do is to add a customer_number to the customers table on the database, and to have it be a varchar(64) and have your customer creations script do something like $customer_number = 'cr'. $customers_id; that way you dont have to think of messing w/ the auto incrementing that that the database already does for you.
    both methods will will require you to change the loging script to match the customer_number w/ the database instead of the email address.

  5. #5
    Join Date
    Feb 2007
    Location
    UK & Germany
    Posts
    52
    Plugin Contributions
    2

    Default Re: Customer Order Ids

    If you just want to add the CR to the order number there is alot easier way to do this, as I have done it to mine, I will dig out the files needed and come up with a short tutorial
    "I see" said the blind man
    "You're a liar" said the dumb

    www.Pictures2Stitches.com

  6. #6
    Join Date
    Jan 2008
    Posts
    1,700
    Plugin Contributions
    6

    Default Re: Customer Order Ids

    Thanks Paddy, that will help a lot of people.

  7. #7
    Join Date
    Feb 2007
    Location
    UK & Germany
    Posts
    52
    Plugin Contributions
    2

    Default Re: Customer Order Ids

    OK Dead simple,

    In the developers tool kit (admin>tools>Developers tool kit) do a search in the bottom search field for "Order #" then change the text in the files you wish to whatever you want to see in fromt of the order number.

    EG. if you want it to read Order # CRXXXX

    Just add 'CR' after the hash symbol
    "I see" said the blind man
    "You're a liar" said the dumb

    www.Pictures2Stitches.com

  8. #8
    Join Date
    Jan 2008
    Location
    Roswell, Ga USA
    Posts
    144
    Plugin Contributions
    0

    Default Re: Customer Order Ids

    i know this is an older post but hope people are watching it.

    is this option gone in 1.3.8?

    When i search for order # it can not find anything looks like it is only searching the files and not the database for order number....

 

 

Similar Threads

  1. v151 Missing customer IDs in phpmyadmin
    By waterbender in forum General Questions
    Replies: 2
    Last Post: 12 Jan 2014, 03:22 PM
  2. Delete Old Order IDs 1 to 3369 Using SQL Query
    By limelites in forum General Questions
    Replies: 1
    Last Post: 12 Apr 2013, 02:29 PM
  3. restrict ez pages to specific customer ids
    By srose6 in forum General Questions
    Replies: 0
    Last Post: 31 Jan 2012, 02:20 AM
  4. Reset prod IDs and Categories IDs
    By savchenko01 in forum General Questions
    Replies: 2
    Last Post: 31 Jan 2011, 05:21 PM
  5. Duplicate customer IDs in zen_address_book table
    By dcdiaz in forum Managing Customers and Orders
    Replies: 6
    Last Post: 24 Apr 2010, 05:59 PM

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