---- dataentry integration ---- type : integration # do not change this line supports-foxycart-version-from : 0.7.0 # Minimum required FoxyCart version for this to work supports-foxycart-version-to : # Last FoxyCart version that supports this (leave empty if unknown) systems : FoxyCart # the system(s) that the integration is for, separated with commas if more than one name : Bulk Transactions Exporter # the name of the integration description : Export your transactions in bulk as a single file rather than page by page as required currently in the FoxyCart administration tags : transactions, reports, export # tags, separated by commas. don't include the "system" here. date_dt : 2012-11-20 # the date in YYYY-MM-DD format version : 1.8 # if you have a version for your code, enter it here developer_url : http://www.foxycart.com # if you'd like a link back to your site, stick it here ---- ====== Bulk Transactions Exporter ====== ===== Description ===== {{ :integration:foxycart:bulktransactionsexport.jpg?nolink&300|}}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. ===== Installation ===== - Download the .zip file below - Extract the contents, and edit settings.php - Add your stores API Key (as found in the advanced page of your stores FoxyCart Administration) - Set a custom passphrase - Set the folder that exports will be added to - Edit the ''$extra_custom_fields_columns'' array value if you want to include custom fields in a column - Edit the ''$extra_product_options_columns'' array value if you want to include product options in a column - Set the ''$include_subscription_columns'' variable to ''true'' if you want to include subscription parameters - Upload the extracted files and folders to your server, to a folder that is not linked to publicly, and create the folder that you specified in settings.php inside that structure - Navigate to where you uploaded the files in a browser, and follow the prompts ===== Requirements ===== * FoxyCart version 0.7.0+ * PHP * Curl (PHP Library) ===== Notes ===== When 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. ===== Code ===== * {{:integration:foxycart:transaction_exporter_1.8.zip|Bulk Transactions Exporter, v1.8}} * {{:integration:foxycart:transaction_exporter_1.7.zip|Bulk Transactions Exporter, v1.7}} * {{:integration:foxycart:transaction_exporter_1.6.zip|Bulk Transactions Exporter, v1.6}} * {{:integration:foxycart:transaction_exporter_1.5.zip|Bulk Transactions Exporter, v1.5}} * {{:integration:foxycart:transaction_exporter_1.4.zip|Bulk Transactions Exporter, v1.4}} * {{:integration:foxycart:transaction_exporter_1.3.zip|Bulk Transactions Exporter, v1.3}} * {{:integration:foxycart:transaction_exporter_1.2.zip|Bulk Transactions Exporter, v1.2}} * {{:integration:foxycart:transaction_exporter_1.1.zip|Bulk Transactions Exporter, v1.1}} * {{:integration:foxycart:transaction_exporter_1.0.zip|Bulk Transactions Exporter, v1.0}}