SSIS Components for Qoo10

Build 22.0.8397

GoodsInventoryOption

Retrieve and query information related GoodsInventory info.

Select

The {i will use the Qoo10 API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the {i.

  • ItemNo supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM GoodsInventoryOption WHERE ItemNo=621050268
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Insert

Required fields for an insert are ItemNo, Name1, Value1, Price and Quantity.
Optional: Name2, Value2, Name3, Value3, ItemTypeCode.

INSERT INTO GoodsInventoryOption (ItemNo, Name1, Value1, Price, Quantity) values ('621050268','Color', 'Red', '93', '971')

Update

Qoo10 allows updates for the Price and Quantity columns.

UPDATE GoodsInventoryOption SET Price=172,Quantity=332 WHERE ItemNo=621068441
UPDATE GoodsInventoryOption SET Price=172,Quantity=332 WHERE ItemNo=621068441 AND ItemTypeCode='CD0000091'
UPDATE GoodsInventoryOption SET Price=150,Quantity=150 WHERE ItemNo=621050268 AND OptionNo='Size:-:XL:-:Color:-:Blue'

Delete

GoodsInventoryOption can be deleted by providing the ItemNo or ItemNo and ItemTypeCode or ItemNo and OptionNo.

DELETE FROM GoodsInventoryOption WHERE ItemNo=621068441
DELETE FROM GoodsInventoryOption WHERE ItemNo=621068441 AND ItemTypeCode='CD0000091'
DELETE FROM GoodsInventoryOption WHERE ItemNo=625522959 AND OptionNo='Color:-:Red'

Columns

Name Type ReadOnly Description
ItemNo [KEY] String True

The item code of Qoo10.

OptionNo [KEY] String True

Code of the option.

Name1 String True

OptionName1

Value1 String True

OptionValue1

Name2 String True

OptionName2

Value2 String True

OptionValue2

Name3 String True

OptionName3

Value3 String True

OptionValue3

Price Decimal False

OptionPrice

Quantity Integer False

Quantity

ItemTypeCode String False

Item Type Code

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8397