Daily Excel Upload

📋 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)

✅ Upload Complete! (Full Refresh)

🔄 WIPE & REPLACE: All jewel data refreshed from Excel

✅ JewelLibrary: TRUNCATED → Fresh INSERT
✅ JewelTotals: TRUNCATED → Fresh INSERT
✅ GrossWeights: Updated (Images Preserved)

Excel is now the ground truth. Database fully synchronized.

Unique Jewels (JewelLibrary)

0

Total Detail Records: 0

Unique Jewels (JewelTotals)

0

Total Aggregated Records: 0

Unique Jewels (GrossWeights)

0

Total Weight Records: 0

Last Updated: N/A

Ready for next upload!
You can now select and upload more files using the cards above.

📊 Daily Excel Upload (Full Refresh)

📋 Raw FG Sheet (Finished Goods Inventory)

Click to Select File or Drag & Drop

⚖️ Gross Weight Sheet

Click to Select File or Drag & Drop

✅ Upload Complete! (Full Refresh)

🔄 WIPE & REPLACE: All jewel data refreshed from Excel