source-shopify: Add id and position fields to product_variants.options schema #72277
Description
Summary
The product_variants.options array in the Shopify connector currently uses a generic array schema that loses field type information. This causes the id and position fields from Shopify's ProductOption object to be dropped or mistyped during sync.
Problem
When syncing product_variants, the options array returns data from Shopify's ProductOption API, which includes:
id- needed for API operations (updates, lookups)name- option nameposition- display order (critical for correct UI rendering)values- option values
The current schema defines options as a generic array, so id and position are not captured.
Requested Change
Update product_variants.json schema to explicitly define the options array items with proper field types for id, name, position, and values.
Use Case
Customer needs id for downstream API operations and position to maintain correct display ordering of product options.
Internal Tracking: https://github.com/airbytehq/oncall/issues/11012