📘 Delay Ship Item Management System Documentation

🧾 Overview

This system manages items with shipping delays greater than 7 days (GT 7 Days). It provides functionality to:

• View and manage delayed ship items.
• Upload delayed item lists from files.
• Download vendor item lists for processing.
• Set estimated delivery weeks (2, 3, 4 weeks, etc.).
• Mark items for delayed shipping or remove them from the delay list.

---

🗂️ Tabs Overview

1. Delay Ship Item List
2. Upload Delay Item List
3. Download Vendor Item List

---

1️⃣ Delay Ship Item List

📄 Description

This section displays all items with lead time > 7 days. Users can manage item delay status, delivery estimate, or delete items from the delay list.

🧩 Features

Field	Description
Item SKU / ID	Unique identifier for the product
Item Name	Name/description of the product
Current Status	Shows if item is marked as delayed (Yes/No)
Estimated Delivery	Dropdown to select 2, 3, 4 weeks, or custom
Action Buttons	Yes, No, Delete, Update

🛠️ Actions

• ✅ Mark as Delayed: Click Yes to confirm delay.
• ❌ Remove from Delay List: Click No.
• 🗑️ Delete Item: Completely remove item.
• 📅 Set Estimated Delivery Weeks: Select from dropdown.
• 💾 Save Changes: Apply updates.

---

2️⃣ Upload Delay Item List

📄 Description

Upload a CSV or Excel file containing delayed items to import them into the system.

🧩 Accepted File Format

Column Name	Description
Item SKU	(Required) Unique product ID
Item Name	Optional
Delay Status	Optional (Yes / No)
Estimated Weeks	Optional (2, 3, 4, etc.)

📤 Instructions

1. Navigate to the Upload Delay Item List tab.
2. Click Choose File and select your .csv or .xlsx file.
3. Click Upload.
4. The system will validate and:
   • Add new items.
   • Update existing items based on SKU.

🔐 Validations

• SKU must not be empty.
• Estimated weeks must be between 1 and 52.
• Invalid rows will be skipped with warnings.

---

3️⃣ Download Vendor Item List

📄 Description

Download a vendor item list, edit it, and re-upload using the "Upload Delay Item List" tab.

📤 File Format

Column	Description
Item SKU	Unique identifier
Item Name	Product description
Vendor	Vendor name or code
Lead Time	In days
Delay Status	Marked Yes if Lead Time > 7
Estimated Weeks	Empty by default

📥 Usage

1. Click Download in the Download Vendor Item List tab.
2. Open in Excel or Google Sheets.
3. Modify fields such as Delay Status and Estimated Weeks.
4. Save and upload via the Upload Delay Item List tab.

---