Jack1t Data Flow V2

flowchart LR LL[Line List] --> PANDA[Panda File Generation] DESC[Product Descriptions] --> PANDA IMG[Product Imagery] --> PANDA PANDA --> PRICING[Pricing Input] PRICING --> PROCESS[Processing & Currency Conversion] PROCESS --> CHECK{Break-Even Check} CHECK --> OUTPUT[Generate CSV Files] CHECK --> FLAG[Flag for Review] FLAG --> OUTPUT OUTPUT --> ZAL[Zalando CSV] OUTPUT --> AY[About You CSV] OUTPUT --> SHOP[Shopify CSVs] OUTPUT --> R360[Refined 360 CSV] style PANDA fill:#e6fffa style PRICING fill:#faf5ff style PROCESS fill:#f0fff4 style OUTPUT fill:#fff5f5

flowchart LR subgraph CSV_FILES["GENERATED FILES"] ZAL[Zalando CSV
15 territories] AY[About You CSV
6 territories] PANDA[Full Panda File
194 columns] SHOP_UK[Shopify UK CSV] SHOP_EU[Shopify EU CSV] SHOP_US[Shopify US CSV] R360[R360 CSV] end subgraph DATA_PLATFORMS["🖥️ DATA PLATFORMS"] TB[Tradebyte] SHOPIFY[Shopify Admin] REFINED[Refined 360] ZDIRECT[ZDirect
for Zalando] SCALE[Scale
for About You] end subgraph SALES_PLATFORMS["🛒 SALES PLATFORMS"] ZALANDO[Zalando
15 EU Markets] ABOUTYOU[About You
6 EU Markets] J1T_UK[jack1t.com
UK Site] J1T_EU[jack1t.eu
EU Site] US_DTC[US DTC
Shopify US] MACYS[Macy's] NORD[Nordstrom] end subgraph WAREHOUSES["📦 PHYSICAL STOCK"] UK_WH[UK Warehouse
Whistl] EU_WH[EU Warehouse
ZEOS] US_WH[US Warehouse
Refined] end %% File to platform routing ZAL --> TB AY --> TB PANDA --> TB TB --> ZDIRECT --> ZALANDO TB --> SCALE --> ABOUTYOU TB --> J1T_EU SHOP_UK --> SHOPIFY --> J1T_UK SHOP_EU --> SHOPIFY --> J1T_EU SHOP_US --> SHOPIFY --> US_DTC R360 --> REFINED --> MACYS & NORD SHOP_US --> REFINED %% Warehouse fulfillment J1T_UK --> UK_WH ZALANDO --> EU_WH ABOUTYOU --> EU_WH J1T_EU --> EU_WH US_DTC --> US_WH MACYS --> US_WH NORD --> US_WH style CSV_FILES fill:#fff5f5,stroke:#c53030 style DATA_PLATFORMS fill:#e6f3ff,stroke:#2c5282 style SALES_PLATFORMS fill:#f0fff4,stroke:#276749 style WAREHOUSES fill:#faf5ff,stroke:#805ad5

flowchart TB subgraph INPUT["Pricing Input"] EUR_PRICE[EUR Base Price] end subgraph ZALANDO_TERRITORIES["Zalando 15 Territories"] subgraph EUR_ZONE["EUR Zone (8)"] ZAFD[zafd - Germany] ZAFF[zaff - France] ZAFA[zafa - Austria] ZAFB[zafb - Belgium] ZAFN[zafn - Netherlands] ZAFE[zafe - Spain] ZAZI[zazi - Italy] ZAFH[zafh - ???] ZAZFSFI[zazfsfi - Finland] end subgraph OTHER_CCY["Other Currencies (6)"] ZAZFSCF[zazfscf - Switzerland FR
CHF] ZAZFSCD[zazfscd - Switzerland DE
CHF] ZAZFSPL[zazfspl - Poland
PLN] ZAZFSSE[zazfsse - Sweden
SEK] ZAZFSDK[zazfsdk - Denmark
DKK] ZAZFSCZ[zazfscz - Czech
CZK] end end subgraph ABOUTYOU_TERRITORIES["About You 6 Territories"] AYDE[ayde - Germany
EUR] AYAT[ayat - Austria
EUR] AYFR[ayfr - France
EUR] AYNL[aynl - Netherlands
EUR] AYBE[aybe - Belgium
EUR] AYIT[ayit - Italy
EUR] end EUR_PRICE --> EUR_ZONE EUR_PRICE --> OTHER_CCY EUR_PRICE --> ABOUTYOU_TERRITORIES style INPUT fill:#faf5ff,stroke:#805ad5 style ZALANDO_TERRITORIES fill:#fff5f5,stroke:#c53030 style EUR_ZONE fill:#f0fff4,stroke:#276749 style OTHER_CCY fill:#fffaf0,stroke:#c05621 style ABOUTYOU_TERRITORIES fill:#e6f3ff,stroke:#2c5282

flowchart LR subgraph LINE_LIST["LINE LIST Source"] LL_OPT[OPTION CODE] LL_SKU[SKU CODE] LL_EAN[EAN] LL_DESC[ITEM DESCRIPTION] LL_COL[COLOUR] LL_ZAL_COL[ZALANDO COLOUR] LL_HS[HS CODE] LL_GENDER[M/W Gender] LL_SEASON[DELIVERY SEASON] LL_PRICE[GBP RRP] LL_FABRIC[SHELL/LINING/FILL] end subgraph PANDA_FILE["📄 PANDA FILE (194 Columns)"] subgraph PRODUCT["Product Level (~40 cols)"] P_NR[p_nr] P_NAME[p_name_proper EN+DE] P_TEXT[p_text EN+DE] P_BULLET[p_bullet 0-7 EN+DE] P_BRAND[p_brand] P_COMP[p_comp × 30 fields] P_TAG[p_tag × 5 fields] end subgraph ARTICLE["Article/SKU Level (~30 cols)"] A_NR[a_nr] A_EAN[a_ean] A_COMP_COL[a_comp color] A_COMP_SIZE[a_comp size] A_INTRASTAT[a_intrastat] end subgraph MEDIA["Media (~40 cols)"] A_FRONT[a_media Frontview] A_BACK[a_media Backview] A_DETAIL[a_media Details 0-14] A_AY[a_media aboutyou 1-8] end subgraph PRICING["Pricing (~60 cols)"] A_VK_ZAL[a_vk zafd...zazfscz × 15] A_VK_OLD[a_vk_old × 15] A_VK_AY[a_vk ayde...ayit × 6] A_VK_OLD_AY[a_vk_old AY × 6] end subgraph FLAGS["Activation (~20 cols)"] A_ACTIVE[a_active] A_ACTIVE_T[a_active territory × 17] end end %% Mappings LL_OPT --> P_NR LL_SKU --> A_NR LL_EAN --> A_EAN LL_DESC --> P_NAME LL_COL --> A_COMP_COL LL_ZAL_COL --> A_COMP_COL LL_HS --> A_INTRASTAT LL_GENDER --> P_TAG LL_SEASON --> P_TAG LL_PRICE --> PRICING LL_FABRIC --> P_COMP style LINE_LIST fill:#e6f3ff,stroke:#2c5282 style PANDA_FILE fill:#f0fff4,stroke:#276749 style PRODUCT fill:#faf5ff,stroke:#805ad5 style ARTICLE fill:#fffaf0,stroke:#c05621 style MEDIA fill:#fff5f5,stroke:#c53030 style PRICING fill:#e6fffa,stroke:#319795 style FLAGS fill:#f7fafc,stroke:#4a5568

flowchart LR subgraph TBI_FLOW["TBI Wholesale - Separate from DTC"] TBI_WH[TBI Warehouse] POWERBI[Power BI
TBI Reporting] ZAL_TBI[Zalando
Sold & Dispatched by TBI] end TBI_WH --> ZAL_TBI TBI_WH --> POWERBI style TBI_FLOW fill:#f7fafc,stroke:#4a5568

flowchart TB SALE_PRICE[Sale Price per Territory] subgraph COSTS["Cost Components"] FOB[FOB Cost] LANDED[Landed Cost] SHIP[Shipping Cost] COMM[Platform Commission] TARIFF[Tariffs
US Only] end CALC[Calculate Break-Even
= FOB + Landed + Ship + Comm + Tariff] CHECK{Sale Price
Greater Than Break-Even?} OK[Proceed to Generate] FLAG[Flag for Review] OVERRIDE{Manual
Override?} PROCEED[Proceed with Warning] BLOCK[Block Generation] SALE_PRICE --> CHECK COSTS --> CALC CALC --> CHECK CHECK --> OK CHECK --> FLAG FLAG --> OVERRIDE OVERRIDE --> PROCEED OVERRIDE --> BLOCK style COSTS fill:#fffaf0,stroke:#c05621 style OK fill:#f0fff4,stroke:#276749 style FLAG fill:#fff5f5,stroke:#c53030