<h2>Easily import Customers, Orders, and Coupons via a CSV file</h2>
<p>Mass import hundreds, even thousands of customers, coupons, and orders into your WooCommerce store with the Customer / Coupon / Order CSV Import Suite. This user-friendly importer will import customers with a minimum of hassle, and can import orders and link them to your shop’s customers and products.</p>
<p>This is an ideal tool when migrating an existing shop on a different eCommerce platform to WooCommerce, allowing you to maintain your customer accounts and order history. Have coupons to migrate from your old eCommerce platform, or campaigns requiring the creation of hundreds of coupons or more? The importer will import those, too!</p>
<figure style="width: 950px" class="wp-caption aligncenter"><a href="https://woocommerce.com/wp-content/uploads/2012/07/woocommerce-customer-coupon-order-import-suite.png"><img class="aligncenter size-large wp-image-161953" src="https://woocommerce.com/wp-content/uploads/2012/07/woocommerce-customer-coupon-order-import-suite.png?w=950" alt="WooCommerce Customer / Coupon / Order CSV Import: Select import type" width="950" height="710" /></a><figcaption class="wp-caption-text">Main Import Screen</figcaption></figure>
<p>The importer is flexible enough to handle several kinds of import formats, and you can map your import columns to the appropriate WooCommerce data to merge or create customers, coupons, and orders. You can also import data from a variety of sources, such as an uploaded file, URL / file path, or via copy and paste.</p>
<h3>What can the CSV Importer do?</h3>
<ul>
<li>Choose an import <strong>file location</strong>: upload your file, import from a URL / file path, or copy and paste import data <strong><sup>NEW</sup></strong></li>
<li><strong>Import customer data</strong> such as name, email, addresses, whether they are a paying customer, etc</li>
<li><strong>Merge customer data</strong> from your import with existing users – useful for mass-updating customer information!</li>
<li><strong>Import coupons</strong> – <em>all</em> coupon fields are supported, including sale item exclusions and usage limits</li>
<li><strong>Merge coupons</strong> – useful for mass-updating coupon data</li>
<li><strong>Import order data</strong>, such as line items, linked customers, order totals, order notes, order numbers (works well when paired with the <a href="https://woocommerce.com/extension/sequential-order-numbers-pro/">Sequential Order Number Pro</a> plugin), and more</li>
<li><strong>Merge order data</strong> to update totals, order status, or add meta in bulk such as tracking numbers <strong><sup>NEW</sup></strong></li>
<li>Import <strong>custom fields</strong> (meta) for customers, coupons, and orders</li>
<li>Import <strong>custom taxonomies</strong> for customers, coupons, and orders if you have them added by plugins / third party code</li>
<li>Supports multiple shipping methods per order</li>
<li>Imports order data in the background so that you can import large sets of data without timeouts <strong><sup>NEW</sup></strong></li>
<li>Flexible import format requires a minimum of fields to import, but allows fully defined customers, orders, and coupons</li>
<li>Fully compatible with the <a href="https://woocommerce.com/products/ordercustomer-csv-export/" target="_blank" rel="noopener noreferrer">Order / Customer CSV Export</a> extension</li>
</ul>
<h3>Import Process</h3>
<p>The import process for customers, coupons, and orders is similar. You’ll first select your import file location.</p>
<p><a href="https://woocommerce.com/wp-content/uploads/2012/07/woocommerce-customer-order-csv-import-suite-select-file.png"><img class="aligncenter size-large wp-image-161919" src="https://woocommerce.com/wp-content/uploads/2012/07/woocommerce-customer-order-csv-import-suite-select-file.png?w=679" alt="WooCommerce Customer / coupon / Order CSV Import: Select import file" width="679" height="273" /></a></p>
<p>Then you’ll select options for the import, and get a quick preview of your import file so you can ensure the plugin has detected the delimiter correctly. For any import type, you can opt to <em>merge data</em>, which will update existing records if they match, or only <em>create</em> data with each imported row.</p>
<figure id="attachment_161927" aria-describedby="caption-attachment-161927" style="width: 821px" class="wp-caption aligncenter"><a href="https://woocommerce.com/wp-content/uploads/2012/07/woocommerce-customer-order-csv-import-suite-import-customers-1.png"><img class="size-large wp-image-161927" src="https://woocommerce.com/wp-content/uploads/2012/07/woocommerce-customer-order-csv-import-suite-import-customers-1.png?w=821" alt="WooCommerce Customer / coupon / Order CSV Import: customer import options" width="821" height="706" /></a><figcaption id="caption-attachment-161927" class="wp-caption-text">Customer Import Options</figcaption></figure>
<p>Next, you’ll map the columns in your import to the appropriate WooCommerce data. This lets you easily import almost any file format, so long as it contains the necessary information for import.</p>
<p><a href="https://woocommerce.com/wp-content/uploads/2012/07/woocommerce-customer-order-csv-import-suite-import-coupons-mapping.png"><img class="aligncenter size-large wp-image-161938" src="https://woocommerce.com/wp-content/uploads/2012/07/woocommerce-customer-order-csv-import-suite-import-coupons-mapping.png?w=789" alt="WooCommerce Customer / coupon / Order CSV Import: coupon import mapping" width="789" height="612" /></a></p>
<p>Finally, you can run a dry run to ensure your file will import safely, and do a live run. This will process in the background, meaning you can navigate away from the import page as it churns through your imported file, which can even be thousands of rows long!</p>
<p><a href="https://woocommerce.com/wp-content/uploads/2012/07/woocommerce-customer-order-csv-import-suite-import-progress.png"><img class="aligncenter size-large wp-image-161926" src="https://woocommerce.com/wp-content/uploads/2012/07/woocommerce-customer-order-csv-import-suite-import-progress.png?w=796" alt="WooCommerce Customer / coupon / Order CSV Import: import progress completed" width="796" height="576" /></a></p>
<p>You’ll get a status update when the import is completed of how many rows modified data, were inserted, or were skipped.</p>
<h3>How to Get Started (in 5 minutes or less)</h3>
<ol>
<li>Buy this extension 🙂</li>
<li>Download and install into your WooCommerce store</li>
<li>Read the <a href="https://woocommerce.com/document/customer-order-csv-import-suite/">Documentation</a> and download the sample CSV files to see the format required for import.</li>
<li>Add your data to the CSV file, upload, and click import.</li>
<li>That’s it! Sit back and enjoy your easily imported customers, coupons, and coupons!</li>
</ol>
<p><em>Need any more reason to buy? When you purchase a SkyVerge-developed extension, you’re getting the highest quality extensions for your WooCommerce store. Gain peace of mind by knowing that when you purchase our products, your store’s performance is as important to us as it is to you.</em></p>

Customer/Order/Coupon CSV Import Suite

<p>Import both customers and orders into WooCommerce from a CSV file.</p>

<div class="twocol-one" style="margin-bottom: 0">
<h2 style="color: #f5247d;margin-bottom: 1em">Update price and stock data in your store with a simple CSV spreadsheet in a few easy steps</h2>
<p>Price and Stock Import was designed specifically for price and stock data management – the data which needs to be updated in bulk regularly. The extension relieves you of the headaches of complicated spreadsheets filled with tons of other data you don’t understand.</p>
<p>Manage the prices and stock in your store with ease. You can export your existing price and stock data in an easy to understand CSV spreadsheet, then make your changes and import it back in easily, you can even review your changes using the import test tool. That’s all there is to it!</p>
<p style="color: #999999;font-style: italic">Read on to find out why you should use Price and Stock Import and the great features included…</p>
</div>
<div class="twocol-one last" style="margin-bottom: 0">
<p><a href="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-export.jpg" target="_blank" rel="noopener"><img style="border: 1px solid #dedee0;border-radius: 5px" src="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-export.jpg" /></a></p>
<div class="woocommerce-message">
<div><strong>Chris, an eCommerce store owner said:</strong></div>
<div style="margin-top: 0.5em"><i>“The best tool I have found for updating price and stock data in bulk with no hassle 🙂”</i></div>
</div>
</div>
<hr style="clear: both" />
<div class="woo-sc-box">
<h2>Features</h2>
<ul class="wccom-tick-list-secondary" style="line-height: 1.8em;margin-bottom: 18px">
<li><strong>Makes bulk price and stock data changes as easy as 1, 2, 3</strong></li>
<li><strong>Easy to understand CSV spreadsheet with price and stock columns</strong></li>
<li><strong>Review your CSV spreadsheet data before importing with the import test tool</strong></li>
<li>Allows bulk updates of both regular and sale prices</li>
<li>Product ID or SKU mode to map spreadsheet rows to existing products</li>
<li>Progress of import is displayed in percentage, rows processed and rows remaining</li>
<li>Browser tab shows progress during import so you can work in another tab while checking progress</li>
<li>Works with the WooCommerce Subscriptions product types</li>
</ul>
<p><a class="wccom-button is-primary" style="font-weight: 400;text-decoration: none;width: 130px" href="https://woocommerce.com/?add-to-cart=5610063" target="_blank" rel="noopener"><span class="wccom-button__text">Buy Now</span></a></p>
</div>
<hr style="clear: both" />
<h2>Highlights</h2>
<p style="color: #999999;font-style: italic">Get these great features for your store…</p>
<div class="twocol-one" style="margin-bottom: 0">
<h3>Export</h3>
<p>To get started click the export button, this downloads a simple CSV to your computer where you edit the stock and price columns in your spreadsheet software.</p>
<p><a href="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-export.jpg" target="_blank" rel="noopener"><img style="border: 1px solid #dedee0;border-radius: 5px" src="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-export.jpg" /></a></p>
</div>
<div class="twocol-one last" style="margin-bottom: 0">
<h3>Import</h3>
<p>Once you have made changes to the price and stock data in the exported CSV and have saved it simply select the file and click the import or import test button.</p>
<p><a href="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-import.jpg" target="_blank" rel="noopener"><img style="border: 1px solid #dedee0;border-radius: 5px" src="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-import.jpg" /></a></p>
</div>
<div class="twocol-one" style="margin-bottom: 0">
<h3>Import test</h3>
<p>It is recommended you review your data changes before import using the handy import test tool to look at the data and once happy you can import it.</p>
<p><a href="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-import-test.jpg" target="_blank" rel="noopener"><img style="border: 1px solid #dedee0;border-radius: 5px" src="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-import-test.jpg" /></a></p>
</div>
<div class="twocol-one last" style="margin-bottom: 0">
<h3>Import progress</h3>
<p>While importing you can see the percentage progress, number of rows processed and remaining, this is information is also shown in the browser tab.</p>
<p><a href="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-import-progess.jpg" target="_blank" rel="noopener"><img style="border: 1px solid #dedee0;border-radius: 5px" src="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-import-progess.jpg" /></a></p>
</div>
<div class="twocol-one" style="margin-bottom: 0">
<h3>Product ID or SKU mode</h3>
<p>The data in the CSV imported is matched by the product ID or SKU, you can choose either mode depending on how you reference products.</p>
<p><a href="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-mode.jpg" target="_blank" rel="noopener"><img style="border: 1px solid #dedee0;border-radius: 5px" src="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-mode.jpg" /></a></p>
</div>
<div class="twocol-one last" style="margin-bottom: 0">
<h3>WooCommerce Subscriptions compatibility</h3>
<p>Compatible with WooCommerce Subscriptions product types to allow you to update subscription product price and stock data in bulk.</p>
<p><a href="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-subscriptions.jpg" target="_blank" rel="noopener"><img style="border: 1px solid #dedee0;border-radius: 5px" src="https://woocommerce.com/wp-content/uploads/2020/03/price-stock-import-screenshot-subscriptions.jpg" /></a></p>
</div>
<hr style="clear: both" />
<h2>Screenshots</h2>
<p style="color: #999999;font-style: italic">See the extension in action…</p>
<p class="jetpack-slideshow-noscript robots-nocontent">This slideshow requires JavaScript.</p><div id="gallery-0-8-slideshow" class="jetpack-slideshow-window jetpack-slideshow jetpack-slideshow-black" data-trans="fade" data-autostart="1" data-gallery="[{"src":"https:\/\/woocommerce.com\/wp-content\/uploads\/2020\/03\/price-stock-import-screenshot-export.jpg","id":"18734000526755","title":"price-stock-import-screenshot-export","alt":"","caption":"","itemprop":"image"},{"src":"https:\/\/woocommerce.com\/wp-content\/uploads\/2020\/03\/price-stock-import-screenshot-import.jpg","id":"18734000526707","title":"price-stock-import-screenshot-import","alt":"","caption":"","itemprop":"image"},{"src":"https:\/\/woocommerce.com\/wp-content\/uploads\/2020\/03\/price-stock-import-screenshot-import-test.jpg","id":"18734000526767","title":"price-stock-import-screenshot-import-test","alt":"","caption":"","itemprop":"image"},{"src":"https:\/\/woocommerce.com\/wp-content\/uploads\/2020\/03\/price-stock-import-screenshot-import-progess.jpg","id":"18734000529129","title":"price-stock-import-screenshot-import-progess","alt":"","caption":"","itemprop":"image"},{"src":"https:\/\/woocommerce.com\/wp-content\/uploads\/2020\/03\/price-stock-import-screenshot-mode.jpg","id":"18734000526850","title":"price-stock-import-screenshot-mode","alt":"","caption":"","itemprop":"image"},{"src":"https:\/\/woocommerce.com\/wp-content\/uploads\/2020\/03\/price-stock-import-screenshot-subscriptions.jpg","id":"18734000529130","title":"price-stock-import-screenshot-subscriptions","alt":"","caption":"","itemprop":"image"}]"></div>
<hr style="clear: both" />
<div class="woocommerce-message">
<h2>Example usage</h2>
<p>Emma manages a WooCommerce store selling car accessories, she places orders with a wholesaler for products each week and sometimes the wholesaler has changed the product prices. Each week she needs to update the price and stock levels in her store. With Price and Stock Import she can quickly export a CSV of the price and stock data for every product and variation in her store and edit the values quickly in a spreadsheet, once done she imports it back in, all the products within the website are easily updated to the new price and stock data.</p>
</div>
<hr style="clear: both" />
<h2>More information</h2>
<ul style="line-height: 1.8em">
<li><a href="https://woocommerce.com/document/price-stock-import/" target="_blank" rel="noopener">Read documentation</a> for an overview of the settings, options, frequently asked questions and more</li>
<li><a href="https://woocommerce.com/contact-us/" target="_blank" rel="noopener">Contact us</a> if you have any questions and we’ll be happy to help</li>
</ul>
<hr style="clear: both" />
<p><a class="wccom-button is-primary" style="font-weight: 400;text-decoration: none;width: 130px" href="https://woocommerce.com/?add-to-cart=5610063" target="_blank" rel="noopener"><span class="wccom-button__text">Buy Now</span></a></p>
<p>Made by the team at:<br />
<img src="https://static.kestrelwp.com/kestrel-logo.png?s=11f666810fe50b7bdfdaead4b408d71b6588e7d0" alt="Kestrel logo" width="200" height="45" /></p>

Price and Stock Import

<p>Bulk-update prices and stock in WooCommerce with a simple CSV. Export, edit, and re-import in minutes.</p>

Customer/Order/Coupon CSV Import Suite vs Price and Stock Import