This project is a REST API built with Laravel, designed to handle product management, including parsing a CSV file, managing product data and exporting HTTP response data to a new CSV file.
- REST API implementation
- CSV file processing and import
- CRUD implementation
- Category-based product filtering
- JSON data export to CSV file
The CSV file for processing must be located in the project's root folder.
To parse the CSV file and store data in the database, run the following Artisan command:
php artisan import:products-csv
For testing API functionalities, use Postman or any API testing tool.
- Base URL:
http://127.0.0.1:8000/api/
- Available Endpoints:
| Method | Endpoint | Description |
|---|---|---|
| GET | /api/products |
Fetch products (general data) |
| GET | /api/products-specific |
Fetch products (product specific data) |
| GET | /api/category-products |
Fetch products by category |
| GET | /api/categories |
Fetch categories |
| PUT | /api/categories/{category} |
Update category name |
| DELETE | /api/categories/{category} |
Delete a category |
| PUT | /api/products/{product} |
Update a product |
| DELETE | /api/products/{product} |
Delete a product |
| POST | /api/category-products |
Generate a CSV of products for a category |
- Few examples of HTTP request parameters are located in routes/api.php as comments above each route definition.
- Implement soft deletion and update migration tables with proper
onDeleteconstraints - Modify
ProductController@updateto allow updating a product's category and manufacturer - Implement rate limiting for API endpoints
This project is open-source and available under the MIT License.