Land 'N' Sea as a Source
Summary
Land 'N' Sea is a marine and powersports products distributor connected via FTP and EDI. Before configuring the integration, submit Land 'N' Sea's EDI questionnaire — approval takes 5–10 business days and unlocks full order-operation credentials, while Get Inventory (Primary) works with no connection setup required. The integration covers Get Inventory (Primary and Secondary), Send Fulfillment Requests, Get Fulfillment Acknowledgements, Get Invoices, and Get Shipments over EDI (850/855/856/810).
Land 'N' Sea requires an approved EDI questionnaire before full credentials are issued (see Important Notes). Get Inventory (Primary) works automatically with no connection setup. For every other operation, add a Land 'N' Sea source, start configuring an operation, and when Flxpoint prompts you click + New Connection, enter the SFTP and EDI trading-partner values Land 'N' Sea provided, then Test Connection → Save Connection.
ZZ.FLXPOINT.12.9549720473T for Get Inventory (Secondary) and Get Invoices, or 9549720473 for Send Fulfillment Requests and Get Shipments.DS (Dropship) or SA (Stand Alone Order) — controls which N104 value Send Fulfillment Requests uses. Confirm with Land 'N' Sea which applies to your account.support@flxpoint.com.EDI questionnaire required — 5–10 business day approval before integration can be configured
Before any integration work begins, download and submit the EDI questionnaire — contact support@flxpoint.com for the template. Land 'N' Sea must approve the EDI setup before they issue full FTP credentials or allow live order transmission. The generic pricing/quantity feed is publicly available without credentials, but order operations (Send FR, Get Shipments, Get Ack, Get Invoices) require approved EDI credentials. A test order must be placed and confirmed before switching to production.
GIS uses 846 EDI files in Item-Warehouse format — Warehouse-Item format is not supported
Get Inventory Secondary reads 846 EDI files from the configured FTP folder. These files must be in Item-Warehouse format (e.g., 846_X12_item_whse.edi). The Warehouse-Item format is not supported and will fail to parse correctly. Confirm with Land 'N' Sea that your 846 feed is configured for Item-Warehouse before activating GIS.
EDI 850 Send FR uses GS08 = 004010VICS — fixed as of April 23, 2026
Land 'N' Sea's EDI system requires Group Version 004010VICS in the GS08 segment of EDI 850 files. Prior to April 23, 2026, Flxpoint sent 004010, causing rejections. This was corrected and all Send FR submissions now automatically use 004010VICS — no user action is needed. If you experienced rejected orders before this date, resubmit those FRs.
REF*WS segments required for warehouse-specific quantities — missing segments default to 0
Warehouse-specific quantities in the 846 EDI file depend on REF*WS segments being present for each warehouse. If these segments are missing from Land 'N' Sea's feed, warehouse quantities will default to 0 even if stock exists. Additionally, quantity values must be integers or include only a trailing ".00" — other decimal fractions (e.g., ".23") may not parse correctly.
| Field | Maps To — Notes |
|---|---|
| Item Code (SKU) | Not available in mapping or field. |
| Description | → Product → Title & Description. The feed's single description field is used for both. |
| UPC | → Variant → Identifiers → UPC. |
| Wholesale (Dealer Price) | → Pricing → Cost. |
| MSRP | → Pricing → MSRP. |
| MAP (Minimum Advertised Price) | → Pricing → MAP. Only applied when today's date falls within the feed's active MAP date range. |
| Height / Depth / Length / Weight, Unit of Measure, Pack Quantity, Hazardous flag | → Variant → Dimensions, Weight & Attributes. |
| Per-warehouse quantities & active flags | → Inventory → Quantity and Product → Active status. Quantity is summed across warehouses; the product is active if any warehouse reports it active. |
| Marketing Data file (Brand, Category, Bullets, Images) — optional | → Product → Attributes & Images. Only merged in when Flxpoint Support enables the additional dealer marketing feed for your account. |
| Field | Maps To — Notes |
|---|---|
| Item/Warehouse identifier (SKU or UPC) | → Inventory Variant → SKU. Required. Matches the identifier type configured for the 846 feed. |
| Warehouse quantities (REF*WS segments) | → Inventory → Quantity. Required. Only the warehouses you select in the job config are summed; missing REF*WS segments default to 0. |
| Unit Cost Price | → Pricing → Cost. Included when Land 'N' Sea's 846 file carries a cost value. |
| Full catalog fields (title, images, attributes) | Not included in GIS — those come from Get Inventory (Primary). Run GIP for the full catalog and GIS more frequently to keep Quantity (and Cost, if provided) current. |
| Source Field | Maps To (Land 'N' Sea EDI 850) — Notes |
|---|---|
| Fulfillment Request # | Not available in mapping or field. |
| Fulfillment Request line → SKU | → Buyer's Part Number / Vendor's Item Number. Required. Identifies the line item to Land 'N' Sea. |
| Fulfillment Request line → Quantity | → Quantity. Required. |
| Shipping address | → Ship To (N1 Loop). Required. End-customer shipping address. |
| Order Type (DS or SA, set on the connection) | → N104 Ship-To Qualifier. Dropship (DS) and Stand Alone (SA) orders use different N104 values — both must be mapped in the mapping template before orders can send. |
| Shipping Carrier Code & Description | → Carrier (TD5 segment). Optional, but if one is mapped the other must be too. |
| UPC / Vendor's Catalog Number / Part Description | → Item identifiers (PO1 segment). Optional additional identifiers sent per line. |
| Field | Maps To (Land 'N' Sea EDI 855) — Notes |
|---|---|
| Acceptance Code | → Acknowledgement Status. IA = accepted, IR = rejected. Partial acknowledgements are supported; backorder (IB) is not. |
| Acknowledged Quantity | Not available in mapping or field. |
| Order line matching | Not available in mapping or field. |
| Field | Maps To — Notes |
|---|---|
| Buyer's/Vendor's Item Number or SKU | → Invoice Item → SKU. Required. |
| Quantity Invoiced | → Invoice Item → Quantity. Required. |
| Unit Price | → Invoice Item → Per Unit Cost. Required. |
| Invoice Total | Not available in mapping or field. |
| Line item charges (freight, allowances, etc.) | Nothing available in mapping or field. |
| Field | Maps To — Notes |
|---|---|
| Buyer's/Vendor's Item Number or SKU | → Shipment Item → SKU. Required. |
| Quantity Shipped | Not available in mapping or field. |
| Tracking Number | Not available in mapping or field. |
| UPC / Buyer's Item Number (N) & Vendor's Item Number (VN) | → Shipment Item → Identifiers. Additional identifiers Land 'N' Sea returns alongside SKU. |
004010 instead of the required 004010VICS. This issue was corrected on April 23, 2026 — all EDI 850 files now automatically use 004010VICS. No user configuration change is needed. If you had orders rejected before this date, resubmit those FRs from Flxpoint and they should now transmit correctly.What are the Sender/Receiver ID values used across all Land 'N' Sea EDI operations?▸
FLXPOINT, Qualifier: ZZ. Their Sender/Receiver ID: 9549720473T (used for GIP, GIS, Get Invoices) or 9549720473 (used for Send FR and Get Shipments), Qualifier: 12. For Get Invoices, both Inbound and Outbound Remote File Folders are typically /lns-invoices.What warehouses does Land 'N' Sea support and what does each operation cover?▸
DSEDIIM.ZIP (product details) plus 846 EDI files for warehouse quantities. GIS retrieves 846 Item-Warehouse EDI files with per-warehouse quantities. Supported named warehouses include: Pompano Beach FL, Norfolk VA, Houston TX, Fresno CA, Clinton Township MI, plus Eagan, Grand Rapids, Kansas City, Kent, Lake Suzy, Norcross, Old Lyme, and Shreveport. Select only the warehouses you need in the integration settings.What EDI file types does each order operation use?▸
004010VICS. Purchase Order Type DS-Dropship sets N104 = 303; other types set N104 = 02. Get Shipments: EDI 856 (Advance Ship Notice) from the Inbound folder. Maps SKU, Buyer's Item Number, UPC, and Vendor's Item Number. Get Fulfillment Acknowledgements: EDI 855. Acceptance Code IA = accepted, IR = rejected. Partial acks supported; IB (backorder) is not. Get Invoices: EDI 810. After processing, Flxpoint sends an acknowledgement back to Land 'N' Sea.