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	EDGE	ALLYEAR	1	1	Test
A_4001-36	4001-36	EDGE	ALLYEAR	1	1	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	EDGE	ALLYEAR	1	0	Test
A_4001-47	4001-47	EDGE	ALLYEAR	1	0	Test
A_4001-48	4001-48	EDGE	ALLYEAR	1	0	Test
A_4001-49	4001-49	EDGE	ALLYEAR	1	1	Test
A_4001-50	4001-50	EDGE	ALLYEAR	1	1	Test
A_40015-35	40015-35	CORE	ALLYEAR	1	0	5er Pack
A_40015-36	40015-36	CORE	ALLYEAR	1	0	5er Pack
A_40015-37	40015-37	CORE	ALLYEAR	1	0	5er Pack
A_40015-38	40015-38	CORE	ALLYEAR	1	0	5er Pack
A_40015-39-2	40015-39-2	CORE	ALLYEAR	1	0	5er Pack
A_40015-40	40015-40	CORE	ALLYEAR	1	0	5er Pack
A_40015-41	40015-41	CORE	ALLYEAR	1	0	5er Pack
A_40015-42	40015-42	CORE	ALLYEAR	1	0	5er Pack
A_40015-43	40015-43	CORE	ALLYEAR	1	0	5er Pack
A_40015-44	40015-44	CORE	ALLYEAR	1	0	5er Pack
A_40015-45	40015-45	CORE	ALLYEAR	1	0	5er Pack
A_40015-46	40015-46	CORE	ALLYEAR	1	0	5er Pack
A_40015-47	40015-47	CORE	ALLYEAR	1	0	5er Pack
A_40015-48	40015-48	CORE	ALLYEAR	1	0	5er Pack
A_40015-49	40015-49	CORE	ALLYEAR	1	0	5er Pack
A_40015-50	40015-50	CORE	ALLYEAR	1	0	5er Pack

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": "Nawemo Bambusslipper Flowers, Größe 41.5 EU",
        "FNSKU": "X00114E0DP",
        "Merchant SKU": "A_1070-41-42",
        "ASIN": "B07SFVSRNZ",
        "Condition": "New",
        "Supplier": "--",
        "Supplier part no.": "",
        "Currency code": "EUR",
        "Price": "19.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.0028 m3"
    },
    {
        "Country": "DE",
        "Product Name": "Nawemo Zimtlatschen Wide Strap, schwarz, Größe 44\/45",
        "FNSKU": "X000RQ5GR7",
        "Merchant SKU": "A_1009-44-45",
        "ASIN": "B0775ZMJ18",
        "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.0006 m3"
    },
    {
        "Country": "DE",
        "Product Name": "Nawemo Zimtslipper Camouflage (36\/37, Mehrfarbig)",
        "FNSKU": "X000RP11YZ",
        "Merchant SKU": "A-1056-36-37",
        "ASIN": "B0719R1439",
        "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": "0",
        "Recommended ship date": "",
        "Unit storage size": "0.0034 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) | Berechnung (inkl. Sub-API)

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

Debug: SKU-Schnittmenge

Matchende SKUs: 32

Report-SKU Beispiel: A_1070-41-42, A_1009-44-45, A-1056-36-37, A_40025-45, A_1026-40-41, 9001H-44, 9000D-43, A-1056-40-41, A-40135-48, A_4002-44

Matching-SKU Beispiel: A_40015-44, A_4001-36, A_4001-45, A_40015-50, A_4001-37, A_40015-41, A_4001-44, A_40015-35, A_40015-46, A_40015-47

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-35	0	countries=DE,FR,ES,IT;units30_eu=6;demand_day=0.200;lead=70;target_days=60;segment=EDGE(0.5);season=ALLYEAR(1);rare_size(=0.7);has_sub(1);sub_min_days=30;fba=19;inbound=0;target=6;need=-13
A_4001-36	0	countries=DE,FR,ES,IT;units30_eu=3;demand_day=0.100;lead=70;target_days=60;segment=EDGE(0.5);season=ALLYEAR(1);rare_size(=0.7);has_sub(1);sub_min_days=30;fba=68;inbound=0;target=4;need=-64
A_4001-37	0	countries=DE,FR,ES,IT;units30_eu=17;demand_day=0.567;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=40;inbound=20;target=38;need=-22
A_4001-38	0	countries=DE,FR,ES,IT;units30_eu=25;demand_day=0.833;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=81;inbound=30;target=56;need=-55
A_4001-39	0	countries=DE,FR,ES,IT;units30_eu=41;demand_day=1.367;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=116;inbound=50;target=91;need=-75
A_4001-40	0	countries=DE,FR,ES,IT;units30_eu=36;demand_day=1.200;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=101;inbound=50;target=80;need=-71
A_4001-41	25	countries=DE,FR,ES,IT;units30_eu=48;demand_day=1.600;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=81;inbound=0;target=106;need=25
A_4001-42	43	countries=DE,FR,ES,IT;units30_eu=70;demand_day=2.333;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=111;inbound=0;target=154;need=43
A_4001-43	0	countries=DE,FR,ES,IT;units30_eu=49;demand_day=1.633;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=113;inbound=30;target=108;need=-35
A_4001-44	7	countries=DE,FR,ES,IT;units30_eu=34;demand_day=1.133;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=58;inbound=10;target=75;need=7
A_4001-45	5	countries=DE,FR,ES,IT;units30_eu=44;demand_day=1.467;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=78;inbound=15;target=97;need=4;min_ship_applied=5
A_4001-46	6	countries=DE,FR,ES,IT;units30_eu=45;demand_day=1.500;lead=70;target_days=60;segment=EDGE(0.5);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=44;inbound=0;target=50;need=6
A_4001-47	0	countries=DE,FR,ES,IT;units30_eu=11;demand_day=0.367;lead=70;target_days=60;segment=EDGE(0.5);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=37;inbound=5;target=13;need=-29
A_4001-48	0	countries=DE,FR,ES,IT;units30_eu=8;demand_day=0.267;lead=70;target_days=60;segment=EDGE(0.5);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=16;inbound=5;target=9;need=-12
A_4001-49	0	countries=DE,FR,ES,IT;units30_eu=4;demand_day=0.133;lead=70;target_days=60;segment=EDGE(0.5);season=ALLYEAR(1);rare_size(=0.7);has_sub(1);sub_min_days=30;fba=11;inbound=0;target=4;need=-7
A_4001-50	0	countries=DE,FR,ES,IT;units30_eu=0;demand_day=0.000;lead=70;target_days=60;segment=EDGE(0.5);season=ALLYEAR(1);rare_size(=0.7);has_sub(1);sub_min_days=30;fba=10;inbound=0;target=0;need=-10
A_40015-35	0	countries=DE,FR,ES,IT;units30_eu=5;demand_day=0.167;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=15;inbound=10;target=11;need=-14
A_40015-36	0	countries=DE,FR,ES,IT;units30_eu=10;demand_day=0.333;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=18;inbound=10;target=22;need=-6
A_40015-37	0	countries=DE,FR,ES,IT;units30_eu=18;demand_day=0.600;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=48;inbound=20;target=40;need=-28
A_40015-38	0	countries=DE,FR,ES,IT;units30_eu=24;demand_day=0.800;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=60;inbound=10;target=53;need=-17
A_40015-39-2	0	countries=DE,FR;units30_eu=30;demand_day=1.000;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=92;inbound=0;target=66;need=-26
A_40015-40	32	countries=DE,FR,ES,IT;units30_eu=51;demand_day=1.700;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=61;inbound=20;target=113;need=32
A_40015-41	33	countries=DE,FR,ES,IT;units30_eu=44;demand_day=1.467;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=44;inbound=20;target=97;need=33
A_40015-42	0	countries=DE,FR,ES,IT;units30_eu=60;demand_day=2.000;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=151;inbound=20;target=132;need=-39
A_40015-43	28	countries=DE,FR,ES,IT;units30_eu=84;demand_day=2.800;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=137;inbound=20;target=185;need=28
A_40015-44	0	countries=DE,FR,ES,IT;units30_eu=58;demand_day=1.933;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=131;inbound=20;target=128;need=-23
A_40015-45	0	countries=DE,FR,ES,IT;units30_eu=43;demand_day=1.433;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=213;inbound=0;target=95;need=-118
A_40015-46	30	countries=DE,FR,ES,IT;units30_eu=44;demand_day=1.467;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=67;inbound=0;target=97;need=30
A_40015-47	0	countries=DE,FR,ES,IT;units30_eu=10;demand_day=0.333;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=41;inbound=0;target=22;need=-19
A_40015-48	0	countries=DE,FR,ES,IT;units30_eu=7;demand_day=0.233;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=24;inbound=0;target=16;need=-8
A_40015-49	0	countries=DE,FR,ES,IT;units30_eu=3;demand_day=0.100;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=7;inbound=0;target=7;need=0
A_40015-50	0	countries=DE,FR,ES,IT;units30_eu=0;demand_day=0.000;lead=70;target_days=60;segment=CORE(1);season=ALLYEAR(1);rare_size(=1);has_sub(1);sub_min_days=30;fba=10;inbound=0;target=0;need=-10