Changing the syntax of orderID

[onkadonk]

Hi all,

I'm currently working on a project which integrates a warehouse management system with Magento. To communicate with the WMS properly, our orderID's need to change from UEO100000123 to UEO-100000123. Can anyone tell me how i can add the - in between the string and the integers? I'm still learning Magento, so don't pull out the pitchforks just yet, haha.

Kind regards,

Jurgen van Delft

[Gabriel Guarino]

Hi @onkadonk,

Since that is not the increment ID that is included by default in Magento, I guess that there is a custom module that has implemented that change.

Have you reviewed the codebase? You could search for the following string: "UEO".

Best regards.

Gabriel

[Fooman]

As @Gabriel Guarino mentioned it looks like you already have some customisation present. While we do offer an extension that allows customising the order number the following should work without the need for an extension:

However the below assumes you are comfortable editing your Magento database directly (a backup beforehand is always a good idea).

Run the below query 

SELECT * FROM sales_sequence_profile;

which should bring up something like this

+------------+---------+--------+--------+-------------+------+------------+---------------+-----------+
| profile_id | meta_id | prefix | suffix | start_value | step | max_value  | warning_value | is_active |
+------------+---------+--------+--------+-------------+------+------------+---------------+-----------+
|          1 |       1 | UEO    | NULL   |           1 |    1 | 4294967295 |    4294966295 |         1 |
|          2 |       2 | NULL   | NULL   |           1 |    1 | 4294967295 |    4294966295 |         1 |
|          3 |       3 | NULL   | NULL   |           1 |    1 | 4294967295 |    4294966295 |         1 |
|          4 |       4 | NULL   | NULL   |           1 |    1 | 4294967295 |    4294966295 |         1 |
|          5 |       5 | NULL   | NULL   |           1 |    1 | 4294967295 |    4294966295 |         1 |
|          6 |       6 | NULL   | NULL   |           1 |    1 | 4294967295 |    4294966295 |         1 |
|          7 |       7 | NULL   | NULL   |           1 |    1 | 4294967295 |    4294966295 |         1 |
|          8 |       8 | NULL   | NULL   |           1 |    1 | 4294967295 |    4294966295 |         1 |
+------------+---------+--------+--------+-------------+------+------------+---------------+-----------+

note the profile_id for the entry that already includes your "UEO" prefix.

Run the below query to change the prefix to "UEO-"  

UPDATE sales_sequence_profile SET prefix='UEO-' WHERE profile_id=1;