order base number

Help for integrating the Laravel package
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
User avatar
bilginkilic
Posts: 34
Joined: 05 Jul 2020, 07:08

order base number

Post by bilginkilic » 22 Oct 2020, 12:50

how can we make order number starting from another base like 10000 ? Where should we edit for this purpose?
@bilginkilic_ (twitter)

User avatar
aimeos
Administrator
Posts: 8356
Joined: 01 Jan 1970, 00:00

Re: order base number

Post by aimeos » 23 Oct 2020, 16:04

Set the start value of the mshop_order.id column to a different value using phpMyAdmin or another tool.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

columbo
Advanced
Posts: 151
Joined: 09 Oct 2019, 09:42

Re: order base number

Post by columbo » 27 Mar 2023, 09:40

is this still valid for 2022.10?
  1. the current order number is eg. 30
  2. set mshop_order.id to 1.000
  3. created next order and the order number was 31
Thank you!

User avatar
aimeos
Administrator
Posts: 8356
Joined: 01 Jan 1970, 00:00

Re: order base number

Post by aimeos » 29 Mar 2023, 07:23

Since 2022.10 there are two numbers:
- The mshop_order.id which is the sequential number of the order records
- The mshop_locale_site.invoiceno which is the invoice number shown per site
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply