This is not released yet!speedingorange wrote:Is this now included in the latest release?
Cheers
James
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.
Daniel wrote: after I get some food.
There your go!
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.
Sorry to reopen this thread however I am trying to work out of OpenCart will provide a suitable platform for a client project.
Firstly my client is Italian and so like has been mentioned there are some very specific requirements for invoicing which are -
1. Sequential Numbering with no missing invoice numbers (Canceling an order should not delete a created invoice).
2. Starting from 1 each year (A simple way to do this which we use in WHMCS is to have a "next invoice number" field in admin so we have 2010-01345 and next year we would simply change the next invoice field to 2011-00001).
Can OpenCart support the Italian requirements?
Regards
Sam M
www.servwise.com - Hosting Windows & Linux italia
Yessonicsam wrote: Can OpenCart support the Italian requirements?
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Xsecrets wrote:well you can do sequential and you can set the initial start number, but I'm not sure if you can reset it to start over at 1 each year.
You can, by running a query via phpMyAdmin at the beginning of each year.
Thats how i do it with osCommerce and this should work with OpenCart as well.
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.
What query it should be? Like setting all invoice id's to "0"??? I think there might be some problems for users when they view order history from account page and when I need to print an old invoice.i2Paq wrote:You can, by running a query via phpMyAdmin at the beginning of each year.
Modification:
In a file "admin/model/sale/order.php" I found where it says:
Code: Select all
$query = $this->db->query("SELECT MAX(invoice_id) AS invoice_id FROM `" . DB_PREFIX . "order`");
Code: Select all
$query = $this->db->query("SELECT MAX(invoice_id) AS invoice_id FROM `" . DB_PREFIX . "order` WHERE invoice_prefix = '" . $this->db->escape($this->config->get('config_invoice_prefix')) . "'");
Now you don't need to reset invoice counter when year starts. Just change the Invoice prefix when new year (month or whatever) and the counter will be re-set automatically. And you won't have to lose previously saved invoice numbers to reset counter.
Explanation:
Thing is that originally core file searches in DB for highest invoice number and adds +1. After this modification core file searches for highest invoice number in DB only in rows that use current invoice prefix (set at BackOffice settings). In this way, when you set a prefix that was never used before (like when changing from INV2009 to INV2010 whne a new year starts) invoice id automatically sets to 0+1 = 1
Disclaimer:
Edit this file at your own risk. I am not a coder. Just edited this file for my own shop (which is not even jet launched) and I might not be aware of harm it might cause.
Users browsing this forum: No registered users and 103 guests