Solved

Uniqueness of ID data across multiple shopify stores

btempo
Visitor
1 0 0
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? 
Accepted Solution (1)

PaulNewton
Shopify Partner
6274 573 1319

This is an 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.

Save time & money ,Ask Questions The Smart Way


Confused? Busy? Get the solution you need paull.newton+shopifyforum@gmail.com


Problem Solved? ✔Accept and Like solutions to help future merchants

Answers powered by coffee Buy Paul a Coffee for more answers or donate to eff.org


View solution in original post

Reply 1 (1)

PaulNewton
Shopify Partner
6274 573 1319

This is an 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.

Save time & money ,Ask Questions The Smart Way


Confused? Busy? Get the solution you need paull.newton+shopifyforum@gmail.com


Problem Solved? ✔Accept and Like solutions to help future merchants

Answers powered by coffee Buy Paul a Coffee for more answers or donate to eff.org