Shopify Connector
Documentation
Version: 2
Documentation
Home » API Integration Hub » Shopify Connector » EndPoints > Create an Order

EndPoint Create an Order

Name

post_order

Description

Creates a new order. [API reference]

Parameters

Parameter Label Required Options Description
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_I8 bigint False
BillingAddressLine1 DT_WSTR nvarchar(255) 255 False
BillingAddressLine2 DT_WSTR nvarchar(255) 255 False
BillingAddressCity DT_WSTR nvarchar(255) 255 False
BillingAddressCompany DT_WSTR nvarchar(255) 255 False
BillingAddressCountry DT_WSTR nvarchar(255) 255 False
BillingAddressFirstName DT_WSTR nvarchar(255) 255 False
BillingAddressLastName DT_WSTR nvarchar(255) 255 False
BillingAddressPhone DT_WSTR nvarchar(255) 255 False
BillingAddressProvince DT_WSTR nvarchar(255) 255 False
BillingAddressZip DT_WSTR nvarchar(255) 255 False
BillingAddressName DT_WSTR nvarchar(255) 255 False
BillingAddressProvinceCode DT_WSTR nvarchar(255) 255 False
BillingAddressCountryCode DT_WSTR nvarchar(255) 255 False
BillingAddressLatitude DT_WSTR nvarchar(255) 255 False
BillingAddressLongitude DT_WSTR nvarchar(255) 255 False
BrowserIp DT_WSTR nvarchar(255) 255 False
BuyerAcceptsMarketing DT_BOOL bit False
LineItems DT_NTEXT nvarchar(MAX) True
CancelReason DT_WSTR nvarchar(255) 255 False
CancelledAt DT_WSTR nvarchar(255) 255 False
CartToken DT_WSTR nvarchar(255) 255 False
CheckoutToken DT_WSTR nvarchar(255) 255 False
ClientDetailsAcceptLanguage DT_WSTR nvarchar(255) 255 False
ClientDetailsBrowserHeight DT_I4 int False
ClientDetailsBrowserIp DT_WSTR nvarchar(255) 255 False
ClientDetailsBrowserWidth DT_I4 int False
ClientDetailsSessionHash DT_WSTR nvarchar(255) 255 False
ClientDetailsUserAgent DT_WSTR nvarchar(255) 255 False
ClosedAt DT_WSTR nvarchar(255) 255 False
CompanyId DT_I8 bigint False
CompanyLocationId DT_I8 bigint False
CreatedAt DT_WSTR nvarchar(255) 255 False
Currency DT_WSTR nvarchar(255) 255 False
CurrentTotalDiscounts DT_WSTR nvarchar(255) 255 False
CurrentTotalDiscountsShopMoneyAmount DT_WSTR nvarchar(255) 255 False
CurrentTotalDiscountsShopMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
CurrentTotalDiscountsPresentmentMoneyAmount DT_WSTR nvarchar(255) 255 False
CurrentTotalDiscountsPresentmentMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
CurrentTotalDutiesShopMoneyAmount DT_WSTR nvarchar(255) 255 False
CurrentTotalDutiesShopMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
CurrentTotalDutiesPresentmentMoneyAmount DT_WSTR nvarchar(255) 255 False
CurrentTotalDutiesPresentmentMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
CurrentTotalPrice DT_WSTR nvarchar(255) 255 False
CurrentTotalPriceShopMoneyAmount DT_WSTR nvarchar(255) 255 False
CurrentTotalPriceShopMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
CurrentTotalPricePresentmentMoneyAmount DT_WSTR nvarchar(255) 255 False
CurrentTotalPricePresentmentMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
CurrentSubtotalPrice DT_WSTR nvarchar(255) 255 False
CurrentSubtotalPriceShopMoneyAmount DT_WSTR nvarchar(255) 255 False
CurrentSubtotalPriceShopMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
CurrentSubtotalPricePresentmentMoneyAmount DT_WSTR nvarchar(255) 255 False
CurrentSubtotalPricePresentmentMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
CurrentTotalTax DT_WSTR nvarchar(255) 255 False
CurrentTotalTaxShopMoneyAmount DT_WSTR nvarchar(255) 255 False
CurrentTotalTaxShopMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
CurrentTotalTaxPresentmentMoneyAmount DT_WSTR nvarchar(255) 255 False
CurrentTotalTaxPresentmentMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
CustomerId DT_I8 bigint False
CustomerLocale DT_WSTR nvarchar(255) 255 False
Email DT_WSTR nvarchar(255) 255 False
EstimatedTaxes DT_BOOL bit False
FinancialStatus DT_WSTR nvarchar(255) 255 False
FulfillmentStatus DT_WSTR nvarchar(255) 255 False
LandingSite DT_WSTR nvarchar(255) 255 False
LocationId DT_I8 bigint False
MerchantOfRecordAppId DT_I8 bigint False
Name DT_WSTR nvarchar(255) 255 False
Note DT_NTEXT nvarchar(MAX) False
Number DT_I4 int False
OrderNumber DT_I4 int False
OriginalTotalDutiesShopMoneyAmount DT_WSTR nvarchar(255) 255 False
OriginalTotalDutiesShopMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
OriginalTotalDutiesPresentmentMoneyAmount DT_WSTR nvarchar(255) 255 False
OriginalTotalDutiesPresentmentMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
PaymentTermsAmount DT_DECIMAL decimal(0,5) False
PaymentTermsCurrency DT_WSTR nvarchar(255) 255 False
PaymentTermsName DT_WSTR nvarchar(255) 255 False
PaymentTermsType DT_WSTR nvarchar(255) 255 False
PaymentTermsDueInDays DT_I4 int False
Phone DT_WSTR nvarchar(255) 255 False
PresentmentCurrency DT_WSTR nvarchar(255) 255 False
ProcessedAt DT_WSTR nvarchar(255) 255 False
ProcessingMethod DT_WSTR nvarchar(255) 255 False
ReferringSite DT_WSTR nvarchar(255) 255 False
ShippingAddressLine1 DT_WSTR nvarchar(255) 255 False
ShippingAddressLine2 DT_WSTR nvarchar(255) 255 False
ShippingAddressCity DT_WSTR nvarchar(255) 255 False
ShippingAddressCompany DT_WSTR nvarchar(255) 255 False
ShippingAddressCountry DT_WSTR nvarchar(255) 255 False
ShippingAddressFirstName DT_WSTR nvarchar(255) 255 False
ShippingAddressLastName DT_WSTR nvarchar(255) 255 False
ShippingAddressPhone DT_WSTR nvarchar(255) 255 False
ShippingAddressProvince DT_WSTR nvarchar(255) 255 False
ShippingAddressZip DT_WSTR nvarchar(255) 255 False
ShippingAddressName DT_WSTR nvarchar(255) 255 False
ShippingAddressProvinceCode DT_WSTR nvarchar(255) 255 False
ShippingAddressCountryCode DT_WSTR nvarchar(255) 255 False
ShippingAddressLatitude DT_WSTR nvarchar(255) 255 False
ShippingAddressLongitude DT_WSTR nvarchar(255) 255 False
SourceName DT_WSTR nvarchar(255) 255 False
SourceIdentifier DT_WSTR nvarchar(255) 255 False
SourceUrl DT_WSTR nvarchar(255) 255 False
SubtotalPrice DT_DECIMAL decimal(0,5) False
SubtotalPriceSetShopMoneyAmount DT_WSTR nvarchar(255) 255 False
SubtotalPriceSetShopMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
SubtotalPriceSetPresentmentMoneyAmount DT_WSTR nvarchar(255) 255 False
SubtotalPriceSetPresentmentMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
Tags DT_NTEXT nvarchar(MAX) False
TaxesIncluded DT_BOOL bit False
Test DT_BOOL bit False
Token DT_WSTR nvarchar(255) 255 False
TotalDiscounts DT_WSTR nvarchar(255) 255 False
TotalDiscountsSetShopMoneyAmount DT_WSTR nvarchar(255) 255 False
TotalDiscountsSetShopMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
TotalDiscountsSetPresentmentMoneyAmount DT_WSTR nvarchar(255) 255 False
TotalDiscountsSetPresentmentMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
TotalLineItemsPrice DT_WSTR nvarchar(255) 255 False
TotalLineItemsPriceSetShopMoneyAmount DT_WSTR nvarchar(255) 255 False
TotalLineItemsPriceSetShopMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
TotalLineItemsPriceSetPresentmentMoneyAmount DT_WSTR nvarchar(255) 255 False
TotalLineItemsPriceSetPresentmentMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
TotalOutstanding DT_WSTR nvarchar(255) 255 False
TotalPrice DT_WSTR nvarchar(255) 255 False
TotalPriceSetShopMoneyAmount DT_WSTR nvarchar(255) 255 False
TotalPriceSetShopMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
TotalPriceSetPresentmentMoneyAmount DT_WSTR nvarchar(255) 255 False
TotalPriceSetPresentmentMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
TotalShippingPriceSetShopMoneyAmount DT_WSTR nvarchar(255) 255 False
TotalShippingPriceSetShopMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
TotalShippingPriceSetPresentmentMoneyAmount DT_WSTR nvarchar(255) 255 False
TotalShippingPriceSetPresentmentMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
TotalTax DT_WSTR nvarchar(255) 255 False
TotalTaxSetShopMoneyAmount DT_WSTR nvarchar(255) 255 False
TotalTaxSetShopMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
TotalTaxSetPresentmentMoneyAmount DT_WSTR nvarchar(255) 255 False
TotalTaxSetPresentmentMoneyCurrencyCode DT_WSTR nvarchar(255) 255 False
TotalTipReceived DT_WSTR nvarchar(255) 255 False
TotalWeight DT_DECIMAL decimal(0,5) False
UpdatedAt DT_WSTR nvarchar(255) 255 False
UserId DT_I8 bigint False
OrderStatusUrl DT_WSTR nvarchar(255) 255 False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
BillingAddressLine1 DT_WSTR nvarchar(255) 255 False
BillingAddressLine2 DT_WSTR nvarchar(255) 255 False
BillingAddressCity DT_WSTR nvarchar(255) 255 False
BillingAddressCompany DT_WSTR nvarchar(255) 255 False
BillingAddressCountry DT_WSTR nvarchar(255) 255 False
BillingAddressFirstName DT_WSTR nvarchar(255) 255 False
BillingAddressLastName DT_WSTR nvarchar(255) 255 False
BillingAddressPhone DT_WSTR nvarchar(255) 255 False
BillingAddressProvince DT_WSTR nvarchar(255) 255 False
BillingAddressZip DT_WSTR nvarchar(255) 255 False
BillingAddressName DT_WSTR nvarchar(255) 255 False
BillingAddressProvinceCode DT_WSTR nvarchar(255) 255 False
BillingAddressCountryCode DT_WSTR nvarchar(255) 255 False
BillingAddressLatitude DT_WSTR nvarchar(255) 255 False
BillingAddressLongitude DT_WSTR nvarchar(255) 255 False
BuyerAcceptsMarketing DT_BOOL bit False
LineItems DT_NTEXT nvarchar(MAX) True
CustomerId DT_I8 bigint False
Email DT_WSTR nvarchar(255) 255 False
EstimatedTaxes DT_BOOL bit False
FinancialStatus DT_WSTR nvarchar(255) 255 False
FulfillmentStatus DT_WSTR nvarchar(255) 255 False
LocationId DT_I8 bigint False
MerchantOfRecordAppId DT_I8 bigint False
Name DT_WSTR nvarchar(255) 255 False
Note DT_NTEXT nvarchar(MAX) False
Phone DT_WSTR nvarchar(255) 255 False
Currency DT_WSTR nvarchar(255) 255 False
PresentmentCurrency DT_WSTR nvarchar(255) 255 False
ProcessedAt DT_WSTR nvarchar(255) 255 False
ReferringSite DT_WSTR nvarchar(255) 255 False
ShippingAddressLine1 DT_WSTR nvarchar(255) 255 False
ShippingAddressLine2 DT_WSTR nvarchar(255) 255 False
ShippingAddressCity DT_WSTR nvarchar(255) 255 False
ShippingAddressCompany DT_WSTR nvarchar(255) 255 False
ShippingAddressCountry DT_WSTR nvarchar(255) 255 False
ShippingAddressFirstName DT_WSTR nvarchar(255) 255 False
ShippingAddressLastName DT_WSTR nvarchar(255) 255 False
ShippingAddressPhone DT_WSTR nvarchar(255) 255 False
ShippingAddressProvince DT_WSTR nvarchar(255) 255 False
ShippingAddressZip DT_WSTR nvarchar(255) 255 False
ShippingAddressName DT_WSTR nvarchar(255) 255 False
ShippingAddressProvinceCode DT_WSTR nvarchar(255) 255 False
ShippingAddressCountryCode DT_WSTR nvarchar(255) 255 False
ShippingAddressLatitude DT_WSTR nvarchar(255) 255 False
ShippingAddressLongitude DT_WSTR nvarchar(255) 255 False
SourceName DT_WSTR nvarchar(255) 255 False
SourceIdentifier DT_WSTR nvarchar(255) 255 False
SourceUrl DT_WSTR nvarchar(255) 255 False
Tags DT_NTEXT nvarchar(MAX) False
TaxesIncluded DT_BOOL bit False
TotalWeight DT_DECIMAL decimal(0,5) False
UserId DT_I8 bigint False
InventoryBehaviour DT_WSTR nvarchar(255) 255 False
SendReceipt DT_BOOL bit False
SendFulfillmentReceipt DT_BOOL bit False
Required columns that you need to supply are bolded.