Uniqueness of ID data across multiple shopify stores

[btempo]

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? 

[PaulNewton · Accepted solution]

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-s...

---

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...

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.