Shop IDs now exceed 32-bit integer max value

Shopify Staff
Shopify Staff
36 0 7

Hey Developers!

Back in 2013, Shopify started to transition its ID columns from 32-bit to 64-bit in order to handle the sheer amount of data we process. This post is a reminder of all the great advice from that thread, as recently generated shop IDs have exceeded the 32-bit threshold. We're excited to have reached this milestone, and wanted to give everyone a heads up.

What this means for you
If your app processes the shop ID from an API call, you will need to ensure that your data type can handle 64-bit integers.

If you have any questions about this news, feel free to shout out below in the thread.

1 Like
Shopify Partner
4 0 3

If using Ruby on Rails this link has some helpful info about migrating to 64-bit integer.

Rails 5.1: Default Primary Keys Are Now BIGINT