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.
SELECT * FROM Products WHERE StoreCategoryKey = 'category_key'
SELECT * FROM Products WHERE ItemCode = 'CD001' AND SellerId = 'store'
SELECT * FROM Products WHERE Name LIKE '%prod_name%'
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 |