Jon Boss

simplistics.ca

<p>Given a CSV document of the proper template, imports all rows as Woocommerce products. Created by Simplistics Web Design.</p>
<h4>Operation</h4>
<ol>
<li>Navigate to the ‘Products Importer’ Link in the wordpress administrator menu.</li>
<li>Click ‘choose file’ to upload the desired products document (only .csv file type is supported. For details on .csv formatting see ‘csv template format’ below)</li>
<li>Click ‘submit’ to run the import. The loading screen will appear, please wait while the import finished.</li>
<li>The importer will display the number of records successfully imported. You can view these in the ‘Products’ tab.</li>
</ol>
<h4>Required Plugins</h4>
<ul>
<li>[Woocommerce] is required to use this plugin, downloadable here (https://en-ca.wordpress.org/plugins/woocommerce/)</li>
</ul>
<h4>CSV Template Format</h4>
<p>Included with this plugin is a template file entitled ‘products_template.csv’ to be used to format your products for upload. The Columns in that CSV expect the following data:</p>
<ul>
<li>A: A unique reference ID used for your products. This must be an integer – it is used to link your products to the proper post ID.</li>
<li>B: Categories for this product. This should be formatted as follows:
<ul>
<li>Each Category Name must be separated with a ‘|’<br />
The Categories need not exist and will be created for you if the string is written in this way. This plugin does not currently support heirarchical categories – you will have to assign categories to parents from the Woocommerce admin panel yourself. Alternatively, creating the categories ahead of time and only referencing the child category will link your product to the correct category.</li>
</ul>
</li>
<li>C: Product Weight (as a number)</li>
<li>D: Product Name. The product’s name is used to determine variable products – so any product you wish to be a variation should have the same product name as its parent. The first product of its name will create the parent product as well as a variation with the given attributes – indicating a parent row is not necessary.</li>
<li>E: Product SKU</li>
<li>F: Product Description</li>
<li>G: Product Images. Images will be searched for in the database and attached to the product if they already exist. Multiple images should be separated by a ‘|’, the first image in the string being the product thumbnail. The other images will be added to the product’s gallery. Images may include or disclude the file extension.</li>
<li>H: Inventory. Please note that if you don’t wish to update the product inventory in this way, you can deselect the ‘update stock’ option in the plugin’s options page.</li>
<li>I: Product Regular Price</li>
<li>J: Product Sale Price, if applicable</li>
<li>K-onwards: All columns from K onwards are parsed as product attributes. The column names will be created as new attributes if they do not already exist. If a product does not use that attribute, simply leave the field blank. Attributes of a Variable Product will automatically be set to ‘use for variation’</li>
</ul>
<h4>Adding Custom Meta To Your Products</h4>
<p>It may be necessary to add extra information to your product for some reason. If you require this, you can do so by leaving an empty column after your product attributes, followed by any custom meta values you require. The titles of any custom meta columns will be translated into a meta_key and stored in the postmeta table associated with the product or variation.</p>
<h4>Customization Hooks</h4>
<p>action ’wpci_importer_finished’ – This hook fires immediately after the import finishes, and before the page is redirected.</p>


Products CSV Importer for Woocommerce

Given a CSV document of the proper template, imports all rows as Woocommerce products. Created by Simplistics Web Design.

groupbwt

<p>Plugin imports posts from CSV file, allowing to connect CSV field with post field when creating a post.</p>
<ul>
<li>Custom Post Type support</li>
<li>Advanced Custom Fields (ACF) support</li>
</ul>
<h4>Available fields:</h4>
<ul>
<li>Post Content: (string) The post content. Default empty.</li>
<li>Post Title: (string) The post title. Default empty.</li>
<li>Comment Status: (string) Defines if the post can accept comments. Accepts ‘open’ or ‘closed’. Default is the value of ‘default_comment_status’ option.</li>
<li>Post Category: (string, comma separated) Post category names. Defaults to value of the ‘default_category’ option.</li>
<li>Featured Image: (string) The uri of the post thumbnail. Default is empty.</li>
<li>ID: (int) The post ID. If the ID does not exist, importer will try to create a new post with suggested ID.</li>
<li>Post Date: (string in format ‘yyyy-mm-dd hh:mm:ss’) Post date. Default is the current time.</li>
<li>Post Date GTM: (string in format ‘yyyy-mm-dd hh:mm:ss’) The date of the post in the GMT timezone. Default is the value of Post Date.</li>
<li>Post Content Filtered: (string) A filtered post content. Default is empty.</li>
<li>Post Excerpt: (string) The post excerpt. Default is empty.</li>
<li>Post Status: (string) The post status. Default is ‘published’.</li>
<li>Ping Status: (string) Defines if the post can accept pings. Accepts ‘open’ or ‘closed’. Default is the value of ‘default_ping_status’ option.</li>
<li>Post Password: (string) The password to access the post. Default is empty.</li>
<li>Slug: (string) The post name. Default is the sanitized post title when creating a new post.</li>
<li>To Ping: (string) Space or carriage return-separated list of URLs to ping. Default empty.</li>
<li>Pinged: (string) Space or carriage return-separated list of URLs that have been pinged. Default is empty.</li>
<li>Post Parent: (int) Set this for the post it belongs to, if any. Default is 0.</li>
<li>Menu Order:(int) The order number your want for the post to be displayed. Default is 0.</li>
<li>GUID: (string) Global Unique ID for referencing the post. Default is empty.</li>
<li>Taxonomy: (JSON) JSON of taxonomy terms keyed by their taxonomy name. Taxonomy must already exist. Default is empty.</li>
<li>Meta: (JSON) JSON of post meta values keyed by their post meta key. Default is empty.</li>
</ul>


CSV Posts Importer

Plugin imports posts from CSV file, allowing to connect CSV field with post field when creating a post.

Products CSV Importer for Woocommerce vs CSV Posts Importer