I need to customize my prefix for the order / invoice ID´s. So my order number should look like this: 16-0001 I need the year as prefix with an "-". But when I try this:
UPDATE eav_entity_store SET increment_prefix = 16-, increment_last_id = '16-00000' WHERE store_id = 1 AND entity_type_id = 5; # orders
I get an mysql error. So can anybody say how i do this or it is not possible?