What's your biggest current challenge? Have your say in Community Polls along the right column.
Our Partner & Developer boards on the community are moving to a brand new home: the .dev community forums! While you can still access past discussions here, for all your future app and storefront building questions, head over to the new forums.

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

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 38

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