Pro Features of Products & Order Export for WooCommerce

Products & Order Export for WooCommerce: Pro Functionality Explained #

This article delves into the advanced features offered by the Products & Order Export for WooCommerce plugin, helping you customize and optimize your data exports.

Export Options #

• CSV Separator: Define the character that separates data points within your CSV file. Commas (“,”) are common, but you can choose others for compatibility.
• CSV Wrap: Enable this to wrap long data entries within quotes in your CSV, ensuring proper data handling in different applications.
• UTF-8 BOM: This option adds a Byte Order Mark (BOM) to your CSV file, indicating the character encoding (UTF-8) and preventing potential display issues across different systems.
• Content-Length Header: Disabling this can be helpful if you’re encountering download issues with the “Download CSV” or “Download XML” buttons. Experiment to see if it resolves the problem.
• User Capability: Control who can access the export functionality. By default, only administrators (“manage_options”) can export. You can adjust this to “manage_woocommerce” which grants access to shop managers as well.
• Timepicker: Enable this to add a timepicker function to the “Custom” range option within the date filter, allowing for more precise date selections.

Secondary Separators #

These options allow you to define alternative characters used to separate specific data within certain export sections #

• Orders: Separate product input fields, backend order notes, and order items data using a secondary separator (default: “/”).
• Customers: Separate user roles within the “User Roles” column (default: “/”).
• Products: Separate data points within columns like “Stock Quantity”, “Price”, and “Variation Attributes” (default: “/”).

Advanced Options #

• Block Size: For very large data sets, this option allows you to adjust the amount of data processed at once during the export, potentially improving performance.
• Time Limit: Set a maximum execution time for the export process to prevent timeouts on your server with massive data volumes.
• Ajax Download: (Currently for Product CSV only) This option enables using AJAX for downloading large product CSV files, potentially improving download speed and avoiding server timeouts.

Export Products Options #

• Customization: Move desired fields between the left (available) and right (selected) tables using drag-and-drop. Save your changes before previewing or exporting.
• Extensive Product Fields: Export a wide range of product details including ID, name, SKU, stock data, prices, type, attributes, image URLs, descriptions, status, tax information, dimensions, and more.

Additional Product Export Options #

• Export Product Attribute: Choose specific product attributes (e.g., brand, color) to include in your export.
• Export Product Meta Fields: Export custom product metadata fields you’ve created.

Export Products Filter Options #

• Date Filter: Set the date range for the product data you want to export, with various predefined options like “Last Month”, “Yesterday”, “Custom Date Range”, etc.
• Download File Type: Choose between exporting your data as a CSV (comma-separated values) or XML file format.