Title: Problem creating 288K Variations Last modified: February 18, 2025 --- # Problem creating 288K Variations * Resolved [pgilpat](https://wordpress.org/support/users/pgilpat/) * (@pgilpat) * [1 year, 3 months ago](https://wordpress.org/support/topic/problem-creating-288k-variations/) * We are setting up a new WP/WooCommerce site and trying to migrate from an existing ColdFusion website with 4,000 products. Each product has 5 Attributes. We need to create variations of each attribute for a total of 72 variations per product. Successfully creating all the variations for each product results in 288K variations. This would take a very long time completing in WOO doing 1 product at a time. * We have tried bulk editors that have worked successfully testing 100-500 products by importing CSV files. Once we reach 1,000 products, nothing works. And no errors are reported or logged. * What is considered best practices to create these many variations? Do you have any suggested settings in WOO, PHP, SQL, or APACHE that need changing? * I have other websites running WooCommerce with nearly 3,000 products but were not created by importing products. * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fproblem-creating-288k-variations%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 7 replies - 1 through 7 (of 7 total) * [Mahfuzur Rahman](https://wordpress.org/support/users/mahfuzurwp/) * (@mahfuzurwp) * [1 year, 3 months ago](https://wordpress.org/support/topic/problem-creating-288k-variations/#post-18313197) * Hi [@pgilpat](https://wordpress.org/support/users/pgilpat/), * It sounds like the issue might be related to server limits when handling large imports. Please try increasing max_execution_time, memory_limit, and relevant database settings, or reach out to your hosting support for assistance. * You could also try: - **WP-CLI for importing** – This avoids timeouts and memory issues compared to web-based imports. - **Splitting CSV files into smaller batches** – Importing 500-1000 products at a time may work more reliably. * If the issue persists, it may require a custom solution. Consulting a developer with experience in large-scale WooCommerce migrations could help ensure a smooth process. * Let us know how it goes! * Thread Starter [pgilpat](https://wordpress.org/support/users/pgilpat/) * (@pgilpat) * [1 year, 3 months ago](https://wordpress.org/support/topic/problem-creating-288k-variations/#post-18314591) * Hello [@mahfuzurwp](https://wordpress.org/support/users/mahfuzurwp/), * The problem we are having is with creating variations. With each product having 5 attributes it requires 72 variations and ultimately nearly 300,000 total variations and it takes forever and finally just stops. It has successfully worked with 100 products and once with 500 products but cannot process 1,000 products. Not sure what to do with the SQL, but it is taking many CPU resources. * We are going to try this product to see if we can gain anything. Have upped the resources you discussed. * [Zee](https://wordpress.org/support/users/doublezed2/) * (@doublezed2) * [1 year, 3 months ago](https://wordpress.org/support/topic/problem-creating-288k-variations/#post-18317811) * Hello [pgilpat](https://wordpress.org/support/users/pgilpat/), * Thank you for your reply. * I understand that each product has 5 attributes, requiring 72 variations, and with 1,000 products, this results in nearly 300,000 total variations, causing high CPU usage and failure during processing. * I recommend reducing the number of variations, as this setup will make your store very resource-intensive. * Please share more details about the product attributes and how they result in 72 variations per product. A screenshot of your CSV sheet or another format would help me better understand the structure and suggest an optimized approach. * Looking forward to your response. 🙂 * Thread Starter [pgilpat](https://wordpress.org/support/users/pgilpat/) * (@pgilpat) * [1 year, 3 months ago](https://wordpress.org/support/topic/problem-creating-288k-variations/#post-18320637) * Here you go * [https://www.hostworks.com/wp-content/uploads/2025/02/1500-02.19.25-Short.csv](https://www.hostworks.com/wp-content/uploads/2025/02/1500-02.19.25-Short.csv) * [Zee](https://wordpress.org/support/users/doublezed2/) * (@doublezed2) * [1 year, 3 months ago](https://wordpress.org/support/topic/problem-creating-288k-variations/#post-18322017) * Hello [pgilpat](https://wordpress.org/support/users/pgilpat/), * Thank you for your reply. * I checked the CSV file you shared. I noticed that the Price column is empty for all products. * I was going to suggest creating variations only for products that have different prices. For example:I sell shirts in my store, for me the color of the shirt does not affect the price.The size of the shirt does affect the price.So I would create three variations based on small, medium, and large sizes.I would leave color as a Custom Product Option. This way color will still appear as a dropdown but not as a variation. * So customers can choose a large variation and select red from the Custom Product Option. In the order details, I will get Large + Red shirt as an order. * For product options, I recommend [Extra Custom Product Options for WooCommerce](https://woocommerce.com/products/extra-custom-product-options-for-woocommerce/). * Please don’t hesitate to ask any questions. 🙂 * Best regards. * Thread Starter [pgilpat](https://wordpress.org/support/users/pgilpat/) * (@pgilpat) * [1 year, 3 months ago](https://wordpress.org/support/topic/problem-creating-288k-variations/#post-18323616) * I don’t think you are understanding the problem. We didn’t include price on the spreadsheet just because we are focusing just getting the variations to simply be created without stopping along the hours of this process. How does anyone get this process of building the variations? This has become maddening. It doesn’t appear to be a resource issue. The debug.log attached here is talking about a deadlock error. What do you make of this? This is just from the start of the day to current. There are many thousands of these. * [https://staging.klemcoll.com/wp-content/uploads/2025/02/Feb23Logs.txt](https://staging.klemcoll.com/wp-content/uploads/2025/02/Feb23Logs.txt) * This file should illustrate the 72 variations for one product. * [https://staging.klemcoll.com/wp-content/uploads/2025/02/OA22.csv](https://staging.klemcoll.com/wp-content/uploads/2025/02/OA22.csv) * [Moses M. (woo-hc)](https://wordpress.org/support/users/mosesmedh/) * (@mosesmedh) * [1 year, 3 months ago](https://wordpress.org/support/topic/problem-creating-288k-variations/#post-18323707) * Hi [@pgilpat](https://wordpress.org/support/users/pgilpat/), * As [@mahfuzurwp](https://wordpress.org/support/users/mahfuzurwp/) mentioned, this issue still appears to be related to server resources and usage. The most effective approach for handling such a large number of variations is to use WP CLI. While increasing `max_execution_time`, `memory_limit`, `post_max_size`, and `upload_max_filesize` to their maximum values may help, it’s not always the best solution. * A better approach is to utilize WP CLI or the WooCommerce REST API for importing variations instead of relying on CSV files. This requires writing a script that interacts with the WooCommerce REST API, allowing variations to be processed in manageable batches automatically. * Alternatively, you could implement a job queue system using a plugin like WP All Import Pro with cron jobs to handle the import process more efficiently. * If you need professional assistance, I’ll advise consulting [WooExperts](https://woocommerce.com/development-services/). Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Problem creating 288K Variations’ is closed to new replies. * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504) * [WooCommerce](https://wordpress.org/plugins/woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/) * 7 replies * 4 participants * Last reply from: [Moses M. (woo-hc)](https://wordpress.org/support/users/mosesmedh/) * Last activity: [1 year, 3 months ago](https://wordpress.org/support/topic/problem-creating-288k-variations/#post-18323707) * Status: resolved