Dear All,
Hope you guys can provide solution for this.
I need to change the Invoice No#.
Instead of 0 or single character, I would like to have more, e.g: 00950886 or INV 0900764, etc...
I was made understood the variable is order_id, however I couldn't find where to change it.
Hope to receive response as soon as possible.
cadsifu@inbox.com
Hi All,
In the beginning, the order_id started from 0.
However this doesn't look good since it only displays single numeric character.
Is there any possibility to change to mixed-character e.g: INV 0094065 or maybe numerics only 0094065
Looking forward for some guide from all experts here.
In the beginning, the order_id started from 0.
However this doesn't look good since it only displays single numeric character.
Is there any possibility to change to mixed-character e.g: INV 0094065 or maybe numerics only 0094065
Looking forward for some guide from all experts here.
Are the other Alphanumerics laughing at him because he's only a number? Is there a fashion show that he wants to win? What does a good looking order number do for you? Perhaps if we converted it to Roman numerals?cadsifu wrote: However this doesn't look good since it only displays single numeric character..
I understand and agree. It is the same issue as using the temporary check books given by banks.cadsifu wrote:Hi All,
In the beginning, the order_id started from 0.
However this doesn't look good since it only displays single numeric character
A customer could have less confidants in a online store when they receive there invoice as No.3
instead of No. 21003.
Small issue that clears it self up after a 1000 sales or so.
However having a option to format the invoice number (the presented number not the real db number) to match a company's own invoice would be nice. perhaps even an option to add a base number so that it can line up with orders from a previous shopping cart.
Execute this simple sql in your phpmyadmin
(prepend a prefix if needed (i.e. `xxx_order`)
Now it will start at 10000
Code: Select all
ALTER TABLE `order` AUTO_INCREMENT =10000Now it will start at 10000
thanks for your nice comments
maybe it's too late for me to reply, however I've managed to change it.
the only i can't do is to add alphabet character infront of the numbers.. e.g: INV0020456
as well as change the number so that it looks like this >>> 0020456 instead of 20456
thanks for your kind support and assistance...
maybe it's too late for me to reply, however I've managed to change it.
the only i can't do is to add alphabet character infront of the numbers.. e.g: INV0020456
as well as change the number so that it looks like this >>> 0020456 instead of 20456
thanks for your kind support and assistance...
Qphoria wrote:Execute this simple sql in your phpmyadmin
(prepend a prefix if needed (i.e. `xxx_order`)Code: Select all
ALTER TABLE `order` AUTO_INCREMENT =10000
Now it will start at 10000
we will have to see how the new invoicing system
will look like in opencart.
in most of the eu countries the current invoice implementation
is not usable. Daniel said he is working on a new one,
and as there is no "one good type" of invoice number formatting,
hopefully it will be customisable to a degree. otherwise
it won't be very useful for a lot of people once again.
will look like in opencart.
in most of the eu countries the current invoice implementation
is not usable. Daniel said he is working on a new one,
and as there is no "one good type" of invoice number formatting,
hopefully it will be customisable to a degree. otherwise
it won't be very useful for a lot of people once again.
we is experts(tm)
I want to make the Order ID as OC09FR1227A,
refer to
OC: OpenCart
09: 2 digital for the year that the order has been placed
FR: ISO Code of France, can get the Country Code when clients Register.
1227: is the date that the order has been placed
A: is a series No for order which placed in same day, ex. Dec. 27, from A to Z
If it can make it would be great, it will be more easy for us to make statistics.
Allen
refer to
OC: OpenCart
09: 2 digital for the year that the order has been placed
FR: ISO Code of France, can get the Country Code when clients Register.
1227: is the date that the order has been placed
A: is a series No for order which placed in same day, ex. Dec. 27, from A to Z
If it can make it would be great, it will be more easy for us to make statistics.
Allen
I know nothing about PHP and SQL, but I still try my best to understand it.
wow, that seems a bit overengineered.OC09FR1227A
-why separate the year from the other parts of the date?
-also, what will you do if you get more than 26 orders a day?
mixing numbers and letters this way will make working
with this invoice "number" rather difficult.
how about:
OC-FR-2009122701
now the invoice has a constant prefix 'OC-FR' and a simple number
that has everything you wanted. this would be quite easy
to implement.
we is experts(tm)
Is it possible to relate order numbers to clients ie [clientname][ordernum].
OR
Cocatenation of date to order number in numerics? ie [ordernum]-[numericdate] or vice-versa?
Just a thought.
Disclaimer: Not a programmer so wouldn't have a clue how it is done or whether it is possible with the structure of OC.
cheers
OR
Cocatenation of date to order number in numerics? ie [ordernum]-[numericdate] or vice-versa?
Just a thought.
Disclaimer: Not a programmer so wouldn't have a clue how it is done or whether it is possible with the structure of OC.
cheers
Where do I find this to change it?Qphoria wrote:Execute this simple sql in your phpmyadmin
(prepend a prefix if needed (i.e. `xxx_order`)Code: Select all
ALTER TABLE `order` AUTO_INCREMENT =10000
Now it will start at 10000
Thank you, Melanie
Via your phpMyAdmin.sizzlingscience wrote:Where do I find this to change it?Qphoria wrote:Execute this simple sql in your phpmyadmin
(prepend a prefix if needed (i.e. `xxx_order`)Code: Select all
ALTER TABLE `order` AUTO_INCREMENT =10000
Now it will start at 10000
Thank you, Melanie
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
do this command work if i have a order id 38 with invoice 1
and manual set the order 38 to 1001 in phpMyAdmin afterwards? 
i just need a confirmation of someone with mysql experience before i do it
OpenCart 1.4.8b
Code: Select all
ALTER TABLE `order` AUTO_INCREMENT =1002i just need a confirmation of someone with mysql experience before i do it
OpenCart 1.4.8b
i2Paq wrote:Via your phpMyAdmin.sizzlingscience wrote:Where do I find this to change it?Qphoria wrote:Execute this simple sql in your phpmyadmin
(prepend a prefix if needed (i.e. `xxx_order`)Code: Select all
ALTER TABLE `order` AUTO_INCREMENT =10000
Now it will start at 10000
Thank you, Melanie
Hi!
I went into my phpMyAdmin,
clicked on "structure" for the "order" table.
clicked on "change" for the "order_id" field.
Now I don't know what to do anymore.
This is so complicated.
Can you please kindly help me?
Thank you very much!
I'm using Opencart 1.5.4.1 & vQmod 2.3.2.
go to you phpmyadmin, click SQL (located on the top) then paste this on the text area:
Click the Go button on the right side.
Code: Select all
ALTER TABLE `order` AUTO_INCREMENT =10000
Who is online
Users browsing this forum: No registered users and 177 guests
