SSIS Components for Qoo10

Build 22.0.8397

GoodsDetail

Retrieve and query information related goods.

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.
  • SellerCode supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM GoodsDetail WHERE ItemNo=625522959
SELECT * FROM GoodsDetail WHERE ItemNo=510833894 AND SellerCode='qoo10-201105-03'
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: ItemTitle, SecondSubCatCd, ImageUrl, ItemDetail, RetailPrice, SellPrice, ItemQty, ExpireDate, ShippingNo and AdultYN.
Optional: ContactTel, ManufacturerCd, BrandCd, SellerCode, IndustrialCode, ProductionPlace, AvailableDateType, AvailableDateValue.

INSERT INTO GoodsDetail  (ItemTitle,SecondSubCatCd,ImageUrl,ItemDetail,RetailPrice,SellPrice,ItemQty,ExpireDate,ShippingNo,AdultYN) VALUES('Insert test 22','300000113','https://gd.image-qoo10.jp/CDATAJ-CDATA-SAMPLE-BAG/ai/347/344/1105344347_00.g_80-w-st_g.jpg','Just for testing purpose 2.',41,120,21,'2019/12/12','0','N')

Update

Qoo10 allows updates for the ItemTitle,ItemStatus, ItemDetail, SellPrice, ItemQty, ImageUrl, SecondSubCatCd, ManufacturerCd,BrandCd,IndustrialCode,ProductionPlace and ContactTel columns.

 UPDATE GoodsDetail SET ItemDetail = 'Test', SecondSubCatCd='300000113' WHERE ItemNo=624988017

Delete

GoodsDetail can be deleted by providing the ItemNo.

DELETE FROM GoodsDetail WHERE ItemNo=625401830

Columns

Name Type ReadOnly Description
ItemNo [KEY] Integer True

The item code of Qoo10.

ItemTitle String False

Item Title

ItemStatus String False

Item Status. Possible values are: (1 : On Queue, 2 : Available, 3 : Deleted)

MainCatCd String True

Item's main category code of the Qoo10. (ex.100000001)

MainCatNm String True

Item's main category name of the Qoo10. (ex.Women's Clothing)

FirstSubCatCd String True

Item's sub-category code of the Qoo10. (ex.200000001)

FirstSubCatNm String True

Item's sub-category category name of the Qoo10. (ex.Dresses)

SecondSubCatCd String False

Item's 2nd sub-category code of the Qoo10. (ex.300000001)

SecondSubCatNm String True

Item's sub-category category name of the Qoo10. (ex.Dresses)

SellerCode String False

Item code managed by the seller.

IndustrialCode String False

Industrial Code such as JAN Code or ISBN etc. If you fill in the standard code, the item would be exposed in the price comparison sites.

RetailPrice Decimal False

Reference price of the item.

SellPrice Decimal False

Price of the item.

SettlePrice Decimal True

Settle price of the item.

ItemQty Integer False

Available item Qty

ExpireDate Date True

Expiry date to sell the item Please input with this format (yyyy-mm-dd). If you input

ManufacturerCd String False

Manufacturer code that is registered in Qoo10. (ex. 21750)

ManufacturerNm String True

Manufacturer name that is registered in Qoo10.

BrandCd String False

Brand code that is registered in Qoo10. (ex. 21750)

BrandNm String True

Brand name that is registered in Qoo10.

AdultYN String False

If the item is an adult product, the value is 'Y'. If not, the value is 'N'

ShippingNo Intiger False

Qoo10 Shipping fee code.

ContactTel String False

Contact number of the seller.

ItemDetail String False

Description of the item.

ImageUrl String False

The Standard image of item.

ProductionPlace String False

Place of production.

AvailableDateType String True

Information of the available shipping date type ( null : do not edit 0: do not set 1 : preparing date , 2 : release date )

AvailableDateValue String True

If Type= 1(Preparing date), preparing date (dd) enter : ex) 5. If Type 2=(release date), set release date(YYYY-MM-DD) : ex) 2011-09-15. If Type null, the setting value = null : do not edit

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