type:
integration
supports-foxycart-version-from:
0.7.0
system:
FoxyCart
name:
Bulk Transactions Exporter
description:
Export your transactions in bulk as a single file rather than page by page as required currently in the FoxyCart administration
tag:
transactions, reports, export
date:
2012-11-20
version:
1.4
developer:
http://www.foxycart.com

Bulk Transactions Exporter

Description

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

  1. Download the .zip file below
  2. Extract the contents, and edit settings.php
    1. Add your stores API Key (as found in the advanced page of your stores FoxyCart Administration)
    2. Set a custom passphrase
    3. Set the folder that exports will be added to
    4. Edit the $extra_custom_fields_columns array value if you want to include custom fields in a column
    5. Edit the $extra_product_options_columns array value if you want to include product options in a column
    6. Set the $include_subscription_columns variable to true if you want to include subscription parameters
  3. 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
  4. 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

Site Tools