Shopify API Not showing all Orders Attributes

Topic summary

A developer is encountering an issue when fetching order data through the Shopify API using Python. The API response is missing critical product identification fields needed to properly identify products within orders.

Missing Data:

  • product_id
  • product_name
  • variant_id

Current Limitation:
Only the line_item_id is visible in the returned attributes, which is insufficient for product identification purposes.

The user has shared a sample of the attributes they’re currently receiving (including order metadata like email, financial_status, fulfillment_status, timestamps, and line_items array). The data appears partially corrupted or reversed in the shared output, making it difficult to assess the exact structure.

Status: The issue remains unresolved with no responses yet. The developer is seeking guidance on how to retrieve the missing product-related fields from the Orders API endpoint.

Summarized with AI on November 25. AI used: claude-sonnet-4-5-20250929.

I am trying to fetch data using the Shopify API. The problem is; I am not getting all the attributes / columns in Orders.

I need to be able to identify the products in the Orders but the only identification I can see is the LineItem ID.

I need product_id or product_name or even variant_id. How do I get these? I’ve attached the attributes I’m able to get.

(I am using python for my script)

Kindly see below.

‘device_id’: None, ‘discount_codes’: , ‘email’: [email removed] ‘estimated_taxes’: False, ‘financial_status’: ‘pending’, ‘fulfillment_status’: None, ‘gateway’: ‘’, ‘landing_site’: ‘’, ‘landing_site_ref’: None, ‘location_id’: None, ‘name’: ‘#1377’, ‘note’: None, ‘note_attributes’: , ‘number’: 1277, ‘order_number’: 1377, ‘order_status_url’: ‘’, ‘original_total_duties_set’: None, ‘payment_gateway_names’: [‘’], ‘phone’: None, ‘presentment_currency’: ‘’, ‘processed_at’: ‘2022-11-29T11:55:43+03:00’, ‘processing_method’: ‘manual’, ‘reference’: None, ‘referring_site’: ‘’, ‘source_identifier’: None, ‘source_name’: ‘web’, ‘source_url’: None, ‘subtotal_price’: ‘’, ‘subtotal_price_set’: subtotal_price_set(None), ‘tags’: ‘’, ‘tax_lines’: [tax_line(None)], ‘taxes_included’: True, ‘test’: False, ‘token’: ‘’, ‘total_discounts’: ‘0.00’, ‘total_discounts_set’: total_discounts_set(None), ‘total_line_items_price’: ‘’, ‘total_line_items_price_set’: total_line_items_price_set(None), ‘total_outstanding’: ‘’, ‘total_price’: ‘’, ‘total_price_set’: total_price_set(None), ‘total_price_usd’: ‘’, ‘total_shipping_price_set’: total_shipping_price_set(None), ‘total_tax’: ‘’, ‘total_tax_set’: total_tax_set(None), ‘total_tip_received’: ‘0.00’, ‘total_weight’: 0, ‘updated_at’: ‘2022-11-29T11:55:45+03:00’, ‘user_id’: None, ‘billing_address’: billing_address(None), ‘customer’: customer(643705061), ‘discount_applications’: , ‘fulfillments’: , ‘line_items’: [line_item(16947123703)], ‘payment_terms’: None, ‘refunds’: , ‘shipping_address’: shipping_address(None), ‘shipping_lines’: [shipping_line()]}