Land N Sea as Source

Land 'N' Sea is a leading distributor in the marine industry, offering a wide range of boating accessories, marine parts, and recreational products. Serving dealers and retailers, it provides reliable access to high-quality products for boating enthusiasts and professionals. 
 

How To Connect

  • Navigate to Sources from the left-hand menu (building icon).
  • Click the + button in the top-left of the screen and follow the prompts.
  • Select Land N Sea (if you don't see the integration, reach our support for assistance).
  • Fill out the required connection details following the prompts.
  • Save Connection to complete the setup.
D&H Setup


Product Operations

The primary operation handles the bulk of your inventory management needs, while the secondary operation allows for more detailed control, such as focusing on specific products or updates     

Get Inventory (Primary)

Yes, Get Inventory (Primary) is supported!

The Get Inventory (Primary) integration for Land 'N' Sea enables seamless automation of product inventory updates. This process retrieves product details, warehouse-specific quantities, and pricing from a static FTP feed, ensuring your inventory data remains accurate and up to date.

Connect Your Integration

To connect your FTP and start retrieving inventory data:

1. Establish FTP Connection

Enter the FTP credentials provided by the supplier:

  • Connection Name: A name for your connection
  • FTP Protocol: Choose FTP or SFTP
  • FTP Host: Provided by Supplier (e.g., ftp.fixpoint.com)
  • FTP Port: Standard ports (e.g., 21 for FTP, 22 for SFTP)
  • FTP User: Provided by Supplier
  • FTP Password: Provided by Supplier

Test Connection: Verify the FTP connection before saving.

2. Advanced Settings (Optional)

  • Maintain Constant Connection: Ensures uninterrupted FTP sessions for smooth file transfers.

Configure Your Settings

1. Define File Locations

  • Inbound Remote File Folder: /incoming
    • This is the folder where inventory data files (like DSEDIIM.ZIP and 846 EDI) are stored and retrieved.

2. Sender/Receiver Identifiers

The Sender/Receiver configuration aligns the integration with Land 'N' Sea's system:

  • Our Sender/Receiver ID: FLXPOINT
  • Our Sender/Receiver Qualifier: ZZ
  • Their Sender/Receiver ID: 9549720473T
  • Their Sender/Receiver Qualifier: 12
     
Image 1

File Retrieval & Data Processing

Files Retrieved

DSEDIIM.ZIP: Contains essential product details, including:

  • SKU, Dimensions (Length, Width, Height), Weight
  • Title, Description, UPC
  • MSRP, Wholesale, MAP
  • Quantity and Active/Inactive Status

846 EDI Files: Downloads warehouse-specific pricing and quantities.

Archive/Un-Archive Inventory

This optional feature determines how inventory is managed when it is removed from the supplier feed:

  • Archive: Products not found in the current feed are set to a quantity of 0 (archived).
  • Un-Archive: Products re-added to the feed are automatically reactivated with their mapped quantities.
     

Recommendation: Do not enable this setting if Get Inventory (Secondary) is already active for the same integration.


Warehouse Configuration

  • Multi-Warehouse Support: You can configure which warehouses to include in updates.
  • Example Warehouses:
    • PompanoBeach, FL
    • Norfolk, VA
    • Houston, TX
    • Fresno, CA
    • ClintonTownship, MI

How It Works

  1. FTP Connection: Connects to the specified FTP server.
  2. File Retrieval: Downloads:
    • DSEDIIM.ZIP for product details
    • 846 EDI Files for pricing and warehouse-specific quantities
  3. Inventory Processing: Extracts product data and updates:
    • SKU, pricing, quantities, and product statuses (active/inactive).
  4. Warehouse Updates: Updates stock levels for the selected warehouses.
 
 

Get Inventory (Secondary)

Yes, Get Inventory (Secondary) is supported!

The Get Inventory (Secondary) integration for Land 'N' Sea allows you to automate the retrieval of warehouse-specific quantities and pricing details using 846 EDI files. This integration streamlines inventory management across warehouses, ensuring your product data remains up-to-date.

Connect Your Integration

To connect your FTP and begin retrieving inventory data:

1. Establish FTP Connection

Enter the FTP credentials provided by the supplier:

  • Connection Name: A name for your connection
  • FTP Protocol: Choose FTP, SFTP, or FTPS
  • FTP Host: Provided by Supplier
  • FTP Port: Standard FTP port (e.g., 21)
  • FTP User: Provided by Supplier
  • FTP Password: Provided by Supplier

Test Connection: Use this feature to verify FTP connectivity.

2. Advanced Settings (Optional)

  • Maintain Constant Connection: Ensures uninterrupted data transfers by maintaining a persistent FTP connection.

Configure Your Settings

1. Define Data Folder

Set the location where the integration retrieves files:

  • Inbound Remote File Folder: Example: /incoming

2. EDI File Retrieval

The integration downloads 846 EDI files from the configured FTP folder. These files provide:

  • Warehouse-Specific Quantities
  • Pricing Information

3. Sender/Receiver Configuration

Enter the required identifiers to align with Land 'N' Sea’s system:

  • Our Sender/Receiver ID: FLXPOINT
  • Our Sender/Receiver Qualifier: ZZ
  • Their Sender/Receiver ID: 9549720473T
  • Their Sender/Receiver Qualifier: 12
     
Image 1

Warehouse Selection

  • The integration supports multiple warehouses.
  • Warehouse Configuration: You can select which warehouse-level inventory data will be retrieved and updated.

How It Works

  1. File Retrieval: The system automatically pulls the 846 EDI file from the configured FTP location.
  2. Data Processing: Extracts warehouse-level quantities and pricing from the EDI file.
  3. Inventory Updates: Updates your system with accurate quantities and pricing for selected warehouses.
 
 

 

Order Operations

It submits orders to vendors for fulfillment and subsequently imports the shipment details, ensuring an integration between order processing and shipment tracking.     
 

Send Fulfillment Requests

Yes, Send Fulfillment Request is supported!

The Send Fulfillment Requests integration for Land 'N' Sea enables seamless automation of purchase order submissions, optimizing operational efficiency while reducing manual effort. This integration is designed to streamline the flow of fulfillment requests for Land 'N' Sea orders. 
 

Connect Your Integration:

  1. Select Integration Type: Choose Land 'N' Sea as your integration type.
  2. Establish Connection:
    • Enter the necessary FTP credentials, including:
      • Connection Name
      • FTP Host
      • FTP Protocol (FTP, SFTP, or FTPS)
      • FTP Port
      • FTP Username and Password
    • Use the Test Connection feature to ensure the connection works before saving.
  3. Advanced Settings (Optional):
    • Maintain Constant Connection: Ensures uninterrupted performance by maintaining a persistent FTP connection.
    • Unbuffered Private Data Channel: Resolves FTPS-specific SSL issues, if applicable.

Configure Your Settings:

Adjust the integration to meet your operational needs:

File Folders:

  • Outbound Remote File Folder: Location for outgoing fulfillment requests.
  • Inbound Remote File Folder: Folder to monitor incoming files or responses.

Sender/Receiver Details:

  • Our Sender/Receiver Qualifier: ZZ
  • Our Sender/Receiver ID: FLXPOINT
  • Their Sender/Receiver Qualifier: 12
  • Their Sender/Receiver ID: 9549720473

Order Processing Options:

  • Purchase Order Type: DS-Dropship
  • Hold for X Hours: Set a delay before fulfillment requests are submitted, allowing time for final checks or edits.
  • Send During Business Hours: Restrict submissions to Land 'N' Sea’s working hours for prompt handling.

Define a Mapping Template:

Customize your mapping template to ensure accurate data transfer. This allows you to match your order fields with Land 'N' Sea’s requirements.

Mapped Fields Include:

  • Fulfillment Request Number: Sent in the BEG03 segment for tracking.
  • FR Item Association: SKU, quantity, shipping codes, and other item details can be mapped.
  • Shipping Selection: Supplier-approved shipping methods can be sent.

Unmapped Fields:

  • Customer Association
  • Auto Acknowledgements
  • Custom Fields
  • Attachments

Automate the Process:

  1. Schedule Submissions: Automate the submission process using the integration’s scheduling feature.
  2. Receive Notifications: Get alerts for successful or failed fulfillment requests.

Key Features of Send Fulfillment Requests:

  1. Automated Processing: Automatically submit fulfillment requests, reducing manual input.
  2. Flexible Configuration: Adjust settings like hold periods, mapping templates, and working hours for operational alignment.
  3. Business Hour Support: Align submissions with Land 'N' Sea’s business hours for faster processing.
  4. Custom Mapping Templates: Ensure accurate data transfer through customizable templates.

Supported Operations:

  • Fulfillment Request Numbers: Unique tracking for each request.
  • FR Item Association: Properly map and associate SKUs and quantities for accurate order fulfillment.
  • Shipping Selection: Choose appropriate shipping methods for each order.

 

Limitations:

  • Customer Association: This feature is not supported.
  • Custom Fields and Attachments: Adding additional fields or attachments to requests is unavailable.
 
 

Get Shipments

Yes, Send Fulfillment Requests is supported!

The Send Fulfillment Requests integration for Land 'N' Sea enables seamless automation of purchase order submissions, optimizing operational efficiency while reducing manual effort. This integration is designed to streamline the flow of fulfillment requests for Land 'N' Sea orders. 
 

Connect Your Integration:

  1. Select Integration Type: Choose Land 'N' Sea as your integration type.
  2. Establish Connection:
    • Enter the necessary FTP credentials, including:
      • Connection Name
      • FTP Host
      • FTP Protocol (FTP, SFTP, or FTPS)
      • FTP Port
      • FTP Username and Password
    • Use the Test Connection feature to ensure the connection works before saving.
  3. Advanced Settings (Optional):
    • Maintain Constant Connection: Ensures uninterrupted performance by maintaining a persistent FTP connection.
    • Unbuffered Private Data Channel: Resolves FTPS-specific SSL issues, if applicable.

Configure Your Settings:

Adjust the integration to meet your operational needs:

File Folders:

  • Outbound Remote File Folder: Location for outgoing fulfillment requests.
  • Inbound Remote File Folder: Folder to monitor incoming files or responses.

Sender/Receiver Details:

  • Our Sender/Receiver Qualifier: ZZ
  • Our Sender/Receiver ID: FLXPOINT
  • Their Sender/Receiver Qualifier: 12
  • Their Sender/Receiver ID: 9549720473

Order Processing Options:

  • Purchase Order Type: DS-Dropship
  • Hold for X Hours: Set a delay before fulfillment requests are submitted, allowing time for final checks or edits.
  • Send During Business Hours: Restrict submissions to Land 'N' Sea’s working hours for prompt handling.

Define a Mapping Template:

Customize your mapping template to ensure accurate data transfer. This allows you to match your order fields with Land 'N' Sea’s requirements.

Mapped Fields Include:

  • Fulfillment Request Number: Sent in the BEG03 segment for tracking.
  • FR Item Association: SKU, quantity, shipping codes, and other item details can be mapped.
  • Shipping Selection: Supplier-approved shipping methods can be sent.

Unmapped Fields:

  • Customer Association
  • Auto Acknowledgements
  • Custom Fields
  • Attachments

Automate the Process:

  1. Schedule Submissions: Automate the submission process using the integration’s scheduling feature.
  2. Receive Notifications: Get alerts for successful or failed fulfillment requests.

Key Features of Send Fulfillment Requests:

  1. Automated Processing: Automatically submit fulfillment requests, reducing manual input.
  2. Flexible Configuration: Adjust settings like hold periods, mapping templates, and working hours for operational alignment.
  3. Business Hour Support: Align submissions with Land 'N' Sea’s business hours for faster processing.
  4. Custom Mapping Templates: Ensure accurate data transfer through customizable templates.

Supported Operations:

  • Fulfillment Request Numbers: Unique tracking for each request.
  • FR Item Association: Properly map and associate SKUs and quantities for accurate order fulfillment.
  • Shipping Selection: Choose appropriate shipping methods for each order.

 

Limitations:

  • Customer Association: This feature is not supported.
  • Custom Fields and Attachments: Adding additional fields or attachments to requests is unavailable.
 
 

Get Fulfillment Acknowledgements

Yes, Get Fulfillment Request Acknowledgements is supported!

The Get Fulfillment Request Acknowledgements integration enables seamless retrieval and processing of EDI 855 files from Land 'N' Sea. This ensures the acknowledgement of fulfillment requests or identification of cancellations, allowing for real-time updates on order statuses.

Connect Your Integration

If you have already set up a connection for "Send Fulfillment Requests," the same connection can be used for this process. However, you can create a new FTP connection if necessary:

  • Enter the Connection Name, FTP Protocol, FTP Host, FTP Port, FTP User, and FTP Password.
  • Use Advanced Settings to enable a constant connection or resolve FTPS connection issues.
  • Test your connection before saving to ensure all credentials are correct.

Configure Your Settings

Configure integration-specific details for retrieving acknowledgements:

  • Outbound Remote File Folder: Specify the location of files to be processed on the FTP server.
  • Inbound Remote File Folder: Specify where files will be received.
  • Qualifiers and Identifiers: Configure the sender and receiver identifiers and qualifiers as per Land 'N' Sea's specifications.
  • Purchase Order Type: Set the purchase order type for this integration (e.g., DS-Dropship).
  • Save the settings and proceed to the next step.

Define a Mapping Template

Create or select a mapping template to define how the data will be processed. Map fields such as:

  • Acknowledgement Code: Extracts the acceptance or rejection status of each item.
  • Quantity: Ensures the correct quantities are acknowledged.
  • SKU: Matches the acknowledged item to the SKU in your system.
  • Acknowledged Status: Tracks whether an item is successfully acknowledged or marked for cancellation.

Automate the Process

Once the configuration and mapping are complete:

  • Enable scheduling to retrieve acknowledgement files automatically.
  • Notifications will be sent each time the process runs, ensuring you stay informed of the integration’s activities.

Key Features of Get Fulfillment Request Acknowledgements

  • Seamless Integration: Automatically retrieves and processes acknowledgement files from Land 'N' Sea's FTP server.
  • Real-Time Updates: Tracks the acknowledgement or rejection of fulfillment requests.
  • Custom Mapping: Ensures accurate processing of acknowledgement codes and other data fields.
  • Automated Scheduling: Configures automated retrieval for minimal manual intervention.

Supported Operations

  • Cancellations: Items marked as canceled are flagged with an "IR" (Item Rejected) code.
  • Item Association: Ensures accurate mapping between acknowledgement files and your system.
  • Partial Acknowledgements: Partially acknowledged items may vary depending on the data provided.

Limitations

  • IB (Item Backordering): Not supported within the scope of this integration.
 
 

Get Invoices

Yes, Get Invoices is supported!

The Get Invoices integration for Land 'N' Sea automates the retrieval and processing of invoice data. It downloads 810 EDI files from a configured FTP location, parses the data, and generates matching invoices. This process reduces manual effort, ensures timely updates, and improves invoice accuracy.

Connect Your Integration

To connect and start pulling invoice data:

1. Establish FTP Connection

Enter the FTP credentials provided by the supplier:

  • Connection Name: A name for the connection
  • FTP Protocol: Choose FTP, SFTP, or FTPS
  • FTP Host: Provided by Supplier (e.g., ftp.fixpoint.com)
  • FTP Port: Standard FTP ports (e.g., 21)
  • FTP User: Provided by Supplier
  • FTP Password: Provided by Supplier

Test Connection: Use this feature to validate the connection before proceeding.

2. Advanced Settings (Optional)

  • Maintain Constant Connection: Ensures uninterrupted FTP sessions for large file transfers.

Configure Your Settings

1. Define File Locations

  • Inbound Remote File Folder: The folder where invoice files are retrieved. Example: /lns-invoices
  • Outbound Remote File Folder: The folder where acknowledgments are sent after processing. Example: /lns-invoices

2. Sender/Receiver Identifiers

Provide the necessary details to align with Land 'N' Sea’s system:

  • Our Sender/Receiver ID: FLXPOINT
  • Our Sender/Receiver Qualifier: ZZ
  • Their Sender/Receiver ID: 9549720473T
  • Their Sender/Receiver Qualifier: 12
     
Image 1

How It Works

File Retrieval:

  • The integration connects to the FTP server and downloads 810 EDI files from the Inbound Remote File Folder.

Data Processing:

  • Parses invoice data from the 810 EDI files.
  • Generates invoices that match the associated Fulfillment Requests (FR).

Acknowledgment:

  • Sends acknowledgment files back to the supplier via the Outbound Remote File Folder for processed 810 EDI files.

Automation Features

  • Automated Retrieval: Automatically fetches invoices from the configured FTP folder.
  • Data Parsing: Reads and processes standard 810 EDI files to generate accurate invoices.
  • Acknowledgment Automation: Sends confirmation for processed invoices to the supplier.