At present, when exporting transactions from a stores FoxyCart transaction, you're limited to the transactions on the current page of results. If you're trying to export more than 300 transactions at a time, that means you have to export each page of results, which can be quite time-consuming. It's possible to export transactions using the API, but not everyone is comfortable setting up a script to do that.
This script will allow you to export any number of transactions required, as a single file.
$extra_custom_fields_columns
array value if you want to include custom fields in a column$extra_product_options_columns
array value if you want to include product options in a column$include_subscription_columns
variable to true
if you want to include subscription parametersWhen you load up the tool, you'll see a form to specify your store domain, passphrase and the filters you'd like to apply to this export. After submitting the form, a dialog will appear which will give you an update of how the export is going, including a rough timeframe of how much longer the export will take. It should also error nicely and display any errors to you within that dialog.
Once the export is complete, a button will appear to download the file, once clicked and the download has completed, another button will appear to delete the existing file. This is a safety precaution to help prevent whole exports of customers data from sitting on your server where you may forget about it. Make sure you click that button to delete the file from your server once you've downloaded it.
The security of this script and the exported customers data is up to you. Please note the risks involved with having full exports of customers data on your server and proceed accordingly.