{"id":1860,"date":"2017-06-02T20:22:12","date_gmt":"2017-06-02T11:22:12","guid":{"rendered":"http:\/\/alaki.co.jp\/blog\/?p=1860"},"modified":"2017-06-02T20:22:12","modified_gmt":"2017-06-02T11:22:12","slug":"ec-cube%e3%81%a7%e5%8f%97%e6%b3%a8%e5%95%86%e5%93%81%e3%82%92csv%e5%87%ba%e5%8a%9b%e3%82%92%e9%a0%bc%e3%81%be%e3%82%8c%e3%81%9f%e3%81%a8%e3%81%8d%e3%81%ae%e5%87%a6%e6%96%b9%e7%ae%8b","status":"publish","type":"post","link":"http:\/\/test.alaki.co.jp\/blog\/?p=1860","title":{"rendered":"EC-CUBE\u3067\u53d7\u6ce8\u5546\u54c1\u3092CSV\u51fa\u529b\u3092\u983c\u307e\u308c\u305f\u3068\u304d\u306e\u51e6\u65b9\u7b8b"},"content":{"rendered":"<p>\u3053\u3093\u3070\u3093\u306f\u3001Web\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u7be0\u7530\u3067\u3059\u3002<\/p>\n<p>PC\u306e\u6392\u71b1\u304c\u51f6\u5668\u306b\u306a\u308b\u5b63\u7bc0\u306b\u306a\u308a\u307e\u3057\u305f\u3002<br \/>\n\u30aa\u30d5\u30a3\u30b9\u3067\u4f7f\u3063\u3066\u3044\u308bPC\u306b\u306f\u65e2\u306b\u3001PC\u306e\u51b7\u5374\u7528\u7a7a\u51b7\u30d5\u30a1\u30f3\u3092\u53d6\u308a\u4ed8\u3051\u3066\u5feb\u9069\u306b\u904e\u3054\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>EC-CUBE\u3067\u30b5\u30a4\u30c8\u3092\u904b\u55b6\u3055\u308c\u3066\u3044\u308b\u65b9\u3082\u591a\u3044\u3068\u601d\u3044\u307e\u3059\u3002<br \/>\nEC-CUBE\u306e\u904b\u7528\u306e\u4e2d\u3067\u51fa\u3066\u304f\u308b\u56f0\u3063\u305f\u554f\u984c\u304c\u300c\u53d7\u6ce8\u5546\u54c1\u306eCSV\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u300d\u3067\u3059\u3002<\/p>\n<p>\u3053\u306e\u554f\u984c\u306b\u5bfe\u3057\u3066\u3001\u5bfe\u51e6\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<p><!--more--><\/p>\n<h2>\u554f\u984c\u70b9<\/h2>\n<p>EC\u2212CUBE\u3067\u306f\u3001\u53d7\u6ce8\u7ba1\u7406\u6a5f\u80fd\u3068\u3057\u3066CSV\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001\u305d\u306e\u4e2d\u306b\u300c\u5546\u54c1\u540d\u300d\u3068\u3044\u3046\u9805\u76ee\u306f\u5b58\u5728\u3057\u306a\u3044\u306e\u3067\u3059\u3002<br \/>\n\u3064\u307e\u308a\u3001\u5546\u54c1\u540d\u4ed8\u304d\u306e\u53d7\u6ce8\u30c7\u30fc\u30bf\u3092EC-CUBE\u7ba1\u7406\u753b\u9762\u304b\u3089\u306f\u3001\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u304c\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n<h2>\u6a21\u7bc4\u89e3\u7b54<\/h2>\n<p>\u3053\u306e\u554f\u984c\u306b\u5bfe\u3057\u3066\u306e\u6a21\u7bc4\u89e3\u7b54\u306f\u4e0b\u8a18\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n<p><strong>\u300cEC-CUBE\u306e\u5546\u54c1\u540d\u3092\u542b\u3080\u53d7\u6ce8\u30c7\u30fc\u30bf\u306eCSV\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u6a5f\u80fd\u3092\u5b9f\u88c5\u3059\u308b\uff01\u300d<\/strong><br \/>\n<strong><br \/>\n\u300c\u9ad8\u5ea6\u306a\u8a2d\u5b9a\u3067SQL\u3092\u4f7f\u3044CSV\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u300d<\/strong><\/p>\n<p>\u3053\u306e\u3042\u305f\u308a\u304c\u3001Google\u5148\u751f\u306b\u8cea\u554f\u3092\u3057\u3066\u3001\u89e3\u7b54\u3068\u3057\u3066\u6559\u3048\u3066\u3082\u3089\u3048\u308b\u5185\u5bb9\u304b\u3068\u304a\u3082\u3044\u307e\u3059\u3002<\/p>\n<h2>\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u4f5c\u308b\u3001\u307e\u305f\u306f\u9b54\u6539\u9020\u3059\u308b<\/h2>\n<p>\u591a\u304f\u306eWeb\u30d7\u30ed\u30b0\u30e9\u30de\u304c\u3001\u6301\u3066\u308b\u30b9\u30ad\u30eb\u3068Google\u5148\u751f\u306e\u52a9\u8a00\u3092\u30d5\u30eb\u306b\u4f7f\u3063\u3066\u3001\u6226\u3044\u3092\u6311\u3080\u30d9\u30bf\u30fc\u306a\u65b9\u6cd5\u3067\u3059\u3002<\/p>\n<p>\u305f\u3060\u3057\u3001\u3053\u306e\u624b\u6cd5\u306f\u300c\u8cc7\u91d1\u300d\u3068\u300c\u6642\u9593\u300d\u304c\u3042\u308b\u3053\u3068\u304c\u524d\u63d0\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><strong>\u300c\u4eca\u65e5\u4e2d\u306b\u30c7\u30fc\u30bf\u304c\u307b\u3057\u826f\u3044\u3093\u3060\u3088\u3002\u305d\u308c\u3082\u4eca\u56de\u3060\u3051\u3002\u300d<\/strong><\/p>\n<p>\u3053\u306e\u3088\u3046\u306a\u6848\u4ef6\u3067\u3001\u30c1\u30e3\u30ec\u30f3\u30b8\u3059\u308b\u3068\u76ee\u7684\u3092\u9054\u6210\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n<h2>EC\u2212CUBE\u3067SQL\u3092\u4f7f\u3046<\/h2>\n<p>\u3053\u308c\u306f\u3001Web\u30d7\u30ed\u30b0\u30e9\u30de\u3067\u3042\u308c\u3070\u3001\u6bd4\u8f03\u7684\u624b\u8efd\u306a\u65b9\u6cd5\u3067\u3059\u3002<\/p>\n<p>\u305f\u3060\u3057\u3001\u3053\u306e\u65b9\u6cd5\u306b\u3082\u7f60\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u4e00\u90e8\u306eEC-CUBE\u3067\u306f\u3001\u300c\u9ad8\u5ea6\u306a\u8a2d\u5b9a\u300d\u3092\u5229\u7528\u3057\u3066SQL\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u753b\u9762\u304c\u771f\u3063\u767d\u306b\u306a\u308b\u3068\u3044\u3046\u73fe\u8c61\u306b\u906d\u9047\u3057\u307e\u3059\u3002<\/p>\n<p>\u6b63\u76f4\u3001\u304a\u6025\u304e\u306e\u3068\u304d\u306b\u4e0d\u5177\u5408\u306e\u539f\u56e0\u3092\u89e3\u6c7a\u3059\u308b\u3068\u3044\u3046\u306e\u306f\u3001\u30d9\u30b9\u30c8\u306a\u65b9\u6cd5\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<h2>\u4f4e\u30b3\u30b9\u30c8\u3067\u89e3\u6c7a\u3059\u308b\u65b9\u6cd5<\/h2>\n<p>\u3044\u304f\u3064\u304b\u306e\u6761\u4ef6\u304c\u5fc5\u8981\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>1\uff0e1\u5546\u54c11\u53d7\u6ce8\u30c7\u30fc\u30bf\u306e\u5f62\u5f0f\u3067\u51fa\u529b\u3057\u3066\u3082\u826f\u3044\u3002<br \/>\n\u3000\u3000\u2192\u30001\u53d7\u6ce8\u3067\u8907\u6570\u5546\u54c1\u3092\u51fa\u529b\u3057\u3066\u307b\u3057\u3044\u3068\u8a00\u308f\u308c\u308b\u3068\u30c0\u30e1\u3067\u3059\u3002<\/p>\n<p>2\uff0eSQL\u306f\u7406\u89e3\u3067\u304d\u308b\u3002<\/p>\n<p>3\uff0eEC-CUBE\u306e\u300c\u9ad8\u5ea6\u306a\u8a2d\u5b9a\u300d\u3067SQL\u304c\u52d5\u304b\u306a\u304b\u3063\u305f\u3002<\/p>\n<p>\u3053\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3057\u3066\u3044\u308b\u5834\u5408\u306b\u9650\u308a\u307e\u3059\u306e\u3067\u3001\u4e88\u3081\u3054\u4e86\u627f\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u4f55\u3092\u3059\u308b\u304b\u3068\u3044\u3046\u3068\u4e0b\u8a18\u306eSQL\u6587\u3092\u300cphpMyAdmin\u300d\u3067\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"lang:mysql decode:true \" title=\"\u53d7\u6ce8\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308bSQL\" >SELECT\r\n    dtb_order.order_id,\r\n    dtb_order.customer_id,\r\n    dtb_order.message,\r\n    dtb_order.order_name01,\r\n    dtb_order.order_name02,\r\n    dtb_order.order_kana01,\r\n    dtb_order.order_kana02,\r\n    dtb_order.order_email,\r\n    dtb_order.order_tel01,\r\n    dtb_order.order_tel02,\r\n    dtb_order.order_tel03,\r\n    dtb_order.order_fax01,\r\n    dtb_order.order_fax02,\r\n    dtb_order.order_fax03,\r\n    dtb_order.order_zip01,\r\n    dtb_order.order_zip02,\r\n    (SELECT mtb_pref.name FROM mtb_pref WHERE mtb_pref.id = dtb_order.order_pref),\r\n    dtb_order.order_addr01,\r\n    dtb_order.order_addr02,\r\n    dtb_order.order_sex,\r\n    dtb_order.order_birth,\r\n    dtb_order.order_job,\r\n    dtb_order_detail.product_name,\r\n    dtb_order_detail.product_code,\r\n    dtb_order_detail.classcategory_name1,\r\n    dtb_order_detail.classcategory_name2,\r\n    dtb_order_detail.price,\r\n    dtb_order_detail.quantity,\r\n    dtb_order.subtotal,\r\n    dtb_order.discount,\r\n    dtb_order.deliv_fee,\r\n    dtb_order.charge,\r\n    dtb_order.use_point,\r\n    dtb_order.add_point,\r\n    dtb_order.tax,\r\n    dtb_order.total,\r\n    dtb_order.payment_total,\r\n    dtb_order.deliv_id,\r\n    dtb_order.payment_method,\r\n    dtb_order.note,\r\n    dtb_order.status,\r\n    dtb_order.create_date,\r\n    dtb_order.update_date,\r\n    dtb_order.commit_date,\r\n    dtb_order.device_type_id,\r\n    (SELECT count(*) FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id)\r\nFROM\r\n    dtb_order\r\nINNER JOIN\r\n    dtb_order_detail\r\nON\r\n    dtb_order.order_id = dtb_order_detail.order_id\r\nWHERE\r\n    del_flg = 0<\/pre>\n<p>\u3053\u306e\u7d50\u679c\u3092\u3001phpMyAdmin\u306e\u6a5f\u80fd\u3067\u3042\u308b\u300c\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u300d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3092\u3059\u308b\u3068\u304d\u306e\u8a2d\u5b9a\u306f\u4e0b\u8a18\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n<p>1\uff0e\u300c\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u306e\u65b9\u6cd5\u300d\uff1a\u7c21\u6613<br \/>\n2\uff0e\u300c\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u300d\uff1aCSV<br \/>\n3\uff0e\u300c\u30a8\u30f3\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u3078\u306e\u5909\u63db\u300d\uff1a\u306a\u3057<\/p>\n<p>\u3042\u3068\u306f\u3001\u3053\u306eCSV\u3092\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u52a0\u5de5\u3059\u308b\u3060\u3051\u3067\u3059\u3002<\/p>\n<p>Mac\u74b0\u5883\u3067\u8abf\u6574\u3055\u308c\u308b\u5834\u5408\u306f\u300c<a href=\"https:\/\/alaki.co.jp\/blog\/?p=1846\" target=\"_blank\">Mac\u3067\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305fUTF-8\u306eCSV\u30c7\u30fc\u30bf\u3092\u3001\u6587\u5b57\u5316\u3051\u305b\u305a\u306bMac\u7248Microsoft Excel\u3067\u958b\u3051\u308b\u65b9\u6cd5<\/a>\u300d\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002<\/p>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>\u9577\u671f\u7684\u306a\u904b\u7528\u3092\u8003\u3048\u308b\u3068\u3001\u30d7\u30e9\u30b0\u30a4\u30f3\u3084\u9b54\u6539\u9020\u3092\u3059\u308b\u306e\u304c\u4e00\u756a\u826f\u3044\u3068\u8003\u3048\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u305f\u3060\u3001\u4e00\u904e\u6027\u306e\u3082\u306e\u3067\u3042\u308b\u306e\u3067\u3042\u308c\u3070\u3001SQL\u3084phpMyAdmin\u3092\u4f7f\u3063\u3066\u3001\u304a\u624b\u8efd\u306b\u30c7\u30fc\u30bf\u3092\u96c6\u3081\u308b\u65b9\u304c\u52b9\u7387\u304c\u826f\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u306e\u3067\u30011\u3064\u306e\u65b9\u6cd5\u3068\u3057\u3066\u304a\u5f79\u306b\u7acb\u3066\u308c\u3070\u3001\u5e78\u3044\u3067\u3059\u3002<\/p>\n<h2>PR<\/h2>\n<p>ALAKI\u3067\u306f\u3001\u7d76\u8cdbWeb\u30d7\u30ed\u30b0\u30e9\u30de\u3092\u52df\u96c6\u4e2d\u3067\u3059\uff01<br \/>\n\u7d20\u6575\u306a<a href=\"http:\/\/recruit.alaki.co.jp\/\" target=\"_blank\">\u30ea\u30af\u30eb\u30fc\u30c8\u30b5\u30a4\u30c8<\/a>\u3082\u30aa\u30fc\u30d7\u30f3\u3057\u307e\u3057\u305f\u306e\u3067\u3001\u8208\u5473\u306e\u3042\u308b\u65b9\u306f\u662f\u975e\u3001\u30b5\u30a4\u30c8\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u306d\u3002<\/p>\n<p><a href=\"http:\/\/recruit.alaki.co.jp\/\" target=\"_blank\">ALAKI\u306e\u30ea\u30af\u30eb\u30fc\u30c8\u5c02\u7528\u30b5\u30a4\u30c8<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u3093\u3070\u3093\u306f\u3001Web\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u7be0\u7530\u3067\u3059\u3002 PC\u306e\u6392\u71b1\u304c\u51f6\u5668\u306b\u306a\u308b\u5b63\u7bc0&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":978,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[16],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/test.alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1860"}],"collection":[{"href":"http:\/\/test.alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/test.alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/test.alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/test.alaki.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1860"}],"version-history":[{"count":6,"href":"http:\/\/test.alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1860\/revisions"}],"predecessor-version":[{"id":1867,"href":"http:\/\/test.alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1860\/revisions\/1867"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/test.alaki.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/media\/978"}],"wp:attachment":[{"href":"http:\/\/test.alaki.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/test.alaki.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1860"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/test.alaki.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}