Shopify Connector
Documentation
Version: 2
Documentation
Endpoint

Create an Order

Name

post_order

Description

Creates a new order. [API reference]

Related Tables

Orders

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
If the column you are looking for is missing, consider customizing Shopify Connector.

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.

Examples

SSIS

Use Shopify Connector in API Source component to read data or in API Destination component to read/write data:

Insert into Orders table using API Destination

This Endpoint belongs to Orders table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Shopify
Orders
Insert
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Insert a new order record 

INSERT INTO Orders (BillingAddressLine1, BillingAddressLine2, BillingAddressCity, BillingAddressCompany, BillingAddressCountry, BillingAddressFirstName, BillingAddressLastName, BillingAddressPhone, BillingAddressProvince, BillingAddressZip, BillingAddressName, BillingAddressProvinceCode, BillingAddressCountryCode, BuyerAcceptsMarketing, LineItems, CustomerId, Email, EstimatedTaxes, FinancialStatus, FulfillmentStatus, Name, Note, Phone, Currency, PresentmentCurrency, ProcessedAt, ReferringSite, ShippingAddressLine1, ShippingAddressLine2, ShippingAddressCity, ShippingAddressCompany, ShippingAddressCountry, ShippingAddressFirstName, ShippingAddressLastName, ShippingAddressPhone, ShippingAddressProvince, ShippingAddressZip, ShippingAddressName, ShippingAddressProvinceCode, ShippingAddressCountryCode, Tags, TaxesIncluded, TotalWeight, SendReceipt, SendFulfillmentReceipt)
VALUES
('123 Main Street', 'Suite #54', 'Memphis', 'Acme, Inc.', 'United States', 'John', 'Doe', '4045559876', 'Tennessee', '38101', 'John Doe', 'GA', 'US', 1, '[{"title":"Super Strong Glue","price":24.99,"grams":"100","quantity":1,"tax_lines":[{"price":13.5,"rate":0.06,"title":"State tax"}]}]', 5945175474276, 'johndoe2@gmail.com', 1, 'pending', null, '#40294', 'This order needs to be expedited, so register it in the system as so.', '4045559876', 'USD', 'USD', '2023-02-27T11:00:00', 'https://referringsite.com', '123 Main Street', 'Suite #54', 'Memphis', 'Acme, Inc.', 'United States', 'John', 'Doe', '4045559876', 'Tennessee', '38101', 'John Doe', 'GA', 'US', NULL, 1, 20, 1, 1)

post_order endpoint belongs to Orders table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Insert a new order record 

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Orders (BillingAddressLine1, BillingAddressLine2, BillingAddressCity, BillingAddressCompany, BillingAddressCountry, BillingAddressFirstName, BillingAddressLastName, BillingAddressPhone, BillingAddressProvince, BillingAddressZip, BillingAddressName, BillingAddressProvinceCode, BillingAddressCountryCode, BuyerAcceptsMarketing, LineItems, CustomerId, Email, EstimatedTaxes, FinancialStatus, FulfillmentStatus, Name, Note, Phone, Currency, PresentmentCurrency, ProcessedAt, ReferringSite, ShippingAddressLine1, ShippingAddressLine2, ShippingAddressCity, ShippingAddressCompany, ShippingAddressCountry, ShippingAddressFirstName, ShippingAddressLastName, ShippingAddressPhone, ShippingAddressProvince, ShippingAddressZip, ShippingAddressName, ShippingAddressProvinceCode, ShippingAddressCountryCode, Tags, TaxesIncluded, TotalWeight, SendReceipt, SendFulfillmentReceipt)
VALUES
(''123 Main Street'', ''Suite #54'', ''Memphis'', ''Acme, Inc.'', ''United States'', ''John'', ''Doe'', ''4045559876'', ''Tennessee'', ''38101'', ''John Doe'', ''GA'', ''US'', 1, ''[{"title":"Super Strong Glue","price":24.99,"grams":"100","quantity":1,"tax_lines":[{"price":13.5,"rate":0.06,"title":"State tax"}]}]'', 5945175474276, ''johndoe2@gmail.com'', 1, ''pending'', null, ''#40294'', ''This order needs to be expedited, so register it in the system as so.'', ''4045559876'', ''USD'', ''USD'', ''2023-02-27T11:00:00'', ''https://referringsite.com'', ''123 Main Street'', ''Suite #54'', ''Memphis'', ''Acme, Inc.'', ''United States'', ''John'', ''Doe'', ''4045559876'', ''Tennessee'', ''38101'', ''John Doe'', ''GA'', ''US'', NULL, 1, 20, 1, 1)';

EXEC (@MyQuery) AT [LS_TO_SHOPIFY_IN_GATEWAY];

post_order endpoint belongs to Orders table(s), and can therefore be used via those table(s).