Vladimir Zabara

You can use this plugin to import huge CSV files into WordPress database.

CSV To DB

datafeedr

NOTE: The Datafeedr Product Sets plugin requires the <a href="https://wordpress.org/plugins/datafeedr-api/" rel="ugc">Datafeedr API plugin</a>.
What is a Product Set?
A Product Set is a collection of related products. Once you create a Product Set, the products in that set will be imported into your website (via an importer plugin). The Product Set is also responsible for updating those imported products with the newest information at an interval you choose.
The Datafeedr Product Sets plugin currently integrates with the following plugins:
<ul>
<li><a href="https://wordpress.org/plugins/datafeedr-api/" rel="ugc">Datafeedr API</a></li>
<li><a href="https://wordpress.org/plugins/datafeedr-woocommerce-importer/" rel="ugc">Datafeedr WooCommerce Importer</a></li>
</ul>
How does it work?
<ol>
<li>
Create a new Product Set by performing a product search for specific keywords. In this example lets use “rock climbing shoes” as our keywords.
</li>
<li>
The Datafeedr Product Sets plugin connects to the Datafeedr API and makes an API request querying 250 million affiliate products in the Datafeedr database for the keywords “rock climbing shoes”.
</li>
<li>
The Datafeedr API returns the products in the database that match your search keywords.
</li>
<li>
At this point, you have 2 choices: You can “save” your search (so that all products returned are added to your Product Set) or you can pick and choose specific products to add to your Product Set.
</li>
<li>
After your Product Set has some products in it, you choose what WordPress Post Type and Category to import the Product Set into. For example, you could import all of the rock climbing shoes into your WooCommerce store in the “Climbing Shoes” product category.
</li>
<li>
Within a few seconds the Product Set will attempt to import those products into your WooCommerce product category. It will do so by getting all of the products in the Product Set and passing them to an importer plugin (in this case the <a href="https://wordpress.org/plugins/datafeedr-woocommerce-importer/" rel="ugc">Datafeedr WooCommerce Importer plugin</a>).
</li>
<li>
After a few minutes (depending on how many products are in your set and your update settings) your “Climbing Shoes” product category will be filled with products from your Product Set.
</li>
<li>
Lastly, at an interval you configure, the Product Set will trigger a product update. At this time, products no longer available via the Datafeedr API will be removed from your WooCommerce store, all product information will be updated and any new products that match your “saved search” will be added to your store.
</li>
</ol>
The Datafeedr Product Sets plugin requires at least one importer plugin to import products from a Product Set into your blog.
We currently have one importer which imports products from your Product Sets into your WooCommerce store: <a href="https://wordpress.org/plugins/datafeedr-woocommerce-importer/" rel="ugc">Datafeedr WooCommerce Importer plugin</a>. Additional importers will be developed over the coming months. Custom importers may also be written. Product Sets can be imported into one or more WordPress Post Types.
Requirements
<ul>
<li>PHP 7.4 or greater</li>
<li>MySQL version 5.6 or greater</li>
<li><a href="https://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP" rel="nofollow ugc">WordPress memory limit of 256 MB or greater</a></li>
<li>PHP’s <code>CURL</code> enabled</li>
<li>WordPress Cron enabled</li>
<li><a href="https://wordpress.org/plugins/datafeedr-woocommerce-importer/" rel="ugc">Datafeedr WooCommerce Importer Plugin</a></li>
<li><a href="https://wordpress.org/news/2016/12/moving-toward-ssl/" rel="ugc">HTTPS support</a></li>
</ul>

Datafeedr Product Sets

Build sets of products to import into your website.

CSV To DB vs Datafeedr Product Sets