📊 Daily Excel Upload (Full Refresh)

Loading...

⚠️ Wipe & Replace Strategy: Excel = Ground Truth | Images Preserved

🏢 Multi-Company Upload (4 Files - MS + NSM)

Upload all 4 Excel files for both companies in one batch

⚡ New Workflow: Uploads → Lambda 0 (Combine) → Lambda 1 (FG) + Lambda 3 (GW) → Database
Processes MS and NSM data separately with ManufacturerName column

Click to select MS RM file

Click to select MS Itemised file

Click to select NSM RM file

Click to select NSM Itemised file

Legacy 2-File Upload (Single Company)

Use this for old workflow without manufacturer separation

📋 Raw FG Sheet (Finished Goods Inventory)

Upload the daily raw FG Excel file (complex multi-column format)

⚡ Full Replacement: Deletes ALL existing data in JewelLibrary → Inserts ALL jewels from Excel
Contains: Item Codes, Batches, Shapes, Colors, Quality, Sizes, Weights (granular component details)

Click to Select File or Drag & Drop

Accepts: .xlsx files only (Max 50MB)

⚖️ Gross Weight Sheet

Upload the gross weight Excel file (2 columns: Jewel Code, Gross Wt)

🔄 Smart Update (UPSERT): Updates weights from Excel → Image mappings PRESERVED
Contains: Jewel Code, Gross Weight (physically measured total weight per jewel)

Click to Select File or Drag & Drop

Accepts: .xlsx files only (Max 50MB)