Spaces:
Sleeping
Sleeping
| title: HTS Review Tool | |
| sdk: streamlit | |
| emoji: 👀 | |
| colorFrom: blue | |
| colorTo: green | |
| # HTS Checker - Tariff Audit Tool | |
| A Streamlit application for auditing HTS (Harmonized Tariff Schedule) codes, validating primary HTS against additional tariffs and description keywords. | |
| ## Features | |
| - **Auto-validation**: Validation runs automatically when file is uploaded | |
| - **17 Scenarios**: Validates Steel, Aluminum, Copper tariff classifications | |
| - **Unique Combinations View**: De-duplicates entries by HTS+Description for efficient review | |
| - **Interactive Filters**: Filter by HTS, description, status, scenario | |
| - **Bulk Export**: Add filtered results to cache and export to Excel | |
| - **HTS Reference**: View all Steel/Aluminum/Copper HTS lists with overlap analysis | |
| - **Editable Keywords**: Customize metal, aluminum, copper, zinc, plastics keyword lists | |
| ## Validation Scenarios | |
| | ID | Description | | |
| |----|-------------| | |
| | S1 | Steel HTS + 232 tariff applied - verify 99030133 present, no 99030125 | | |
| | S2 | Metal keyword but NOT steel HTS - should apply 99030125, no 232 tariffs | | |
| | S4 | Aluminum HTS + 232 tariff applied - verify 99030133 present, no 99030125 | | |
| | S5 | Aluminum keyword but NOT aluminum HTS - should apply 99030125, no 232 tariffs | | |
| | S7 | Dual Steel+Aluminum HTS - matches keyword, apply corresponding 232, no 99030125 | | |
| | S7a | Dual Steel+Aluminum HTS + BOTH keywords - flag for manual review | | |
| | S8 | Dual Steel+Aluminum HTS + NO keywords - flag for manual review | | |
| | S9 | Copper keyword but NOT copper HTS - should apply 99030125, no 232 tariffs | | |
| | S11 | Dual Aluminum+Copper HTS + copper keyword - apply 99030133 + copper tariffs, no 99030125 | | |
| | S12 | Dual Aluminum+Copper HTS + aluminum keyword - apply 99030133 + aluminum 232, no 99030125 | | |
| | S13 | Zinc keyword - should ONLY apply 99030125, no 232 tariffs allowed | | |
| | S14 | Plastics keyword + metal HTS - override, should ONLY apply 99030125 | | |
| | S15 | Steel HTS + aluminum keyword - should apply 99030125, no 99030133 or 232 tariffs | | |
| | S16 | Aluminum HTS + steel keyword - should apply 99030125, no 99030133 or 232 tariffs | | |
| | S17 | Copper HTS but NO copper keyword - should apply copper tariffs + 99030125, no 99030133 | | |
| ## Key Additional HTS Codes | |
| | Code | Type | | |
| |------|------| | |
| | 99038190, 99038191 | Steel Section 232 | | |
| | 99038507, 99038508 | Aluminum Section 232 | | |
| | 99037801, 99037802 | Copper tariffs | | |
| | 99030133 | General 301 (accompanies 232) | | |
| | 99030125 | Mismatch/Override code | | |
| ## Input File Format | |
| Upload Excel file with these columns: | |
| - **Column E (Description)**: Product description for keyword matching | |
| - **Column F (Tariff)**: 10-digit Primary HTS code | |
| - **Columns I-N (Primary 1-6)**: Additional HTS codes applied | |
| ## Default Keywords | |
| **Metal**: steel, stainless steel, carbon steel, iron, metal | |
| **Aluminum**: aluminum, aluminium | |
| **Copper**: copper | |
| **Zinc**: zinc | |
| **Plastics**: plastic, abs, pu, pvc, polyester, nylon | |
| ## Tabs | |
| 1. **Upload & Filter**: Upload Excel file, apply initial filters | |
| 2. **Validation Results**: View all results with interactive filters, add to export cache | |
| 3. **Unique Combinations**: De-duplicated view by HTS+Description with occurrence count | |
| 4. **Keyword Management**: Edit keyword lists used for validation | |
| 5. **Export Selection**: Manage export cache and download Excel reports | |
| 6. **HTS Reference**: View Steel/Aluminum/Copper HTS lists and overlaps | |
| ## Password Protection | |
| The app requires password authentication. Configure it using one of these methods: | |
| ### For Hugging Face Spaces | |
| 1. Go to your Space's **Settings** > **Repository secrets** | |
| 2. Add a secret named `APP_PASSWORD` with your password value | |
| 3. The app will automatically use this for authentication | |
| ### For Local Development | |
| Set the environment variable before running: | |
| ```bash | |
| # Windows | |
| set HTS_CHECKER_PASSWORD=your_password_here | |
| streamlit run app.py | |
| # Linux/Mac | |
| export HTS_CHECKER_PASSWORD=your_password_here | |
| streamlit run app.py | |
| ``` | |
| Or create a `.streamlit/secrets.toml` file: | |
| ```toml | |
| APP_PASSWORD = "your_password_here" | |
| ``` | |
| **Note**: If no password is configured, the app runs without authentication (for development). | |
| ## Local Development | |
| ```bash | |
| cd HTS_Checker | |
| pip install -r requirements.txt | |
| streamlit run app.py | |
| ``` | |
| ## Hugging Face Deployment | |
| 1. Create a new Space on [Hugging Face](https://huggingface.co/spaces) | |
| 2. Select **Streamlit** as the SDK | |
| 3. Upload these files: | |
| - `app.py` | |
| - `hts_validator.py` | |
| - `HTS_list.py` | |
| - `requirements.txt` | |
| 4. Go to **Settings** > **Repository secrets** and add `APP_PASSWORD` | |
| 5. The app will auto-deploy with password protection | |
| ## Files | |
| | File | Description | | |
| |------|-------------| | |
| | `app.py` | Streamlit UI application | | |
| | `hts_validator.py` | Core validation logic | | |
| | `HTS_list.py` | Steel, Aluminum, Copper HTS code lists | | |
| | `requirements.txt` | Python dependencies | | |
| ## Requirements | |
| - streamlit | |
| - pandas | |
| - openpyxl | |