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.