JDBC Driver for BigCommerce

Build 24.0.9062

ProductVariants

Returns data from Products table.

Table Specific Information

Select


SELECT * FROM ProductVariants

Insert

To create a new ProductVariant, a set of OptionValues are required to be inserted along with it. This can be done by populating a temporary ProductVariantValues table with the desired values for the option you are creating, and later using this table as a value for the LinkedOptionValues Pseudo-Columns during insertion:

INSERT INTO ProductVariantValues#TEMP (Id, OptionId, Label, DisplayName) VALUES (181, 118, 'Elegance', 'Series');
INSERT INTO ProductVariants (ProductId, LinkedOptionValues, SKU) VALUES (955, ProductVariantValues#TEMP, 'DSFMGG');

Update


UPDATE ProductVariants SET Weight='23' where Id=64

Delete


DELETE FROM ProductVariants WHERE Id = 3

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

The ID of the product variant.

ProductId [KEY] Integer True

Products.Id

The ID of the product.

SKU String False

User defined product code/stock keeping unit (SKU).

SKU_ID String False

The ID for User defined product code/stock keeping unit (SKU).

Price Decimal False

The price of the product variant. The price should include or exclude tax, based on the store settings.

CalculatedPrice Integer False

The variant’s calculated price on the storefront.

SalePrice Integer False

The variant’s sale price on the storefront.

RetailPrice Integer False

The variant’s retail price on the storefront.

MapPrice Integer False

The Minimum Advertised Price.

Weight String False

This variant’s base weight on the storefront. If this value is null, the product’s default weight (set in the Product resource’s weight field) will be used as the base weight.

Calculated_Weight Integer False

The variant’s calculated weight on the storefront.

Width Long False

Width of the variant, which can be used when calculating shipping costs.

Height Long False

The Height of the variant, which can be used when calculating shipping costs.

Depth Long False

The Depth of the variant, which can be used when calculating shipping costs.

Is_Free_Shipping Boolean False

The Flag used to indicate whether the variant has free shipping. If true, the shipping cost for the variant will be zero.

FixedCostShippingPrice Integer False

The fixed shipping cost for the variant. If defined, this value will be used during checkout instead of normal shipping-cost calculation.

Purchasing_Disabled String False

Accepts AvaTax System Tax Codes, which identify products and services that fall into special sales-tax categories.

Purchasing_Disabled_Message String False

Accepts AvaTax System Tax Codes, which identify products and services that fall into special sales-tax categories.

Image_Url String False

The Image url for the variant.

CostPrice Integer False

The cost price of the variant.

Upc String False

The UPC code used in feeds for shopping comparison sites and external channel integrations.

Mpn String False

The Manufacturer Part Number (MPN) for the variant.

Gtin String False

The Global Trade Item Number.

InventoryLevel Integer False

The Inventory level for the variant, which is used when the product’s inventory_tracking is set to variant.

InventoryWarningLevel Integer False

The Inventory warning level for the product

BinPickingNumber String False

Identifies where in a warehouse the variant is located.

LinkedOptionValues String False

The Option Value Id.

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