---
id: object/table/30121
type: object
title: Table 30121 "Shpfy Orders to Import"
summary: Table 30121 "Shpfy Orders to Import" in Shopify (Microsoft.Integration.Shopify). 34 fields, 3 public procedures. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
  - table
  - shopify
versions:
  introduced: "29"
  last_changed: null
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: ac9a3a3fe9205724cc7f37c215296a5a789ae9372e60beb8fb5b6f5e0acace6c
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Shopify/app/src/Order%20handling/Tables/ShpfyOrdersToImport.Table.al
    title: src/Apps/W1/Shopify/app/src/Order handling/Tables/ShpfyOrdersToImport.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/shopify/synchronize-orders
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/online-store-with-shopify
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 30121
name: Shpfy Orders to Import
caption: Shopify Orders to Import
namespace: Microsoft.Integration.Shopify
app: Shopify
extends: null
first_version: "29"
last_version: "30"
present_in:
  - "29"
  - "30"
changed_in: []
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 34
  procedures: 3
  events: 0
  subscribers: 0
relations:
  out: 3
  referenced_by: 0
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 30121 "Shpfy Orders to Import"

> Table 30121 "Shpfy Orders to Import" in Shopify (Microsoft.Integration.Shopify). 34 fields, 3 public procedures. Introduced in BC29, still in BC30.

Shopify · Microsoft.Integration.Shopify · captioned "Shopify Orders to Import" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Shopify/app/src/Order%20handling/Tables/ShpfyOrdersToImport.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 30121 "Shpfy Orders to Import"](../page/30121.md) (1 Learn page).

## Properties

| Property | Value |
|---|---|
| Caption | Shopify Orders to Import |
| Access | Internal |
| DataClassification | CustomerContent |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Entry No. | Integer | — | not editable; AutoIncrement; DataClassification SystemMetadata |
| 2 | Shop Id | Integer | — | not editable |
| 3 | Shop Code | Code[20] | Specifies the Shopify Shop from which the order originated. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | TableRelation [Table 30102 "Shpfy Shop"](../table/30102.md) ("Shpfy Shop".Code where("Shop Id" = field("Shop Id"))) |
| 4 | Id | BigInteger | Specifies the id for the order in Shopify. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable |
| 5 | Order No. | Text[50] | Specifies the order number from Shopify. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> |  |
| 6 | Created At | DateTime | Specifies the autogenerated date and time when the order was created in Shopify. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable |
| 7 | Updated At | DateTime | Specifies the date and time when the order was last modified in Shopify. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable |
| 8 | Test | Boolean | Specifies if this is an test order. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable |
| 9 | Confirmed | Boolean | Specifies whether the order has been confirmed. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable |
| 10 | Fully Paid | Boolean | Specifies the order from Shopify is fully paid. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable |
| 11 | Unpaid | Boolean | Specifies the order from Shopify is unpaid. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable |
| 12 | Risk Level | enum "Shpfy Risk Level" | — | obsolete Removed 28.0; #if not CLEANSCHEMA28; enum [Enum 30126 "Shpfy Risk Level"](../enum/30126.md); not editable |
| 13 | Financial Status | enum "Shpfy Financial Status" | Specifies the status of payments associated with the order. Valid values are: pending, authorized, partially_paid, paid, partially_refunded, refunded, voided. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | enum [Enum 30117 "Shpfy Financial Status"](../enum/30117.md); not editable |
| 14 | Fulfillment Status | enum "Shpfy Order Fulfill. Status" | Specifies the order's status in terms of fulfilled line items. Valid values are: Fulfilled, null, partial, restocked. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | enum [Enum 30113 "Shpfy Order Fulfill. Status"](../enum/30113.md); not editable |
| 15 | Order Amount | Decimal | Specifies the sum of the line amounts on all lines in the document minus any discount amounts. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable |
| 16 | Currency Code | Code[10] | Specifies the currency code from Shopify. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable |
| 17 | Total Quantity of Items | Integer | Specifies the sum of the line quantities on all lines in the document. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable |
| 18 | Number of Order Lines | Integer | — | not editable |
| 19 | Tags | Text[2048] | Specifies the tags that are set on this Shopify order. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable |
| 20 | Attribute Key Filter | Text[100] | — | FlowFilter |
| 21 | Attribute Key Exists | Boolean | — | FlowField: exist("Shpfy Order Attribute" where("Order Id" = field(Id), "Key" = field("Attribute Key Filter"))) |
| 22 | Channel Name | Text[100] | Specifies the name of the channel where you sell your products. A channel can be a platform or a marketplace such as an online store or POS. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | TableRelation [Table 30160 "Shpfy Sales Channel"](../table/30160.md) ("Shpfy Sales Channel".Name where("Shop Code" = field("Shop Code"))); not editable; DataClassification SystemMetadata |
| 23 | Purchasing Entity | Enum "Shpfy Order Purchasing Entity" | Specifies the purchasing entity from Shopify. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | enum [Enum 30150 "Shpfy Order Purchasing Entity"](../enum/30150.md); not editable |
| 24 | High Risk | Boolean | — | not editable; DataClassification SystemMetadata |
| 25 | Sell-to Country/Region Code | Code[20] | — |  |
| 26 | Ship-to Country/Region Code | Code[20] | — |  |
| 27 | Bill-to Country/Region Code | Code[20] | — |  |
| 28 | VAT Amount | Decimal | — | DataClassification SystemMetadata |
| 29 | Presentment VAT Amount | Decimal | — | DataClassification SystemMetadata |
| 30 | Channel Liable Taxes | Boolean | Specifies if any tax line on the order is liable to be collected by the sales channel. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable; DataClassification SystemMetadata |
| 100 | Import Action | Enum "Shpfy Import Action" | Specifies the action to take for this order. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | enum [Enum 30100 "Shpfy Import Action"](../enum/30100.md); not editable |
| 102 | Has Error | Boolean | Specifies if this order have processing errors. <small>via [Page 30121 "Shpfy Orders to Import"](../page/30121.md)</small> | not editable; DataClassification SystemMetadata |
| 103 | Error Message | Blob | — | DataClassification SystemMetadata |
| 104 | Error Call Stack | Blob | — | DataClassification SystemMetadata |

## Keys

- PK: Entry No. (clustered)
- Idx1: Id, Shop Id

## Procedures

- `SetErrorInfo()` (internal): Description for SetErrorMessage.
- `GetErrorMessage(): Text` (internal): Description for GetErrorMessage.
- `GetErrorCallStack(): Text` (internal): Description for GetErrorCallStack.

## Relations

- Shop Code: TableRelation [Table 30102 "Shpfy Shop"](../table/30102.md)
- Attribute Key Exists: CalcFormula [Table 30116 "Shpfy Order Attribute"](../table/30116.md)
- Channel Name: TableRelation [Table 30160 "Shpfy Sales Channel"](../table/30160.md)

## Pages and codeunits on this table

- [Page 30121 "Shpfy Orders to Import"](../page/30121.md) (source table)
- [Codeunit 30161 "Shpfy Import Order"](../codeunit/30161.md) (codeunit runs on it)

## Across versions

- Present in: BC29-30
- Changed (declaration) in: none

## Deprecations

- field Risk Level: Removed 28.0 (#if not CLEANSCHEMA28), "This field is not imported. Use field"

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Shpfy Orders to Import")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.