Invoice to CSV Export for Prestashop

# Invoice to CSV Export Module

Streamline your financial management and eliminate the tedious task of manual data entry with the Invoice to CSV Export module for PrestaShop. Designed for busy store owners, accountants, and data analysts, this powerful tool automates the process of extracting crucial financial data from your store. Forget spending hours copying details from individual invoices; this module allows you to effortlessly export all your invoices and credit notes into a clean, universally compatible CSV or Excel file with just a few clicks.

This extension is more than just an exporter; it's a complete data management solution. Gain full control over your financial reporting by utilizing customizable field selections and advanced filtering capabilities. Whether you need a detailed sales report for a specific quarter, a list of paid invoices for your accountant, or a data set for analysis in external software, you can tailor the export to your exact needs. By bridging the gap between your PrestaShop store and your accounting software (like QuickBooks, Xero, or Sage), this module saves you invaluable time, significantly reduces the risk of human error, and empowers you to make smarter, data-driven decisions for your business.

## 🚀 Features

### Core Functionality

- **Export invoices and credit notes** to CSV format

- **Customizable field selection** - Choose which data to export

- **Advanced filtering options** - Filter by date range, order status, and document type

- **Product information export** - Include product lists and SKUs

- **Multi-language support** - Fully translatable interface

- **Professional UI** - Clean, responsive admin interface

### Export Fields Available

- Document type (Invoice/Credit Note)

- Document number

- Order ID and reference

- Order and invoice dates

- Customer information (name, email)

- Billing and delivery addresses

- Financial data (totals, taxes, shipping costs)

- Payment method and order status

- Currency information

- Product lists with SKUs

- And more...

### Filtering Options

- **Date Range**: Export invoices from specific date periods

- **Order Status**: Filter by order status (paid, pending, etc.)

- **Document Type**: Choose between invoices only, credit notes only, or all documents

## 📋 Requirements

- **PrestaShop**: 1.7.0.0 or higher (up to 9.0.x)

- **PHP**: 7.1 or higher

- **MySQL**: 5.6 or higher

## 🔧 Installation

### Method 1: Manual Installation

1. Download the module files

2. Upload the `invoicetocsv` folder to your PrestaShop `/modules/` directory

3. Go to **Modules → Module Manager** in your PrestaShop admin

4. Search for "Invoice to CSV Export"

5. Click **Install**

### Method 2: ZIP Upload

1. Create a ZIP file containing all module files

2. Go to **Modules → Module Manager** in your PrestaShop admin

3. Click **Upload a module**

4. Select the ZIP file and upload

5. Click **Install**

## 🎯 Usage

### Accessing the Module

After installation, you can access the module in two ways:

1. **Direct Menu Access** (Recommended):

  - Go to **Advanced Parameters → Invoice to CSV** in the left sidebar

2. **Module Configuration**:

  - Go to **Modules → Module Manager**

  - Search for "Invoice to CSV Export"

  - Click **Configure**

### Configuring Export Fields

1. In the module configuration page, you'll see the **Field Selection** section

2. Toggle the switches to enable/disable specific fields for export

3. Click **Save Settings** to store your preferences

### Exporting Data

1. Scroll down to the **Export Invoices** section

2. Set your filtering criteria:

  - **Date From/To**: Leave empty to export all dates

  - **Order Status**: Select specific status or "All statuses"

  - **Document Type**: Choose invoices, credit notes, or all documents

3. Click **Export to CSV**

4. The CSV file will be automatically downloaded

## 📊 Export Fields Reference

| Field | Description |

|-------|-------------|

| Type | Document type (Invoice/Credit Note) |

| Document Number | Invoice or credit note number |

| Order ID | Internal order identifier |

| Order Reference | Customer-facing order reference |

| Order Date | Date when order was placed |

| Invoice Date | Date when invoice was generated |

| Customer Name | Customer's full name |

| Customer Email | Customer's email address |

| Billing Address | Complete billing address |

| Delivery Address | Complete delivery address |

| Total Excl. Tax | Order total excluding taxes |

| Total Incl. Tax | Order total including taxes |

| Tax Amount | Total tax amount |

| Shipping Cost | Shipping and handling costs |

| Payment Method | Payment method used |

| Order Status | Current order status |

| Currency | Order currency |

| Products List | List of ordered products with SKUs |

| Products SKU | Product SKUs only |

## 🔒 Security Features

- **CSRF Protection** - All forms include security tokens

- **Access Control** - Admin-only access

- **File Security** - All directories protected with index.php files

- **Input Validation** - All user inputs are sanitized

- **SQL Injection Protection** - Uses PrestaShop's DbQuery class

## 🌍 Internationalization

The module is fully translatable. To add a new language:

1. Copy `translations/en.php` to `translations/[language_code].php`

2. Translate all strings in the new file

3. The module will automatically detect and use the new translation

## 🐛 Troubleshooting

### Common Issues

**"Invalid token" error when exporting:**

- Make sure you're accessing the module through the correct menu

- Try refreshing the page and attempting the export again

**No data in export:**

- Check your date range filters

- Ensure you have invoices matching your criteria

- Verify that the selected fields are enabled

**Module not appearing in menu:**

- Uninstall and reinstall the module

- Clear PrestaShop cache

- Check that the module is properly installed

### Debug Mode

Enable PrestaShop debug mode to see detailed error messages:

1. Edit `/config/defines.inc.php`

2. Set `define('_PS_MODE_DEV_', true);`

## 📝 Changelog

### Version 2.0.0

- Complete module rebuild

- Added menu integration

- Enhanced field selection

- Improved product data export

- Added SKU support

- Better error handling

- Responsive design

- Multi-language support

## 👨‍💻 Developer Information

**Author**: Lyreluxe 

**Version**: 2.0.0 

**License**: Academic Free License (AFL 3.0) 

**Compatibility**: PrestaShop 1.7.0.0 - 9.0.x