Name of Apps confusion

[Chadduck]

I am finally in the process of adding the Apps that I placed in my library after getting the shipping and other basic Apps working.

As I usually do when I move to new version, I want to set the starting order number to a value that is far higher than that currently in use within my existing OsCommerce store (currently using 67000 series). I want to set the start number to start at something like 80000 series.  

Searching the forums I found the topic "Order Number start setting" originally posted on March 30.  Within that topic @Ivan Holbi states that this will be available within the module "Custom Invoice Numeration" and offered a link to the App.  Sadly the offered link no longer works.  Here's where it was posted....

So I am uncertain if the App that I placed within my library is the same. The App I placed in my library is entitled "Invoice Number Format".

Is this the App to which Ivan referred?

BJ

[Ivan Holbi]

10 minutes ago, Chadduck said:

I am finally in the process of adding the Apps that I placed in my library after getting the shipping and other basic Apps working.

As I usually do when I move to new version, I want to set the starting order number to a value that is far higher than that currently in use within my existing OsCommerce store (currently using 67000 series). I want to set the start number to start at something like 80000 series.  

Searching the forums I found the topic "Order Number start setting" originally posted on March 30.  Within that topic @Ivan Holbi states that this will be available within the module "Custom Invoice Numeration" and offered a link to the App.  Sadly the offered link no longer works.  Here's where it was posted....

So I am uncertain if the App that I placed within my library is the same. The App I placed in my library is entitled "Invoice Number Format".

Is this the App to which Ivan referred?

BJ

Hi BJ,

Thank you for spotting it.

You are right, the module "Custom Invoice Numeration" was renamed to "Invoice Number Format".

Best regards,

Ivan

[Chadduck]

4 hours ago, Ivan Holbi said:

You are right, the module "Custom Invoice Numeration" was renamed to "Invoice Number Format".

So is the starting number located outside the module? I ask because the attached screen is all I see...

BJ

[Chadduck]

Apologies I should have included this information from the module description since I see no place to do what it says - 

Invoice Number Format module allows shop owners to define the desired order and invoice number formats, ensuring compliance with accounting regulations and meeting individual preferences.

You can use 

fiscal year start date selection with Invoice Number Format.

 The module offers the flexibility to select the fiscal year's start date based on country-specific regulations. Shop owners can choose any date within a year as the starting point.

Furthermore, the module accommodates shop owner requirements. 

Enable customizable order and invoice counters using Invoice Number Format

 to start from a specified number (e.g., 100). These counters reset at the beginning of each fiscal year and can differ for orders and invoices.

The module also allows 

separate configuration of order and invoice number formats.

 Various combinations can be utilized, such as:
Y: Full numeric representation of a year (4 digits), e.g., 2022
y: Two-digit representation of a year, e.g., 99 or 03
0Xc: Invoice counter with X-digit zero padding, e.g., 04c for 0001, 02c for 01 or 123 (e.g., for invoice 123)
For instance, a format like GGY-04c would result in invoice numbers such as GG2022-0001.

Additionally, you can 

define start and end dates for formats using Invoice Number Format,

 providing further customization options to suit specific needs.

Once implemented, 

order and invoice numbers appear in formats in emails and lists,

 excluding payment methods.

By leveraging Invoice Number Format module, shop owners can establish personalized order and invoice numbering systems that align with their requirements and adhere to applicable regulations.

[pandrei]

16 hours ago, Chadduck said:

As I usually do when I move to new version, I want to set the starting order number to a value that is far higher than that currently in use within my existing OsCommerce store (currently using 67000 series). I want to set the start number to start at something like 80000 series.

if you only want to increase the starting order numder, the easiest way to do it is to use this SQL command:

ALTER TABLE orders AUTO_INCREMENT=80000;

 

[Chadduck]

3 hours ago, pandrei said:

if you only want to increase the starting order numder, the easiest way to do it is to use this SQL command:

ALTER TABLE orders AUTO_INCREMENT=80000;

@pandrei

Curiosity. Because I am still working on the upgrade, and before going live, I will need to import orders placed since I initially installed the "developmental" store, should this be done AFTER that or does it matter? 

BJ

[pandrei]

20 hours ago, Chadduck said:

should this be done AFTER that or does it matter?

It matters. You should run the above SQL after import orders

[Chadduck]

That is what I thought....

I will catalog the command away to run right before I go live.

Thank you