CData JDBC Driver for Magento 2019 - Online Help
Questions / Feedback?

Inventory

CData JDBC Driver for Magento 2019 - Build 19.0.7354

Update and query the available inventory in Magento.

Select

The Inventory table supports server-side processing for all columns in the WHERE clause. Most of these columns support server-side processing for the >, >=, <, <=, =, IN, and NOT IN operators.

The driver will use the Magento API to filter the results with these operators while the rest of the filter is executed client side within the driver. You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that invokes other operators will cause an error.

For example, the following query is processed server side:

SELECT * FROM Inventory WHERE ProductId IN (300,301,302,316) AND Qty >=10 AND Qty <=100 AND IsDecimalDivided = 'True' ORDER BY Qty ASC

Insert

Magento does not allow Inventory items to be added.

Update

The Inventory table allows updates for all columns except ItemId, ProductId, and StockId.

UPDATE Inventory SET UseConfigMinQty=2, ProductId=232, StockId=2, Qty=1000, IsQtyDecimal=1, MinSaleQty=99 WHERE ItemId=366

Delete

Magento does not allow Inventory items to be deleted.

Columns

Name Type ReadOnly Description
ItemId [KEY] Integer True

The unique identifier of the item.

ProductId Integer True

The unique identifier of the product.

StockId Integer True

The unique identifier of the stock.

Qty Double False

Quantity of in-stock items for the current product

MinQty Double False

Quantity for in-stock items to become out of stock

UseConfigMinQty Boolean False

Choose whether the Config settings will be applied for the MinQty column.

The allowed values are False, True.

IsQtyDecimal Boolean False

Choose whether the product can be sold using decimals (e.g., you can buy 2.5 products)

Backorders Integer False

Defines whether the customer can place the order for products that are out of stock at the moment (0 - No Backorders, 1 - Allow Qty Below 0, and 2 - Allow Qty Below 0 and Notify Customer).

The allowed values are 0, 1, 2.

UseConfigBackorders Boolean False

Choose whether the Config settings will be applied for the Backorders column.

MinSaleQty Double False

Minimum number of items in the shopping cart to be sold.

UseConfigMinSaleQty Boolean False

Choose whether the Config settings will be applied for the MinSaleQty column.

MaxSaleQty Double False

Maximum number of items in the shopping cart to be sold.

UseConfigMaxSaleQty Boolean False

Choose whether the Config settings will be applied for the MaxSaleQty column.

IsInStock Boolean False

Defines whether the product is available for selling (False - Out of Stock; True - In Stock).

The allowed values are False, True.

LowStockDate Datetime False

Date when the number of in-stock items became lower than NotifyStockQty.

NotifyStockQty Double False

The number of inventory items below which the customer will be notified via the RSS feed.

UseConfigNotifyStockQty Boolean False

Choose whether the Config settings will be applied for the NotifyStockQty column.

The allowed values are False, True.

ManageStock Boolean False

Choose whether to view and specify the product quantity and availability and whether the product is in stock management ( False - No; True - Yes).

The allowed values are False, True.

UseConfigManageStock Boolean False

Choose whether the Config settings will be applied for the ManageStock column.

The allowed values are False, True.

StockStatusChangedAuto Boolean False

Defines whether products can be automatically returned to stock when the refund for an order is created.

The allowed values are False, True.

UseConfigQtyIncrements Boolean False

Choose whether the Config settings will be applied for the QtyIncrements column

QtyIncrements Double False

The product quantity increment value.

UseConfigEnableQtyInc Boolean False

Choose whether the Config settings will be applied for the EnableQtyIncrements column.

The allowed values are False, True.

EnableQtyIncrements Boolean False

Defines whether the customer can add products only in increments to the shopping cart.

The allowed values are False, True.

IsDecimalDivided Boolean False

Defines whether the stock items can be divided into multiple boxes for shipping.

The allowed values are False, True.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0