Shopify Multi-Store Inventory Dashboard + Competitor Price Monitoring Tool (AU + UAE)

We operate Shopify stores in two regions:

-Australia -5 shopify stores  
-UAE - 2 shopify stores  

We need one integrated or tightly connected solution that covers two related needs:

1. Inventory Visibility & Reallocation (shared 3PL stock within each region)  
2. Competitor Price Monitoring (with RRP + selling price, alerts, and suggested adjustments)

1. Inventory Management Scope

Current situation  
We manually allocate quantities of shared stock across stores. When one store sells faster, we reduce quantity on slower stores and increase it on the faster-selling store. This is messy and makes it difficult to see total allocated stock, low-stock products, slow sellers, and when to reorder.

Key requirements
- Central dashboard showing, per SKU/barcode:
  - Current quantity allocated on each store
  - Total allocated across stores in that region
  - Recent sales velocity per store (7 / 14 / 30 days)
  - Clear flags for products that are low on stock AND where sales are slow
- Easy way to reallocate stock between stores (reduce on one → increase on another)
- Better visibility to support reordering decisions

Important constraints & structure
- 3PL only provides Goods Received Notes (GRN). There is no live inventory feed or portal**.
- Inventory is managed by location/warehouse logic:
  - Shared products (can be allocated across multiple stores in the same region)
  - Non-shared products (assigned to one store only)
  - Dropshipping products → ignore (suppliers manage their own inventory and emails us when out of stock)
- Australia and UAE are separate pools (no stock sharing between regions).
- Same barcodes and product titles are used within each region.
- Scale:
  - Australia: currently ~3,400 SKUs → design for 4,000 products
  - UAE: currently ~700 SKUs → design for 2,000 products

2. Competitor Price Monitoring Scope

Current situation  
We currently use Google Merchant Center pricing insights (not very useful) and a custom tool built (not great) by an outgoing partner that covers only 5 Australian competitors.

Requirements
- Monitor competitor RRP and selling price so we can see true price positioning
- Highlight price gaps vs our prices
- Alerts when competitors drop their price
- Suggested price adjustments
- Weekly price refresh

Competitor coverage
- Australia 10 competitors due to a mix of products between Australian, Korean and other International brands
- UAE: 6 competitors due to a mix of products from hair, local beauty and international beauty brands  

We will provide the competitor list. Any sites that block price reading should be flagged (do not guess or force).

What We Expect From Your Proposal

When bidding, please:

1. Confirm your understanding of the full scope (Inventory + Pricing for both AU and UAE).
2. Ask any clarification questions you need.
3. Clearly state the solution/approach you propose (tools, architecture, how data will be pulled and displayed).
4. Provide:
   - Fixed price (or clear pricing structure)
   - Timeline
   - Any ongoing costs (hosting, apps, maintenance, API usage, etc.)
5. Confirm the solution can handle the stated scale (4,000 AU + 2,000 UAE products).

We are open to different technical approaches (lightweight combinations of existing tools, custom dashboards, or hybrid solutions) as long as the result is simple for a small admin team to use and cost-effective.

Goal 
Reduce messy manual work, give clear weekly visibility for stock reallocation and reordering, and give reliable competitor price intelligence (RRP + selling price) with alerts and suggested adjustments for both Australia and UAE.