Max length for fields `order_id` and` order_number` of Order object

Jabades
Visitor
1 0 0

Hello everyone and thanks for your help,

I have a question about the maximum size that the `order_id` and` order_number` fields of the Order object can have.

I need it for the database structure creation of my App, because later i will use these data for my shipping references and i don't know if these fields (`order_id` and `order_number`) will exced my carriers references lenght in future.

I hope I have explained myself correctly and that you can understand me.

Thank you very much!

Reply 1 (1)

awwdam
Shopify Staff
249 42 36

Hey @Jabades, great question here in regards to planning for you database!

At the current time, on the Order object/resource: "order_id" could reach  20 characters and "order_number"  11 characters. Also worth noting is the "name" field on Order often confused with the order_number. This is a combination of order_number and unique user set prefix and/or suffix, and therefor could be longer than 11 characters.

- Cheers!

awwdam | API Support @ Shopify
- Was my reply helpful? Click Like to let me know!
- Was your question answered? Mark it as an Accepted Solution
- To learn more visit Shopify.dev or the Shopify Web Design and Development Blog