Excel Add-In for BCart

Build 22.0.8503

ProductSets

Returns data from ProductSets table.

Select

The 本製品 will use the BCart API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • Most of the columns support the following operators: <, >, <=, >=, =, !=, IN, NOT_IN.
  • Custom field columns support the following operator: =.
  • GroupPrice1Name, GroupPrice1Rate and each GroupPrice number columns does not support server side operators.
For example, the following query is processed server side: 
    SELECT * FROM ProductSets WHERE Name = 'Sample ProductSets'
    SELECT * FROM ProductSets WHERE Id IN (1,10)
    SELECT * FROM ProductSets WHERE UpdatedAt <= '2019-09-26 09:20:45'

Insert

To add a ProductSets, specify Name, ProductId, UnitPrice and the non-read-only columns. 

    INSERT INTO ProductSets(Name,ProductId,UnitPrice)VALUES('Sample Product Set',2,1000)

Bulk Insert


    INSERT INTO ProductSets#TEMP (Name,ProductId,UnitPrice) VALUES('Sample Product Set 1',2,1000)
    INSERT INTO ProductSets#TEMP (Name,ProductId,UnitPrice) VALUES('Sample Product Set 2',2,1000)
    INSERT INTO ProductSets (Name,ProductId,UnitPrice) SELECT Name,ProductId,UnitPrice FROM ProductSets#TEMP

Update

BCart allows updates for Name, ProductId, UnitPrice and the non-read-only columns. 

    UPDATE ProductSets SET Name = 'Sample Product Set' WHERE Id = 2

Bulk Update


    INSERT INTO ProductSets#TEMP (Id,Name,UnitPrice) VALUES(1,'Sample Product Set 1',2000)
    INSERT INTO ProductSets#TEMP (Id,Name,UnitPrice) VALUES(2,'Sample Product Set 2',3000)
    UPDATE ProductSets (Id,Name,UnitPrice) SELECT Id,Name,UnitPrice FROM ProductSets#TEMP

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

ProductId Integer False

ProductNo String False

JanCode String False

LocationNo String False

JodaiType String False

Jodai Integer False

Name String False

UnitPrice Decimal False

MinOrder Integer False

MaxOrder Integer False

GroupPrice1Name String False

GroupPrice1Rate String False

GroupPrice1UnitPrice Decimal False

GroupPrice1FixedPrice Decimal False

GroupPrice1VolumeDiscount String False

GroupPrice2Name String False

GroupPrice2Rate String False

GroupPrice2UnitPrice Decimal False

GroupPrice2FixedPrice Decimal False

GroupPrice2VolumeDiscount String False

GroupPrice3Name String False

GroupPrice3Rate String False

GroupPrice3UnitPrice Decimal False

GroupPrice3FixedPrice Decimal False

GroupPrice3VolumeDiscount String False

GroupPrice4Name String False

GroupPrice4Rate String False

GroupPrice4UnitPrice Decimal False

GroupPrice4FixedPrice Decimal False

GroupPrice4VolumeDiscount String False

GroupPrice5Name String False

GroupPrice5Rate String False

GroupPrice5UnitPrice Decimal False

GroupPrice5FixedPrice Decimal False

GroupPrice5VolumeDiscount String False

GroupPrice6Name String False

GroupPrice6Rate String False

GroupPrice6UnitPrice Decimal False

GroupPrice6FixedPrice Decimal False

GroupPrice6VolumeDiscount String False

GroupPrice7Name String False

GroupPrice7Rate String False

GroupPrice7UnitPrice Decimal False

GroupPrice7FixedPrice Decimal False

GroupPrice7VolumeDiscount String False

GroupPrice8Name String False

GroupPrice8Rate String False

GroupPrice8UnitPrice Decimal False

GroupPrice8FixedPrice Decimal False

GroupPrice8VolumeDiscount String False

GroupPrice9Name String False

GroupPrice9Rate String False

GroupPrice9UnitPrice Decimal False

GroupPrice9FixedPrice Decimal False

GroupPrice9VolumeDiscount String False

GroupPrice10Name String False

GroupPrice10Rate String False

GroupPrice10UnitPrice Decimal False

GroupPrice10FixedPrice Decimal False

GroupPrice10VolumeDiscount String False

GroupPriceNName String False

GroupPriceNRate String False

GroupPriceNUnitPrice Decimal False

GroupPriceNFixedPrice Decimal False

GroupPriceNVolumeDiscount String False

SpecialPrice String False

VolumeDiscount String False

Quantity Integer False

Unit String False

Description String False

Stock Integer False

StockFlag Integer False

StockParent String False

StockViewId Integer False

StockFew Integer False

ViewGroupFilter String False

VisibleCustomerId String False

OptionIds String False

ShippingGroupId Integer False

ShippingSize Integer False

Priority Integer False

SetFlag String False

TaxTypeId Integer False

UpdatedAt Datetime False

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8503