WickedCoolers Posted June 2, 2003 Posted June 2, 2003 When a customer makes an order, an email is sent to them with the invoice and it contains the order number ie..65, is it possible to redefine this as something like 0100065 so it does not make it s obvious how many orders my website has actually had?? or to give an order ID rather than order number like WC-010065?? any help would be much appreciated :-) The hardest thing in life is watching someone you love, love someone else.
Daemonj Posted June 2, 2003 Posted June 2, 2003 My first thought would be to simply run an sql update to update all of the order numbers to their current value + a starting value. For example, if you wanted all of your orders to be in the 10,000 range (you know, gotta make it look good ;)), then you would say order number + 10000. Once that is done all new orders will simply pick up where the last order number left off. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
WickedCoolers Posted June 2, 2003 Author Posted June 2, 2003 Thanks for the reply. Would it be possible to change the type from INT to VARCHAR and put WC-00000 at the front of ever value and then the only part which changes would be the last 2 numbers or is that too complicated?? :-) The hardest thing in life is watching someone you love, love someone else.
Guest Posted June 2, 2003 Posted June 2, 2003 bit of a hack - but if you go to catalog/checkout_process.php and look for EMAIL_TEXT_ORDER_NUMBER - you can put an order prefix here that would get sent in the mail. Bit dirty but its a 1 min fix.
Daemonj Posted June 2, 2003 Posted June 2, 2003 Thanks for the reply. Would it be possible to change the type from INT to VARCHAR and put WC-00000 at the front of ever value and then the only part which changes would be the last 2 numbers or is that too complicated?? :-) No, that would not work. :( Meltus's idea would do what you need though. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Guest Posted June 26, 2003 Posted June 26, 2003 If you are only interested in increasing your product id number the simple way to do it is to: - manually add a product to your 'product' table and specify a (unique) value in the product_id field. ( In my case I gave it a value of 10000 ) - Add a product using catalog. Since product_id field is an autonumber it will assign the next product to be 10001 - go back to the database and remove product 10000 This is a total hack but it worked for me. Of course if your database is already populated this is a completeley different story as product_is a key and a foreign key in several tables. Have fun! Andy
Recommended Posts
Archived
This topic is now archived and is closed to further replies.