PHPackages                             boukjijtarik/woo-sales - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [API Development](/categories/api)
4. /
5. boukjijtarik/woo-sales

ActiveLibrary[API Development](/categories/api)

boukjijtarik/woo-sales
======================

WooCommerce Sales Report Package for Laravel 12

04PHP

Since Jun 28Pushed 1y agoCompare

[ Source](https://github.com/djeytkey/WooCommerce-sales-Laravel)[ Packagist](https://packagist.org/packages/boukjijtarik/woo-sales)[ RSS](/packages/boukjijtarik-woo-sales/feed)WikiDiscussions main Synced today

READMEChangelogDependenciesVersions (1)Used By (0)

WooCommerce Sales Report Package for Laravel 12
===============================================

[](#woocommerce-sales-report-package-for-laravel-12)

A Laravel 12 package that integrates directly with a WordPress WooCommerce MySQL database to fetch, display, and export order details using Eloquent ORM.

Features
--------

[](#features)

- **Direct Database Integration**: Connects directly to WooCommerce MySQL database using Eloquent
- **Advanced Filtering**: Filter by date range, order ID, and order status
- **DataTable Display**: Paginated DataTable with search and sorting capabilities
- **Smart Export System**:
    - Client-side export for datasets ≤ 1500 items
    - Server-side export for datasets > 1500 items using Laravel Excel
- **Performance Optimized**: Efficient queries with proper indexing support
- **Modern UI**: Bootstrap 5 with DataTables and Flatpickr date picker

Requirements
------------

[](#requirements)

- PHP 8.1+
- Laravel 12.0+
- MySQL/MariaDB (WooCommerce database)
- Composer

Installation
------------

[](#installation)

1. **Install the package via Composer:**

```
composer require boukjijtarik/woo-sales
```

2. **Publish the configuration file:**

```
php artisan vendor:publish --tag=wooSales-config
```

3. **Publish the views (optional):**

```
php artisan vendor:publish --tag=wooSales-views
```

Configuration
-------------

[](#configuration)

### 1. Database Connection

[](#1-database-connection)

Add a new database connection in your `config/database.php` file:

```
'connections' => [
    // ... other connections

    'woocommerce' => [
        'driver' => 'mysql',
        'host' => env('WOOCOMMERCE_DB_HOST', '127.0.0.1'),
        'port' => env('WOOCOMMERCE_DB_PORT', '3306'),
        'database' => env('WOOCOMMERCE_DB_DATABASE', 'wordpress'),
        'username' => env('WOOCOMMERCE_DB_USERNAME', 'root'),
        'password' => env('WOOCOMMERCE_DB_PASSWORD', ''),
        'unix_socket' => env('WOOCOMMERCE_DB_SOCKET', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'prefix_indexes' => true,
        'strict' => true,
        'engine' => null,
        'options' => extension_loaded('pdo_mysql') ? array_filter([
            PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
        ]) : [],
    ],
],
```

### 2. Environment Variables

[](#2-environment-variables)

Add these variables to your `.env` file:

Package Configuration
=====================

[](#package-configuration)

MAX\_CLIENT\_EXPORT=1500 ITEMS\_PER\_PAGE=25

```

### 3. Package Configuration

The package configuration file (`config/wooSales.php`) contains:

- `database_connection`: The database connection name to use
- `max_client_export`: Maximum items for client-side export (default: 1500)
- `table_prefix`: WordPress table prefix (default: 'wp_')
- `items_per_page`: Number of items per page in DataTable (default: 25)

## Usage

### Access the Orders Page

Once installed and configured, you can access the WooCommerce orders page at:

```

/woo-orders

```

### Available Routes

- `GET /woo-orders` - Display the orders page
- `GET /woo-orders/data` - Get orders data for DataTable (AJAX)
- `POST /woo-orders/export` - Export orders to Excel

### Features

#### 1. Filtering

- **Date Range**: Filter orders by creation date
- **Order ID**: Search for specific order IDs
- **Order Status**: Multi-select filter for order statuses (completed, processing, etc.)

#### 2. Data Display

The DataTable shows:
- Order ID
- Product Name
- Line Quantity
- Line Subtotal
- Line Discount
- Order Date
- Order Status

#### 3. Export Options

- **Small Datasets (≤1500 items)**: Client-side export using DataTables
- **Large Datasets (>1500 items)**: Server-side export using Laravel Excel

## Database Schema

The package works with the following WooCommerce tables:

- `wp_posts` - Orders and products
- `wp_woocommerce_order_items` - Order line items
- `wp_woocommerce_order_itemmeta` - Order item metadata
- `wp_postmeta` - Order and product metadata

## Models

The package includes these Eloquent models:

- `WooOrder` - Maps to `wp_posts` (shop orders)
- `WooOrderItem` - Maps to `wp_woocommerce_order_items`
- `WooOrderItemMeta` - Maps to `wp_woocommerce_order_itemmeta`
- `WooPostMeta` - Maps to `wp_postmeta`
- `WooProduct` - Maps to `wp_posts` (products)

## Performance Considerations

1. **Database Indexing**: Ensure proper indexes on:
   - `wp_posts.ID` and `wp_posts.post_type`
   - `wp_posts.post_date`
   - `wp_posts.post_status`
   - `wp_woocommerce_order_items.order_id`

2. **Query Optimization**: The package uses eager loading and optimized queries to minimize database load.

3. **Export Performance**: Large exports are handled server-side to prevent browser memory issues.

## Security

- All inputs are sanitized and validated
- Uses Laravel's built-in CSRF protection
- Database queries use parameterized statements
- Proper database user permissions are required

## Customization

### Customizing Views

If you've published the views, you can customize them in `resources/views/vendor/wooSales/`.

### Customizing Export

You can extend the `WooOrdersExport` class to customize the export format and styling.

### Adding Custom Filters

Extend the `WooOrdersController` to add custom filtering logic.

## Troubleshooting

### Common Issues

1. **Database Connection Error**
   - Verify your WooCommerce database credentials
   - Ensure the database user has read permissions
   - Check if the table prefix is correct

2. **No Data Displayed**
   - Verify that WooCommerce orders exist in the database
   - Check if the table prefix matches your WordPress installation
   - Ensure the database connection is working

3. **Export Not Working**
   - Check if Laravel Excel is properly installed
   - Verify file permissions for temporary storage
   - Check browser console for JavaScript errors

### Debug Mode

Enable Laravel's debug mode to see detailed error messages:

```env
APP_DEBUG=true

```

Contributing
------------

[](#contributing)

1. Fork the repository
2. Create a feature branch
3. Make your changes
4. Add tests
5. Submit a pull request

License
-------

[](#license)

This package is open-sourced software licensed under the [MIT license](https://opensource.org/licenses/MIT).

Support
-------

[](#support)

For support, please open an issue on the GitHub repository or contact the maintainer.

Changelog
---------

[](#changelog)

### Version 1.0.0

[](#version-100)

- Initial release
- Basic order data retrieval and display
- Filtering and export functionality
- DataTable integration
- Laravel Excel integration for large exports

###  Health Score

15

—

LowBetter than 3% of packages

Maintenance36

Infrequent updates — may be unmaintained

Popularity3

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity15

Early-stage or recently created project

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/23666990?v=4)[Tarik BOUKJIJ](/maintainers/djeytkey)[@djeytkey](https://github.com/djeytkey)

---

Top Contributors

[![djeytkey](https://avatars.githubusercontent.com/u/23666990?v=4)](https://github.com/djeytkey "djeytkey (6 commits)")

### Embed Badge

![Health badge](/badges/boukjijtarik-woo-sales/health.svg)

```
[![Health](https://phpackages.com/badges/boukjijtarik-woo-sales/health.svg)](https://phpackages.com/packages/boukjijtarik-woo-sales)
```

###  Alternatives

[exsyst/swagger

A php library to manipulate Swagger specifications

35916.4M7](/packages/exsyst-swagger)[hubspot/api-client

Hubspot API client

24016.2M20](/packages/hubspot-api-client)[pocketmine/bedrock-protocol

An implementation of the Minecraft: Bedrock Edition protocol in PHP

172445.0k15](/packages/pocketmine-bedrock-protocol)[botman/driver-telegram

Telegram driver for BotMan

93459.5k6](/packages/botman-driver-telegram)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)