There are 100’s of posts, page updates and other custom posts were updated by every company. It takes time to upload each file. You can make it easily by Import data from Google sheet or XMl or drop box with the powerful WP Ultimate CSV Importer plugin is a very easy process. It allows you to import XML file or publicly accessible URL into and align them as the post, page and custom post. This tutorial guides you to import and perform mapping configuration using the simple steps.
Install and Activate the WP Ultimate CSV Importer plugin
To attain the benefits of WP Ultimate CSV Importer plugin, you need to install it in your WordPress website. Follow the instructions here to upload, install and activate the plugin.
WP Ultimate CSV Importer is a robust tool designed to help you manage your content management system easily. Advanced features like updating the existing content, schedule the import, drag & drop mapping, duplicate handling, export the data and much more included.
Step 1: Upload file into WP ultimate CSV importer
Method 1: How to import an XML file using WP Ultimate CSV Importer plugin
Here we have discussed the steps to follow when importing the XML content into WordPress website.
Method 2:Import Data from Google sheet or drop box
The term such as XML, URL, CSV are horrible, we can go from basics. Hope you know how to create an Excel file, so prepare an Excel file and then save it as a CSV file or you can upload it into a spreadsheet. Later import it into WordPress using Ultimate CSV importer. Or else you can directly update data in Google sheet and assign the URL in the import field of the plugin
How to Get the Publicly Accessible URL
You can create a publicly accessible URL on Google sheets by following the following steps:
1. Go to your Google Drive and open your spreadsheet. Click on the blue Share button in the top right-hand corner to open the Share with another modal.
2. If you haven’t shared your file already, just click on the Get shareable link (green button). Otherwise, click the dropdown to choose the access permissions. Then select More.
3. A window will pops up, and you select either on – Anyone with the link can view or On – Public on the web. Choose the one you prefer.
4. Click Copy link to copy your sharing link and click done to close the Share with other modal.
How to Import Now?
Upload the URL like below, where you can import data from Google sheet. To import only new items, choose a new item from the options. To update the existing posts/pages/custom posts/Woo-Products using title or ID or slug or SKU, you can choose an existing item.
Mapping the XML fields with WordPress core fields
You can do mapping in either “Advanced mode” or “Drag ‘n’ Drop” mode. Select the WordPress core fields for the appropriate WordPress fields. You can save the mapping as a template for later use by providing a name in ‘Save mapping as a template’ textbox. Once you mapped, click on the Continue button.
After performing mapping, You will be redirected to the Featured Media Handling page. Be sure to enable the external images to your media checkbox if you have used any external images. You can use images for importing if it is already available in the WP Media.
A way underneath the “Image Handling”, there’s Media SEO and Advanced options. Here you can map the image title, image caption, image description and on. You can use ‘Media SEO & Advanced options’ to set image title, image caption and on.
Importing the XML file
Afterwards, You’ll be navigated to the “Import Configuration Settings” page. More advanced options are available to ensure your importing process security.
Enable the pre-state rollback option, if you want to revert to the previous state in case the importing is not done properly.
Here enable the “Do you want to switch on Maintenance Mode while import?” checkbox to notify your website visitors about your site being under maintenance while you’re importing. If you want to skip the duplicate content while importing, enable the ‘Do you want to handle the duplicate on existing records?’ check box. Once you enable these, click on ‘Import’ to proceed the instant import.
Scheduling the Import
To schedule your importing in WP Ultimate CSV Importer, enable the ‘Do you want to schedule this Import?’ on the ‘Import Configuration Section’. Next provide schedule date, frequency, time zone and schedule time. Like the below screenshot,
Now after importing, Go and visit ‘Posts’, you will get the new Posts there. You can be able to see your posts are added in the post page. Similarly, go to ‘Pages’ and you will see the Pages are added. Like the same, if "custom post" are added it will display as a session in left side navigation.
Export XML file
With WP Ultimate CSV importer you can easily export your post, pages, images, even WooCommerce data in easy steps. As a first process clicks on the field you want to export from WordPress. Then name the export file and click on the type of file you have to export.
How do you split multiple files in XML?
The advanced feature of CSV importer is, you can split your records. After typing the name, click on XML as the file format to download, then enable split the records, provide the number of records in each split, click on export. If you want to export an XML file with other information just tick on the check box and then submit export.
Don’t stop yourself just to learn about the importing process. Instead get into the steps and Start Happy Importing. Refer our documentation here to learn more about CSV Importer. If you’ve any further doubts on importing, feel free to ask us in this helpdesk [email protected] We would be happy to hear from you.