{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["メイン","取得結果","設定","ASIN変換リスト","変換シート"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"メイン","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"↓チャットワーク",null,"↓ホームページ"]
[null,null,null,"本ツールに関するお問い合わせは⇒","https://www.chatwork.com/murakami15",null,"http://ec-merchant.com/"]
[null,null,"Amazon検索URL"]
[null,null,"URL入力","https://www.amazon.co.jp/s/ref=nb_sb_noss_2?__mk_ja_JP=%E3%82%AB%E3%82%BF%E3%82%AB%E3%83%8A&url=search-alias%3Daps&field-keywords=%E6%99%82%E8%A8%88%E3%80%80%E3%82%AB%E3%82%B7%E3%82%AA","　"]
[null,null,"取得上限数",300]
[null,null,"取得情報の設定"]
[null,null,"番号","内容","状態","処理速度目安（ASIN/時間)","分類色","注意事項"]
[null,null,1,"PAAPIのみで取得できる基本情報","有効",10000,null,"要MWSアカウント"]
[null,null,2,"MWSで取得できる最低価格などの基本情報","有効",10000,null,"要MWSアカウント"]
[null,null,3,"MWSで取得できるFBA出品者数の情報","無効",200,null,"制限が厳しい"]
[null,null,4,"モノレートで取得できるランキング変動数の情報","無効",400,null,"スクレイピングのため40件ごとにインターバル、1日2000件まで"]
[null,null,5,"海外アマゾンの価格情報（アメリカ）","無効",10000,null,"要海外PAAPIアカウント"]
[null,null,6,"海外アマゾンの価格情報（イギリス）","無効",10000,null,"要海外PAAPIアカウント"]
[null,null,7,"海外アマゾンの価格情報（イタリア）","無効",10000,null,"要海外PAAPIアカウント"]
[null,null,8,"海外アマゾンの価格情報（フランス）","無効",10000,null,"要海外PAAPIアカウント"]
[null,null,9,"海外アマゾンの価格情報（ドイツ）","無効",10000,null,"要海外PAAPIアカウント"]
[null,null,10,"海外アマゾンの価格情報（スペイン）","無効",10000,null,"要海外PAAPIアカウント"]
[]
[null,null,"使用方法）"]
[null,null,"1.ASINの取得から行う場合はF4セルにアマゾンの検索URLを入力する"]
[null,null,"2.①のASIN取得ボタンを押すと取得結果タブにASINを出力します"]
[null,null,"3.取得したい情報を選択してE列の状態を設定"]
[null,null,"4.取得結果タブのA列に情報を取得したいASINを記入した状態で②の商品情報取得ボタンをクリックします"]

{"sheet":"取得結果","index":1,"n_rows":10,"n_cols":46,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["ASIN","商品名","ブランド名","カート価格","カート送料","発送重量 [g]","サイズ 高さ [cm]","サイズ 幅 [cm]","サイズ 奥行 [cm]","容積重量係数 [cm3/kg]","容積重量 [kg]","カテゴリー手数料","販売手数料","出荷費用合計","カテゴリー別成約料","基本成約料","発送重量手数料","出荷作業手数料","FBA出品者数","カテゴリー","ランキング","新品最安値平均","新品出品者平均","ランキング平均","ランキング変動数\n（１ヶ月）","ランキング変動数\n（２ヶ月）","ランキング変動数\n（３ヶ月）","モノレート","US価格($)","US商品URL","USセラー名","UK価格(￡)","UK商品URL","UKセラー名","IT価格(€)","IT商品URL","ITセラー名","FR価格(€)","FR商品URL","FRセラー名","DE価格(€)","DE商品URL","DEセラー名","ES価格(€)","ES商品URL","ESセラー名"]
["B0719L43B6","[ラドウェザー] 時計 フィールド ギア デジタルコンパス/高度計/気圧計/温度計/天気予測/湿度計 釣り/ハイキング/キャンプ/サイクリング カラビナ ウォッチ","LAD WEATHER(ラドウェザー）",3740,0,80,3,16,8,5000,{"$f":"G2*H2*I2/J2","v":7.6799999999999993E-2},0.15,561,329,0,0,229,100,null,"時計",438]
["B01MRACAUE","[ラドウェザー] 腕時計 高度計/ 気圧計/ 温度計 距離/ 速度/ 歩数/ 運動時間/ 消費カロリー スマートラップ 登山/ 山登り ランニングウォッチ デジタル時計","LAD WEATHER(ラドウェザー）",9800,0,80,10,11,11,5000,0.24199999999999999,0.15,1470,329,0,0,229,100,null,"時計",2399]
["B00C0LZS18","[ラドウェザー]腕時計 ドイツ製センサー デジタル コンパス 高度計 気圧計 温度計　アウトドア時計","LAD WEATHER(ラドウェザー）",7450,0,20,11,15,12,5000,0.39600000000000002,0.15,1118,329,0,0,229,100,null,"時計",1900]
["B000VOBQXK","CASIO MQ-24-7B2LLJF Men's Analog Watch","CASIO STANDARD(カシオ スタンダード)",939,0,80,2,15,8,5000,4.8000000000000001E-2,0.15,141,329,0,0,229,100,null,"時計",1]
["B00FLMCJMY","[カシオ]Casio 腕時計 スタンダードデジタルウォッチ 日常生活防水 LEDライトつき F-91W-1JF メンズ","CASIO STANDARD(カシオ スタンダード)",940,0,140,2,15,6,5000,3.5999999999999997E-2,0.15,141,329,0,0,229,100,null,"時計",2]
["B00ME67X5I","[カシオ]CASIO 腕時計 スタンダードアナログウォッチ ブラック×ゴールド 海外モデル 国内メーカー保証付き MQ-24-1B2LJF","CASIO STANDARD(カシオ スタンダード)",1382,0,180,2,15,6,5000,3.5999999999999997E-2,0.15,207,329,0,0,229,100,null,"時計",3]
["B008NYUJ9C","[カシオ]CASIO 腕時計 WAVE CEPTOR 世界6局対応電波ソーラー WVA-M630D-1AJF メンズ","WAVE CEPTOR(ウェーブセプター)",8380,0,220,8,11,10,5000,0.17599999999999999,0.15,1257,329,0,0,229,100,null,"時計",261]
["B0076FBBMS","[カシオ]CASIO 腕時計 WAVE CEPTOR ウェーブセプター タフソーラー 電波時計 MULTIBAND 6 WVQ-M410-1AJF メンズ","WAVE CEPTOR(ウェーブセプター)",8769,0,200,8,11,10,5000,0.17599999999999999,0.15,1315,329,0,0,229,100,null,"時計",26]
["B003OIB8Q0","[カシオ]CASIO 腕時計  スタンダード A158WA-1JF メンズ","CASIO STANDARD(カシオ スタンダード)",1090,0,20,2,15,6,5000,3.5999999999999997E-2,0.15,164,329,0,0,229,100,null,"時計",5]

{"sheet":"設定","index":2,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"アマゾンPA-APIアカウント情報設定（日本）",null,null,"為替情報","※エクセルを開いた際にヤフーファイナンスから取得"]
[null,"AWSアクセスキーID","AKIAJWYZXQ57QND7DNEA",null,"ドル/円",105.82]
[null,"秘密キー","iNDLIrTVK84d/qxVHAWfra97nfV9eOMLaYOBMexf",null,"ユーロ/円",130.29]
[null,"アソシエイトタグ","mamegomari-22",null,"ポンド/円",146.13999999999999]
[null,"※無料で取得可能なAPIアカウント、開発者の記入済アカウントも使用可能"]
[]
[null,"アマゾンMWSアカウント情報設定（日本）"]
[null,"AWSアクセスキーID","AKIAI23J7OMOAPQFVTGQ"]
[null,"秘密キー","/MVEJ2vfyJ0IEjqo9eqLXXC1mxgYHS1UGpGZOzqz"]
[null,"セラーID","A3449AXENJUW3T"]
[null,"※大口出品者が取得可能なMWSアカウント"]
[]
[null,"アマゾンPA-APIアカウント情報設定（アメリカ）"]
[null,"AWSアクセスキーID","AKIAJ6JYFU62BTJQK4TA"]
[null,"秘密キー","F64bY/W4JBQR9GfLvXmQhwwo1nWsyJteDG0/W1fy"]
[null,"アソシエイトタグ","ecmerchant77-20"]
[null,"※無料で取得可能なAPIアカウント、開発者の記入済アカウントも使用可能"]
[]
[null,"アマゾンPA-APIアカウント情報設定（イギリス）"]
[null,"AWSアクセスキーID","AKIAJ6JYFU62BTJQK4TA"]
[null,"秘密キー","F64bY/W4JBQR9GfLvXmQhwwo1nWsyJteDG0/W1fy"]
[null,"アソシエイトタグ","ecmerchant10b-21"]
[null,"※無料で取得可能なAPIアカウント、開発者の記入済アカウントも使用可能"]
[]
[null,"アマゾンPA-APIアカウント情報設定（ドイツ）"]
[null,"AWSアクセスキーID","AKIAJ6JYFU62BTJQK4TA"]
[null,"秘密キー","F64bY/W4JBQR9GfLvXmQhwwo1nWsyJteDG0/W1fy"]
[null,"アソシエイトタグ","ecmerchant11-21"]
[null,"※無料で取得可能なAPIアカウント、開発者の記入済アカウントも使用可能"]
[]
[null,"アマゾンPA-APIアカウント情報設定（フランス）"]
[null,"AWSアクセスキーID","AKIAJ6JYFU62BTJQK4TA"]
[null,"秘密キー","F64bY/W4JBQR9GfLvXmQhwwo1nWsyJteDG0/W1fy"]
[null,"アソシエイトタグ","ecmerchant106-21"]
[null,"※無料で取得可能なAPIアカウント、開発者の記入済アカウントも使用可能"]
[]
[null,"アマゾンPA-APIアカウント情報設定（イタリア）"]
[null,"AWSアクセスキーID","AKIAJ6JYFU62BTJQK4TA"]
[null,"秘密キー","F64bY/W4JBQR9GfLvXmQhwwo1nWsyJteDG0/W1fy"]
[null,"アソシエイトタグ","ecmerchant107-21"]
[null,"※無料で取得可能なAPIアカウント、開発者の記入済アカウントも使用可能"]
[]
[null,"アマゾンPA-APIアカウント情報設定（スペイン）"]
[null,"AWSアクセスキーID","AKIAJ6JYFU62BTJQK4TA"]
[null,"秘密キー","F64bY/W4JBQR9GfLvXmQhwwo1nWsyJteDG0/W1fy"]
[null,"アソシエイトタグ","ecmerchant108-21"]
[null,"※無料で取得可能なAPIアカウント、開発者の記入済アカウントも使用可能"]

{"sheet":"ASIN変換リスト","index":3,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ASIN変換表",null,"※あらかじめ下の変換テーブルを埋めておくと、日本のASINと海外のASINが異なる場合に変換表のASINを利用する"]
[]
[null,"日本ASIN","日本JAN","⇒","アメリカ","イギリス","イタリア","フランス","ドイツ",null,null,"例）","日本ASIN","⇒","アメリカ"]
[null,"B00DBQQAT0","4971850978381",null,"B009A5WBIK","B00DBQQAT0","B00DBQQAT0","B00DBQQAT0","B00DBQQAT0",null,null,null,"B00JXRRSLK",null,"B018D6A818"]

{"sheet":"変換シート","index":4,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"日本ASINまたはJANコードから海外アマゾンのASINを検索し変換リストに登録する"]
[null,"入力データ"]
[null,"ASIN","←入力するデータの種類を選択"]
[null,"↓データを貼付け",null,"↓入力にあわせて自動で取得"]
[null,{"$f":"IF($B$4=\"JAN\",\"日本JAN\",\"日本ASIN\")","v":"日本ASIN"},"⇒",{"$f":"IF($B$4=\"JAN\",\"日本ASIN\",\"日本JAN\")","v":"日本JAN"},"⇒","アメリカ","イギリス","イタリア","フランス","ドイツ"]
[null,"B01MYURQRZ",null,"8990085063354",null,"-","-","-","-","-"]
[null,"B005JVP0LE",null,"7848059615324",null,"B005JVP0LE","B005JVP0LE","B005JVP0LE","B005JVP0LE","B005JVP0LE"]
[null,"B01FD9QR86",null,"6957559250391",null,"B01FD9QR86","B01FD9QR86","B01FD9QR86","B01FD9QR86","B01FD9QR86"]
[null,"B01ALKEX6U",null,"6957559246356",null,"B01ALKEX6U","B01ALKEX6U","B01ALKEX6U","B01ALKEX6U","B01ALKEX6U"]
[null,"B00DIY5NKM",null,"6957559212962",null,"B00DIY5NKM","B00DIY5NKM","B00DIY5NKM","B00DIY5NKM","B00DIY5NKM"]
[null,"B017IJ5AOG",null,"6954847751141",null,"B017IJ5AOG","B017IJ5AOG","-","-","B017IJ5AOG"]
[null,"B074T42BLQ",null,"6908923165513",null,"-","-","-","-","-"]
[null,"B074T5FQ3C",null,"6519274009311",null,"-","-","-","-","-"]
[null,"B074SGPFPH",null,"6519274009106",null,"-","-","-","-","-"]
[null,"B074SGPFPH",null,"6519274009106",null,"-","-","-","-","-"]
[null,"B013GNRDNO",null,"5745029267182",null,"-","-","-","-","-"]
[null,"B000MMCPKO",null,"5055284716104",null,"B000MMCPKO","B000MMCPKO","B000MMCPKO","B000MMCPKO","B000MMCPKO"]
[null,"B071ZKX3SL",null,"4988617312821",null,"-","-","-","-","-"]
[null,"B00I2E4YL2",null,"4971850996163",null,"B00I2E4YL2","-","-","-","-"]
[null,"B00IK5Z3T0",null,"4971850995012",null,"B00IK5Z3T0","B00IK5Z3T0","-","-","-"]
[null,"B00IK5Z3T0",null,"4971850995012",null,"B00IK5Z3T0","B00IK5Z3T0","-","-","-"]
[null,"B00I2E4YOE",null,"4971850994527",null,"B00I2E4YOE","-","-","-","-"]
[null,"B00I2E4YOE",null,"4971850994527",null,"B00I2E4YOE","-","-","-","-"]
[null,"B00FLMCJMY",null,"4971850988021",null,"B00FLMCJMY","B00FLMCJMY","B00FLMCJMY","B00FLMCJMY","B00FLMCJMY"]
[null,"B00GNPN1Y8",null,"4971850983934",null,"B00GNPN1Y8","-","-","-","-"]
[null,"B00GNPN1Y8",null,"4971850983934",null,"B00GNPN1Y8","-","-","-","-"]
[null,"B00FJISY5G",null,"4971850983927",null,"B00FJISY5G","-","-","-","-"]
[null,"B00CY158WS",null,"4971850980421",null,"B00CY158WS","-","-","-","-"]
[null,"B00CY158WS",null,"4971850980421",null,"B00CY158WS","-","-","-","-"]
[null,"B00DBQQAT0",null,"4971850978381",null,"B009A5WBIK","B00DBQQAT0","B00DBQQAT0","B00DBQQAT0","B00DBQQAT0"]
[null,"B007EGYEDM",null,"4971850966173",null,"B007EGYEDM","-","B007EGYEDM","B007EGYEDM","B007EGYEDM"]
[null,"B0086ZP7LS",null,"4971850965466",null,"-","-","-","-","-"]
[null,"B0086ZP6JG",null,"4971850965459",null,"-","-","-","-","-"]
[null,"B0086ZP6IM",null,"4971850965442",null,"-","B0086ZP6IM","-","-","-"]
[null,"B0086ZP6IM",null,"4971850965442",null,"-","B0086ZP6IM","-","-","-"]
[null,"B006JUUQJK",null,"4971850961932",null,"B006JUUQJK","-","-","-","-"]