Long order number

how can i make the order number longer insted of B1 somthing like B156456 ?

that worked, thanks a lot.
but for me was
ALTER TABLE fewcn_hikashop_order AUTO_INCREMENT = 156456;

Hi,

I'm not sure if this is the right topic to ask but I think my question is related.

I upgraded to the Business version today (as a different user) and I'd like to use a custom order number format. However, I'm not sure if this can be done. What I'd like is for example:

MYD-120135

where the 'MYD-' is static (the initials of the website name), '12' is the year, '01' the month and then '35' is a number that increments with each order. Is that possible? I know my way around MySQL databases so if I can solve it with a query or something then that'll work. I just need to know what I need to change exactly.

Thanks!

Terrific! Every time I ask a question here the answer is so simple I feel ridiculous for asking.

Thanks again for a wonderful product.