SSIS Components for BigCommerce

Build 24.0.9060

ShippingConsignmentQuotes

Gets all shipping quotes persisted on an order for a shipping consignment.

Table Specific Information

Select

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

  • OrderId supports the '=' comparison.
  • ShippingConsignmentId supports the '=' comparison.

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

SELECT * FROM ShippingConsignmentQuotes WHERE OrderId = 123 and ShippingConsignmentId=234

Columns

Name Type References Description
Id Integer ID of the shipping quote.
OrderId Integer

Orders.Id

Identifier for the BigCommerce Order with which this transaction is associated.
ShippingConsignmentId Integer

ShippingConsignments.Id

ID of the shipping consignment.
UUID String UUID of the shipping quote.
Timestamp String Time the order was created in RFC 2822 format.
ProviderCode String Code of the shipping provider.
CarrierCode String Code of the shipping carrier.
RateCode String Type of delivery. This can vary based on shipping quote.
RateId String This can vary based on shipping quote.
MethodId Integer Shipping method ID.
ProviderQuoteRateValue Integer Provider quote's rate_value.
ProviderQuoteRateUnit String Provider quote's rate_unit.
ProviderQuoteName String Provider quote's name.
ProviderQuoteTransitTime Integer Provider quote's transitTime.
ProviderQuoteSignatureConfirmationFee String Provider quote's signatureConfirmationFee.
ProviderQuoteCarrierName String Provider quote's CarrierName.
ProviderQuoteDeliveryMessage String Provider quote's deliveryMessage.
ProviderQuoteLabelSizes String Provider quote's label sizes.
ProviderQuoteDates String Provider quote's dates.
ProviderQuoteInsuredMailFee String Provider quote's insuredMailFee.
ProviderQuoteRateId String Provider quote's rateId.
ProviderQuoteDescription String Provider quote's description.
ProviderQuoteAdditionalInfo String Provider quote's additionalInfo.

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