FBA Replenishment – Setup

App-Umgebung: local

Debug: true

Datenbankstatus

Connection OK

Lege eine .env an (siehe .env.example) und trage DB-Zugangsdaten ein.

SKU-Mapping

Schema aus storage/schema.sql ausführen und dann einen Testeintrag anlegen.

Amazon SKU DreamRobot SKU Segment Saison Has Sub Rare Size Notes
A_4001-35 4001-35 CORE ALLYEAR 1 0 Test
A_4001-36 4001-36 CORE ALLYEAR 1 0 Test
A_4001-37 4001-37 CORE ALLYEAR 1 0 Test
A_4001-38 4001-38 CORE ALLYEAR 1 0 Test
A_4001-39 4001-39 CORE ALLYEAR 1 0 Test
A_4001-40 4001-40 CORE ALLYEAR 1 0 Test
A_4001-41 4001-41 CORE ALLYEAR 1 0 Test
A_4001-42 4001-42 CORE ALLYEAR 1 0 Test
A_4001-43 4001-43 CORE ALLYEAR 1 0 Test
A_4001-44 4001-44 CORE ALLYEAR 1 0 Test
A_4001-45 4001-45 CORE ALLYEAR 1 0 Test
A_4001-46 4001-46 CORE ALLYEAR 1 0 Test
A_4001-47 4001-47 CORE ALLYEAR 1 0 Test
A_4001-48 4001-48 CORE ALLYEAR 1 0 Test
A_4001-49 4001-49 CORE ALLYEAR 1 0 Test
A_4001-50 4001-50 CORE ALLYEAR 1 0 Test

SP-API Report

Report laden | Report neu laden | Live-Report laden

Optional: ?load_report=1&mock_report=/pfad/zum/report.json

Quelle: cache

Cache-Pfad: /www/htdocs/w01f9a20/fba.nawemo.io/storage/cache/spapi_report.json

Report-Ausschnitt
[
    {
        "Country": "DE",
        "Product Name": "Zimtsohlen Nawemo \"Frottee\" (5er Pack), Größe 50",
        "FNSKU": "X000DVBM29",
        "Merchant SKU": "A_40095-50",
        "ASIN": "B00DCOHP04",
        "Condition": "New",
        "Supplier": "--",
        "Supplier part no.": "",
        "Currency code": "EUR",
        "Price": "29.90",
        "Sales last 30 days": "0.0",
        "Units Sold Last 30 Days": "0",
        "Total Units": "0",
        "Inbound": "0",
        "Available": "0",
        "FC transfer": "0",
        "FC Processing": "0",
        "Customer Order": "0",
        "Unfulfillable": "0",
        "Working": "0",
        "Shipped": "0",
        "Receiving": "0",
        "Fulfilled by": "Amazon",
        "Total Days of Supply (including units from open shipments)": "",
        "Days of Supply at Amazon Fulfillment Network": "",
        "Alert": "out_of_stock",
        "Recommended replenishment qty": "",
        "Recommended ship date": "",
        "Unit storage size": "0.0042 m3"
    },
    {
        "Country": "DE",
        "Product Name": "Nawemo Zimtslipper Modern-Brown, Größe 36.5 EU",
        "FNSKU": "X00119Q4FH",
        "Merchant SKU": "A_1061-36-37",
        "ASIN": "B07SFVS9FL",
        "Condition": "New",
        "Supplier": "--",
        "Supplier part no.": "",
        "Currency code": "EUR",
        "Price": "21.80",
        "Sales last 30 days": "0.0",
        "Units Sold Last 30 Days": "0",
        "Total Units": "0",
        "Inbound": "0",
        "Available": "0",
        "FC transfer": "0",
        "FC Processing": "0",
        "Customer Order": "0",
        "Unfulfillable": "0",
        "Working": "0",
        "Shipped": "0",
        "Receiving": "0",
        "Fulfilled by": "Amazon",
        "Total Days of Supply (including units from open shipments)": "",
        "Days of Supply at Amazon Fulfillment Network": "",
        "Alert": "out_of_stock",
        "Recommended replenishment qty": "",
        "Recommended ship date": "",
        "Unit storage size": "0.0027 m3"
    },
    {
        "Country": "DE",
        "Product Name": "Nawemo Zimtslipper Diamond, Größe 35\/36",
        "FNSKU": "X000RP14M9",
        "Merchant SKU": "A_1059-35-36",
        "ASIN": "B074H71B13",
        "Condition": "New",
        "Supplier": "--",
        "Supplier part no.": "",
        "Currency code": "EUR",
        "Price": "21.80",
        "Sales last 30 days": "0.0",
        "Units Sold Last 30 Days": "0",
        "Total Units": "0",
        "Inbound": "0",
        "Available": "0",
        "FC transfer": "0",
        "FC Processing": "0",
        "Customer Order": "0",
        "Unfulfillable": "0",
        "Working": "0",
        "Shipped": "0",
        "Receiving": "0",
        "Fulfilled by": "Amazon",
        "Total Days of Supply (including units from open shipments)": "",
        "Days of Supply at Amazon Fulfillment Network": "",
        "Alert": "out_of_stock",
        "Recommended replenishment qty": "",
        "Recommended ship date": "",
        "Unit storage size": "0.0025 m3"
    }
]

DreamRobot Bestände

Bestände laden | Bestände neu laden

Noch keine Bestände geladen.

Replenishment Vorschläge

Berechnung starten | Berechnung (Live-Report) | Berechnung (Live + Force)

Report-Zeilen: 2503 | Mappings: 16 | Entscheidungen: 16

Debug: SKU-Schnittmenge

Matchende SKUs: 16

Report-SKU Beispiel: A_40095-50, A_1061-36-37, A_1059-35-36, 9000D-42, A_40065-30, A_1038-38, A_1005-46-47, GF-50-3-46_A, 9001H-49, 5000H3-48

Matching-SKU Beispiel: A_4001-36, A_4001-39, A_4001-41, A_4001-42, A_4001-44, A_4001-37, A_4001-48, A_4001-50, A_4001-47, A_4001-45

Report-Felder: Country, Product Name, FNSKU, Merchant SKU, ASIN, Condition, Supplier, Supplier part no., Currency code, Price, Sales last 30 days, Units Sold Last 30 Days, Total Units, Inbound, Available, FC transfer, FC Processing, Customer Order, Unfulfillable, Working, Shipped, Receiving, Fulfilled by, Total Days of Supply (including units from open shipments), Days of Supply at Amazon Fulfillment Network, Alert, Recommended replenishment qty, Recommended ship date, Unit storage size

Amazon SKU Ship Qty Reason
A_4001-36 0 countries=DE,FR,ES,IT;units30_eu=3;demand_day=0.100;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=68;inbound=0;target=10;need=-58
A_4001-39 0 countries=DE,FR,ES,IT;units30_eu=41;demand_day=1.367;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=117;inbound=50;target=136;need=-31
A_4001-41 78 countries=DE,FR,ES,IT;units30_eu=48;demand_day=1.600;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=81;inbound=0;target=159;need=78
A_4001-42 121 countries=DE,FR,ES,IT;units30_eu=70;demand_day=2.333;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=111;inbound=0;target=232;need=121
A_4001-44 45 countries=DE,FR,ES,IT;units30_eu=34;demand_day=1.133;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=58;inbound=10;target=113;need=45
A_4001-37 0 countries=DE,FR,ES,IT;units30_eu=17;demand_day=0.567;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=40;inbound=20;target=57;need=-3
A_4001-48 6 countries=DE,FR,ES,IT;units30_eu=8;demand_day=0.267;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=16;inbound=5;target=27;need=6
A_4001-50 0 countries=DE,FR,ES,IT;units30_eu=0;demand_day=0.000;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=10;inbound=0;target=0;need=-10
A_4001-47 0 countries=DE,FR,ES,IT;units30_eu=11;demand_day=0.367;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=37;inbound=5;target=37;need=-5
A_4001-45 52 countries=DE,FR,ES,IT;units30_eu=44;demand_day=1.467;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=79;inbound=15;target=146;need=52
A_4001-38 0 countries=DE,FR,ES,IT;units30_eu=25;demand_day=0.833;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=81;inbound=30;target=83;need=-28
A_4001-43 19 countries=DE,FR,ES,IT;units30_eu=49;demand_day=1.633;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=113;inbound=30;target=162;need=19
A_4001-49 5 countries=DE,FR,ES,IT;units30_eu=4;demand_day=0.133;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=11;inbound=0;target=14;need=3;min_ship_applied=5
A_4001-46 105 countries=DE,FR,ES,IT;units30_eu=45;demand_day=1.500;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=44;inbound=0;target=149;need=105
A_4001-35 5 countries=DE,FR,ES,IT;units30_eu=6;demand_day=0.200;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=19;inbound=0;target=20;need=1;min_ship_applied=5
A_4001-40 0 countries=DE,FR,ES,IT;units30_eu=36;demand_day=1.200;lead=70;target_days=90;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=101;inbound=50;target=119;need=-32