Amazon SP-API Integration for Green Mobile

Challenges

• •

  Manual Shipment Tracking: The client relied on Google Sheets to manage Amazon shipments and inventory, which was inefficient and error-prone.

• •

  IMEI Entry Errors: The warehouse team occasionally entered incorrect IMEI numbers during the inward process, leading to discrepancies and extra workload.

• •

  Discrepancy Resolution Delays: Identifying and rectifying shipment issues manually slowed down the Amazon Case creation process.

• •

  Lack of Real-Time Tracking: Without real-time courier integration, the team couldn’t monitor delivery status efficiently.

• •

  Disconnected Systems: Shipment data had to be manually updated across multiple systems including ERP, leading to redundant effort and inconsistencies.

Tools & Technologies

Solution

• •

  Amazon SP-API Integration: Automated retrieval of shipment and tracking data directly from Amazon, eliminating manual entry.

• •

  Courier Aggregator Integration: Enabled real-time shipment tracking from multiple courier partners.

• •

  IMEI Scanning Inward Screen: Introduced a dedicated UI for accurate scanning and recording of items received.

• •

  Automated Case Management: System flagged shipment discrepancies and enabled direct Amazon Case generation to resolve issues quickly.

• •

  ERP & Google Sheets Sync: Integrated with Microsoft Dynamics and Google Sheets for seamless data flow and reconciliation.

• •

  Google SSO & RBAC: Implemented secure access with Google OAuth and role-based permissions for unlimited users.