Owning or maintaining an online store comes with a lot of repetitive tasks. Your product list is continuously being updated, and so are your customers and orders. Keeping track of them can become an issue.
In some of our previous posts, we’ve seen how the WP All Import plugin can help you keep your online store organized and up-to-date by enabling you to import all your data – be it products, customers and orders.
This process is made more convenient with the plugin’s ability to import your WooCommerce products on a schedule. In this article, I’ll be explaining how to do so.
Let’s get down to it.
Create a new WooCommerce product import
Under “All Import” in the sidebar, go to “New Import”. Although the plugin lets you import your data by uploading a file, or using an existing file on your database, to enable scheduling, we need to download the data from a URL.
The reason behind this is that as you continuously update your file, located on either Dropbox, Google Sheets, or Google Drive, the plugin will be able to retrieve that same file over time and locate any updates or changes. Consequently, the plugin will then update your online shop accordingly.
So, after you’ve copied and pasted your file URL, WP All Import will import your product feed into WooCommerce automatically. The plugin supports XML, CSV, JSON, or XSLX file URLs and will also unzip any zipped feeds and locate the data file.
Next, choose whether you want to update existing items or create new ones. If you are doing both, select the “existing items” button. From the drop-down menu, select the items you would like to import. In this case, I want to create new WooCommerce Products for my online pet shop.
Continue to Step 2 where you can set filtering rules to only import products that meet certain criteria. Alternatively, you can skip this step and continue to step 3.
Drag and drop to import WooCommerce data
At this point, you’ll want to start to drag and drop your product data into the WooCommerce fields.
Under the “General” tab of the WooCommerce Add-On, start by importing your regular and sale price. One of the great features of this plugin is that it allows you to schedule your sale price and increase or decrease the prices based on a percentage or set amount under “Adjust Prices”.
You can also set your product URL and button text. If your data has currency symbols, you
This article was written by Gabriella Galea and originally published on WP Mayor.