<input type="hidden" id="_wpnonce" name="_wpnonce" value="1998df12a5" /><input type="hidden" name="_wp_http_referer" value="/blog/wp-json/wp/v2/posts/278" /><input type="hidden" id="_wpnonce" name="_wpnonce" value="1998df12a5" /><input type="hidden" name="_wp_http_referer" value="/blog/wp-json/wp/v2/posts/278" />{"id":278,"date":"2012-02-12T02:59:20","date_gmt":"2012-02-12T02:59:20","guid":{"rendered":"https:\/\/www.businesslegions.com\/blog\/?p=278"},"modified":"2012-02-24T04:20:24","modified_gmt":"2012-02-24T04:20:24","slug":"csv-import-for-jigoshop-wordpress-plugin","status":"publish","type":"post","link":"https:\/\/www.businesslegions.com\/blog\/2012\/02\/12\/csv-import-for-jigoshop-wordpress-plugin\/","title":{"rendered":"CSV Import for Jigoshop WordPress plugin"},"content":{"rendered":"<!--CusAds0--><p>Jigoshop must be one of the easiest and most comprehensive \u00a0e-commerce wordpress plugins available on the market. I started using this plugin and love the way you can just purchase and install themes for Jigoshop. \u00a0Adding products to Jigoshop is very easy and straight forward but what happens when you want to import hundreds of products into your shop?<\/p>\n<p>I spent hours figuring out what to do and came up with a solution. Credit must go to Colin for Colin&#8217;s CSV importer. This plugin does the job but I had a few issues with this and managed to solve it. I&#8217;m not a developer but analysing some of the code allowed me to fix the issues.<\/p>\n<p>Here is a quick install and setup guide (tested with Jigoshop v1.0):<\/p>\n<p>1. Firstly, you must obviously install Jigoshop in WordPress.<\/p>\n<p>2. Download the zip file called csvloader.zip \u00a0<a title=\"CSVloader\" href=\"http:\/\/forum.jigoshop.com\/discussions\/suggestions\/82-how-about-a-csv-import-plugin\/page\/3?to=%2Fdiscussions%2Fsuggestions%2F82-how-about-a-csv-import-plugin%2Fpage%2F2%3Fto%3D%252Fdiscussions%252Fsuggestions%252F82-how-about-a-csv-import-plugin\" target=\"_blank\">here<\/a> (post number 71) \u00a0and extract the files to your plugin folder in WordPress. Generally it will be located here\u00a0\/blog\/wp-content\/plugins.<\/p>\n<p><a href=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/cvsimporter-folders.jpg?strip=all&w=2560\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-279\" title=\"cvsimporter folders\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/cvsimporter-folders.jpg?strip=all\" alt=\"\" width=\"289\" height=\"147\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/cvsimporter-folders.jpg?strip=all 289w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/cvsimporter-folders.jpg?strip=all&amp;w=57 57w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/cvsimporter-folders.jpg?strip=all&amp;w=115 115w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/cvsimporter-folders.jpg?strip=all&amp;w=173 173w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/cvsimporter-folders.jpg?strip=all&amp;w=231 231w\" sizes=\"(max-width: 289px) 100vw, 289px\" \/><\/a><\/p>\n<p>Once extracted you will have a folder called\u00a0\/blog\/wp-content\/plugins\/csvloader<\/p>\n<p><a href=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/cvsimporter-folders2.jpg?strip=all&w=2560\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-280\" title=\"cvsimporter folders2\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/cvsimporter-folders2.jpg?strip=all\" alt=\"\" width=\"177\" height=\"119\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/cvsimporter-folders2.jpg?strip=all 177w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/cvsimporter-folders2.jpg?strip=all&amp;w=70 70w\" sizes=\"(max-width: 177px) 100vw, 177px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>3. Once uploaded, click on Plugins, and activate.<\/p>\n<p><a href=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-loader-activate.jpg?strip=all&w=2560\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-281\" title=\"jigosohp csv loader activate\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-loader-activate.jpg?strip=all\" alt=\"\" width=\"381\" height=\"45\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-loader-activate.jpg?strip=all 381w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-loader-activate-300x35.jpg?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-loader-activate.jpg?strip=all&amp;w=76 76w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-loader-activate.jpg?strip=all&amp;w=152 152w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-loader-activate.jpg?strip=all&amp;w=228 228w\" sizes=\"(max-width: 381px) 100vw, 381px\" \/><\/a><\/p>\n<p>4. Click on CSV Loader and it will load the following page. This will confirm that the plugin has been installed correctly.<\/p>\n<p><a href=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-for-jigoshop.jpg?strip=all&w=2560\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-282\" title=\"csv loader for jigoshop\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-for-jigoshop.jpg?strip=all\" alt=\"\" width=\"929\" height=\"719\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-for-jigoshop.jpg?strip=all 929w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-for-jigoshop-300x232.jpg?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-for-jigoshop.jpg?strip=all&amp;w=185 185w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-for-jigoshop.jpg?strip=all&amp;w=371 371w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-for-jigoshop.jpg?strip=all&amp;w=557 557w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-for-jigoshop.jpg?strip=all&amp;w=743 743w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-for-jigoshop.jpg?strip=all&amp;w=450 450w\" sizes=\"(max-width: 929px) 100vw, 929px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>5. Now, I had a few issues when using this plugin. The first one was that prices, sku code, \u00a0weight fields did not upload correctly and some of the column didn&#8217;t match when importing. To fix this, I changed some code in the CSVloaded.php file.<\/p>\n<p>e.g: code that was included + there was some other additional code:<\/p>\n<blockquote><p>update_post_meta( $post_id, &#8216;sku&#8217;, $sku );<br \/>\nupdate_post_meta( $post_id, &#8216;regular_price&#8217;, $price );<br \/>\nupdate_post_meta( $post_id, &#8216;weight&#8217;, $weight );<\/p><\/blockquote>\n<p>I have included the zip file below. Just click on it, download it and extract it to to the\u00a0\/blog\/wp-content\/plugins\/csvloader\/admin folder.<br \/>\n<script type=\"text\/javascript\">\/\/ <![CDATA[\n  google_ad_client = \"ca-pub-8957967531511047\"; \/* businesslegions *\/ google_ad_slot = \"1600232421\"; google_ad_width = 300; google_ad_height = 250;\n\/\/ ]]><\/script><br \/>\n<script type=\"text\/javascript\" src=\"http:\/\/pagead2.googlesyndication.com\/pagead\/show_ads.js\">\/\/ <![CDATA[\n\n\n\/\/ ]]><\/script><\/p><!--CusAds0-->\n<p><a href=\"https:\/\/www.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/CSVLoader-businesslegions.zip\">CSVLoader-businesslegions<\/a><\/p>\n<p>6. Now you need to have your CSV file for uploading. The headings and format that you should use is as follows (just an example):<\/p>\n<table width=\"613\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"105\" height=\"20\">Name<\/td>\n<td width=\"109\">Content<\/td>\n<td width=\"64\">Price<\/td>\n<td width=\"64\">Weight<\/td>\n<td width=\"64\">SKU<\/td>\n<td width=\"143\">Multi_cat<\/td>\n<td width=\"64\">Thumbnail<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Based on the code all the fields\/headings that you can use are:<\/p>\n<p>Name, Content, Excerpt, Price, Stock, Weight, sku, order, tax, attachment, thumbnail, multi_cat, attribs.<\/p>\n<p>For multi_cat, make sure you have a comma &#8220;,&#8221; between the different categories.<\/p>\n<p>Click below for an example of a working csv file I used.<br \/>\n<script type=\"text\/javascript\">\/\/ <![CDATA[\n  google_ad_client = \"ca-pub-8957967531511047\"; \/* businesslegions *\/ google_ad_slot = \"1600232421\"; google_ad_width = 300; google_ad_height = 250;\n\/\/ ]]><\/script><br \/>\n<script type=\"text\/javascript\" src=\"http:\/\/pagead2.googlesyndication.com\/pagead\/show_ads.js\">\/\/ <![CDATA[\n\n\n\/\/ ]]><\/script><\/p>\n<p><a href=\"https:\/\/www.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-uploader-example.csv\">csv uploader example<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>7. When you have the csv file ready to upload, go to the CSVloader plugin page and change the following:<\/p>\n<ul>\n<li>1. Instead of the &#8220;|&#8221; use &#8220;,&#8221; (comma) that&#8217;s if you&#8217;re using a , in seperating your data fields. Make sure &#8220;columns title in first line&#8221; is selected.<\/li>\n<li>2. If you plan to use Hierarchical categories, select this option.<\/li>\n<li>3. Click on choose file and select the csv file you intent to upload.<\/li>\n<li>4. Click LOAD.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-settings.jpg?strip=all&w=2560\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-285\" title=\"jigoshop settings\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-settings.jpg?strip=all\" alt=\"\" width=\"542\" height=\"255\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-settings.jpg?strip=all 542w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-settings-300x141.jpg?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-settings.jpg?strip=all&amp;w=108 108w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-settings.jpg?strip=all&amp;w=216 216w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-settings.jpg?strip=all&amp;w=433 433w\" sizes=\"(max-width: 542px) 100vw, 542px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>8. After you click LOAD, it will display the first 4 rows of your CSV file. If you see the data and columns, it means that the file format is correct. Here&#8217;s an example:<\/p>\n<p><a href=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-load1.jpg?strip=all&w=2560\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-288\" title=\"jigoshop load\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-load1.jpg?strip=all\" alt=\"\" width=\"1504\" height=\"127\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-load1.jpg?strip=all 1504w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-load1-300x25.jpg?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-load1.jpg?strip=all&amp;w=601 601w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-load1.jpg?strip=all&amp;w=902 902w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-load1.jpg?strip=all&amp;w=1203 1203w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigoshop-load1.jpg?strip=all&amp;w=450 450w\" sizes=\"(max-width: 960px) 100vw, 960px\" \/><\/a><\/p>\n<p>9. If the data content loaded correctly confirm the mappings between the CSV file and jigoshop. Generally the SKU column doesn&#8217;t match so you need to select this manually.<\/p>\n<p><a href=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-mappings.jpg?strip=all&w=2560\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-289\" title=\"jigosohp csv mappings\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-mappings.jpg?strip=all\" alt=\"\" width=\"948\" height=\"340\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-mappings.jpg?strip=all 948w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-mappings-300x108.jpg?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-mappings.jpg?strip=all&amp;w=189 189w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-mappings.jpg?strip=all&amp;w=379 379w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-mappings.jpg?strip=all&amp;w=568 568w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-mappings.jpg?strip=all&amp;w=758 758w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/jigosohp-csv-mappings.jpg?strip=all&amp;w=450 450w\" sizes=\"(max-width: 948px) 100vw, 948px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>10. Finally, select whether you want to publish the imported data or not, and then click Upload.<\/p>\n<p><a href=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-upload.jpg?strip=all&w=2560\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-290\" title=\"csv loader upload\" src=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-upload.jpg?strip=all\" alt=\"\" width=\"467\" height=\"80\" srcset=\"https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-upload.jpg?strip=all 467w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-upload-300x51.jpg?strip=all 300w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-upload.jpg?strip=all&amp;w=93 93w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-upload.jpg?strip=all&amp;w=186 186w, https:\/\/cdn.businesslegions.com\/blog\/wp-content\/uploads\/2012\/02\/csv-loader-upload.jpg?strip=all&amp;w=373 373w\" sizes=\"(max-width: 467px) 100vw, 467px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Check your Jigoshop and confirm the data is correct. Hopefully this has helped a few people.<\/p>\n<p>&nbsp;<\/p>\n<div class=\"lt-box\" style=\"border:1px solid #1d6a9e\"><div class=\"lt-box-title\" style=\"background-color:#2485C6;border-top:1px solid #a7cee8;text-shadow:1px 1px 0 #0b283b\">DO YOU LIKE WHAT YOU'VE READ?<\/div><div class=\"lt-box-content\">Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!\r\n\r\n<p><div class=\"tnp tnp-subscription \">\n<form method=\"post\" action=\"https:\/\/www.businesslegions.com\/blog\/wp-admin\/admin-ajax.php?action=tnp&amp;na=s\">\n<input type=\"hidden\" name=\"nlang\" value=\"\">\n<div class=\"tnp-field tnp-field-firstname\"><label for=\"tnp-1\">Name<\/label>\n<input class=\"tnp-name\" type=\"text\" name=\"nn\" id=\"tnp-1\" value=\"\" placeholder=\"\"><\/div>\n<div class=\"tnp-field tnp-field-email\"><label for=\"tnp-2\">Email<\/label>\n<input class=\"tnp-email\" type=\"email\" name=\"ne\" id=\"tnp-2\" value=\"\" placeholder=\"\" required><\/div>\n<div class=\"tnp-field tnp-field-button\" style=\"text-align: left\"><input class=\"tnp-submit\" type=\"submit\" value=\"Subscribe\" style=\"\">\n<\/div>\n<\/form>\n<\/div>\n<\/p>\r\n\r\n<\/div><\/div><!--CusAds0-->\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Jigoshop must be one of the easiest and most comprehensive \u00a0e-commerce wordpress plugins available on the market. I started using this plugin and love the way you can just purchase and install themes for Jigoshop. \u00a0Adding products to Jigoshop is very easy and straight forward but what happens when you want to import hundreds of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":279,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[459,3],"tags":[258,410,204,404,397,405,381,131,401,403,409,148,398,383,394,390,406,402,1936,384],"class_list":["post-278","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-jigoshop-technology","category-technology","tag-blog","tag-cat","tag-click","tag-csv-file","tag-csvloader","tag-headings","tag-jigoshop","tag-job","tag-match","tag-meta","tag-multi","tag-nbsp","tag-number-71","tag-plugin","tag-plugin-folder","tag-solution-credit","tag-thumbnail","tag-weight","tag-wordpress","tag-wordpress-plugin"],"_links":{"self":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/278","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/comments?post=278"}],"version-history":[{"count":13,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/278\/revisions"}],"predecessor-version":[{"id":1746,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/278\/revisions\/1746"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/media\/279"}],"wp:attachment":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/media?parent=278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/categories?post=278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/tags?post=278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}