Power BI-style analysis using live Stock Control database
Weekly current period vs same period last year
Qty sold mix from live categories
Stores with store_filter = 1 only; zero-sales stores are retained
Qty sold, inventory, stock-turn and contribution
| Category | Description | Qty Sold | Current Inv | Stock Turn | Contribution |
|---|
Beginning + Delivery − Sales − Pullout
Uses complete size master and actual sold quantities
| Size | Qty Sold | Contribution |
|---|
| Size | Qty Sold | Contribution |
|---|
Sales joined to merchandise, category and size masters
| SKU | Description | Style | Category | Color | Size | Qty Sold | Share |
|---|
Only stores with store_filter = 1, including zero-sales stores in the selected period
| Store ID | Store Name | Store No. | Qty Sold | Contribution |
|---|---|---|---|---|
| 86 | ARROW AYALA CEBU | 0034 | 0 | 0.0% |
| 95 | ARROW GREENHILLS MALL | 0084 | 0 | 0.0% |
| 90 | ARROW LUCKY CHINATOWN | 0070 | 0 | 0.0% |
| 78 | ARROW PODIUM | 0005 | 0 | 0.0% |
| 94 | ARROW ROBINSONS PLACE MANILA | 0080 | 0 | 0.0% |
| 88 | ARROW SM CITY CEBU | 0038 | 0 | 0.0% |
| 81 | ARROW SM CITY CLARK | 0023 | 0 | 0.0% |
| 89 | ARROW SM CITY ILOILO | 0069 | 0 | 0.0% |
| 91 | ARROW SM CITY LANANG | 0072 | 0 | 0.0% |
| 84 | ARROW SM CITY LIPA | 0030 | 0 | 0.0% |
| 79 | ARROW SM CITY PAMPANGA | 0006 | 0 | 0.0% |
| 80 | ARROW SM CITY STA. ROSA | 0022 | 0 | 0.0% |
| 82 | ARROW SM MALL OF ASIA | 0025 | 0 | 0.0% |
| 87 | ARROW SM MEGAMALL2 | 0035 | 0 | 0.0% |
| 83 | ARROW SM THE BLOCK | 0027 | 0 | 0.0% |
| 85 | ARROW TRINOMA | 0033 | 0 | 0.0% |
| 4 | CITYSUPER ALABANG INC. - A | 1099 | 0 | 0.0% |
| 6 | CITYSUPER INCORPORATED - MEN (A) | 1002 | 0 | 0.0% |
| 9 | GAISANO ILIGAN - A | 1081 | 0 | 0.0% |
| 10 | KCC MALL DE ZAMBOANGA - A | 1088 | 0 | 0.0% |
| 12 | LANDMARK (MEN) - A | 1032 | 0 | 0.0% |
| 99 | LAZADA PHILIPPINES | 1105 | 0 | 0.0% |
| 13 | METRO ALABANG - A | 1070 | 0 | 0.0% |
| 14 | METRO AYALA - A | 1020 | 0 | 0.0% |
| 15 | METRO MARKET MARKET - A | 1080 | 0 | 0.0% |
| 20 | ROBINSONS ERMITA - A | 1021 | 0 | 0.0% |
| 28 | ROBINSONS MAGNOLIA - A | 1072 | 0 | 0.0% |
| 31 | ROBINSONS TACLOBAN - A | 1112 | 0 | 0.0% |
| 100 | SHOPEE | 1108 | 0 | 0.0% |
| 32 | SM AURA PREMIER - A | 1076 | 0 | 0.0% |
| 33 | SM BACOLOD - A | 1034 | 0 | 0.0% |
| 35 | SM BACOOR - A | 1008 | 0 | 0.0% |
| 36 | SM BAGUIO - A | 1056 | 0 | 0.0% |
| 37 | SM BATANGAS - A | 1093 | 0 | 0.0% |
| 38 | SM BAY CITY MALL OF ASIA - A | 1012 | 0 | 0.0% |
| 40 | SM BUTUAN - A | 1110 | 0 | 0.0% |
| 44 | SM CDO DOWNTOWN PREMIER - A | 1098 | 0 | 0.0% |
| 45 | SM CEBU - A | 1016 | 0 | 0.0% |
| 47 | SM CLARK - A | 1111 | 0 | 0.0% |
| 48 | SM CUBAO - A | 1009 | 0 | 0.0% |
| 50 | SM DASMARINAS - A | 1102 | 0 | 0.0% |
| 51 | SM DAVAO - A | 1017 | 0 | 0.0% |
| 53 | SM ESTANCIA - A | 1104 | 0 | 0.0% |
| 54 | SM FAIRVIEW - A | 1045 | 0 | 0.0% |
| 58 | SM ILOILO - A | 1018 | 0 | 0.0% |
| 60 | SM LANANG PREMIER - A | 1068 | 0 | 0.0% |
| 98 | SM LAOAG - A | 1119 | 0 | 0.0% |
| 61 | SM LEGAZPI - A | 1103 | 0 | 0.0% |
| 62 | SM MAKATI - A | 1011 | 0 | 0.0% |
| 64 | SM MANILA - A | 1058 | 0 | 0.0% |
| 65 | SM MARIKINA - A | 1084 | 0 | 0.0% |
| 66 | SM MEGAMALL - A | 1028 | 0 | 0.0% |
| 68 | SM NORTH EDSA - A | 1014 | 0 | 0.0% |
| 70 | SM PAMPANGA - A | 1046 | 0 | 0.0% |
| 72 | SM SAN LAZARO - A | 1091 | 0 | 0.0% |
| 73 | SM SEASIDE CITY CEBU - A | 1085 | 0 | 0.0% |
| 74 | SM SOUTHMALL - A | 1042 | 0 | 0.0% |
| 76 | SM STA MESA - A | 1057 | 0 | 0.0% |
| 77 | SM STA ROSA - A | 1113 | 0 | 0.0% |