Import WooCommerce Products into WordPress with Ultimate CSV Importer

April 18, 2016

WooCommerce is the world’s fastest growing eCommerce platform. Hosting an ecommerce store is not an easy task. It involves a lot of mundane process of updates like stock update, price update, product update and similar new additions. WordPress Ultimate CSV Importer helps you automate the manual process in creating and updating your WooCommerce products and stocks. The importer imports all Simple, Variable, Grouped and External/Affiliate product types. You can use any simple xml/csv editor or spreadsheet editor and create your csv / xml. The WooCommerce product information in CSV and XML are scheduled to get the work done easy and fast without any manual intervention. It keeps your eCommerce site updated by importing and updating product information frequently.

Import WooCommerce Products

WordPress Ultimate CSV Importer imports CSV/XML in bulk with all product type data in a single file. The import is executed in simple steps.

Upload CSV/XML file

WordPress Ultimate CSV Importer lets you to upload your CSV/XML in four different methods. Upload file from the local computer, FTP, external link and server. You can choose any one of the methods to upload your CSV/XML file. Once uploaded click on ‘Import’.

Upload CSV or XML into WordPress

Map the header/node with WordPress fields

In mapping section, the default product fields and custom fields are listed under the WordPress core fields and the product meta fields are listed under eCommerce meta fields. Each fields are grouped in it’s specified section. If the headers/nodes are same as WordPress fields, it will be mapped automatically, else choose the corresponding field from the drop down manually.

To schedule an import, after mapping the required column check on ‘Save this mapping as a template’ at the bottom and save it as a template.

Map the CSV headers or XML nodes with WordPress fields

Summary view of the mapped fields

In the summary view, verify details of the mapped and unmapped fields. It lists all the WordPress fields and corresponding CSV header or XML nodes mapped.

WordPress mapping summary

Import or Schedule CSV/XML

You can eliminate duplicates products import with product title and content. You can also import selective products or a range of products in the CSV/XML by specifying row number in the ‘Import specific records only’.

Schedule Import

Import with run-time log

If the import is right away the records will be imported based on your server configurations and the real-time log will be generated with Admin and Web view links of the each imported record.

WordPress Import Log

Update WooCommerce Products

WordPress Ultimate CSV Importer keeps your WooCommerce product updated by updating or inserting the new field into the existing product. The product is updated with the product title. If the existing product title doesn’t match the title then the record will be inserted as a new record.

Upload the CSV/XML to update the existing WooCommerce product with anyone of the 4 methods. Click on ‘update’ to choose any previously created mapping template. Mapping templates are the user defined list of mapped CSV headers or XML nodes to the WordPress fields. If none of them matches your current update you can choose fresh update to create a new mapping template.

Update WooCommerce Product

If you choose fresh update map the required CSV headers or XML nodes to the WordPress fields and save the current mapping as a template. The update will be executed based on the newly created template.

The summary view of the mapped fields and the Import or Schedule CSV/XML procedure is same as the import process. The update can also be performed for the specific range of records in the uploaded file. If the process is imported right away the real-time log is generated to show the updated record details. If the process is scheduled then it will be triggered by cron on the specified date and time.

Download sample CSV and try our live demo. You can refer our product page and documentation to know more about the WordPress Ultimate CSV Importer features. If you need further assistance you can write to us at [email protected]. You can also read more about latest features in our WordPress products in our blogs.