Excel Add-In for BigCommerce

Build 23.0.8839


Returns shipments and their corresponding orders.

Table Specific Information


The 本製品 uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the '=' comparison.
  • OrderId supports the '=, and IN' comparison.

The rest of the filter is executed client-side within the 本製品.

For example, the following queries are processed server-side:

SELECT * FROM OrderShipments WHERE Id = 1 

SELECT * FROM OrderShipments where OrderId=1428


To insert a new Order Shipment, at least one Shipment Item is required to be attached to the INSERT query. For this reason, you can first populate a temporary ShipmentItems table with the desired items for the shipment you are about to create, and later using this table as a value for the LinkedProducts Pseudo-Columns during insertion:

INSERT INTO ShipmentItems#TEMP (Id, Quantity) VALUES (2519, 1);
INSERT INTO OrderShipments (OrderId, OrderAddressId, LinkedProducts) VALUES (1106, 1007, ShipmentItems#TEMP);


Name Type ReadOnly References Description
Id [KEY] Integer True

Numeric ID of this shipment within this order.

OrderId Integer False


Numeric ID of the associated order.

DateCreated Datetime True

Creation date for the shipment.

TrackingNumber String False

Tracking number of the shipment.

TrackingCarrier String False

Tracking carrier for the shipment.

TrackingLink String True

Returns a tracking link from the shipping service.

ShippingProvider String False

Enum of the BigCommerce shipping-carrier integration/module.

ShippingMethod String False

Enum of the BigCommerce shipping-carrier integration/module.

Comments String False

Comments the shipper wishes to add.

OrderAddressId Integer False


ID of this shipping address.



Name Type Description
LinkedProducts String

Column for the aggregate table name holding order products.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839