Excel Add-In for BigCommerce

Build 23.0.8839


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

Table Specific Information


The 本製品 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


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


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


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 23.0.8839