<h2 class="wp-block-heading">The most important features for you</h2>
<ul class="wccom-tick-list-primary">
<li>Add products to the shopping cart in bulk, based on a default or custom excel or .csv file</li>
<li>User-friendly and customizable front-end spreadsheet widget: Determine the location, position, text, translations and layout</li>
<li>Limit products, product categories, tags, users and user roles</li>
<li>Allow custom spreadsheet templates and field mapping</li>
<li>Compatible with WPML, Polylang & Weglot</li>
</ul>
<h2 class="wp-block-heading" id="h-setup-and-installation">Setup and Installation</h2>
<p>1. Download the plugin ZIP file and upload it to the WordPress plugins screen<br />2. Activate the plugin through the ‘Plugins’ screen in WordPress.<br />3. Navigate to WooCommerce > Settings > Order by Spreadsheet to configure the plugin settings.<br />4. Customize options as desired.</p>
<h2>All features</h2>
<p>Find out what Order By Spreadsheet can do for you:</p>
<ul class="wccom-tick-list-secondary">
<li><strong>User-friendly spreadsheet widget</strong> ― Let WooCommerce customers or guests place orders by downloading a spreadsheet of your products (.csv) and re-uploading them (.csv, .xls, .xlsx) to the WooCommerce shopping cart using an easy-to-use frontend widget.</li>
<li><strong>Determine which users are allowed to order by spreadsheets </strong>― Determine whether all your webshop customers, only logged-in users or only customers with certain user roles are allowed to order by spreadsheets.</li>
<li><strong>Limit product categories & tags </strong>― Choose which WooCommerce product categories and/or product tags may or may not be ordered from spreadsheets. Thus, personalize the export template that customers can download.</li>
<li><strong>Exclude products individually </strong>― For each WooCommerce product or variation, determine whether it may be included in the export template that customers can download.</li>
<li><strong>Add your own product EAN field to export template </strong>― Do you have a custom field for the product EAN code in your WooCommerce product sheet? Link this field to the export template that customers can download. Handy for customers with a barcode scanner!</li>
<li><strong>Allow custom spreadsheet templates </strong>― Allow customers to upload their own spreadsheet template and link their columns. Useful for large B2B clients!</li>
<li><strong>Determine the position and layout of the spreadsheet widget </strong>― Make sure the frontend spreadsheet widget fits seamlessly into your store layout! Determine the colors, position and whether it is visible on the entire website, only on the shop pages or also in the account area.</li>
<li><strong>Personalize the contents of the spreadsheet widget </strong>― Order By Spreadsheet automatically detects which languages your WooCommerce store uses and allows you to change the contents of the spreadsheet widget for each language.</li>
<li><strong>Redirect after import </strong>― Determine whether customers are redirected to the shopping cart or checkout page after importing the their order spreadsheet.</li>
<li><strong>Compatible with WPML, Polylang & Weglot </strong>― If you use WPML, Polylang or Weglot, you can change the contents of the spreadsheet widget for any set language.</li>
<li><strong>Plugin admin available in NL, EN, FR, DE, & ES </strong>― Order By Spreadsheet is available in the admin languages English, Dutch, French, German and Spanish.</li>
<li><strong>Translation ready</strong></li>
</ul>

Order By Spreadsheet

<p>Let WooCommerce customers or guests place orders by downloading a spreadsheet of your products (.csv) and uploading it again (.csv, .xls, .xlsx) to the WooCommerce shopping cart. Also supports field mapping for custom spreadsheets.</p>

<p>The <strong>Invoice Payment Option</strong> extension for WooCommerce enables you to add a new invoice payment method to let customers place orders without making any payment. Display the new payment option based on user roles, product in cart, order amount, quantity and other conditions.</p>
<p>You can rename the payment method to Pay Later, Pay by Invoice or give it any other name that suits your business requirements. Once the order is placed, the customer will receive the standard WooCommerce order email. If needed, you can also attach invoice PDF with the order emails.</p>
<p>After the order and payment confirmation, you can send a direct payment link using the default WooCommerce feature to let customers pay using the default WooCommerce checkout process. Alternatively, you can choose to receive payment via other channels such as banking checks, cash on delivery, etc.</p>
<h2>Use Cases:</h2>
<p>The following are use cases where this extension can be extremely helpful but not limited to!</p>
<p><strong>B2B Orders:</strong></p>
<p>When working with a company, they usually require an invoice before making the payment. Using this extension, you can allow your customers to place an order without payment. The admin can later on send the payment link to merchants to receive payment via WooCommerce default checkout.</p>
<p><strong>Bulk Orders:</strong></p>
<p>When placing bulk orders, the customers are sometimes reluctant to pay upfront and need assurance before paying. The extension allows them to place orders and once confirmed, they can proceed with the payment.</p>
<h2><strong>Features of Invoice Payment Method</strong></h2>
<ul>
<li>Automatically creates new payment method “Pay by Invoice”</li>
<li>Customize title, description and default order status</li>
<li>Create multiple rules to show invoice payment method based on
<ul>
<li>Customers and user roles</li>
<li>Specific products, categories or tags</li>
<li>Minimum & maximum order quantity and amount</li>
<li>Country, state, city and zip codes</li>
<li>Shipping method</li>
</ul>
</li>
<li>Generate and attach PDF invoice with orders emails<strong> (New)</strong></li>
<li>Separate email notification for customer and admin when order is placed using invoice payment option <strong> (New)</strong></li>
</ul>
<h2>Customize payment method label:</h2>
<p>Once the extension is installed, you can configure the newly created invoice payment method from WooCommerce > Settings > Payments. You can customize the label and other details of the payment method. You can also configure the default order status for orders placed using this payment option.</p>
<p><img class="alignnone size-full wp-image-8520897" src="https://woocommerce.com/wp-content/uploads/2021/09/invoice-payment-option.png" alt="" width="980" height="553" /></p>
<p>The invoice payment method appears along with other payment methods on the front-end.</p>
<p><img class="alignnone size-full wp-image-8520912" src="https://woocommerce.com/wp-content/uploads/2021/09/Invoice-payment-option-frontend.png" alt="" width="980" height="538" /></p>
<h2>Trigger Invoice Payment based on various condition:</h2>
<p>You can create multiple rules to trigger the invoice payment option based on variations conditions like product in cart, order amount, user roles, country and more.</p>
<p><img class="alignnone size-full wp-image-8520902" src="https://woocommerce.com/wp-content/uploads/2021/09/Create-restrictions-rules.jpg" alt="" width="980" height="439" /></p>
<p>While creating a new rule, you can configure the following options:</p>
<ul>
<li>Add rule title</li>
<li>Select shipping method (enable invoice payment option for selected shipping method)</li>
<li>Enable invoice payment for virtual products</li>
<li>Enable for selected customers and user roles</li>
<li>Enable for specific cart quantity and amount range</li>
<li>Enable for specific product, product category and tags</li>
<li>Show to selected countries, states, cities or zip codes</li>
</ul>
<p><img class="alignnone size-full wp-image-8520901" src="https://woocommerce.com/wp-content/uploads/2021/09/Creating-new-rule-for-invoice-payment-method.jpg" alt="" width="980" height="2263" /></p>
<h2>Invoice PDF</h2>
<p>You can attach a customizable PDF invoice with the orders placed using this “Invoice Payment Method”. The extension offers 3 different PDF templates to choose from. You can customize the PDF content and color scheme to match your business needs.</p>
<p>Using the extension settings, you can trigger separate email notifications for both customer and merchants when an order is placed using the invoice payment option.</p>
<p><img class="alignnone size-full wp-image-18734003700000" src="https://woocommerce.com/wp-content/uploads/2021/09/PDF-Invoice-1.png" alt="" width="980" height="912" /></p>
<h3>Requirements</h3>
<p>Minimum PHP version: 7.2</p>

Invoice Payment Option

<p>Order Now and Pay Later! Allow your customers to select invoice payment option during checkout to place orders. Add conditions to show invoice payment options for specific products, categories, countries, cart total, user roles and more.</p>

Order By Spreadsheet vs Invoice Payment Option