Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Name of Apps confusion


Chadduck

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Installed Module.png

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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;

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...