SSIS Components for Yahoo Shopping

Build 20.0.7587

Products

Return the list of registered products of your store.

Select

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

  • StoreCategoryKey and/or SellerId support the = operator.
  • ItemCode supports the =, LIKE operator.
  • Name supports the LIKE operator.
For example, the following queries are processed server side:
SELECT * FROM Products WHERE StoreCategoryKey = 'category_key'

SELECT * FROM Products WHERE ItemCode = 'CD001' AND SellerId = 'store' 

SELECT * FROM Products WHERE Name LIKE '%prod_name%'
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 unfiltered data to be pushed.

Insert

To add a product you specify the ItemCode (required), Name, Path, ProductCategory, Price, SalePrice, OriginalPrice, MemberPrice, ReleaseDate, display, Headline, Caption ,Abstract, Explanation, Additional1, Additional2, Additional3, SpAdditional, ShipWeight, Taxable, PointCode, MetaDesc, HiddenPageFlag, TemplateName, SaleLimit, BrandCode, ProductCode, JanCode, Delivery, Condition, Options, Subcodes, PostageSet columns.

INSERT INTO Products (Name, ItemCode, Price, SalePrice, MemberPrice, SalePeriodEnd, SalePeriodStart, Display )  VALUES ('productName1', 'CD0001', 5000, 4000, 3000, '2018-06-25T03:00:00.000+02:00', '2018-05-25T03:00:00.000+02:00', 0)

Update

Yahoo Shopping allows updates for the Name, Path, ProductCategory, Price, SalePrice, OriginalPrice, MemberPrice, ReleaseDate, display, Headline, Caption ,Abstract, Explanation, Additional1, Additional2, Additional3, SpAdditional, ShipWeight, Taxable, PointCode, MetaDesc, HiddenPageFlag, TemplateName, SaleLimit, BrandCode, ProductCode, JanCode, Delivery, Condition, Options, Subcodes, PostageSet columns.

Update Products set Name='ProductName', Path='CategoryPage:SubCategory', ProductCategory = '12345', Price = 110 , SalePrice = 109, OiginalPrice = 111 , MemberPrice = 108 , ReleaseDate = '2013-06-25T03:00:00.000+02:00', display = 1 ,Headline = ' headline text', Caption = 'tset caption', Abstract = 'sample Abstract', Explanation = 'sample Explanation', Additional1 = 'sample Additional1', Additional2 = 'sample Additional2' , Additional3 = 'sample Additional3', SpAdditional = 'sample SpAdditional', ShipWeight = 234, Taxable = 0, PointCode = 'D05' , MetaDesc = 'sample MetaDesc', HiddenPageFlag = '0' , TemplateName = 'IT02', SaleLimit = 100, BrandCode = '12312', ProductCode ='04-7282' , JanCode = '4971275472819' , Delivery = 3, Condition= 0, PostageSet = 0 Where ItemCode='CD001' 

Update Products set Options = '<Options><Option type=\"2\" name=\"Color\" specId=\"123\"> <Value specValue=\"23\" name=\"Red\"/> <Value specValue=\"34\" name=\"Blue\"/> </Option><Option type=\"1\" name=\"Size\" specId=\"24181\"> <Value specValue=\"210764\" name=\"Large\"/> </Option></Options>', SubCodes = ' <SubCodes> <SubCode code=\"21342\" quantity=\"\" stockClose=\"0\"> <Option name=\"Size\" value=\"Large\"/> <Option name=\"Color\" value=\"Blue\"/> <LeadTimeInStock>4000</LeadTimeInStock> <LeadTimeOutStock>2000</LeadTimeOutStock> </SubCode> <SubCode code=\"211342\" quantity=\"\" stockClose=\"0\"> <Option name=\"Size\" value=\"Large\"/> <Option name=\"Color\" value=\"Red\"/> <LeadTimeInStock></LeadTimeInStock> <LeadTimeOutStock></LeadTimeOutStock> </SubCode> </SubCodes>' Where ItemCode='CD001' 

Upsert

Yahoo Shopping allows upsert for the Name, Path, Price, SalePrice, OriginalPrice, MemberPrice, ReleaseDate, display, Headline, Caption ,Abstract, Explanation, Additional1, Additional2, Additional3, SpAdditional, ShipWeight, Taxable, PointCode, MetaDesc, HiddenPageFlag, TemplateName, SaleLimit, BrandCode, ProductCode, JanCode, Delivery, Condition columns.

Upsert INTO Products (Name, ItemCode, Path, Price) Values ('someName', 'CD0001', 'CategoryPage:SubCategory', 110)

Batch Update

Yahoo Shopping allows batch updates for Name, OriginalPrice, Price, SalePrice, MemberPrice, SalePeriodEnd, SalePeriodStart and Display columns.

INSERT INTO Products#TEMP (Name, ItemCode, Price, SalePrice, MemberPrice, SalePeriodEnd, SalePeriodStart, Display )  VALUES ('productName1', 'CD0001', 5000, 4000, 3000, '2018-06-25T03:00:00.000+02:00', '2018-05-25T03:00:00.000+02:00', 0)

INSERT INTO Products#TEMP (Name, ItemCode, Price, SalePrice, MemberPrice, SalePeriodEnd, SalePeriodStart, Display )  VALUES ('productName2', 'CD0002', 6000, 5000, 2000, '2018-07-25T03:00:00.000+02:00', '2018-06-25T03:00:00.000+02:00', 1)

UPDATE Products SET (Name, ItemCode, Price, SalePrice, MemberPrice, SalePeriodEnd, SalePeriodStart, Display ) SELECT Name, ItemCode, Price, SalePrice, MemberPrice, SalePeriodEnd, SalePeriodStart, Display  FROM [Products#Temp]

Delete

A product be deleted by providing the ItemCode and issuing a DELETE statement

Delete from Products Where ItemCode = 'CD000001'

Batch Delete

Several products be deleted by providing the ItemCodes and issuing a DELETE statement

INSERT INTO DeleteProducts#Temp (ItemCode) VALUES ('CD000001')

INSERT INTO DeleteProducts#Temp (ItemCode) VALUES ('CD000002')

DELETE from Products Where EXISTS (Select ItemCode FROM DeleteProducts#Temp)

Columns

Name Type ReadOnly References Description
ItemCode [KEY] String False

Product code.

HasSubcode Integer True

With subcode. 1: With subcode, 0: No subcode code

使用できる値は次のとおりです。0, 1

SellerId String False

ID of the store account.

Name String False

The name of the product.

ProductCategory String False

Product category ID.

StoreCategoryName String True

The page name of the store category.

Path String False

The path of the store category. (Category names separated by colon).

Price Integer False

Regular selling price.

SalePrice Integer False

Special price.

OriginalPrice Integer False

List price.

OriginalPriceEvidence String True

Evidence URL.

MemberPrice Integer False

Price for members.

SalePeriodStart Datetime False

Sales start date and time.

SalePeriodEnd Datetime False

End of sale date.

SortOrder Integer True

Product display order under store category.

SortPriority Integer True

Product display priority order under store category.

Quantity Integer True

Inventory (There are items only when stock = true request is specified.).

Display Integer False

Page release. 1: Public, 0: Not Disclosed.

使用できる値は次のとおりです。0, 1

EditingFlag Integer True

Edit flag. 1: A state that has not been reflected at the front since being edited, 0: Reflected.

使用できる値は次のとおりです。0, 1

Headline String False

Catch copy.

Caption String False

Product Description.

Abstract String False

One word comment.

Explanation String False

Product information.

Additional1 String False

Free space 1.

Additional2 String False

Free space 2.

Additional3 String False

Free space 3.

SpAdditional String False

Free space for smartphone.

RelevantLinks String False

Recommended product information.

CartRelatedItems String False

Recommended related item information.

TaxRateType Decimal False

Recommended related item information.

使用できる値は次のとおりです。0.1, 0.8

ShipWeight Integer False

Product weight.

Taxable Integer False

Tax object. 1: Taxation , 0: Tax exemption.

使用できる値は次のとおりです。0, 1

TaxrateType Decimal False

Tax rate object.

使用できる値は次のとおりです。0.1, 0.08

ReleaseDate Date False

Release date.

PointCode String False

Point magnification code.

MetaKey String True

META keywords.

MetaDesc String False

META description .

HiddenPage String True

Hidden page information.

HiddenPageFlag String False

Hidden page flag. 0: Normal, 1: Hidden page.

使用できる値は次のとおりです。0, 1

HiddenPageId String True

Hidden page ID.

HiddenPagePassword String True

Password for hidden pages.

TemplateId String True

Design template ID.

TemplateName String False

Design template name.

SaleLimit Integer False

Purchase limit.

SpCode String False

Promotional code.

BrandCode String False

Brand code.

ProductCode String False

Product Code.

JanCode String False

Japanese Article Number Code.

Delivery Integer False

Free shipping set. 0: None, 1: Free shipping, 2: Including shipping fee ( Because shipping costs are treated as free shipping, it will be saved as 1 if 2 is specified), 3: Conditional shipping free.

使用できる値は次のとおりです。0, 1, 2, 3

Image String True

URL of product preview image.

LibImage1 String True

Product details URL of preview image 1.

LibImage2 String True

Product details URL of preview image 2.

LibImage3 String True

Product details URL of preview image 3.

LibImage4 String True

Product details URL of preview image 4.

LibImage5 String True

Product details URL of preview image 5.

LibImage6 String True

Product details URL of preview image 6.

LibImage7 String True

Product details URL of preview image 7.

LibImage8 String True

Product details URL of preview image 8.

LibImage9 String True

Product details URL of preview image 9.

LibImage10 String True

Product details URL of preview image 10.

LibImage11 String True

Product details URL of preview image 11.

LibImage12 String True

Product details URL of preview image 12.

LibImage13 String True

Product details URL of preview image 13.

LibImage14 String True

Product details URL of preview image 14.

LibImage15 String True

Product details URL of preview image 15.

LibImage16 String True

Product details URL of preview image 16.

LibImage17 String True

Product details URL of preview image 17.

LibImage18 String True

Product details URL of preview image 18.

LibImage19 String True

Product details URL of preview image 19.

LibImage20 String True

Product details URL of preview image 20.

AstkCode Integer False

Chiku/Misuzu code. 0: Non-compliant, 1: Matsuku, 2: Kokutsuku.

使用できる値は次のとおりです。0, 1, 2

Condition Integer False

State of goods. 0: New article, 1: Used.

使用できる値は次のとおりです。0, 1

Spec1Id Integer True

Specification 1: Spec ID.

Spec1Name String True

Specification 1: Display name of spec.

Spec1Value String True

Specification 1: Specification value ID.

Spec1ValueName String True

Specification 1: Display name of spec value.

Spec2Id Integer True

Specification 2: Spec ID.

Spec2Name String True

Specification 2: Display name of spec.

Spec2Value String True

Specification 2: Specification value ID.

Spec2ValueName String True

Specification 2: Display name of spec value.

Spec3Id Integer True

Specification 3: Spec ID.

Spec3Name String True

Specification 3: Display name of spec.

Spec3Value String True

Specification 3: Specification value ID.

Spec3ValueName String True

Specification 3: Display name of spec value.

Spec4Id Integer True

Specification 4: Spec ID.

Spec4Name String True

Specification 4: Display name of spec.

Spec4Value String True

Specification 4: Specification value ID.

Spec4ValueName String True

Specification 4: Display name of spec value.

Spec5Id Integer True

Specification 5: Spec ID.

Spec5Name String True

Specification 5: Display name of spec.

Spec5Value String True

Specification 5: Specification value ID.

Spec5ValueName String True

Specification 5: Display name of spec value.

Spec6Id Integer True

Specification 6: Spec ID.

Spec6Name String True

Specification 6: Display name of spec.

Spec6Value String True

Specification 6: Specification value ID.

Spec6ValueName String True

Specification 6: Display name of spec value.

Spec7Id Integer True

Specification 7: Spec ID.

Spec7Name String True

Specification 7: Display name of spec.

Spec7Value String True

Specification 7: Specification value ID.

Spec7ValueName String True

Specification 7: Display name of spec value.

Spec8Id Integer True

Specification 8: Spec ID.

Spec8Name String True

Specification 8: Display name of spec.

Spec8Value String True

Specification 8: Specification value ID.

Spec8ValueName String True

Specification 8: Display name of spec value.

Spec9Id Integer True

Specification 9: Spec ID.

Spec9Name String True

Specification 9: Display name of spec.

Spec9Value String True

Specification 9: Specification value ID.

Spec9ValueName String True

Specification 9: Display name of spec value.

Spec10Id Integer True

Specification 10: Spec ID.

Spec10Name String True

Specification 10: Display name of spec.

Spec10Value String True

Specification 10: Specification value ID.

Spec10ValueName String True

Specification 10: Display name of spec value.

Options String False

Option information .

Inscriptions String False

Inclusion information .

SubCodes String False

Individual product code information.

ShowStock Integer True

Inventory display setting (product individual setting). 1: Stock number display, 2: Stock display.

UpdateTime Datetime True

Update date.

LeadTimeInStock Datetime False

Shipping date information management number when stocked.

LeadTimeOutStock Datetime False

Shipment date information management number when out of stock.

KeepStock Integer False

Set at the time of cancellation from the orderer, set the stock back. 0: Do not take, stock at the time of cancellation, 1: Return stock at the time of cancellation (Initial value).

StockClose Integer True

Stock Close Flag. 0: Normal State, 1: Stock Closed State, Empty: Subcode Exists.

使用できる値は次のとおりです。0, 1

StoreCategoryKey String True

Categories.PageKey

The page key of the store category.

PostageSet Integer False

Delivery group management number tied to the product, values 1-20.

使用できる値は次のとおりです。1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20

PickAndDeliveryCode String False

Barcode information.

PickAndDeliveryTransportRuleType Integer False

使用できる値は次のとおりです。0, 1, 2, 3, 4, 5

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