The client's problem
We have a Shopify website and need to fix our Google & Youtube Sales Channel.
Our goal is to not only have our products correctly shown in Google Merchant Center, but we would like to tag those same products in Youtube.
The big issues right now are that what the Sales Channel is showing does not match up with what Google Merchant Center says product-count wise.
Also the feed is showing multiples of the same product in Google Merchant Center.
Lastly, the Google & Youtube Sales channel has showed pending for months.
And in Youtube, it shows our store connected, but shows no products, so we cannot tag products in our videos. That is the goal of all of this.


My analysis
1
Due to a known bug, the «Google & YouTube» Shopify app in your case erroneously transmits ZZ instead of the correct ISO 3166-1 alpha-2 country code (e.g., US) in the «Item ID» to Google Merchant Center: this is visible in your image All products - Merchant Center (1).png.
This bug was acknowledged 2 weeks ago by Ginny Marvin, Google's Ads Product Liaison: linkedin.com/feed/update/urn:li:activity:7477247186007928832?commentUrn=urn:li:comment:(activity:7477247186007928832,7483929156741791745)
2
Google Merchant Center shows duplicates of your products because each duplicate targets a different country, which is not obvious to you due to §1.
3
The discrepancy between the number of products shown in the «Google & YouTube» Shopify app and in Google Merchant Center directly follows from §2.
4
Your store moregems.com has not completed the mandatory stages of onboarding in Google Merchant Center: this follows both from the «Pending» status in your image Moriartys Gem Art · Overview · Shopify (2).png and from the absence of the store's products in Google Shopping.
5
YouTube Shopping does not show your products for 2 independent reasons: §1 and §4 (§1 leads to this because YouTube Shopping does not show products with the country code ZZ to the US audience).