{"id":137910,"date":"2018-08-10T13:00:13","date_gmt":"2018-08-10T13:00:13","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=137910"},"modified":"2024-03-15T07:28:46","modified_gmt":"2024-03-15T07:28:46","slug":"generating-data-for-performance-testing-in-magento-2","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/","title":{"rendered":"Generating Data for Performance Testing in Magento 2"},"content":{"rendered":"\n

When moving a website to production, it is crucial to identify potential performance bottlenecks.<\/p>\n\n\n\n

Magento offers various profiles for generating data with varying amounts, ranging from 800 products in the small profile to 800,000 in the extra large profile, based on the requirements.<\/p>\n\n\n\n

How to generate Data?<\/strong>
In the terminal, run the following command from your Magento root directory.<\/p>\n\n\n\n

php bin\/magento setup:perf:generate-fixtures setup\/performance-toolkit\/profiles\/ce\/small.xml<\/pre>\n\n\n\n
In the command above we have generated data using a small profile, similarly, other profiles can be found at setup\/performance-toolkit\/profiles\/ce or setup\/performance-toolkit\/profiles\/ee directory depending on your Magento edition.<\/p>\n\n\n\n
The data set for different profiles is as under:<\/p>\n\n\n\n
Parameter<\/th>Small profile<\/th>Medium profile<\/th>Large profile<\/th>Extra large profile<\/th><\/tr>
websites<\/td>1<\/td>1<\/td>3<\/td>5<\/td><\/tr>
store_groups<\/td>1<\/td>2<\/td>3<\/td>5<\/td><\/tr>
store_views<\/td>1<\/td>2<\/td>3<\/td>5<\/td><\/tr>
simple_products<\/td>800<\/td>16,000<\/td>400,000<\/td>800,000<\/td><\/tr>
configurable_products<\/td>50<\/td>1,000<\/td>25,000<\/td>50,000<\/td><\/tr>
categories<\/td>30<\/td>300<\/td>1,000<\/td>3,000<\/td><\/tr>
categories_nesting_level<\/td>3<\/td>3<\/td>3<\/td>6<\/td><\/tr>
catalog_price_rules<\/td>10<\/td>20<\/td>50<\/td>100<\/td><\/tr>
catalog_target_rules<\/td>2<\/td>5<\/td>10<\/td>50<\/td><\/tr>
cart_price_rules<\/td>10<\/td>20<\/td>50<\/td>100<\/td><\/tr>
cart_price_rules_floor<\/td>2<\/td>2<\/td>2<\/td>5<\/td><\/tr>
customers<\/td>20<\/td>200<\/td>2,000<\/td>5,000<\/td><\/tr>
tax rates<\/td>40,000<\/td>40,000<\/td>40,000<\/td>40,000<\/td><\/tr>
orders<\/td>80<\/td>1,600<\/td>40,000<\/td>80,000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Data source: https:\/\/devdocs.magento.com\/guides\/v2.0\/config-guide\/cli\/config-cli-subcommands-perf-data.html<\/a><\/p>\n\n\n\n
This is all for the data generation, hope this may save you some time while deploying some sample data.<\/p>\n","protected":false},"excerpt":{"rendered":"
When moving a website to production, it is crucial to identify potential performance bottlenecks. Magento offers various profiles for generating data with varying amounts, ranging from 800 products in the small profile to 800,000 in the extra large profile, based on the requirements. How to generate Data?In the terminal, run the following command from your […]<\/a><\/p>\n","protected":false},"author":116,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,302],"tags":[7260,7261],"class_list":["post-137910","post","type-post","status-publish","format-standard","hentry","category-magento","category-magento2","tag-performance-testing","tag-sample-data"],"yoast_head":"\nGenerating Data for Performance Testing in Magento 2 - Webkul Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Generating Data for Performance Testing in Magento 2 - Webkul Blog\" \/>\n<meta property=\"og:description\" content=\"When moving a website to production, it is crucial to identify potential performance bottlenecks. Magento offers various profiles for generating data with varying amounts, ranging from 800 products in the small profile to 800,000 in the extra large profile, based on the requirements. How to generate Data?In the terminal, run the following command from your [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Webkul Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webkul\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-10T13:00:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-15T07:28:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-og.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ayaz Mittaqi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webkul\" \/>\n<meta name=\"twitter:site\" content=\"@webkul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ayaz Mittaqi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/\"},\"author\":{\"name\":\"Ayaz Mittaqi\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/3a9d84d349b963ed99f7aead9372dd6d\"},\"headline\":\"Generating Data for Performance Testing in Magento 2\",\"datePublished\":\"2018-08-10T13:00:13+00:00\",\"dateModified\":\"2024-03-15T07:28:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/\"},\"wordCount\":179,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"keywords\":[\"performance testing\",\"sample data\"],\"articleSection\":[\"magento\",\"Magento2\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/\",\"url\":\"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/\",\"name\":\"Generating Data for Performance Testing in Magento 2 - Webkul Blog\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"datePublished\":\"2018-08-10T13:00:13+00:00\",\"dateModified\":\"2024-03-15T07:28:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Generating Data for Performance Testing in Magento 2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/webkul.com\/blog\/#website\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"name\":\"Webkul Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/webkul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/webkul.com\/blog\/#organization\",\"name\":\"WebKul Software Private Limited\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"width\":380,\"height\":380,\"caption\":\"WebKul Software Private Limited\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webkul\/\",\"https:\/\/x.com\/webkul\",\"https:\/\/www.instagram.com\/webkul\/\",\"https:\/\/www.linkedin.com\/company\/webkul\",\"https:\/\/www.youtube.com\/user\/webkul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/3a9d84d349b963ed99f7aead9372dd6d\",\"name\":\"Ayaz Mittaqi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9a683a7c995567db93858f0305606f73f9075f82330789701e3ed345f6f830aa?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9a683a7c995567db93858f0305606f73f9075f82330789701e3ed345f6f830aa?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g\",\"caption\":\"Ayaz Mittaqi\"},\"url\":\"https:\/\/webkul.com\/blog\/author\/ayaz-mittaqi024\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Generating Data for Performance Testing in Magento 2 - Webkul Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/","og_locale":"en_US","og_type":"article","og_title":"Generating Data for Performance Testing in Magento 2 - Webkul Blog","og_description":"When moving a website to production, it is crucial to identify potential performance bottlenecks. Magento offers various profiles for generating data with varying amounts, ranging from 800 products in the small profile to 800,000 in the extra large profile, based on the requirements. How to generate Data?In the terminal, run the following command from your [...]","og_url":"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_published_time":"2018-08-10T13:00:13+00:00","article_modified_time":"2024-03-15T07:28:46+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-og.png","type":"image\/png"}],"author":"Ayaz Mittaqi","twitter_card":"summary_large_image","twitter_creator":"@webkul","twitter_site":"@webkul","twitter_misc":{"Written by":"Ayaz Mittaqi","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/"},"author":{"name":"Ayaz Mittaqi","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/3a9d84d349b963ed99f7aead9372dd6d"},"headline":"Generating Data for Performance Testing in Magento 2","datePublished":"2018-08-10T13:00:13+00:00","dateModified":"2024-03-15T07:28:46+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/"},"wordCount":179,"commentCount":0,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"keywords":["performance testing","sample data"],"articleSection":["magento","Magento2"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/","url":"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/","name":"Generating Data for Performance Testing in Magento 2 - Webkul Blog","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"datePublished":"2018-08-10T13:00:13+00:00","dateModified":"2024-03-15T07:28:46+00:00","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/generating-data-for-performance-testing-in-magento-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Generating Data for Performance Testing in Magento 2"}]},{"@type":"WebSite","@id":"https:\/\/webkul.com\/blog\/#website","url":"https:\/\/webkul.com\/blog\/","name":"Webkul Blog","description":"","publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webkul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/webkul.com\/blog\/#organization","name":"WebKul Software Private Limited","url":"https:\/\/webkul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","width":380,"height":380,"caption":"WebKul Software Private Limited"},"image":{"@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webkul\/","https:\/\/x.com\/webkul","https:\/\/www.instagram.com\/webkul\/","https:\/\/www.linkedin.com\/company\/webkul","https:\/\/www.youtube.com\/user\/webkul\/"]},{"@type":"Person","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/3a9d84d349b963ed99f7aead9372dd6d","name":"Ayaz Mittaqi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9a683a7c995567db93858f0305606f73f9075f82330789701e3ed345f6f830aa?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9a683a7c995567db93858f0305606f73f9075f82330789701e3ed345f6f830aa?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Fmike.png&r=g","caption":"Ayaz Mittaqi"},"url":"https:\/\/webkul.com\/blog\/author\/ayaz-mittaqi024\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/137910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/users\/116"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=137910"}],"version-history":[{"count":6,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/137910\/revisions"}],"predecessor-version":[{"id":427671,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/137910\/revisions\/427671"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=137910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=137910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=137910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}