Excel Add-In for BCart

Build 22.0.8503

Products

Returns data from Products 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: =.
  • SubImages1Image, SubImages1Caption and each SubImages number columns does not support server side operators.
For example, the following query is processed server side:
    SELECT * FROM Products WHERE Name = 'Sample Product'
    SELECT * FROM Products WHERE Id IN (1,10)
    SELECT * FROM Products WHERE UpdatedAt <= '2019-09-26 09:20:45'

Insert

To add a Products, specify Name, CategoryId and the non-read-only columns.

    INSERT INTO Products(Name,CategoryId)VALUES('Sample Product',2)

Bulk Insert


    INSERT INTO Products#TEMP (Name,CategoryId) VALUES('Sample Product 1',2)
    INSERT INTO Products#TEMP (Name,CategoryId) VALUES('Sample Product 2',2)
    INSERT INTO Products (Name,CategoryId) SELECT Name,CategoryId FROM Products#TEMP

Update

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

    UPDATE Products SET Name = 'Sample Product' WHERE Id = 2

Bulk Update


    INSERT INTO Products#TEMP (Id,Name,CategoryId) VALUES(1,'Sample Product 1',2)
    INSERT INTO Products#TEMP (Id,Name,CategoryId) VALUES(2,'Sample Product 2',2)
    UPDATE Products (Id,Name,CategoryId) SELECT Id,Name,CategoryId FROM Products#TEMP

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

MainNo String False

Name String False

CatchCopy String False

CategoryId Integer False

SubCategoryId String False

FeatureId1 Integer False

FeatureId2 Integer False

FeatureId3 Integer False

MadeIn String False

Size String False

Sozai String False

Caution String False

Tag String False

Description String False

MetaTitle String False

MetaKeywords String False

MetaDescription String False

Image String False

ViewGroupFilter String False

VisibleCustomerId String False

PrependText String False

AppendText String False

MiddleText String False

RvPrependText String False

RvAppendText String False

RvMiddleText String False

FileDownload String False

HanbaiStart Datetime False

HanbaiEnd Datetime False

RecommendProductId String False

ViewPattern Integer False

Priority Integer False

Flag String False

UpdatedAt Datetime False

SubImages1Image String False

SubImages1Caption String False

SubImages2Image String False

SubImages2Caption String False

SubImages3Image String False

SubImages3Caption String False

SubImages4Image String False

SubImages4Caption String False

SubImages5Image String False

SubImages5Caption String False

SubImages6Image String False

SubImages6Caption String False

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