@Anonymous Yes that helped.
Thank you.
Topic summary
Access to missing product data in Shopify Admin API was the main issue. The product endpoint returned standard product and variant fields, but not some values visible in CSV export, including cost per item, SEO fields, and Google Shopping data.
Key updates:
- Product status was eventually found in a newer/unstable API version as
status; earlier guidance suggested inferring publish state frompublished_at. - The missing cost value was clarified to be
Cost Per Item, which is not returned on the product object. It must be fetched through the Inventory Item API, using the variant’sinventory_item_id. - SEO title and description are stored as metafields, not core product fields.
- Google Shopping values are also handled via metafields, typically created by the Google channel app rather than native product fields.
Screenshots were important for identifying the admin “Cost Per Item” field and the Google channel metafield examples. The question was effectively resolved for cost data, and the remaining guidance for SEO/Google Shopping points to retrieving metafields per product.