{"id":4380,"date":"2021-06-19T06:33:53","date_gmt":"2021-06-18T21:33:53","guid":{"rendered":"https:\/\/hanami-web.tokyo.jp\/blog\/?p=4380"},"modified":"2021-09-18T06:05:20","modified_gmt":"2021-09-17T21:05:20","slug":"premiumpress-csvimport","status":"publish","type":"post","link":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/","title":{"rendered":"Build a matching site with WordPress! How to bulk import CSV files with PremiumPress&#039; Microjob theme"},"content":{"rendered":"<p>This article explains how to set up the Microjob theme from PREMIUMPRESS, which allows you to build a matching site using WordPress.<\/p>\n\n\n\n<p>This time, I would like to try the convenient bulk CSV registration method.<\/p>\n\n\n\n<p>Bulk register jobs and other themes. For example, you can use it when you want to upload a large amount of data to your PremiumPress site before opening the site, such as download themes or online store themes.<\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"sc\"><a href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/premiumpress-microjob-wordpress\/\" title=\"PremiumPress Theme Explanation Table of Contents\">\r\n\t<p class=\"sc-txt01\">This is an older article.<\/p>\r\n\t<p class=\"sc-txt01\">The design has changed significantly, so please use it as a reference only.<\/p>\r\n\t<p class=\"sc-txt02\">PremiumPress Commentary Table of Contents \u2192<\/p>\r\n<\/a><\/div>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #000000;color:#000000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #000000;color:#000000\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/#csv%e3%82%a4%e3%83%b3%e3%83%9d%e3%83%bc%e3%83%88%e3%83%84%e3%83%bc%e3%83%ab%e3%81%ae%e3%83%80%e3%82%a6%e3%83%b3%e3%83%ad%e3%83%bc%e3%83%89\" >Download the csv import tool<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/#csv%e3%82%a4%e3%83%b3%e3%83%9d%e3%83%bc%e3%83%88%e3%83%84%e3%83%bc%e3%83%ab%e3%81%ae%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab\" >Installing the CSV import tool<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/#%e3%81%be%e3%81%9a%e3%81%af%e3%82%a8%e3%82%af%e3%82%b9%e3%83%9d%e3%83%bc%e3%83%88%e3%81%a7csv%e3%81%ae%e3%83%86%e3%83%b3%e3%83%97%e3%83%ac%e3%83%bc%e3%83%88%e3%82%92%e3%83%80%e3%82%a6%e3%83%b3%e3%83%ad%e3%83%bc%e3%83%89\" >First, download the CSV template by exporting it.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/#csv%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e4%bd%9c%e6%88%90\" >Create CSV data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/#%e5%ae%9f%e9%9a%9b%e3%81%abcsv%e7%99%bb%e9%8c%b2%e3%82%92%e3%81%97%e3%81%a6%e3%81%bf%e3%81%be%e3%81%97%e3%81%9f\" >I actually tried registering the CSV file.<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/#%e4%bb%8a%e5%9b%9e%e3%81%aecsv%e3%82%a4%e3%83%b3%e3%83%9d%e3%83%bc%e3%83%88%e3%81%ab%e5%90%8d%e5%89%8d%e3%82%92%e3%81%a4%e3%81%91%e3%81%be%e3%81%99\" >Give your csv import a name<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/#csv%e3%82%a2%e3%83%83%e3%83%97%e3%83%ad%e3%83%bc%e3%83%89%e5%a0%b4%e6%89%80%e3%82%92%e9%81%b8%e6%8a%9e\" >Select csv upload location<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/#%e3%83%97%e3%83%ac%e3%83%93%e3%83%a5%e3%83%bc%e3%81%a7%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e7%a2%ba%e8%aa%8d\" >Check the data in preview<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/#csv%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e3%83%9e%e3%83%83%e3%83%94%e3%83%b3%e3%82%b0\" >Mapping CSV data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/#csv%e3%83%87%e3%83%bc%e3%82%bf%e3%81%ae%e3%82%a2%e3%83%83%e3%83%97%e3%83%ad%e3%83%bc%e3%83%89%e6%a8%a9%e9%99%90%e8%a8%ad%e5%ae%9a\" >CSV data upload permission settings<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/#%e5%ae%9f%e8%a1%8c%e3%81%ae%e3%82%bf%e3%82%a4%e3%83%9f%e3%83%b3%e3%82%b0\" >Timing of execution<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/microjobs\/premiumpress-csvimport\/#csv%e3%82%a4%e3%83%b3%e3%83%9d%e3%83%bc%e3%83%88%e7%b5%90%e6%9e%9c\" >CSV Import Results<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"csv%e3%82%a4%e3%83%b3%e3%83%9d%e3%83%bc%e3%83%88%e3%83%84%e3%83%bc%e3%83%ab%e3%81%ae%e3%83%80%e3%82%a6%e3%83%b3%e3%83%ad%e3%83%bc%e3%83%89\"><\/span>Download the csv import tool<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>First, the CSV import tool is not a standard feature, so you will need to download it from the PremiumPress site.<\/p>\n\n\n\n<div class=\"wp-block-cocoon-blocks-button-1 aligncenter button-block\"><a href=\"https:\/\/secure.2checkout.com\/affiliate.php?ACCOUNT=MARKFAIL&amp;AFFILIATE=144390&amp;PATH=https%3A%2F%2Fwww.premiumpress.com%2Fplugins%2F%3FAFFILIATE%3D144390&amp;AFFSRC=https%3A%2F%2Fhanami-web.tokyo.jp%2Fblog\" class=\"btn btn-m btn-circle has-background has-key-color-background-color\" target=\"_blank\" rel=\"noopener\">Premium Press free plugin download page<\/a><\/div>\n\n\n\n<p>The plugin called [CSV Import Tool] is a free plugin that imports data via CSV.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"469\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-371-1024x469.png\" alt=\"\" class=\"wp-image-4381\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-371-1024x469.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-371-300x137.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-371-768x352.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-371-1536x704.png 1536w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-371.png 1543w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Click [Download Now] to download the plugin file.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"418\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-372-1024x418.png\" alt=\"\" class=\"wp-image-4384\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-372-1024x418.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-372-300x122.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-372-768x313.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-372.png 1441w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"csv%e3%82%a4%e3%83%b3%e3%83%9d%e3%83%bc%e3%83%88%e3%83%84%e3%83%bc%e3%83%ab%e3%81%ae%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab\"><\/span>Installing the CSV import tool<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Log in to your WordPress site and upload the downloaded zip file from [Appearance] &gt; [Plugins] &gt; [Add New].<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"272\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-373-1024x272.png\" alt=\"\" class=\"wp-image-4385\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-373-1024x272.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-373-300x80.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-373-768x204.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-373-1536x408.png 1536w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-373.png 1678w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Click [Install now] &gt; [Activate].<\/p>\n\n\n\n<p>A new [CSV Import] tool has been added to PREMIUMPRESS.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"337\" height=\"687\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-374.png\" alt=\"\" class=\"wp-image-4386\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-374.png 337w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-374-147x300.png 147w\" sizes=\"(max-width: 337px) 100vw, 337px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%e3%81%be%e3%81%9a%e3%81%af%e3%82%a8%e3%82%af%e3%82%b9%e3%83%9d%e3%83%bc%e3%83%88%e3%81%a7csv%e3%81%ae%e3%83%86%e3%83%b3%e3%83%97%e3%83%ac%e3%83%bc%e3%83%88%e3%82%92%e3%83%80%e3%82%a6%e3%83%b3%e3%83%ad%e3%83%bc%e3%83%89\"><\/span>First, download the CSV template by exporting it.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>First, let&#039;s export the data to see how we can create a CSV file.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"436\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-375-1024x436.png\" alt=\"\" class=\"wp-image-4387\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-375-1024x436.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-375-300x128.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-375-768x327.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-375.png 1497w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>I clicked on the downloaded csv file to open it in Excel. The Japanese characters were garbled...<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"99\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-376-1024x99.png\" alt=\"\" class=\"wp-image-4388\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-376-1024x99.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-376-300x29.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-376-768x74.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-376.png 1376w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>So,<br>[Data] &gt; [From text or CSV] Select the file<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"603\" height=\"167\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-378.png\" alt=\"\" class=\"wp-image-4390\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-378.png 603w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-378-300x83.png 300w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-cocoon-blocks-icon-box information-box common-icon-box block-box\">\n<p>Select the character code as [65001:Unicode(UTF-8)] and load it.<\/p>\n<\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"771\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-377-1024x771.png\" alt=\"\" class=\"wp-image-4389\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-377-1024x771.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-377-300x226.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-377-768x578.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-377.png 1078w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>I was able to open the file without any garbled text. Important headings were colored to make them easier to understand (this may be due to my Excel settings).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"143\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-379-1024x143.png\" alt=\"\" class=\"wp-image-4391\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-379-1024x143.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-379-300x42.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-379-768x107.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-379.png 1415w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"csv%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e4%bd%9c%e6%88%90\"><\/span>Create CSV data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>We will create data to import information into PremiumPress Microjob via CSV.<\/p>\n\n\n\n<p>There was such an item.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>ID: Enter the listing service ID.<\/li><li>post_author: Enter your author ID number<\/li><li>post_data: Register the posting date<\/li><li>post_content: Enter the detailed description of the service you wish to sell<\/li><li>post_title: Enter the title of the service you want to sell<\/li><li>post_excerpt: This is an excerpt from the description, but it was blank so I think it&#039;s fine to leave it blank.<\/li><li>post_type:listing_type<\/li><li>category: Enter the category of the service you want to sell<\/li><li>packageID: The ID of the package<\/li><li>Hits: Since it&#039;s the number of views, I think it&#039;s fine without it.<\/li><li>youtube_id: YouTube URL if you want to post a video<\/li><li>image: URL of the image<\/li><li>days: unknown<\/li><li>price:price<\/li><li>gig: price title<\/li><li>desc: description of the price<\/li><li>days-1: unknown<\/li><li>price-1: Premium price<\/li><li>gig-1: Premium priced title<\/li><li>desc-1: description of the premium title<\/li><li>customextras:Add-on area structured data<\/li><li>background-image: Enter background image number<\/li><li>starrating: Since it&#039;s a rating, I think 0 is fine<\/li><li>hits_array: This is the date and time of viewing, so I think it&#039;s fine to leave it blank.<\/li><li>pageviewed: I think it&#039;s fine to leave it blank<\/li><li>lastviewed: I think it&#039;s fine to leave it blank<\/li><li>online: I think it&#039;s fine to leave it blank<\/li><li>listing_expiry_date: I think it&#039;s fine to leave it blank<\/li><li>post_id: Use the same number as the first ID<\/li><\/ul>\n\n\n\n<div class=\"wp-block-cocoon-blocks-icon-box information-box common-icon-box block-box\">\n<p>I think it would be best to register one service with all the necessary information entered in Japanese, then export the CSV data and enter the information in the same way as the data you registered in Japanese.<\/p>\n\n\n\n<p>Please note that if the created CSV file is not saved in UTF-8, Japanese characters will be garbled. In Excel, the save format is [CSV UTF-8].<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"350\" height=\"145\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-389.png\" alt=\"\" class=\"wp-image-4401\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-389.png 350w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-389-300x124.png 300w\" sizes=\"(max-width: 350px) 100vw, 350px\" \/><\/figure>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%e5%ae%9f%e9%9a%9b%e3%81%abcsv%e7%99%bb%e9%8c%b2%e3%82%92%e3%81%97%e3%81%a6%e3%81%bf%e3%81%be%e3%81%97%e3%81%9f\"><\/span>I actually tried registering the CSV file.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Let&#039;s import the edited CSV data from [NEW INPORT] into the PremiumPress Microjob theme.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"435\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380-1024x435.png\" alt=\"\" class=\"wp-image-4392\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380-1024x435.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380-300x127.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380-768x326.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380.png 1362w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%e4%bb%8a%e5%9b%9e%e3%81%aecsv%e3%82%a4%e3%83%b3%e3%83%9d%e3%83%bc%e3%83%88%e3%81%ab%e5%90%8d%e5%89%8d%e3%82%92%e3%81%a4%e3%81%91%e3%81%be%e3%81%99\"><\/span>Give your csv import a name<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You need to enter a name, so let&#039;s enter [import-202100619].<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"890\" height=\"456\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-381.png\" alt=\"\" class=\"wp-image-4393\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-381.png 890w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-381-300x154.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-381-768x393.png 768w\" sizes=\"(max-width: 890px) 100vw, 890px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"csv%e3%82%a2%e3%83%83%e3%83%97%e3%83%ad%e3%83%bc%e3%83%89%e5%a0%b4%e6%89%80%e3%82%92%e9%81%b8%e6%8a%9e\"><\/span>Select csv upload location<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Select Uploaded file and upload the file you just downloaded and modified.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"847\" height=\"578\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-382.png\" alt=\"\" class=\"wp-image-4394\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-382.png 847w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-382-300x205.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-382-768x524.png 768w\" sizes=\"(max-width: 847px) 100vw, 847px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%e3%83%97%e3%83%ac%e3%83%93%e3%83%a5%e3%83%bc%e3%81%a7%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e7%a2%ba%e8%aa%8d\"><\/span>Check the data in preview<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Since you are editing a downloaded file, there should be no problem. Check the preview and if it is displayed correctly, proceed to [SAVE &amp; CONTINUE].<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"785\" height=\"686\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-383.png\" alt=\"\" class=\"wp-image-4395\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-383.png 785w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-383-300x262.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-383-768x671.png 768w\" sizes=\"(max-width: 785px) 100vw, 785px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"csv%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e3%83%9e%e3%83%83%e3%83%94%e3%83%b3%e3%82%b0\"><\/span>Mapping CSV data<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Select [select] to link each piece of information to the CSV data.<\/p>\n\n\n\n<div class=\"wp-block-cocoon-blocks-icon-box information-box common-icon-box block-box\">\n<p>Just link the information you need and leave the unnecessary information blank.<\/p>\n<\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"810\" height=\"595\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-384.png\" alt=\"\" class=\"wp-image-4396\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-384.png 810w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-384-300x220.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-384-768x564.png 768w\" sizes=\"(max-width: 810px) 100vw, 810px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"csv%e3%83%87%e3%83%bc%e3%82%bf%e3%81%ae%e3%82%a2%e3%83%83%e3%83%97%e3%83%ad%e3%83%bc%e3%83%89%e6%a8%a9%e9%99%90%e8%a8%ad%e5%ae%9a\"><\/span>CSV data upload permission settings<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Create: Add new data<\/li><li>Update: Updates existing files without overwriting them<\/li><li>Delete: Delete and rewrite existing data<\/li><\/ul>\n\n\n\n<p>Check the necessary items. Since we are going to perform initial setup and set data this time, we selected Create and Delete.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"752\" height=\"361\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-385.png\" alt=\"\" class=\"wp-image-4397\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-385.png 752w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-385-300x144.png 300w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%e5%ae%9f%e8%a1%8c%e3%81%ae%e3%82%bf%e3%82%a4%e3%83%9f%e3%83%b3%e3%82%b0\"><\/span>Timing of execution<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It looks like it can be scheduled, but this time I&#039;ll run it using Run Now.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"800\" height=\"567\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-386.png\" alt=\"\" class=\"wp-image-4398\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-386.png 800w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-386-300x213.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-386-768x544.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"csv%e3%82%a4%e3%83%b3%e3%83%9d%e3%83%bc%e3%83%88%e7%b5%90%e6%9e%9c\"><\/span>CSV Import Results<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"928\" height=\"438\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-388.png\" alt=\"\" class=\"wp-image-4400\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-388.png 928w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-388-300x142.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-388-768x362.png 768w\" sizes=\"(max-width: 928px) 100vw, 928px\" \/><\/figure>\n\n\n\n<p>The newly added data has been added to the job!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"215\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-390-1024x215.png\" alt=\"\" class=\"wp-image-4402\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-390-1024x215.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-390-300x63.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-390-768x162.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-390.png 1165w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>It&#039;s now displayed on the site! Plus, some of the data has been deleted, so it&#039;s gone down.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"515\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-391-1024x515.jpg\" alt=\"\" class=\"wp-image-4403\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-391-1024x515.jpg 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-391-300x151.jpg 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-391-768x386.jpg 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-391.jpg 1417w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>This is a very useful feature when you want to register services in bulk. However, I thought the mapping might be a bit difficult.<\/p>\n\n\n\n<p>I thought it would be better to create one piece of data first, get a grasp of the mapping flow, and make sure that it is displayed correctly on the site, then create a large amount of data!<\/p>\n\n\n\n<p>This plugin is useful not only for the Microjob theme, but also for the initial setup of online shops, downloadable themes, and more!<\/p>\n\n\n<div class=\"sc\"><a href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/premiumpress-microjob-wordpress\/\" title=\"PremiumPress Theme Explanation Table of Contents\">\r\n\t<p class=\"sc-txt01\">This is an older article.<\/p>\r\n\t<p class=\"sc-txt01\">The design has changed significantly, so please use it as a reference only.<\/p>\r\n\t<p class=\"sc-txt02\">PremiumPress Commentary Table of Contents \u2192<\/p>\r\n<\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>WordPress\u3067\u30de\u30c3\u30c1\u30f3\u30b0\u30b5\u30a4\u30c8\u69cb\u7bc9\u304c\u51fa\u6765\u308bPREMIUMPRESS\u306eMicrojob\u30c6\u30fc\u30de\u306e\u8a2d\u5b9a\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002 \u4eca\u56de\u306f\u4fbf\u5229\u306acsv\u4e00\u62ec\u767b\u9332\u306b\u30c1\u30e3\u30ec\u30f3\u30b8\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002 job\u3092\u4e00\u62ec\u767b\u9332\u3001\u4ed6\u306e\u30c6\u30fc\u30de\u3002\u4f8b\u3048\u3070 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4392,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[1456],"tags":[1469,1460,1276,1459,281],"class_list":["post-4380","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microjobs","tag-microjob","tag-premium-press","tag-wordpress","tag-1459","tag-281"],"blocksy_meta":[],"aioseo_notices":[],"uagb_featured_image_src":{"full":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380.png",1362,578,false],"thumbnail":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380-150x150.png",150,150,true],"medium":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380-300x127.png",300,127,true],"medium_large":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380-768x326.png",768,326,true],"large":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380-1024x435.png",1024,435,true],"1536x1536":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380.png",1362,578,false],"2048x2048":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380.png",1362,578,false],"trp-custom-language-flag":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2021\/06\/image-380.png",18,8,false]},"uagb_author_info":{"display_name":"\u682a\u5f0f\u4f1a\u793eHanamiWEB \u4ee3\u8868\u53d6\u7de0\u5f79 \u677e\u6d66\u307f\u3055","author_link":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/author\/hanami\/"},"uagb_comment_info":0,"uagb_excerpt":"WordPress\u3067\u30de\u30c3\u30c1\u30f3\u30b0\u30b5\u30a4\u30c8\u69cb\u7bc9\u304c\u51fa\u6765\u308bPREMIUMPRESS\u306eMicrojob\u30c6\u30fc\u30de\u306e\u8a2d\u5b9a\u65b9\u6cd5\u3092\u89e3&hellip;","brizy_media":[],"_links":{"self":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/posts\/4380","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/comments?post=4380"}],"version-history":[{"count":0,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/posts\/4380\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/media\/4392"}],"wp:attachment":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/media?parent=4380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/categories?post=4380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/tags?post=4380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}