Uniqueness of ID data across multiple shopify stores

Retired Boards Appdev Fulfillment Api
1

Hi

I need to load data into Snowflake from multiple shopify instances/stores with Fivetran
Does anyone know if all the ID data in the shopify are unique across shopify stores?

For example, are the id’s for ORDER, ORDER_LINE, CUSTOMER, FULFILLMENT, TRANSACTION, PRODUCT, etc… unique across shopify instances/stores?
Or can we get duplicate ID across the stores, for example, would shopify store 1 and shopify store 2 both generate an ID of 1 for orders?

2

All ID’s should be unique across the platform*

Explicitly and Publicly Confirmed:

  1. Product ID’s
  2. Order ID’s
  3. Smart Collection ID’s

Product and order IDs are unique across all shops (not to be confused with order name).> > https://community.shopify.com/c/Shopify-APIs-and-SDKs/Are-product-and-order-ID-s-unique-across-all-stores-on-Shopify/m-p/1081074/highlight/true#M63286> I can confirm that Smart Collection ids are not relative to shops - they will also be completely unique across shops like product ids. https://community.shopify.com/c/Shopify-APIs-and-SDKs/Uniqueness-of-Smart-collection-Ids/m-p/1220771/highlight/true#M68862

Kinda silly the entire information on this still isn’t explicitly in the api docs, it’s as fundamentally important as explaining rate limits and shouldn’t be left to assumption.

*afaik but I’ve never seen an shopify internal confirm/deny an entire LIST of IDs as unqiue this, either way if you didn’t build the system just assume they aren’t because “should be” isn’t engineering.

3 Likes