{"id":12028,"date":"2021-11-03T10:00:37","date_gmt":"2021-11-03T01:00:37","guid":{"rendered":"https:\/\/trinity.jp\/archive\/12028\/"},"modified":"2021-11-03T10:00:37","modified_gmt":"2021-11-03T01:00:37","slug":"Amazon%e3%81%ab%e5%95%86%e5%93%81%e3%82%92%e3%83%90%e3%83%aa%e3%82%a8%e3%83%bc%e3%82%b7%e3%83%a7%e3%83%b3%e7%99%bb%e9%8c%b2%e3%81%99%e3%82%8b%e3%81%a8%e3%81%8d%e3%81%ae%e3%82%a2%e3%82%a4%e3%83%87","status":"publish","type":"post","link":"https:\/\/trinity.jp\/archive\/12028\/","title":{"rendered":"Amazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u3068\u306e\u95d8\u3044\u3002\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u767b\u9332\u3092\u30b5\u30af\u30c3\u3068\u7d42\u308f\u3089\u305b\u305f\u3044\u3002"},"content":{"rendered":"<p>\u4eca\u56de\u306f\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u30c1\u30fc\u30e0\u304c\u5b9a\u3081\u305f5\u301c9\u6708\u306e\u30d6\u30ed\u30b0\u30c6\u30fc\u30de\u304b\u3089\u9078\u3093\u3060\u300c\u81ea\u5206\u306e\u30c1\u30fc\u30e0\u306e\u4ed5\u4e8b\u5185\u5bb9\u3084\u53d6\u308a\u7d44\u307f\u306b\u3064\u3044\u3066\u300d\u3001\u5148\u65e5\u4f5c\u6210\u3057\u305fAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<h1>\u25bc\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u3068\u306e\u95d8\u3044<\/h1>\n<p>\u30c8\u30ea\u30cb\u30c6\u30a3\u306fAmazon\u3067\u3082\u88fd\u54c1\u3092\u8ca9\u58f2\u3057\u3066\u3044\u307e\u3059\u3002Amazon\u3067\u8ca9\u58f2\u3059\u308b\u305f\u3081\u306b\u306f\u3001Amazon\u306e\u30bb\u30e9\u30fc\u30bb\u30f3\u30c8\u30e9\u30eb\u304b\u3089\u88fd\u54c1\u767b\u9332\u7528\u306e\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u88fd\u54c1\u60c5\u5831\u3092\u5165\u529b\u3057\u3001\u305d\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30b7\u30b9\u30c6\u30e0\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u306e\u88fd\u54c1\u3092\u767b\u9332\u3059\u308b\u305f\u3081\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u3068\u547c\u3093\u3067\u3044\u307e\u3059\u3002\u3053\u306e\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u306b\u5165\u529b\u3059\u308b\u4f5c\u696d\u3002\u5b9f\u306f\u306a\u304b\u306a\u304b\u9aa8\u306e\u6298\u308c\u308b\u4f5c\u696d\u3067\u3059\u3002<\/p>\n<p>\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u306e\u5165\u529b\u4f5c\u696d\u304c\u5927\u5909\u306a\u7406\u7531<\/p>\n<ul>\n<li>\u767b\u9332\u3059\u308b\u88fd\u54c1\u6570\u304c\u591a\u3044\u305f\u3081\u3001\u88fd\u54c1\u30ea\u30b9\u30c8\u304b\u3089\u5fc5\u8981\u306a\u60c5\u5831\u3092\u3072\u3068\u3064\u305a\u3064\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u306b\u30b3\u30d4\u30da\u3059\u308b\u3068\u306a\u308b\u3068\u3001\u5b8c\u6210\u307e\u3067\u306b\u81a8\u5927\u306a\u6642\u9593\u304c\u304b\u304b\u3063\u3066\u3057\u307e\u3046\u3002\u591a\u3044\u3068\u304d\u306f\u3001\u4e00\u5ea6\u306b200\u578b\u756a\u304f\u3089\u3044\u767b\u9332\u3059\u308b\u3002<\/li>\n<li>\u88fd\u54c1\u578b\u756a\u304c\u4f3c\u3066\u3044\u308b\u305f\u3081\u3001\u30b3\u30d4\u30da\u30df\u30b9\u304c\u767a\u751f\u3057\u3084\u3059\u3044\u3002<\/li>\n<li>\u767b\u9332\u3059\u3079\u304d\u81a8\u5927\u306a\u88fd\u54c1\u6570\u3068\u9593\u9055\u3063\u3066\u306f\u3044\u3051\u306a\u3044\u30d7\u30ec\u30c3\u30b7\u30e3\u30fc\u3067\u3001\u3068\u3093\u3067\u3082\u306a\u3044\u76ee\u306e\u75b2\u52b4\u306b\u8972\u308f\u308c\u308b\u3002\u305d\u3057\u3066\u3001\u3082\u306e\u3059\u3054\u304f\u6c17\u3092\u3064\u3051\u3066\u3044\u308b\u306e\u306b\u3001\u9593\u9055\u3063\u3066\u3057\u307e\u3046\u3053\u3068\u3082\u305f\u307e\u306b\u3042\u3063\u3066\u60b2\u3057\u3044\u3002<\/li>\n<\/ul>\n<p>\u3082\u3057\u304b\u3059\u308b\u3068\u3001Amazon\u306b\u88fd\u54c1\u3092\u767b\u9332\u3055\u308c\u305f\u3053\u3068\u306e\u3042\u308b\u65b9\u306f\u7d4c\u9a13\u3057\u305f\u3053\u3068\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u88fd\u54c1\u3092\u4e00\u62ec\u767b\u9332\u3059\u308b\u305f\u3081\u306e\u5916\u90e8\u30b5\u30fc\u30d3\u30b9\u3082\u3042\u308b\u306e\u3067\u3059\u304c\u3001\u30c8\u30ea\u30cb\u30c6\u30a3\u3067\u306f\u88fd\u54c1\u306e\u30ea\u30b9\u30c8\u3092Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u307e\u3068\u3081\u3066\u3044\u3066\u3001\u5916\u90e8\u30b5\u30fc\u30d3\u30b9\u306b\u5408\u308f\u305b\u305f\u30ea\u30b9\u30c8\u3092\u4f5c\u308b\u5fc5\u8981\u304c\u3042\u308a\u305d\u3046\u3067\u3057\u305f\u3002\u305d\u3053\u3067\u3001\u73fe\u5728\u30c8\u30ea\u30cb\u30c6\u30a3\u3067\u4f7f\u3063\u3066\u3044\u308b\u88fd\u54c1\u30ea\u30b9\u30c8\u3092\u7528\u3044\u3066\u3001\u767b\u9332\u3057\u305f\u3044\u578b\u756a\u3068\u3044\u304f\u3064\u304b\u306e\u6761\u4ef6\u3092\u8a2d\u5b9a\u3059\u308c\u3070\u3001\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u304c\u5b8c\u6210\u3059\u308b\u4ed5\u7d44\u307f\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<p>\u88fd\u54c1\u306eJAN\u30b3\u30fc\u30c9\u3084\u578b\u756a\u3001\u88fd\u54c1\u540d\u3084\u4ed5\u69d8\u306e\u66f8\u304b\u308c\u305fGoogle\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u3001IMPORTRANGE\u95a2\u6570\u3084VLOOKUP\u95a2\u6570\u3092\u4f7f\u3063\u3066\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u306b\u8ee2\u8a18\u3055\u305b\u308b\u3068\u3044\u3046\u306e\u304c\u3001\u304a\u304a\u307e\u304b\u306a\u4ed5\u7d44\u307f\u3067\u3059\u3002\u8ee2\u8a18\u3059\u308b\u65b9\u6cd5\u306f\u73fe\u5728\u304a\u4f7f\u3044\u306e\u88fd\u54c1\u30ea\u30b9\u30c8\u306b\u3088\u3063\u3066\u591a\u5c11\u6d41\u308c\u304c\u7570\u306a\u308b\u3068\u601d\u3044\u307e\u3059\u306e\u3067\u4eca\u56de\u306f\u601d\u3044\u5207\u3063\u3066\u5272\u611b\u3057\u3001\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u306e\u300c\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u767b\u9332\u300d\u306b\u95a2\u308f\u308b\u9805\u76ee\u306e\u5165\u529b\u3059\u308b\u30b3\u30c4\u3092\u307e\u3068\u3081\u3066\u3044\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<h1>\u25bcAmazon\u306e\u300c\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u767b\u9332\u300d<\/h1>\n<p>\u4ee5\u4e0b\u306e\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8\u306e\u3088\u3046\u306b\u30011\u3064\u306e\u30da\u30fc\u30b8\u306e\u4e2d\u3067\u8272\u9055\u3044\u3084\u7d20\u6750\u9055\u3044\u306e\u88fd\u54c1\u3092\u9078\u629e\u3067\u304d\u308b\u3088\u3046\u306a\u30da\u30fc\u30b8\u306f\u300c\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u767b\u9332\u300d\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u30c8\u30ea\u30cb\u30c6\u30a3\u306b\u9650\u3089\u305a\u30011\u30da\u30fc\u30b8\u306e\u4e2d\u3067\u8272\u3084\u7d20\u6750\u3092\u9078\u3079\u308b\u30da\u30fc\u30b8\u306fAmazon\u306b\u591a\u304f\u3042\u308a\u307e\u3059\u3088\u306d\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-286934\" src=\"https:\/\/trinity.jp\/archive\/wp-content\/uploads\/2021\/09\/01_variation-1.png\" alt=\"01_variation-1.png\" width=\"849\" \/><\/p>\n<p>\u3053\u308c\u306f\u3001\u300cAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300d\u306e\u4e2d\u306e<\/p>\n<ul>\n<li>\u51fa\u54c1\u8005SKU\uff08item_sku\uff09<\/li>\n<li>\u89aa\u5b50\u95a2\u4fc2\u306e\u6307\u5b9a\uff08parent_child\uff09<\/li>\n<\/ul>\n<p>\u3068\u3044\u3046\u6b04\u306b\u9069\u5207\u306a\u30c7\u30fc\u30bf\u3092\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u300c\u89aa\u5b50\u95a2\u4fc2\u306e\u6307\u5b9a\u300d\u3068\u3044\u3046\u8a00\u8449\u304c\u3061\u3087\u3063\u3068\u96e3\u3057\u3044\u3068\u601d\u3044\u307e\u3059\u306e\u3067\u3001\u30c8\u30ea\u30cb\u30c6\u30a3\u306e\u578b\u756a\u3092\u4f8b\u306b\u8003\u3048\u3066\u307f\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<h1>\u25bc\u300c\u89aa\u5b50\u95a2\u4fc2\u306e\u6307\u5b9a\u300d\u3068\u89aa\u578b\u756a\u30fb\u5b50\u578b\u756a<\/h1>\n<p>\u305f\u3068\u3048\u3070\u3001\u524d\u8ff0\u306eAmazon\u30da\u30fc\u30b8\u306b\u3042\u308b\u88fd\u54c1\u306b\u3064\u3044\u3066\u3002\u3053\u306e\u30da\u30fc\u30b8\u306b\u306f\u8272\u3084\u7d20\u6750\u9055\u3044\u30678\u3064\u306e\u88fd\u54c1\u304c\u3042\u308a\u307e\u3059\u3002\u578b\u756a\u306f\u4e0b\u8a18\u306e8\u3064\u3067\u3059\u3002<\/p>\n<ol>\n<li>TR-IP20S-BC-SMBK<\/li>\n<li>TR-IP20S-BC-SMKK<\/li>\n<li>TR-IP20S-BC-SMRD<\/li>\n<li>TR-IP20S-BC-SMBL<\/li>\n<li>TR-IP20S-BC-SMGR<\/li>\n<li>TR-IP20S-BC-TEDW<\/li>\n<li>TR-IP20S-BC-TENW<\/li>\n<li>TR-IP20S-BC-TEKE<\/li>\n<\/ol>\n<p>\u4e26\u3079\u3066\u307f\u308b\u3068\u3001\u300cTR-IP20S-BC-\u300d\u307e\u3067\u306f\u3059\u3079\u3066\u5171\u901a\u3068\u3044\u3046\u3053\u3068\u304c\u308f\u304b\u308b\u3068\u601d\u3044\u307e\u3059\u3002\u305d\u3053\u3067\u3001\u30c8\u30ea\u30cb\u30c6\u30a3\u3067\u306f\u300cTR-IP20S-BC\u300d\u307e\u3067\u3092\u300c\u89aa\u578b\u756a\uff08Parent\uff09\u300d\u3068\u547c\u3073\u3001\u5143\u306e\u5f62\u3067\u3042\u308b\u300cTR-IP20S-BC-SMBK\u300d\u3092\u300c\u5b50\u578b\u756a\uff08Child\uff09\u300d\u3068\u547c\u3093\u3067\u3044\u307e\u3059\u3002\u3053\u306e\u300c\u89aa\u578b\u756a\u300d\u3068\u300c\u5b50\u578b\u756a\u300d\u3092\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u306e<\/p>\n<ul>\n<li>\u51fa\u54c1\u8005SKU\uff08item_sku\uff09<\/li>\n<\/ul>\n<p>\u306b\u5165\u529b\u3057\u3001<\/p>\n<ul>\n<li>\u89aa\u5b50\u95a2\u4fc2\u306e\u6307\u5b9a\uff08parent_child\uff09<\/li>\n<\/ul>\n<p>\u306e\u89aa\u578b\u756a\u306e\u884c\u306b\u306f\u300cParent\u300d\u3001\u5b50\u578b\u756a\u306e\u884c\u306b\u306f\u300cChild\u300d\u3092\u5165\u529b\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002\u6b21\u306e\u7ae0\u3067\u3088\u308a\u8a73\u3057\u304f\u898b\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<h1>\u25bc\u300c\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u767b\u9332\u300d\u306b\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u30b5\u30af\u30c3\u3068\u4f5c\u308b<\/h1>\n<p>\u4ee5\u4e0b\u306e\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8\u306f\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u3092\u3060\u3044\u3076\u7701\u7565\u3057\u305f\u3082\u306e\u3067\u3059\u3002\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u767b\u9332\u306b\u95a2\u308f\u308b\u60c5\u5831\u3060\u3051\u306b\u7d5e\u3063\u3066\u307e\u3068\u3081\u308b\u3068\u3001\u3053\u306e\u3088\u3046\u306a\u8868\u3092\u4f5c\u308b\u306e\u304c\u30b4\u30fc\u30eb\u3068\u306a\u308a\u307e\u3059\u3002\u300c\u89aa\u5b50\u95a2\u4fc2\u306e\u6307\u5b9a\uff08parent_child\uff09\u300d\u306b\u300cParent\u300d\u3068\u300cChild\u300d\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u306e\u304c\u308f\u304b\u308b\u3068\u601d\u3044\u307e\u3059\u3002\u300c\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u767b\u9332\u300d\u306b\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u30b5\u30af\u30c3\u3068\u4f5c\u308b\u6700\u5927\u306e\u30dd\u30a4\u30f3\u30c8\u306f\u3001B\u5217\uff1a\u51fa\u54c1\u8005SKU\uff08item_sku\uff09\u306b\u300c\u89aa\u578b\u756a\u300d\u3068\u300c\u5b50\u578b\u756a\u300d\u304c\u30bb\u30c3\u30c8\u306b\u306a\u308b\u3088\u3046\u306b\u30c7\u30fc\u30bf\u3092\u6e96\u5099\u3059\u308b\u3053\u3068\u3067\u3059\u3002\u30c8\u30ea\u30cb\u30c6\u30a3\u306e\u88fd\u54c1\u30ea\u30b9\u30c8\u306b\u306f\u89aa\u578b\u756a\u306e\u8a18\u8f09\u304c\u3042\u308a\u307e\u305b\u3093\u306e\u3067\u3001\u5b50\u578b\u756a\u304b\u3089\u89aa\u578b\u756a\u3092\u4f5c\u3063\u3066\u6574\u7406\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-286918\" src=\"https:\/\/trinity.jp\/archive\/wp-content\/uploads\/2021\/09\/02_amazonform.png\" alt=\"02_amazonform.png\" width=\"850\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>\u3010\u89aa\u578b\u756a\u3068\u5b50\u578b\u756a\u304c\u30bb\u30c3\u30c8\u306b\u306a\u3063\u305f\u30c7\u30fc\u30bf\u3092\u4f5c\u308b\u624b\u9806\u3011<\/h2>\n<ol>\n<li>\u88fd\u54c1\u578b\u756a\u306e\u30ea\u30b9\u30c8\u3092\u7528\u610f\u3059\u308b<\/li>\n<li>\u89aa\u578b\u756a\u3092\u4f5c\u308b<\/li>\n<li>\u89aa\u578b\u756a\u3068\u5b50\u578b\u756a\u3092\u6607\u9806\u306b\u4e26\u3079\u308b<\/li>\n<\/ol>\n<p>\u4f5c\u696d\u306f\u3059\u3079\u3066Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u884c\u306a\u3044\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<h3>\u3010\u624b\u98061\u3011\u88fd\u54c1\u578b\u756a\u306e\u30ea\u30b9\u30c8\u3092\u7528\u610f\u3059\u308b<\/h3>\n<p>\u5b50\u578b\u756a\u306e\u30ea\u30b9\u30c8\u3067\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-286919\" src=\"https:\/\/trinity.jp\/archive\/wp-content\/uploads\/2021\/09\/03_skulist.png\" alt=\"03_skulist.png\" width=\"850\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>\u3010\u624b\u98062\u3011\u89aa\u578b\u756a\u3092\u4f5c\u308b<\/h3>\n<p>\u89aa\u578b\u756a\u306f\u3001\u5b50\u578b\u756a\u3092\u300c-\uff08\u30cf\u30a4\u30d5\u30f3\uff09\u300d\u3067\u5206\u89e3\u3057\u3066\u3001\u89aa\u578b\u756a\u306b\u5fc5\u8981\u306a\u90e8\u5206\u3060\u3051\u3092\u307e\u305f\u300c-\uff08\u30cf\u30a4\u30d5\u30f3\uff09\u300d\u3092\u631f\u3093\u3067\u7d50\u5408\u3057\u3066\u4f5c\u308a\u307e\u3059\u3002\u30c8\u30ea\u30cb\u30c6\u30a3\u306e\u5834\u5408\u3001\u88fd\u54c1\u306b\u3088\u3063\u3066\u578b\u756a\u306e\u6587\u5b57\u6570\u306f\u7570\u306a\u308a\u307e\u3059\u304c\u3001\u69cb\u9020\u306f\u540c\u3058\u3067\u3059\u3002\u8a08\u7b97\u5f0f\u3092\u3072\u3068\u3064\u4f5c\u3063\u3066\u30b3\u30d4\u30da\u3059\u308b\u3053\u3068\u3067\u3001\u89aa\u578b\u756a\u3092\u3044\u3063\u307a\u3093\u306b\u4f5c\u3063\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-287065\" src=\"https:\/\/trinity.jp\/archive\/wp-content\/uploads\/2021\/09\/07_conposition.png\" alt=\"07_conposition.png\" width=\"850\" \/><\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"font-size: 16pt\">1. \u578b\u756a\u3092\u300c-\uff08\u30cf\u30a4\u30d5\u30f3\uff09\u300d\u3067\u5206\u89e3\u3059\u308b<\/span><\/h4>\n<p>\u578b\u756a\u3092\u5206\u89e3\u3059\u308b\u305f\u3081\u306b\u3001\u300c<a href=\"https:\/\/support.google.com\/docs\/answer\/3094136?hl=ja\" target=\"_blank\" rel=\"noopener\">SPLIT\u95a2\u6570<\/a>\u300d\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n<p>[wp_visual https:\/\/support.google.com\/docs\/answer\/3094136?hl=ja]<\/p>\n<p>B\u5217\u306b<\/p>\n<p><strong><span style=\"font-size: 16pt\">=SPLIT\uff08A2,&#8221;-&#8220;\uff09<\/span><\/strong><\/p>\n<p>\u3068\u5165\u529b\u3059\u308b\u3068\u3001\u30bb\u30eb\uff1aA2\u306b\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u300cTR-IP20S-BC-SMBK\u300d\u304c\u300c-\uff08\u30cf\u30a4\u30d5\u30f3\uff09\u300d\u3092\u5883\u306b\u3001\u300cTR\u300d\u300cIP20S\u300d\u300cBC\u300d\u300cSMBK\u300d\u306b\u5206\u304b\u308c\u307e\u3059\u3002\u305d\u308c\u305e\u308c\u3001\u300c\u30d6\u30e9\u30f3\u30c9\u30b3\u30fc\u30c9\u300d\u300c\u7aef\u672b\u30b3\u30fc\u30c9\u300d\u300c\u30b7\u30ea\u30fc\u30ba\u30b3\u30fc\u30c9\u300d\u300c\u7d20\u6750\u30fb\u30ab\u30e9\u30fc\u30b3\u30fc\u30c9\u300d\u3068\u547c\u3076\u3053\u3068\u306b\u3057\u307e\u3059\u3002<\/p>\n<ul>\n<li>\u30d6\u30e9\u30f3\u30c9\u30b3\u30fc\u30c9 \u2192 TR<\/li>\n<li>\u7aef\u672b\u30b3\u30fc\u30c9 \u2192 IP20S<\/li>\n<li>\u30b7\u30ea\u30fc\u30ba\u30b3\u30fc\u30c9 \u2192 BC<\/li>\n<li>\u7d20\u6750\u30fb\u30ab\u30e9\u30fc\u30b3\u30fc\u30c9 \u2192 SMBK<\/li>\n<\/ul>\n<p>\u4f5c\u3063\u305f\u300cSPLIT\u95a2\u6570\u300d\u3092B\u5217\u3059\u3079\u3066\u306e\u884c\u306b\u30b3\u30d4\u30da\u3059\u308b\u3068\u3001\u305d\u308c\u305e\u308c\u306e\u578b\u756a\u304c\u5206\u89e3\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-286920\" src=\"https:\/\/trinity.jp\/archive\/wp-content\/uploads\/2021\/09\/04_separate.png\" alt=\"04_separate.png\" width=\"850\" \/><\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"font-size: 18pt\">2. \u300c\u30d6\u30e9\u30f3\u30c9\u30b3\u30fc\u30c9\u300d\u300c\u7aef\u672b\u30b3\u30fc\u30c9\u300d\u300c\u30b7\u30ea\u30fc\u30ba\u30b3\u30fc\u30c9\u300d\u3092\u7d50\u5408\u3059\u308b<\/span><\/h4>\n<p>\u5206\u89e3\u3057\u305f\u30b3\u30fc\u30c9\u306e\u3046\u3061\u3001\u300c\u30d6\u30e9\u30f3\u30c9\u30b3\u30fc\u30c9\u300d\u300c\u7aef\u672b\u30b3\u30fc\u30c9\u300d\u300c\u30b7\u30ea\u30fc\u30ba\u30b3\u30fc\u30c9\u300d\u3060\u3051\u7d50\u5408\u3057\u307e\u3059\u3002\u3053\u306e3\u3064\u304c\u5148\u307b\u3069\u304b\u3089\u3054\u7d39\u4ecb\u3057\u3066\u3044\u308b\u300c\u89aa\u578b\u756a\u300d\u306b\u306a\u308a\u307e\u3059\u3002F\u5217\uff1a\u89aa\u578b\u756a\u306b<\/p>\n<p><strong><span style=\"font-size: 24pt\">=B2&amp;&#8221;-&#8220;&amp;C2&amp;&#8221;-&#8220;&amp;D2<\/span><\/strong><\/p>\n<p>\u3092\u5165\u529b\u3059\u308b\u3068\u3001\u300cTR\u300d\u3068\u300cIP20S\u300d\u3068\u300cBC\u300d\u304c\u300c-\uff08\u30cf\u30a4\u30d5\u30f3\uff09\u300d\u3092\u631f\u3093\u3067\u7d50\u5408\u3055\u308c\u3001\u300cTR-IP20S-BC\u300d\u306b\u306a\u308a\u307e\u3059\u3002F\u5217\u3059\u3079\u3066\u306b\u8a08\u7b97\u5f0f\u3092\u30b3\u30d4\u30da\u3059\u308b\u3068\u3001\u4e00\u6c17\u306b\u89aa\u578b\u756a\u304c\u4f5c\u6210\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-286921\" src=\"https:\/\/trinity.jp\/archive\/wp-content\/uploads\/2021\/09\/05_parent.png\" alt=\"05_parent.png\" width=\"850\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3>\u3010\u624b\u98063\u3011\u89aa\u578b\u756a\u3068\u5b50\u578b\u756a\u3092\u6607\u9806\u306b\u4e26\u3079\u308b<\/h3>\n<p><a href=\"https:\/\/support.google.com\/docs\/answer\/3093198?hl=ja\" target=\"_blank\" rel=\"noopener\">UNIQUE\u95a2\u6570<\/a>\u3068<a href=\"https:\/\/support.google.com\/docs\/answer\/3093150?hl=ja\" target=\"_blank\" rel=\"noopener\">SORT\u95a2\u6570<\/a>\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u3001\u89aa\u578b\u756a\u3068\u5b50\u578b\u756a\u304c1\u30bb\u30c3\u30c8\u306b\u306a\u308b\u3088\u3046\u306b\u4e26\u3079\u307e\u3059\u3002A\u5217\u306e\u5b50\u578b\u756a\u3068F\u5217\u306e\u89aa\u578b\u756a\u3092H\u5217\u306b\u307e\u3068\u3081\u3001\u3055\u3089\u306b\u3001\u88fd\u54c1A\u306e\u89aa\u578b\u756a\u2192\u5b50\u578b\u756a\u3001\u88fd\u54c1B\u306e\u89aa\u578b\u756a\u2192\u5b50\u578b\u756a\u3001\u88fd\u54c1C\u306e\u89aa\u578b\u756a\u2192\u5b50\u578b\u756a\u3068\u3044\u3046\u5177\u5408\u306b\u4e26\u3079\u307e\u3059\u3002<\/p>\n<p>[wp_visual https:\/\/support.google.com\/docs\/answer\/3093198?hl=ja]<\/p>\n<p>[wp_visual https:\/\/support.google.com\/docs\/answer\/3093150?hl=ja]<\/p>\n<p>\u5b8c\u6210\u3057\u305f\u8a08\u7b97\u5f0f\u306f\u3053\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><span style=\"font-size: 24pt\"><strong>=SORT({UNIQUE(F2:F);UNIQUE(A2:A)})<\/strong><\/span><\/p>\n<p>\u95a2\u6570\u304c\u305f\u304f\u3055\u3093\u5165\u3063\u3066\u3044\u3066\u7121\u7406\u3068\u601d\u308f\u308c\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001\u5927\u4e08\u592b\u3067\u3059\uff01\u3000\u9806\u306b\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-286923\" src=\"https:\/\/trinity.jp\/archive\/wp-content\/uploads\/2021\/09\/06_sort.png\" alt=\"06_sort.png\" width=\"850\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u307e\u305a\u3001<\/p>\n<p><span style=\"font-size: 24pt\"><strong>=SORT({<span style=\"color: #ff0000\">UNIQUE(F2:F)<\/span>;UNIQUE(A2:A)})<\/strong><\/span><\/p>\n<p>\u306e <span style=\"color: #ff0000\"><span style=\"font-size: 24pt\"><strong>UNIQUE(F2:F)<\/strong><\/span><span style=\"color: #000000\"> \u306e\u90e8\u5206\u3002<\/span><\/span><\/p>\n<p>\u3053\u308c\u306f\u3001F\u5217\uff1a\u89aa\u578b\u756a\u306b\u5b58\u5728\u3057\u3066\u3044\u308b\u578b\u756a\u3092\u3072\u3068\u3064\u305a\u3064\u629c\u304d\u51fa\u3059\u305f\u3081\u306e\u8a08\u7b97\u5f0f\u3067\u3059\u3002F\u5217\u306b\u306f<\/p>\n<ul>\n<li>TR-IP20S-BC \u304c8\u3064<\/li>\n<li>TR-IP20M-BC \u304c8\u3064<\/li>\n<li>TR-IP20M-BC \u304c4\u3064<\/li>\n<li>TR-IP20S-ST \u304c2\u3064<\/li>\n<\/ul>\n<p>\u5b58\u5728\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u3053\u304b\u3089<\/p>\n<ul>\n<li>TR-IP20S-BC \u30921\u3064<\/li>\n<li>TR-IP20M-BC \u30921\u3064<\/li>\n<li>TR-IP20M-BC \u30921\u3064<\/li>\n<li>TR-IP20S-ST \u30921\u3064<\/li>\n<\/ul>\n<p>\u629c\u304d\u51fa\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u6b21\u306b\u3001<\/p>\n<p><span style=\"font-size: 24pt\"><strong>=SORT({<span style=\"color: #ff0000\">UNIQUE(F2:F)<\/span>;<span style=\"color: #0000ff\">UNIQUE(A2:A)<\/span><span style=\"color: #000000\">}<\/span>)<\/strong><\/span><\/p>\n<p>\u306e<span style=\"font-size: 24pt\"> <strong><span style=\"color: #0000ff\">UNIQUE(A2:A)<\/span><\/strong><\/span><span style=\"color: #ff0000\"><span style=\"color: #000000\"><span style=\"font-size: 24pt\">\u00a0<\/span>\u306e\u90e8\u5206\u3002<\/span><\/span><\/p>\n<p>\u3053\u308c\u3082\u540c\u69d8\u306b\u3001A\u5217\uff1a\u578b\u756a\u304b\u3089\u91cd\u8907\u3057\u306a\u3044\u3088\u3046\u306b\u30c7\u30fc\u30bf\u3092\u3072\u3068\u3064\u305a\u3064\u629c\u304d\u51fa\u3059\u8a08\u7b97\u5f0f\u306b\u306a\u308a\u307e\u3059\u3002\u578b\u756a\u306f\u5143\u30051\u3064\u305a\u3064\u3057\u304b\u5b58\u5728\u3057\u3066\u3044\u307e\u305b\u3093\u304c\u3001<span style=\"color: #ff0000\"><strong>UNIQUE(F2:F)<\/strong><span style=\"color: #000000\"> \u306e\u90e8\u5206\u3068\u5408\u308f\u305b\u3066\u4e26\u3079\u66ff\u3048\u308b\u305f\u3081\u306b\u3001UNIQUE\u95a2\u6570\u3092\u4f7f\u3063\u3066\u3044\u307e\u3059\u3002<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>\u305d\u3057\u3066\u3001<\/p>\n<p><strong><span style=\"font-size: 24pt\">=SORT(<span style=\"color: #339966\">{<\/span><span style=\"color: #ff0000\">UNIQUE(F2:F)<\/span><span style=\"color: #339966\">;<\/span><span style=\"color: #0000ff\">UNIQUE(A2:A)<span style=\"color: #339966\">}<\/span><\/span>)<\/span><\/strong><\/p>\n<p>\u306e<strong><span style=\"font-size: 24pt\"><span style=\"color: #339966\"> { ; }<\/span> <\/span><\/strong>\u306e\u90e8\u5206\u3002<\/p>\n<p>\u5c0f\u3055\u304f\u3066\u898b\u3065\u3089\u3044\u3067\u3059\u304c\u3001<span style=\"color: #ff0000\"><strong>UNIQUE(F2:F)<\/strong><\/span> \u3068 <strong><span style=\"color: #0000ff\">UNIQUE(A2:A)<\/span><\/strong> \u3092\u300c<strong><span style=\"color: #339966\">;\uff08\u30ab\u30f3\u30de\uff09<\/span><\/strong>\u300d\u3067\u3064\u306a\u3052\u3066\u3001\u982d\u306b\u300c<strong><span style=\"color: #339966\">{\uff08\u6ce2\u62ec\u5f27\uff09<\/span><\/strong>\u300d\u3001\u6700\u5f8c\u306b\u300c<strong><span style=\"color: #339966\">}\uff08\u6ce2\u62ec\u5f27\uff09<\/span><\/strong>\u300d\u3092\u5165\u308c\u3066\u3044\u307e\u3059\u3002\u6ce2\u62ec\u5f27\u3068\u30ab\u30f3\u30de\u304c\u4f7f\u308f\u308c\u3066\u3044\u308b\u95a2\u6570\u3092\u300c\u914d\u5217\u95a2\u6570\u300d\u3068\u547c\u3076\u305d\u3046\u3067\u3059\u304c\u3001\u79c1\u306f\u8a73\u3057\u3044\u3053\u3068\u306f\u7406\u89e3\u3057\u3066\u3044\u307e\u305b\u3093\u3002\u305f\u3060\u3001\u8a08\u7b97\u5f0f\u3092\u304f\u3063\u3064\u3051\u305f\u3044\u3068\u304d\u306f<\/p>\n<p>\u300c<strong><span style=\"color: #339966\">;\uff08\u30ab\u30f3\u30de\uff09<\/span><\/strong>\u300d\u3067\u3064\u306a\u3052\u3066\u3001\u300c<strong><span style=\"color: #339966\">{ }\uff08\u6ce2\u62ec\u5f27\uff09<\/span><\/strong>\u300d\u3067\u631f\u3080<\/p>\n<p>\u3068\u899a\u3048\u3066\u3044\u307e\u3059\u3002\u4ed6\u306e\u30b7\u30c1\u30e5\u30a8\u30fc\u30b7\u30e7\u30f3\u3067\u306f\u3001\u305f\u3068\u3048\u3070\u3001IMPORTRANGE\u95a2\u6570\u3092\u4f7f\u3063\u3066\u8907\u6570\u306e\u30b7\u30fc\u30c8\u304b\u3089\u30c7\u30fc\u30bf\u3092\u62fe\u3044\u51fa\u3057\u30661\u3064\u306e\u30b7\u30fc\u30c8\u306b\u8ee2\u8a18\u3057\u305f\u3044\u3068\u304d\u306b\u3088\u304f\u4f7f\u3063\u3066\u3044\u307e\u3059\u3002QUERY\u95a2\u6570\u3084FILTER\u95a2\u6570\u3092\u4f7f\u3063\u305f\u8a08\u7b97\u5f0f\u306a\u3069\u3082\u3001\u8907\u6570\u30b7\u30fc\u30c8\u304b\u30891\u3064\u306e\u30b7\u30fc\u30c8\u306b\u8ee2\u8a18\u3055\u305b\u305f\u3044\u3068\u304d\u306f\u3001\u300c<strong><span style=\"color: #339966\">;\uff08\u30ab\u30f3\u30de\uff09<\/span><\/strong>\u300d\u3067\u3064\u306a\u3052\u3066\u3001\u300c<strong><span style=\"color: #339966\">{ }\uff08\u6ce2\u62ec\u5f27\uff09<\/span><\/strong>\u300d\u3067\u631f\u3080\u3092\u8a66\u3057\u3066\u307f\u308b\u3053\u3068\u306b\u3057\u3066\u3044\u307e\u3059\u3002\u3046\u307e\u304f\u3044\u304b\u306a\u3044\u3053\u3068\u3082\u3042\u308a\u307e\u3059\u304c\u3001\u305f\u3044\u3066\u3044\u306f\u601d\u3044\u304c\u3051\u305a\u3001\u3046\u307e\u304f\u3044\u304f\u3053\u3068\u306e\u65b9\u304c\u591a\u3044\u5370\u8c61\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u305d\u3057\u3066\u3001\u6700\u5f8c\u306b\u3001<\/p>\n<p><span style=\"font-size: 24pt\"><strong>=<span style=\"color: #ff9900\">SORT(<\/span><span style=\"color: #339966\">{<\/span><span style=\"color: #ff0000\">UNIQUE(F2:F)<\/span><span style=\"color: #339966\">;<\/span><span style=\"color: #0000ff\">UNIQUE(A2:A)<span style=\"color: #339966\">}<\/span><\/span><span style=\"color: #ff9900\">)<\/span><\/strong><\/span><\/p>\n<p>\u306e<span style=\"color: #ff9900;font-size: 24pt\"><strong> SORT() <\/strong><\/span>\u306e\u90e8\u5206\u3002<\/p>\n<p>\u300cSORT\u95a2\u6570\u300d\u306f\u30ab\u30c3\u30b3\u306e\u4e2d\u306e\u90e8\u5206\u3092\u6607\u9806\u3084\u964d\u9806\u306b\u4e26\u3079\u66ff\u3048\u3066\u304f\u308c\u307e\u3059\u3002\u3053\u306e\u8a08\u7b97\u5f0f\u3067\u3044\u3046\u3068\u3001<span style=\"color: #ff0000\"><strong>UNIQUE(F2:F)<\/strong><\/span> \u3068 <strong><span style=\"color: #0000ff\">UNIQUE(A2:A)<\/span><\/strong> \u306b\u3088\u3063\u3066\u62bd\u51fa\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u5168\u90e8\u307e\u3068\u3081\u3066\u6607\u9806\u306b\u4e26\u3079\u66ff\u3048\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002\u305d\u3046\u3059\u308b\u3068\u3001\u305f\u3060\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u9806\u306b\u306a\u308b\u3060\u3051\u306a\u306e\u3067\u3059\u304c\u3001\u89aa\u578b\u756a \u2192 \u5b50\u578b\u756a\u3001\u89aa\u578b\u756a \u2192 \u5b50\u578b\u756a&#8230;\u3068\u3044\u3046\u5177\u5408\u306b\u3001\u30bb\u30c3\u30c8\u306b\u306a\u3063\u3066\u8868\u793a\u3055\u308c\u308b\u3068\u3044\u3046\u308f\u3051\u3067\u3059\u3002Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u4f5c\u6210\u3055\u308c\u305f\u7d50\u679c\u3092\u66f8\u304d\u51fa\u3057\u3066\u307f\u308b\u3068\u3001\u4e0b\u8a18\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<ul>\n<li>TR-IP20L-BC \u2026 \u89aa\u578b\u756a\n<ul>\n<li>TR-IP20L-BC-SMBK \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20L-BC-SMRD \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20L-BC-TEDW \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20L-BC-TENW \u2026 \u5b50\u578b\u756a<\/li>\n<\/ul>\n<\/li>\n<li>TR-IP20M-BC \u2026 \u89aa\u578b\u756a\n<ul>\n<li>TR-IP20M-BC-SMBK \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20M-BC-SMBL \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20M-BC-SMGR \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20M-BC-SMKK \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20M-BC-SMRD \u2026\u5b50\u578b\u756a<\/li>\n<li>TR-IP20M-BC-TEDW \u2026\u5b50\u578b\u756a<\/li>\n<li>TR-IP20M-BC-TEKE \u2026\u5b50\u578b\u756a<\/li>\n<li>TR-IP20M-BC-TENW \u2026\u5b50\u578b\u756a<\/li>\n<\/ul>\n<\/li>\n<li>TR-IP20S-BC \u2026 \u89aa\u578b\u756a\n<ul>\n<li>TR-IP20S-BC-SMBK \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20S-BC-SMBL \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20S-BC-SMGR \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20S-BC-SMKK \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20S-BC-SMRD \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20S-BC-TEDW \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20S-BC-TEKE \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20S-BC-TENW \u2026 \u5b50\u578b\u756a<\/li>\n<\/ul>\n<\/li>\n<li>TR-IP20S-ST \u2026 \u89aa\u578b\u756a\n<ul>\n<li>TR-IP20S-ST-AG \u2026 \u5b50\u578b\u756a<\/li>\n<li>TR-IP20S-ST-CC \u2026 \u5b50\u578b\u756a<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\u3053\u3053\u307e\u3067\u4f5c\u6210\u3057\u305f\u3089\u3001\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u306e\u300c\u51fa\u54c1\u8005SKU\uff08item_sku\uff09\u300d\u306e\u6b04\u306b\u3053\u306e\u307e\u307e\u30b3\u30d4\u30da\u3057\u3066\u3001\u4ed6\u306e\u9805\u76ee\u3092\u57cb\u3081\u3066\u3044\u3051\u3070\u5b8c\u6210\u3067\u3059\uff01<\/p>\n<p>&nbsp;<\/p>\n<p>\u3068\u306f\u3044\u3048\u3001\u4ed6\u306e\u9805\u76ee\u3092\u57cb\u3081\u308b\u306e\u3082\u307e\u3060\u307e\u3060\u5927\u5909\u306a\u306e\u3067\u3059\u304c&#8230;\u4eca\u56de\u306e\u3068\u3053\u308d\u306f\u300c\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u767b\u9332\u300d\u3092\u3059\u308b\u305f\u3081\u306b\u89aa\u578b\u756a\u3068\u5b50\u578b\u756a\u306e\u30c7\u30fc\u30bf\u3092\u30b5\u30af\u30c3\u3068\u6e96\u5099\u3059\u308b\u305f\u3081\u306e\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002\u578b\u756a\u306e\u69cb\u6210\u304c\u30c8\u30ea\u30cb\u30c6\u30a3\u3068\u7570\u306a\u308b\u3053\u3068\u3082\u3042\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u304c\u3001\u578b\u756a\u306e\u4e2d\u304b\u3089\u89aa\u578b\u756a\u3092\u629c\u304d\u51fa\u305b\u308b\u300c\u6cd5\u5247\u300d\u3092\u898b\u3064\u3051\u308b\u3053\u3068\u304c\u30dd\u30a4\u30f3\u30c8\u3067\u3059\u3002\u30c8\u30ea\u30cb\u30c6\u30a3\u306e\u3088\u3046\u306b\u3001\u578b\u756a\u306e\u69cb\u6210\u304c\u3069\u306e\u88fd\u54c1\u3082\u540c\u3058\u3067\u3001\u300c-\uff08\u30cf\u30a4\u30d5\u30f3\uff09\u300d\u306a\u3069\u306e\u8a18\u53f7\u3067\u5206\u89e3\u3067\u304d\u308b\u3088\u3046\u3067\u3042\u308c\u3070\u3001\u3054\u7d39\u4ecb\u3057\u305f\u65b9\u6cd5\u3067\u89aa\u578b\u756a\u3092\u4f5c\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3068\u601d\u3044\u307e\u3059\u3002\u3082\u3063\u3068\u30b7\u30f3\u30d7\u30eb\u306b\u3001\u5de6\u304b\u3089\u6c7a\u3081\u3089\u308c\u305f\u6587\u5b57\u6570\u304c\u89aa\u578b\u756a\u306b\u306a\u308a\u305d\u3046\u3067\u3042\u308c\u3070\u300cLEFT\u95a2\u6570\u300d\u304c\u4f7f\u3048\u305d\u3046\u3067\u3059\u3002\u3042\u3068\u306f\u3001\u89aa\u578b\u756a\u3068\u5b50\u578b\u756a\u3092\u305d\u308c\u305e\u308cUNIQUE\u95a2\u6570\u306b\u5165\u308c\u3066\u3001UNIQUE\u95a2\u6570\u3092\u30ab\u30f3\u30de\u3067\u304f\u3063\u3064\u3051\u3066\u6ce2\u62ec\u5f27\u3067\u56f2\u3093\u3067\u3001\u305d\u308c\u3092SORT\u95a2\u6570\u306b\u5165\u308c\u308c\u3070\u3001\u89aa\u578b\u756a\u3068\u5b50\u578b\u756a\u306e\u30bb\u30c3\u30c8\u306e\u5b8c\u6210\u3067\u3059\u3002<\/p>\n<p>\u8a08\u7b97\u5f0f\u30921\u56de\u4f5c\u3063\u3066\u3057\u307e\u3048\u3070\u30012\u56de\u76ee\u4ee5\u964d\u306f\u578b\u756a\u3092\u8cbc\u308a\u4ed8\u3051\u308b\u3060\u3051\u3067\u3001\u89aa\u578b\u756a\u3068\u5b50\u578b\u756a\u304c1\u30bb\u30c3\u30c8\u306b\u306a\u3063\u305f\u30c7\u30fc\u30bf\u3092\u4f5c\u308b\u3053\u3068\u304c\u3067\u304d\u3066\u4fbf\u5229\u3067\u3059\u3002\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u3068\u95d8\u3063\u3066\u3044\u308b\u65b9\u304c\u3044\u3089\u3063\u3057\u3083\u3044\u307e\u3057\u305f\u3089\u3001\u305c\u3072\u8a66\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4eca\u56de\u306f\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u30c1\u30fc\u30e0\u304c\u5b9a\u3081\u305f5\u301c9\u6708\u306e\u30d6\u30ed\u30b0\u30c6\u30fc\u30de\u304b\u3089\u9078\u3093\u3060\u300c\u81ea\u5206\u306e\u30c1\u30fc\u30e0\u306e\u4ed5\u4e8b\u5185\u5bb9\u3084\u53d6\u308a\u7d44\u307f\u306b\u3064\u3044\u3066\u300d\u3001\u5148\u65e5\u4f5c\u6210\u3057\u305fAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002 &nbsp; \u25bc\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u3068\u306e\u95d8\u3044 \u30c8\u30ea\u30cb\u30c6\u30a3\u306fAmazon\u3067\u3082\u88fd\u54c1\u3092\u8ca9\u58f2\u3057\u3066\u3044\u307e\u3059\u3002Amazon\u3067\u8ca9\u58f2\u3059\u308b\u305f\u3081\u306b\u306f\u3001Amazon\u306e\u30bb\u30e9\u30fc\u30bb\u30f3\u30c8\u30e9\u30eb\u304b\u3089\u88fd\u54c1\u767b\u9332\u7528\u306e\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u88fd\u54c1\u60c5\u5831\u3092\u5165\u529b\u3057\u3001\u305d\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30b7\u30b9\u30c6\u30e0\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u306e\u88fd\u54c1\u3092\u767b\u9332\u3059\u308b\u305f\u3081\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u3068\u547c\u3093\u3067\u3044\u307e\u3059\u3002\u3053\u306e\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u306b\u5165\u529b\u3059\u308b\u4f5c\u696d\u3002\u5b9f\u306f\u306a\u304b\u306a\u304b\u9aa8\u306e\u6298\u308c\u308b\u4f5c\u696d\u3067\u3059\u3002 \u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u306e\u5165\u529b\u4f5c\u696d\u304c\u5927\u5909\u306a\u7406\u7531 \u767b\u9332\u3059\u308b\u88fd\u54c1\u6570\u304c\u591a\u3044\u305f\u3081\u3001\u88fd\u54c1\u30ea\u30b9\u30c8\u304b\u3089\u5fc5\u8981\u306a\u60c5\u5831\u3092\u3072\u3068\u3064\u305a\u3064\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u306b\u30b3\u30d4\u30da\u3059\u308b\u3068\u306a\u308b\u3068\u3001\u5b8c\u6210\u307e\u3067\u306b\u81a8\u5927\u306a\u6642\u9593\u304c\u304b\u304b\u3063\u3066\u3057\u307e\u3046\u3002\u591a\u3044\u3068\u304d\u306f\u3001\u4e00\u5ea6\u306b200\u578b\u756a\u304f\u3089\u3044\u767b\u9332\u3059\u308b\u3002 \u88fd\u54c1\u578b\u756a\u304c\u4f3c\u3066\u3044\u308b\u305f\u3081\u3001\u30b3\u30d4\u30da\u30df\u30b9\u304c\u767a\u751f\u3057\u3084\u3059\u3044\u3002 \u767b\u9332\u3059\u3079\u304d\u81a8\u5927\u306a\u88fd\u54c1\u6570\u3068\u9593\u9055\u3063\u3066\u306f\u3044\u3051\u306a\u3044\u30d7\u30ec\u30c3\u30b7\u30e3\u30fc\u3067\u3001\u3068\u3093\u3067\u3082\u306a\u3044\u76ee\u306e\u75b2\u52b4\u306b\u8972\u308f\u308c\u308b\u3002\u305d\u3057\u3066\u3001\u3082\u306e\u3059\u3054\u304f\u6c17\u3092\u3064\u3051\u3066\u3044\u308b\u306e\u306b\u3001\u9593\u9055\u3063\u3066\u3057\u307e\u3046\u3053\u3068\u3082\u305f\u307e\u306b\u3042\u3063\u3066\u60b2\u3057\u3044\u3002 \u3082\u3057\u304b\u3059\u308b\u3068\u3001Amazon\u306b\u88fd\u54c1\u3092\u767b\u9332\u3055\u308c\u305f\u3053\u3068\u306e\u3042\u308b\u65b9\u306f\u7d4c\u9a13\u3057\u305f\u3053\u3068\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u88fd\u54c1\u3092\u4e00\u62ec\u767b\u9332\u3059\u308b\u305f\u3081\u306e\u5916\u90e8\u30b5\u30fc\u30d3\u30b9\u3082\u3042\u308b\u306e\u3067\u3059\u304c\u3001\u30c8\u30ea\u30cb\u30c6\u30a3\u3067\u306f\u88fd\u54c1\u306e\u30ea\u30b9\u30c8\u3092Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u307e\u3068\u3081\u3066\u3044\u3066\u3001\u5916\u90e8\u30b5\u30fc\u30d3\u30b9\u306b\u5408\u308f\u305b\u305f\u30ea\u30b9\u30c8\u3092\u4f5c\u308b\u5fc5\u8981\u304c\u3042\u308a\u305d\u3046\u3067\u3057\u305f\u3002\u305d\u3053\u3067\u3001\u73fe\u5728\u30c8\u30ea\u30cb\u30c6\u30a3\u3067\u4f7f\u3063\u3066\u3044\u308b\u88fd\u54c1\u30ea\u30b9\u30c8\u3092\u7528\u3044\u3066\u3001\u767b\u9332\u3057\u305f\u3044\u578b\u756a\u3068\u3044\u304f\u3064\u304b\u306e\u6761\u4ef6\u3092\u8a2d\u5b9a\u3059\u308c\u3070\u3001\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u304c\u5b8c\u6210\u3059\u308b\u4ed5\u7d44\u307f\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u305f\u3002 \u88fd\u54c1\u306eJAN\u30b3\u30fc\u30c9\u3084\u578b\u756a\u3001\u88fd\u54c1\u540d\u3084\u4ed5\u69d8\u306e\u66f8\u304b\u308c\u305fGoogle\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u304b\u3089\u3001IMPORTRANGE\u95a2\u6570\u3084VLOOKUP\u95a2\u6570\u3092\u4f7f\u3063\u3066\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u306b\u8ee2\u8a18\u3055\u305b\u308b\u3068\u3044\u3046\u306e\u304c\u3001\u304a\u304a\u307e\u304b\u306a\u4ed5\u7d44\u307f\u3067\u3059\u3002\u8ee2\u8a18\u3059\u308b\u65b9\u6cd5\u306f\u73fe\u5728\u304a\u4f7f\u3044\u306e\u88fd\u54c1\u30ea\u30b9\u30c8\u306b\u3088\u3063\u3066\u591a\u5c11\u6d41\u308c\u304c\u7570\u306a\u308b\u3068\u601d\u3044\u307e\u3059\u306e\u3067\u4eca\u56de\u306f\u601d\u3044\u5207\u3063\u3066\u5272\u611b\u3057\u3001\u300eAmazon\u767b\u9332\u30d5\u30a9\u30fc\u30e0\u300f\u306e\u300c\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u767b\u9332\u300d\u306b\u95a2\u308f\u308b\u9805\u76ee\u306e\u5165\u529b\u3059\u308b\u30b3\u30c4\u3092\u307e\u3068\u3081\u3066\u3044\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002 &nbsp; \u25bcAmazon\u306e\u300c\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u767b\u9332\u300d \u4ee5\u4e0b\u306e\u30b9\u30af<\/p>\n","protected":false},"author":93,"featured_media":12029,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[21],"tags":[122],"class_list":["post-12028","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-21","tag-Google"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/trinity.jp\/archive\/wp-json\/wp\/v2\/posts\/12028","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trinity.jp\/archive\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trinity.jp\/archive\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trinity.jp\/archive\/wp-json\/wp\/v2\/users\/93"}],"replies":[{"embeddable":true,"href":"https:\/\/trinity.jp\/archive\/wp-json\/wp\/v2\/comments?post=12028"}],"version-history":[{"count":0,"href":"https:\/\/trinity.jp\/archive\/wp-json\/wp\/v2\/posts\/12028\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trinity.jp\/archive\/wp-json\/wp\/v2\/media\/12029"}],"wp:attachment":[{"href":"https:\/\/trinity.jp\/archive\/wp-json\/wp\/v2\/media?parent=12028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trinity.jp\/archive\/wp-json\/wp\/v2\/categories?post=12028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trinity.jp\/archive\/wp-json\/wp\/v2\/tags?post=12028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}