# Installation and Upgrade Guide

## Installation

### 1. Copy Module to Addons Directory

```bash
# Copy the module to your custom addons directory
cp -r product_lot_sequence_per_product /path/to/odoo/customaddons/
```

### 2. Update Addons List

```bash
# Restart Odoo and update the addons list
odoo-bin -c odoo.conf -d your_database -u all --stop-after-init
```

Or from the Odoo UI:
- Go to Apps
- Click "Update Apps List"
- Search for "Product Lot Sequence Per Product"
- Click Install

### 3. Verify Installation

Check the logs for successful installation:
```
INFO your_database odoo.modules.loading: Module product_lot_sequence_per_product loaded
```

## Upgrading from Previous Version

### Upgrade Steps

1. **Backup your database** before upgrading:
```bash
pg_dump your_database > backup_before_upgrade.sql
```

2. **Update the module files**:
```bash
cp -r product_lot_sequence_per_product /path/to/odoo/customaddons/
```

3. **Upgrade the module**:
```bash
odoo-bin -c odoo.conf -d your_database -u product_lot_sequence_per_product --stop-after-init
```

Or from the Odoo UI:
- Go to Apps
- Remove "Apps" filter
- Search for "Product Lot Sequence Per Product"
- Click Upgrade

### What's New in This Version

#### Performance Optimizations
- **Batch sequence allocation**: Generates multiple lot numbers in a single database query
- **Batch lot creation**: Creates all lots in one operation
- **Smart thresholds**: Automatically uses optimized methods for quantities > 10
- **8-10x speedup** for large batches (500+ units)

#### New Features
- **Auto-generation in inventory adjustments**: Automatically generates lot/serial numbers during physical inventory counts
- **Support for large quantities**: Optimized for 500,000+ units
- **Comprehensive logging**: Better visibility into lot generation operations

#### Technical Improvements
- Added `_allocate_sequence_batch()` method for efficient sequence allocation
- Enhanced `stock.quant` for inventory adjustment auto-generation
- Improved `stock.lot.create()` with product grouping
- Added comprehensive test suites

### Migration Notes

#### No Breaking Changes
This upgrade is **fully backward compatible**. Existing functionality remains unchanged:
- Existing sequences continue to work
- No data migration required
- No configuration changes needed

#### Automatic Optimization
The performance optimizations are **automatically applied**:
- No configuration required
- Transparent to users
- Activates automatically for large quantities

#### New Behavior
The only new behavior is **auto-generation in inventory adjustments**:
- Only applies to products with custom lot sequences configured
- Only for inventory adjustments without existing lots
- Can be disabled by not configuring custom sequences

### Testing After Upgrade

#### 1. Basic Functionality Test

```python
# Test lot generation in receipt
picking = env['stock.picking'].create({...})
move = env['stock.move'].create({...})
# Generate lots and verify they use custom sequence
```

#### 2. Performance Test

```bash
# Run performance tests
odoo-bin -c odoo.conf -d your_database --test-tags product_lot_sequence_per_product.performance
```

#### 3. Inventory Adjustment Test

```python
# Test auto-generation in inventory adjustment
quant = env['stock.quant'].create({
    'product_id': product.id,
    'location_id': location.id,
    'inventory_quantity': 100,
})
quant.action_apply_inventory()
# Verify lots were auto-generated
```

### Rollback Procedure

If you need to rollback:

1. **Restore database backup**:
```bash
psql your_database < backup_before_upgrade.sql
```

2. **Restore old module files**:
```bash
cp -r product_lot_sequence_per_product.old /path/to/odoo/customaddons/product_lot_sequence_per_product
```

3. **Restart Odoo**:
```bash
odoo-bin -c odoo.conf
```

## Configuration

### Setting Up Custom Sequences

1. **Navigate to Product**:
   - Go to Inventory > Products
   - Open a product

2. **Configure Sequence**:
   - Go to Inventory tab
   - Set "Custom Lot/Serial" field (e.g., "SN-" or "LOT-2024-")
   - The system automatically creates a sequence

3. **Verify Configuration**:
   - Check "Next Number" field shows the next lot number
   - Test by creating a receipt or inventory adjustment

### Performance Tuning

For very large operations (> 100,000 units):

1. **Database Configuration** (postgresql.conf):
```ini
work_mem = 256MB
shared_buffers = 2GB
effective_cache_size = 6GB
```

2. **Odoo Configuration** (odoo.conf):
```ini
workers = 4
max_cron_threads = 2
limit_memory_hard = 2684354560
limit_memory_soft = 2147483648
```

3. **Monitor Performance**:
```bash
# Enable detailed logging
odoo-bin -c odoo.conf --log-level=info
```

## Troubleshooting

### Issue: Module Not Appearing in Apps List

**Solution**:
1. Check module is in addons path
2. Update apps list
3. Check logs for errors

### Issue: Slow Performance After Upgrade

**Solution**:
1. Check database statistics are up to date:
```sql
VACUUM ANALYZE stock_lot;
VACUUM ANALYZE ir_sequence;
```

2. Verify PostgreSQL configuration
3. Check for concurrent operations

### Issue: Lots Not Auto-Generating in Inventory Adjustments

**Solution**:
1. Verify product has custom sequence configured
2. Check product tracking is set to 'lot' or 'serial'
3. Ensure inventory adjustment is for positive quantity
4. Check logs for errors

## Support

For issues or questions:
1. Check the logs: `odoo-bin -c odoo.conf --log-level=debug`
2. Review PERFORMANCE_OPTIMIZATION.md for detailed technical information
3. Run test suite to verify functionality
4. Check database configuration and performance

## Version History

### Version 1.1 (Current)
- Added performance optimizations for large batches
- Added auto-generation in inventory adjustments
- Added comprehensive test suites
- Added detailed documentation

### Version 1.0
- Initial release
- Per-product sequence configuration
- Support for receipts and manufacturing orders
- UI enhancements