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.
Click the + button to add a new source and follow the prompts.
Select Land 'N' Sea. If unavailable, contact support.
Complete the EDI Questionnaire: Before integration begins,
download and submit the EDI questionnaire
. Processing takes 5-10 business days.
Enable GIS & Test FTP: Once approved, your inventory and pricing data will be available in a test environment.
Note: Land 'N' Sea provides a generic pricing and quantity feed that does not require a password. However, full EDI integration (with official credentials) is only available after approval.
Confirm your 846 feed accuracy in the test environment (this contains warehouse-specific inventory data) before placing a test order.
Note: The integration has been configured to process quantity values in the Item Warehouse file as integers when they include a trailing “.00”. If the quantity values include any other decimal fractions (for example, “.23” or “.45”), the system may not interpret them as intended. Additionally, please ensure that your EDI file includes the REF*WS segments to capture warehouse-specific quantity data; otherwise, these values will default to 0.
Note: Land 'N' Sea provides a generic pricing and quantity feed that does not require a password. However, full EDI integration (with official credentials) is only available after approval.
Confirm your 846 feed accuracy in the test environment (this contains warehouse-specific inventory data) before placing a test order.
Note: The integration has been configured to process quantity values in the Item Warehouse file as integers when they include a trailing “.00”. If the quantity values include any other decimal fractions (for example, “.23” or “.45”), the system may not interpret them as intended. Additionally, please ensure that your EDI file includes the REF*WS segments to capture warehouse-specific quantity data; otherwise, these values will default to 0.
Send a Test Order: You must place a test order before moving to production.
Switch to Production: After a successful test order and confirmed tracking, your integration moves to live operations.
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)
Supported | Land 'N' Sea - Get Inventory [Primary]
Introduction to Land 'N' Sea - Get Inventory [Primary] Integration
The Land 'N' Sea - Get Inventory [Primary] integration 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 in your Flxpoint system. This guide walks you through the setup process. Let’s get started!
The Land 'N' Sea - Get Inventory [Primary] integration connects your Flxpoint system to Land 'N' Sea to:
- Retrieve product details, pricing, and warehouse-specific quantities from a static FTP feed.
- Map Land 'N' Sea’s inventory fields to your system for accurate inventory management.
- Ensure seamless updates across multiple warehouses in your Flxpoint system.
The integration follows a structured process to retrieve and map inventory data from Land 'N' Sea:
-
FTP Connection: Connects to the specified FTP server using provided credentials (e.g., host:
ftp.fixpoint.com
). -
File Retrieval: Downloads files from the Inbound Remote File Folder (
/incoming
):-
DSEDIIM.ZIP
: Contains product details like SKU, dimensions, weight, title, description, UPC, MSRP, wholesale, MAP, quantity, and active/inactive status. -
846 EDI Files
: Provides warehouse-specific pricing and quantities in the required format (Per Item and Warehouse
, e.g.,846_X12_item_whse.edi
).
-
- Inventory Processing: Extracts product data and updates SKU, pricing, quantities, and product statuses (active/inactive) in your system.
- Warehouse Updates: Updates stock levels for selected warehouses (e.g., PompanoBeach, FL; Norfolk, VA; Houston, TX; Fresno, CA; ClintonTownship, MI).
Customize the integration to fit your needs:
-
FTP Connection Settings:
- Connection Name: A name for your connection.
- FTP Protocol: Choose FTP or SFTP.
-
FTP Host: Provided by the supplier (e.g.,
ftp.fixpoint.com
). - FTP Port: Standard ports (e.g., 21 for FTP, 22 for SFTP).
- FTP User & Password: Provided by the supplier.
- Maintain Constant Connection: Enable to ensure uninterrupted FTP sessions (optional).
-
Inbound Remote File Folder: Set to
/incoming
to retrieve inventory data files. -
Sender/Receiver Identifiers:
-
Our Sender/Receiver ID:
FLXPOINT
. -
Our Sender/Receiver Qualifier:
ZZ
. -
Their Sender/Receiver ID: Example:
9549720473T
. -
Their Sender/Receiver Qualifier:
12
.
-
Our Sender/Receiver ID:
-
Archive/Un-Archive Inventory: Optional feature to manage inventory:
- Archive: Sets products not in the current feed to a quantity of 0.
- Un-Archive: Reactivates products re-added to the feed with their mapped quantities.
- Warehouse Configuration: Select which warehouses to update (e.g., PompanoBeach, FL; Norfolk, VA; Houston, TX; Fresno, CA; ClintonTownship, MI).
Note: Do not enable Archive/Un-Archive if Get Inventory (Secondary) is already active for this integration to avoid conflicts.
Follow these steps to set up the Land 'N' Sea - Get Inventory [Primary] integration:
- 1 Establish FTP Connection: Enter the FTP credentials provided by Land 'N' Sea (Connection Name, FTP Protocol, FTP Host, FTP Port, FTP User, FTP Password). Test the connection to verify it works before saving.
- 2 Configure Advanced Settings (Optional): Enable "Maintain Constant Connection" for uninterrupted FTP sessions if needed.
-
3 Define File Locations: Set the Inbound Remote File Folder to
/incoming
to retrieveDSEDIIM.ZIP
and846 EDI
files. -
4 Set Sender/Receiver Identifiers: Configure identifiers (Our Sender/Receiver ID:
FLXPOINT
, Qualifier:ZZ
; Their Sender/Receiver ID: e.g.,9549720473T
, Qualifier:12
). - 5 Configure Archive Settings: Decide whether to enable Archive/Un-Archive Inventory (not recommended if Get Inventory [Secondary] is active).
- 6 Select Warehouses: Choose which warehouses to update (e.g., PompanoBeach, FL; Norfolk, VA).
- 7 Create a Mapping Template: Use the Mapping Dashboard ("Land 'N' Sea - Get Inventory [Primary]") to define how Land 'N' Sea’s fields map to your inventory fields (details below).
- 8 Run the Integration: Run manually or schedule periodic updates to keep your inventory data current.
- The mapping screen is labeled “Land 'N' Sea - Get Inventory [Primary]” in the Mapping Dashboard.
- Buttons available: Delete to remove the template, Duplicate to copy it, and Save to save changes.
- Sections include:
- From Value: Land 'N' Sea fields (e.g., SKU, Quantity, MAP).
- To Inventory Field: Flxpoint Parent and Variant fields (e.g., Master SKU, Cost, Quantity).
- Mapping Options: Options like Field, Value, Mapping Set, and Rules for customization.
This section provides key details about the Land 'N' Sea - Get Inventory [Primary] integration to help you understand the process:
- Current Date and Time: As of 08:40 AM -04 on Friday, May 16, 2025, this integration is fully operational for retrieving inventory data from Land 'N' Sea.
-
Land 'N' Sea Integration: Retrieves inventory data via FTP, including product details from
DSEDIIM.ZIP
and warehouse-specific data from846 EDI
files. - Supported Warehouses: Updates stock levels for multiple warehouses, such as PompanoBeach, FL; Norfolk, VA; Houston, TX; Fresno, CA; and ClintonTownship, MI.
- Archive/Un-Archive Caution: Avoid enabling Archive/Un-Archive if Get Inventory (Secondary) is active to prevent conflicts.
Tip: Test your FTP connection before saving to ensure successful file retrieval.
Mapping Fields
Below are the fields you can map, with examples and purposes (labeled as "T" for text, "N" for numbers, as in the dashboard):
Land 'N' Sea - Get Inventory [Primary] Mappings
Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
SKU (T) | Parent: Master SKU / Variant: SKU | LNS12345 | Identifies the product at the parent or variant level | Required |
Description (T) | Parent: Description / Variant: Description | Marine GPS Unit | Records the product description | Optional |
Title (T) | Parent: Title / Variant: Title | GPS Navigator | Records the product title | Optional |
UPC (T) | Variant: UPC | 012345678905 | Records the UPC code for the variant | Optional |
Wholesale (N) | Variant: Cost | 150.00 | Records the wholesale cost of the variant | Optional |
MSRP (N) | Variant: MSRP | 199.99 | Records the Manufacturer’s Suggested Retail Price | Optional |
MAP (N) | Variant: MAP | 175.00 | Records the Minimum Advertised Price | Optional |
Quantity (N) | Variant: Quantity | 50 | Records the available quantity for the variant | Required |
Height (N) | Variant: Height | 5 | Records the height of the product | Optional |
Length (N) | Variant: Length | 10 | Records the length of the product | Optional |
Width (N) | Variant: Width | 8 | Records the width of the product | Optional |
Weight (N) | Variant: Weight | 2.5 | Records the weight of the product | Optional |
Available Source Fields
Land 'N' Sea provides fields from the FTP feed, including:
- Product Details (DSEDIIM.ZIP): Description (T), Height (N), Length (N), MAP (N), MSRP (N), Quantity (N), SKU (T), Title (T), UPC (T), Weight (N), Wholesale (N), Width (N).
-
Warehouse Data (846 EDI): Warehouse-specific quantities and pricing in the format
Per Item and Warehouse
.
Mapping Options
You can choose from the following options for each field:
- Field: Link a Land 'N' Sea field (e.g., Quantity) to a Flxpoint inventory field.
- Value: Choose a fixed value for the field.
- Mapping Set: Use preset tools to adjust data (e.g., combine fields).
- Rules: Add "if-then" logic (e.g., only map if quantity > 0).
- Don’t Map: Ignore the field entirely.
- Set to Empty: Clear the field in the Flxpoint inventory, removing existing data.
If the integration encounters an issue, try these steps:
- FTP Connection Failure: Verify your FTP credentials (host, port, user, password) and test the connection again.
-
File Not Found: Ensure the Inbound Remote File Folder is correctly set to
/incoming
and that the supplier has uploaded the required files (DSEDIIM.ZIP
,846 EDI
). -
Warehouse Data Missing: Confirm that the
846 EDI
files are in the correct format (Per Item and Warehouse
) and that the selected warehouses are supported. - Archive/Un-Archive Conflicts: If enabled, ensure Get Inventory (Secondary) is not active to avoid overlapping updates.
Conclusion
With the Land 'N' Sea - Get Inventory [Primary] integration, you can efficiently retrieve and map inventory data from Land 'N' Sea into your Flxpoint system, ensuring accurate updates across multiple warehouses. Flexible mapping options and automated file retrieval make inventory management seamless and reliable.
Get Inventory (Secondary)
Supported | Land 'N' Sea - Get Inventory [Secondary]
Introduction to Land 'N' Sea - Get Inventory [Secondary] Integration
The Land 'N' Sea - Get Inventory [Secondary] integration automates the retrieval of warehouse-specific quantities and pricing details using 846 EDI files. This integration streamlines inventory management across multiple warehouses, ensuring your product data remains up-to-date in your Flxpoint system. This guide walks you through the setup process. Let’s get started!
The Land 'N' Sea - Get Inventory [Secondary] integration connects your Flxpoint system to Land 'N' Sea to:
- Retrieve warehouse-specific quantities and pricing details via 846 EDI files from an FTP server.
- Map Land 'N' Sea’s inventory data to your system for accurate updates at the variant level.
- Ensure seamless inventory management across multiple warehouses in your Flxpoint system.
The integration follows a structured process to retrieve and map secondary inventory data from Land 'N' Sea:
- FTP Connection: Connects to the specified FTP server using provided credentials.
-
File Retrieval: Automatically pulls the 846 EDI file (Item-Warehouse format) from the configured FTP location (e.g.,
/incoming
), which includes warehouse-specific quantities and pricing. - Data Processing: Extracts data such as SKU, unit cost price, and quantities for each warehouse (e.g., Pompano Beach, Norfolk).
- Inventory Updates: Updates your system with accurate quantities and pricing for selected warehouses at the variant level.
Customize the integration to fit your needs:
-
FTP Connection Settings:
- Connection Name: A name for your connection.
- FTP Protocol: Choose FTP, SFTP, or FTPS.
- FTP Host: Provided by the supplier.
- FTP Port: Standard port (e.g., 21 for FTP).
- FTP User & Password: Provided by the supplier.
- Maintain Constant Connection: Enable to ensure uninterrupted data transfers (optional).
-
Inbound Remote File Folder: Set to the location where 846 EDI files are stored (e.g.,
/incoming
). -
Sender/Receiver Identifiers:
-
Our Sender/Receiver ID:
FLXPOINT
(example). -
Our Sender/Receiver Qualifier:
ZZ
. -
Their Sender/Receiver ID: Example:
9549720473T
. -
Their Sender/Receiver Qualifier:
12
.
-
Our Sender/Receiver ID:
- Warehouse Selection: Choose which warehouses to update (e.g., Clinton Township, Pompano Beach, Norfolk).
Follow these steps to set up the Land 'N' Sea - Get Inventory [Secondary] integration:
- 1 Establish FTP Connection: Enter the FTP credentials provided by Land 'N' Sea (Connection Name, FTP Protocol, FTP Host, FTP Port, FTP User, FTP Password). Test the connection to verify it works before saving.
- 2 Configure Advanced Settings (Optional): Enable "Maintain Constant Connection" for uninterrupted data transfers if needed.
-
3 Define Data Folder: Set the Inbound Remote File Folder to the location where 846 EDI files are stored (e.g.,
/incoming
). -
4 Set Sender/Receiver Identifiers: Configure identifiers (Our Sender/Receiver ID:
FLXPOINT
, Qualifier:ZZ
; Their Sender/Receiver ID: e.g.,9549720473T
, Qualifier:12
). - 5 Select Warehouses: Choose which warehouses to update (e.g., Clinton Township, Pompano Beach).
- 6 Create a Mapping Template: Use the Mapping Dashboard ("Land 'N' Sea - Get Inventory [Secondary]") to define how Land 'N' Sea’s fields map to your variant fields (details below).
- 7 Run the Integration: Run manually or schedule periodic updates to keep your inventory data current.
- The mapping screen is labeled “Land 'N' Sea - Get Inventory [Secondary]” in the Mapping Dashboard.
- Buttons available: Delete to remove the template, Duplicate to copy it, and Save to save changes.
- Sections include:
- From Value: Land 'N' Sea inventory fields (e.g., SKU, Unit Cost Price, Warehouse Quantities).
- To Inventory Variant Field: Flxpoint variant fields (e.g., SKU, Cost, Quantity).
- Mapping Options: Options like Field, Value, Mapping Set, and Rules for customization.
This section provides key details about the Land 'N' Sea - Get Inventory [Secondary] integration to help you understand the process:
- Current Date and Time: As of 08:52 AM -04 on Friday, May 16, 2025, this integration is fully operational for retrieving secondary inventory data from Land 'N' Sea.
- Land 'N' Sea Integration: Retrieves warehouse-specific quantities and pricing via 846 EDI files (Item-Warehouse format) from an FTP server.
- Supported Warehouses: Updates stock levels for multiple warehouses, such as Clinton Township, Pompano Beach, Norfolk, Houston, Fresno, and more.
- EDI File Format: The integration is coded for the Item-Warehouse format, which includes all warehouse details for each SKU in a single file.
Tip: Ensure the 846 EDI files are in the Item-Warehouse format, as the integration does not support the Warehouse-Item format.
Mapping Fields
Below are the fields you can map, with examples and purposes (labeled as "T" for text, "N" for numbers, as in the dashboard):
Land 'N' Sea - Get Inventory [Secondary] Mappings
Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
SKU (T) | Variant: SKU | LNS12345 | Identifies the product variant | Required |
Unit Cost Price (N) | Variant: Cost | 150.00 | Records the cost price of the variant | Optional |
Quantity (N) | Variant: Quantity | 50 | Records the total available quantity for the variant | Optional |
Pompano Beach Warehouse Quantity (N) | Variant: Quantity (Pompano Beach) | 20 | Records the quantity available in the Pompano Beach warehouse | Optional |
Norfolk Warehouse Quantity (N) | Variant: Quantity (Norfolk) | 15 | Records the quantity available in the Norfolk warehouse | Optional |
Clinton Township Warehouse Quantity (N) | Variant: Quantity (Clinton Township) | 10 | Records the quantity available in the Clinton Township warehouse | Optional |
Houston Warehouse Quantity (N) | Variant: Quantity (Houston) | 12 | Records the quantity available in the Houston warehouse | Optional |
Fresno Warehouse Quantity (N) | Variant: Quantity (Fresno) | 8 | Records the quantity available in the Fresno warehouse | Optional |
Available Source Fields
Land 'N' Sea provides fields from the 846 EDI file (Item-Warehouse format), including:
- Inventory Data: SKU (T), Unit Cost Price (N), Quantity (N), and warehouse-specific quantities (N) for Clinton Township, Eagan, Fresno, Grand Rapids, Houston, Kansas City, Kent, Lake Suzy, Norcross, Norfolk, Oldlyme, Pompano Beach, and Shreveport.
Mapping Options
You can choose from the following options for each field:
- Field: Link a Land 'N' Sea field (e.g., Quantity) to a Flxpoint variant field.
- Value: Choose a fixed value for the field.
- Mapping Set: Use preset tools to adjust data (e.g., combine fields).
- Rules: Add "if-then" logic (e.g., only map if quantity > 0).
- Don’t Map: Ignore the field entirely.
- Set to Empty: Clear the field in the Flxpoint inventory, removing existing data.
If the integration encounters an issue, try these steps:
- FTP Connection Failure: Verify your FTP credentials (host, port, user, password) and test the connection again.
-
File Not Found: Ensure the Inbound Remote File Folder is correctly set (e.g.,
/incoming
) and that the supplier has uploaded the 846 EDI file. - Incorrect EDI Format: Confirm that the 846 EDI file is in the Item-Warehouse format, as the integration does not support the Warehouse-Item format.
- Warehouse Data Missing: Verify that the selected warehouses are supported and that the EDI file includes data for those warehouses.
Conclusion
With the Land 'N' Sea - Get Inventory [Secondary] integration, you can efficiently retrieve and map warehouse-specific quantities and pricing details into your Flxpoint system. Automated file retrieval and flexible mapping options ensure your inventory management across multiple warehouses is accurate and streamlined.
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
Supported | Land 'N' Sea - Send Fulfillment Requests
Introduction to Land 'N' Sea - Send Fulfillment Requests Integration
The Land 'N' Sea - Send Fulfillment Requests integration enables seamless automation of purchase order submissions, optimizing operational efficiency while reducing manual effort. This integration streamlines the flow of fulfillment requests for Land 'N' Sea orders via FTP, ensuring accurate data transfer through customizable mapping templates. This guide walks you through the setup process. Let’s get started!
The Land 'N' Sea - Send Fulfillment Requests integration enables you to:
- Automate the submission of purchase orders (fulfillment requests) to Land 'N' Sea, reducing manual input.
- Map your order data to Land 'N' Sea’s requirements for accurate fulfillment.
- Schedule submissions and align them with business hours for faster processing.
The integration follows a structured process to send fulfillment requests to Land 'N' Sea:
- Connect: Establish an FTP connection with Land 'N' Sea using provided credentials.
- Configure: Set up file folders, sender/receiver details, and order processing options (e.g., Purchase Order Type, hold periods).
- Map: Define how your order data (e.g., SKU, quantity, shipping methods) maps to Land 'N' Sea’s fields in the EDI 850 document.
- Submit: Automatically submit fulfillment requests to the Outbound Remote File Folder, with notifications for success or failure. Submissions can be scheduled or restricted to business hours.
Customize the integration to fit your needs:
-
FTP Connection Settings:
- Connection Name: A name for your connection.
- FTP Protocol: Choose FTP, SFTP, or FTPS.
- FTP Host: Provided by the supplier.
- FTP Port: Standard port for the chosen protocol.
- FTP Username & Password: Provided by the supplier.
- Maintain Constant Connection: Enable to ensure uninterrupted performance (optional).
- Unbuffered Private Data Channel: Enable to resolve FTPS-specific SSL issues (optional).
-
File Folders:
- Outbound Remote File Folder: Location for outgoing fulfillment requests (EDI 850 documents).
- 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
.
-
Our Sender/Receiver Qualifier:
-
Order Processing Options:
-
Purchase Order Type: Set to
DS-Dropship
for dropship orders. - Hold for X Hours: Delay submissions for final checks or edits.
- Send During Business Hours: Restrict submissions to Land 'N' Sea’s working hours.
-
Purchase Order Type: Set to
Follow these steps to set up the Land 'N' Sea - Send Fulfillment Requests integration:
- 1 Select Integration Type: Choose Land 'N' Sea as your integration type.
- 2 Establish FTP Connection: Enter the FTP credentials (Connection Name, FTP Host, FTP Protocol, FTP Port, FTP Username, FTP Password). Use the Test Connection feature to verify connectivity before saving.
- 3 Configure Advanced Settings (Optional): Enable "Maintain Constant Connection" for uninterrupted performance or "Unbuffered Private Data Channel" for FTPS SSL issues.
- 4 Set File Folders: Specify the Outbound Remote File Folder for sending requests and the Inbound Remote File Folder for monitoring responses.
-
5 Configure Sender/Receiver Details: Set identifiers (Our Sender/Receiver Qualifier:
ZZ
, ID:FLXPOINT
; Their Sender/Receiver Qualifier:12
, ID:9549720473
). -
6 Set Order Processing Options: Choose the Purchase Order Type (
DS-Dropship
), set a hold period if needed, and enable business hours restrictions. - 7 Create a Mapping Template: Use the Mapping Dashboard ("Land 'N' Sea - Send Fulfillment Requests") to define how your order fields map to Land 'N' Sea’s requirements (details below).
- 8 Automate the Process: Schedule submissions and enable notifications for successful or failed requests.
- The mapping screen is labeled “Land 'N' Sea - Send Fulfillment Requests” in the Mapping Dashboard.
- Buttons available: Delete to remove the template, Duplicate to copy it, and Save to save changes.
- Sections include:
- From Value: Flxpoint fields (e.g., Fulfillment Request Item: SKU, Source Shipping Method: Carrier).
- To Land 'N' Sea Order Item Field: Land 'N' Sea fields (e.g., Buyer's Part Number, Quantity, Shipping Carrier Code).
- Mapping Options: Options like Field, Value, Mapping Set, and Rules for customization.
This section provides key details about the Land 'N' Sea - Send Fulfillment Requests integration to help you understand the process:
- Current Date and Time: As of 08:57 AM -04 on Friday, May 16, 2025, this integration is fully operational for sending fulfillment requests to Land 'N' Sea.
- Land 'N' Sea Integration: Submits purchase orders (EDI 850 documents) to Land 'N' Sea via FTP, supporting automated processing and scheduling.
-
Supported Operations:
- Fulfillment Request Numbers: Sent in the BEG03 segment for tracking.
- FR Item Association: Maps SKUs, quantities, and shipping codes for accurate fulfillment.
- Shipping Selection: Allows mapping of supplier-approved shipping methods.
-
Limitations:
- Customer Association: Not supported.
- Auto Acknowledgements: Not supported.
- Custom Fields and Attachments: Adding additional fields or attachments to requests is unavailable.
-
N104 Field Mapping Logic:
- If Purchase Order Type =
DS-Dropship
, the N104 value in the EDI 850 document is set to303
(used for fulfillment orders). - For all other order types (e.g.,
CN-Consigned
,ST-Stock
), N104 is set to02
.
- If Purchase Order Type =
Tip: Align submissions with Land 'N' Sea’s business hours to ensure faster processing of your fulfillment requests.
Mapping Fields
Below are the fields you can map, with examples and purposes (labeled as "T" for text, "N" for numbers, as in the dashboard):
Land 'N' Sea - Send Fulfillment Requests Mappings
Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
SKU (T) | Vendor's Item Number (VN) | LNS12345 | Identifies the product SKU in the fulfillment request | Required |
SKU (T) | Buyer's Part Number (BP) | LNS12345 | Records the buyer's part number for the item | Optional |
Title (T) | Part Number Description (PD) | Marine GPS Unit | Records the description of the part number | Optional |
Quantity (N) | Quantity | 5 | Records the quantity ordered for the item | Required |
UPC (T) | UPC (UP) | 012345678905 | Records the UPC code for the item | Optional |
Carrier (T) | Shipping Carrier Code | UPS | Specifies the shipping carrier code | Optional |
Description (T) | Shipping Carrier Description | UPS Ground | Records the description of the shipping carrier | Optional |
Cost (N) | Unit Price | 150.00 | Records the unit price of the item | Optional |
Available Source Fields
Flxpoint provides fields under categories like:
- Fulfillment Request Item: Bin Location (T), Cost (N), MPN (T), PO Line Item # (N), Quantity (N), SKU (T), Subtotal (N), Title (T), UPC (T).
- Source Shipping Method: Carrier (T), Description (T), Method (T), Shipping Code (T).
Mapping Options
You can choose from the following options for each field:
- Field: Link a Flxpoint field (e.g., SKU) to a Land 'N' Sea field.
- Value: Choose a fixed value for the field.
- Mapping Set: Use preset tools to adjust data (e.g., combine fields).
- Rules: Add "if-then" logic (e.g., only map if quantity > 0).
- Don’t Map: Ignore the field entirely.
- Set to Empty: Clear the field in the Land 'N' Sea request, removing existing data.
If the integration encounters an issue, try these steps:
- FTP Connection Failure: Verify your FTP credentials (host, port, username, password) and test the connection again. If using FTPS, enable "Unbuffered Private Data Channel" to resolve SSL issues.
- File Submission Failure: Ensure the Outbound Remote File Folder is correctly configured and accessible by Land 'N' Sea.
-
Incorrect N104 Value: Confirm the Purchase Order Type is set correctly (
DS-Dropship
for N104 =303
, other types for N104 =02
). - Missing Required Fields: Ensure fields like SKU and Quantity are mapped, as they are required for successful submission.
Conclusion
With the Land 'N' Sea - Send Fulfillment Requests integration, you can efficiently automate purchase order submissions to Land 'N' Sea, streamlining your order fulfillment process. Flexible configuration, custom mapping templates, and automated scheduling ensure operational alignment and accuracy.
Get Shipments
Supported | Land 'N' Sea - Get Shipments
Introduction to Land 'N' Sea - Get Shipments Integration
The Land 'N' Sea - Get Shipments integration automates the retrieval of shipment details for orders fulfilled by Land 'N' Sea. This integration connects to Land 'N' Sea’s FTP server to download shipment data, processes it, and maps the information to your Flxpoint system for seamless tracking updates. This guide walks you through the setup process. Let’s get started!
The Land 'N' Sea - Get Shipments integration enables you to:
- Retrieve shipment details for orders fulfilled by Land 'N' Sea via FTP.
- Map shipment data (e.g., SKU, UPC) to your Flxpoint system for accurate tracking.
- Automate tracking updates to streamline order fulfillment monitoring.
The integration follows a structured process to retrieve and map shipment data from Land 'N' Sea:
- FTP Connection: Connects to Land 'N' Sea’s FTP server using provided credentials.
- File Retrieval: Downloads shipment data (e.g., EDI 856 files) from the configured Inbound Remote File Folder, which includes details like SKU, Buyer's Item Number, and UPC.
- Data Processing: Extracts shipment details from the files for mapping.
- Shipment Updates: Maps the data to your Flxpoint system’s shipment item fields for tracking updates.
Customize the integration to fit your needs:
-
FTP Connection Settings:
- Connection Name: A name for your connection.
- FTP Protocol: Choose FTP, SFTP, or FTPS.
- FTP Host: Provided by the supplier.
- FTP Port: Standard port for the chosen protocol.
- FTP Username & Password: Provided by the supplier.
- Maintain Constant Connection: Enable to ensure uninterrupted performance (optional).
- Unbuffered Private Data Channel: Enable to resolve FTPS-specific SSL issues (optional).
-
File Folders:
- Inbound Remote File Folder: Folder to monitor for incoming shipment files (e.g., EDI 856).
-
Sender/Receiver Details:
-
Our Sender/Receiver Qualifier:
ZZ
. -
Our Sender/Receiver ID:
FLXPOINT
. -
Their Sender/Receiver Qualifier:
12
. -
Their Sender/Receiver ID:
9549720473
.
-
Our Sender/Receiver Qualifier:
Follow these steps to set up the Land 'N' Sea - Get Shipments integration:
- 1 Select Integration Type: Choose Land 'N' Sea as your integration type.
- 2 Establish FTP Connection: Enter the FTP credentials (Connection Name, FTP Host, FTP Protocol, FTP Port, FTP Username, FTP Password). Use the Test Connection feature to verify connectivity before saving.
- 3 Configure Advanced Settings (Optional): Enable "Maintain Constant Connection" for uninterrupted performance or "Unbuffered Private Data Channel" for FTPS SSL issues.
- 4 Set File Folder: Specify the Inbound Remote File Folder to monitor for incoming shipment files.
-
5 Configure Sender/Receiver Details: Set identifiers (Our Sender/Receiver Qualifier:
ZZ
, ID:FLXPOINT
; Their Sender/Receiver Qualifier:12
, ID:9549720473
). - 6 Create a Mapping Template: Use the Mapping Dashboard ("Land 'N' Sea - Get Shipments") to define how Land 'N' Sea’s shipment fields map to your shipment item fields (details below).
- 7 Automate the Process: Schedule periodic retrievals to keep your shipment data up-to-date.
- The mapping screen is labeled “Land 'N' Sea - Get Shipments” in the Mapping Dashboard.
- Buttons available: Delete to remove the template, Duplicate to copy it, and Save to save changes.
- Sections include:
- From Value: Land 'N' Sea shipment fields (e.g., SKU, UPC).
- To Shipment Item Field: Flxpoint shipment item fields (e.g., Sku).
- Mapping Options: Options like Field, Value, Mapping Set, and Rules for customization.
This section provides key details about the Land 'N' Sea - Get Shipments integration to help you understand the process:
- Current Date and Time: As of 09:20 AM -04 on Friday, May 16, 2025, this integration is fully operational for retrieving shipment data from Land 'N' Sea.
- Land 'N' Sea Integration: Retrieves shipment details via FTP, likely using EDI 856 files, which include fields like SKU, Buyer's Item Number, and UPC.
- Supported Operations: Maps shipment item details for tracking updates in your Flxpoint system.
- Limitations: Does not support custom fields or attachments in shipment data.
Tip: Ensure your FTP credentials are correctly configured to avoid delays in retrieving shipment data.
Mapping Fields
Below are the fields you can map, with examples and purposes (labeled as "T" for text, as in the dashboard):
Land 'N' Sea - Get Shipments Mappings
Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
SKU (T) | Shipment Item: Sku | LNS12345 | Identifies the product in the shipment | Required |
Buyer's Item Number (IN) (T) | Shipment Item: Buyer's Item Number | BUY123 | Records the buyer's item number for the product | Optional |
UPC (T) | Shipment Item: UPC | 012345678905 | Records the UPC code for the product | Optional |
Vendor's Item Number (VN) (T) | Shipment Item: Vendor's Item Number | VEN456 | Records the vendor's item number for the product | Optional |
Available Source Fields
Land 'N' Sea provides fields from the shipment data, including:
- Shipment Item: Buyer's Item Number (IN) (T), SKU (T), UPC (T), Unit Measurement Code (T), Vendor's Item Number (VN) (T).
Mapping Options
You can choose from the following options for each field:
- Field: Link a Land 'N' Sea field (e.g., SKU) to a Flxpoint shipment item field.
- Value: Choose a fixed value for the field.
- Mapping Set: Use preset tools to adjust data (e.g., combine fields).
- Rules: Add "if-then" logic (e.g., only map if SKU is present).
- Don’t Map: Ignore the field entirely.
- Set to Empty: Clear the field in the Flxpoint shipment, removing existing data.
If the integration encounters an issue, try these steps:
- FTP Connection Failure: Verify your FTP credentials (host, port, username, password) and test the connection again. If using FTPS, enable "Unbuffered Private Data Channel" to resolve SSL issues.
- File Not Found: Ensure the Inbound Remote File Folder is correctly configured and that Land 'N' Sea has uploaded the shipment files (e.g., EDI 856).
- Missing Shipment Data: Confirm that the shipment files include the expected data (e.g., SKU, UPC) and that the order has been fulfilled by Land 'N' Sea.
- Mapping Issues: Ensure required fields like Sku are mapped correctly in the Mapping Dashboard.
Conclusion
With the Land 'N' Sea - Get Shipments integration, you can efficiently retrieve and map shipment details into your Flxpoint system, ensuring accurate tracking updates. Automated retrieval and flexible mapping options streamline your order fulfillment monitoring process.
Get Fulfillment Acknowledgements
Supported | Land 'N' Sea - Get Fulfillment Acknowledgements
Introduction to Land 'N' Sea - Get Fulfillment Acknowledgements Integration
The Land 'N' Sea - Get Fulfillment 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 in your Flxpoint system. This guide walks you through the setup process. Let’s get started!
The Land 'N' Sea - Get Fulfillment Acknowledgements integration enables you to:
- Retrieve and process EDI 855 files from Land 'N' Sea to confirm fulfillment request statuses.
- Map acknowledgement data (e.g., Acceptance Code, Quantity) to your Flxpoint system for real-time updates.
- Automate the tracking of order confirmations and cancellations with minimal manual intervention.
The integration follows a structured process to retrieve and map fulfillment acknowledgement data from Land 'N' Sea:
- FTP Connection: Connects to Land 'N' Sea’s FTP server using existing or new credentials.
- File Retrieval: Downloads EDI 855 files from the configured Inbound Remote File Folder, which contain acknowledgement details like Acceptance Code and Quantity.
- Data Processing: Extracts data from the EDI 855 files, including acceptance or rejection statuses and quantities.
- Acknowledgement Updates: Maps the data to your Flxpoint system’s Fulfillment Request Acknowledgement Item fields for real-time order status updates.
Customize the integration to fit your needs:
-
FTP Connection Settings:
- Connection Name: A name for your connection (can reuse the "Send Fulfillment Requests" connection).
- FTP Protocol: Choose FTP, SFTP, or FTPS.
- FTP Host: Provided by the supplier.
- FTP Port: Standard port for the chosen protocol.
- FTP Username & Password: Provided by the supplier.
- Maintain Constant Connection: Enable to ensure uninterrupted performance (optional).
- Unbuffered Private Data Channel: Enable to resolve FTPS-specific SSL issues (optional).
-
File Folders:
- Outbound Remote File Folder: Location for processed files on the FTP server.
- Inbound Remote File Folder: Folder to monitor for incoming EDI 855 files.
-
Qualifiers and Identifiers:
-
Our Sender/Receiver Qualifier:
ZZ
. -
Our Sender/Receiver ID:
FLXPOINT
. -
Their Sender/Receiver Qualifier:
12
. -
Their Sender/Receiver ID:
9549720473
.
-
Our Sender/Receiver Qualifier:
-
Purchase Order Type: Set to
DS-Dropship
to align with the type of orders being acknowledged.
Follow these steps to set up the Land 'N' Sea - Get Fulfillment Acknowledgements integration:
- 1 Establish FTP Connection: Use the existing "Send Fulfillment Requests" connection or create a new one. Enter the FTP credentials (Connection Name, FTP Protocol, FTP Host, FTP Port, FTP Username, FTP Password). Test the connection to verify it works before saving.
- 2 Configure Advanced Settings (Optional): Enable "Maintain Constant Connection" for uninterrupted performance or "Unbuffered Private Data Channel" for FTPS SSL issues.
- 3 Set File Folders: Specify the Outbound Remote File Folder for processed files and the Inbound Remote File Folder to monitor for EDI 855 files.
-
4 Configure Qualifiers and Identifiers: Set identifiers (Our Sender/Receiver Qualifier:
ZZ
, ID:FLXPOINT
; Their Sender/Receiver Qualifier:12
, ID:9549720473
). -
5 Set Purchase Order Type: Configure the Purchase Order Type to
DS-Dropship
. - 6 Create a Mapping Template: Use the Mapping Dashboard ("Land 'N' Sea - Get Fulfillment Acknowledgements") to define how Land 'N' Sea’s acknowledgement fields map to your system (details below).
- 7 Automate the Process: Enable scheduling to retrieve acknowledgement files automatically and receive notifications for each run.
- The mapping screen is labeled “Land 'N' Sea - Get Fulfillment Acknowledgements” in the Mapping Dashboard.
- Buttons available: Delete to remove the template, Duplicate to copy it, and Save to save changes.
- Sections include:
- From Value: Land 'N' Sea acknowledgement fields (e.g., Acceptance Code, Quantity).
- To Fulfillment Request Acknowledgement Item Field: Flxpoint fields (e.g., Acknowledgement Code, Quantity).
- Mapping Options: Options like Field, Value, Mapping Set, and Rules for customization.
This section provides key details about the Land 'N' Sea - Get Fulfillment Acknowledgements integration to help you understand the process:
- Current Date and Time: As of 09:36 AM -04 on Friday, May 16, 2025, this integration is fully operational for retrieving fulfillment acknowledgements from Land 'N' Sea.
- Land 'N' Sea Integration: Retrieves EDI 855 files via FTP, which contain acknowledgement details for fulfillment requests.
-
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: Supports partial acknowledgements, varying by provided data.
- Limitations: Does not support IB (Item Backordering) within this integration.
Tip: Reuse your existing "Send Fulfillment Requests" FTP connection to simplify setup and ensure consistency.
Mapping Fields
Below are the fields you can map, with examples and purposes (labeled as "T" for text, "N" for numbers, as in the dashboard):
Land 'N' Sea - Get Fulfillment Acknowledgements Mappings
Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
Acceptance Code (T) | Acknowledgement Code | IA (Item Accepted) | Indicates the acceptance or rejection status of the item | Required |
Quantity (N) | Quantity | 5 | Records the acknowledged quantity for the item | Required |
Vendor's Item Number (VN) (T) | SKU | LNS12345 | Matches the acknowledged item to the SKU in your system | Optional |
Acceptance Code (T) | Acknowledged Status | True (if IA) | Tracks whether the item is acknowledged (True) or canceled (False) | Optional |
UPC (UP) (T) | UPC | 012345678905 | Records the UPC code for the acknowledged item | Optional |
Available Source Fields
Land 'N' Sea provides fields from the EDI 855 file, including:
- Fulfillment Request Acknowledgement Item: Acceptance Code (T), Quantity (N).
- Order Item: Buyer's Part Number (BP) (T), Part Number Description (PD) (T), Quantity (N), UPC (UP) (T), Unit Measurement Code (T), Unit Price (N), Vendor's Catalog Number (CB) (T), Vendor's Item Number (VN) (T).
Mapping Options
You can choose from the following options for each field:
- Field: Link a Land 'N' Sea field (e.g., Quantity) to a Flxpoint field.
- Value: Choose a fixed value for the field.
- Mapping Set: Use preset tools to adjust data (e.g., combine fields).
- Rules: Add "if-then" logic (e.g., only map if Acceptance Code is "IA").
- Don’t Map: Ignore the field entirely.
- Set to Empty: Clear the field in the Flxpoint system, removing existing data.
If the integration encounters an issue, try these steps:
- FTP Connection Failure: Verify your FTP credentials (host, port, username, password) and test the connection again. If using FTPS, enable "Unbuffered Private Data Channel" to resolve SSL issues.
- File Not Found: Ensure the Inbound Remote File Folder is correctly configured and that Land 'N' Sea has uploaded the EDI 855 files.
- Missing Acknowledgement Data: Confirm that the EDI 855 files include the expected data (e.g., Acceptance Code, Quantity) and that the order has been processed by Land 'N' Sea.
- Mapping Issues: Ensure required fields like Acknowledgement Code and Quantity are mapped correctly in the Mapping Dashboard.
Conclusion
With the Land 'N' Sea - Get Fulfillment Acknowledgements integration, you can efficiently retrieve and process EDI 855 files, ensuring real-time updates on order statuses in your Flxpoint system. Automated scheduling, custom mapping, and seamless integration streamline your order management process.
Get Invoices
Supported | Land 'N' Sea - Get Invoices
Introduction to Land 'N' Sea - Get Invoices Integration
The Land 'N' Sea - Get Invoices integration automates the retrieval and processing of invoice data by downloading 810 EDI files from a configured FTP location, parsing the data, and generating matching invoices in your Flxpoint system. This process reduces manual effort, ensures timely updates, and improves invoice accuracy. This guide walks you through the setup process. Let’s get started!
The Land 'N' Sea - Get Invoices integration enables you to:
- Automate the retrieval of invoice data from Land 'N' Sea via 810 EDI files.
- Parse and map invoice data to generate accurate invoices in your Flxpoint system.
- Send acknowledgments to the supplier, ensuring seamless communication and timely updates.
The integration follows a structured process to retrieve and process invoice data from Land 'N' Sea:
- FTP Connection: Connects to Land 'N' Sea’s FTP server using provided credentials.
-
File Retrieval: Downloads 810 EDI files from the configured Inbound Remote File Folder (e.g.,
/lns-invoices
), which contain invoice details like SKU, Quantity, and Unit Price. - Data Processing: Parses the 810 EDI files and generates invoices that match the associated Fulfillment Requests (FR).
-
Acknowledgment: Sends acknowledgment files back to Land 'N' Sea via the Outbound Remote File Folder (e.g.,
/lns-invoices
) for processed invoices.
Customize the integration to fit your needs:
-
FTP Connection Settings:
- Connection Name: A name for your connection.
- FTP Protocol: Choose FTP, SFTP, or FTPS.
-
FTP Host: Provided by the supplier (e.g.,
ftp.fixpoint.com
). - FTP Port: Standard port (e.g., 21 for FTP).
- FTP User & Password: Provided by the supplier.
- Maintain Constant Connection: Enable to ensure uninterrupted FTP sessions for large file transfers (optional).
-
File Folders:
-
Inbound Remote File Folder: Set to the location where 810 EDI files are retrieved (e.g.,
/lns-invoices
). -
Outbound Remote File Folder: Set to the location where acknowledgments are sent after processing (e.g.,
/lns-invoices
).
-
Inbound Remote File Folder: Set to the location where 810 EDI files are retrieved (e.g.,
-
Sender/Receiver Identifiers:
-
Our Sender/Receiver ID:
FLXPOINT
. -
Our Sender/Receiver Qualifier:
ZZ
. -
Their Sender/Receiver ID:
9549720473T
. -
Their Sender/Receiver Qualifier:
12
.
-
Our Sender/Receiver ID:
Follow these steps to set up the Land 'N' Sea - Get Invoices integration:
- 1 Establish FTP Connection: Enter the FTP credentials provided by Land 'N' Sea (Connection Name, FTP Protocol, FTP Host, FTP Port, FTP User, FTP Password). Test the connection to verify it works before saving.
- 2 Configure Advanced Settings (Optional): Enable "Maintain Constant Connection" for uninterrupted FTP sessions if needed.
-
3 Define File Locations: Set the Inbound Remote File Folder (e.g.,
/lns-invoices
) to retrieve 810 EDI files and the Outbound Remote File Folder (e.g.,/lns-invoices
) for sending acknowledgments. -
4 Set Sender/Receiver Identifiers: Configure identifiers (Our Sender/Receiver ID:
FLXPOINT
, Qualifier:ZZ
; Their Sender/Receiver ID:9549720473T
, Qualifier:12
). - 5 Create a Mapping Template: Use the Mapping Dashboard ("Land 'N' Sea - Get Invoices") to define how Land 'N' Sea’s invoice fields map to your Source Invoice Item fields (details below).
- 6 Automate the Process: Enable scheduling to retrieve and process invoice files automatically.
- The mapping screen is labeled “Land 'N' Sea - Get Invoices” in the Mapping Dashboard.
- Buttons available: Delete to remove the template, Duplicate to copy it, and Save to save changes.
- Sections include:
- From Value: Land 'N' Sea invoice fields (e.g., SKU, Quantity, Unit Price).
- To Source Invoice Item Field: Flxpoint invoice fields (e.g., Cost, Quantity, SKU).
- Mapping Options: Options like Field, Value, Mapping Set, and Rules for customization.
This section provides key details about the Land 'N' Sea - Get Invoices integration to help you understand the process:
- Current Date and Time: As of 09:45 AM -04 on Friday, May 16, 2025, this integration is fully operational for retrieving invoice data from Land 'N' Sea.
- Land 'N' Sea Integration: Downloads 810 EDI files via FTP, parses the data, and generates matching invoices in your Flxpoint system.
-
Supported Operations:
- Automated Retrieval: Fetches invoices from the configured FTP folder.
- Data Parsing: Processes standard 810 EDI files to generate accurate invoices.
- Acknowledgment Automation: Sends confirmation for processed invoices to the supplier.
Tip: Ensure the Inbound and Outbound Remote File Folders are correctly configured to avoid issues with file retrieval or acknowledgment submission.
Mapping Fields
Below are the fields you can map, with examples and purposes (labeled as "T" for text, "N" for numbers, as in the dashboard):
Land 'N' Sea - Get Invoices Mappings
Field | Maps To | Example | Purpose | Status |
---|---|---|---|---|
SKU (T) | Source Invoice Item: SKU | LNS12345 | Identifies the product on the invoice | Required |
Quantity (N) | Source Invoice Item: Quantity | 5 | Records the quantity invoiced for the item | Required |
Unit Price (N) | Source Invoice Item: Per Unit Cost | 150.00 | Records the per-unit cost of the item | Optional |
Unit Price (N) | Source Invoice Item: Cost | 150.00 | Records the total cost of the item (can be derived as Unit Price) | Optional |
UPC Consumer Package Code (T) | Source Invoice Item: UPC | 012345678905 | Records the UPC code for the invoiced item | Optional |
Available Source Fields
Land 'N' Sea provides fields from the 810 EDI file, including:
- Invoice Item: Buyer's Item Number (T), Quantity (N), Replacement Product Number (T), SKU (T), UPC Consumer Package Code (T), Unit Measurement Code (T), Unit Price (N), Vendor's Item Number (T).
Mapping Options
You can choose from the following options for each field:
- Field: Link a Land 'N' Sea field (e.g., Quantity) to a Flxpoint invoice field.
- Value: Choose a fixed value for the field.
- Mapping Set: Use preset tools to adjust data (e.g., combine fields).
- Rules: Add "if-then" logic (e.g., only map if quantity > 0).
- Don’t Map: Ignore the field entirely.
- Set to Empty: Clear the field in the Flxpoint invoice, removing existing data.
If the integration encounters an issue, try these steps:
- FTP Connection Failure: Verify your FTP credentials (host, port, user, password) and test the connection again.
-
File Not Found: Ensure the Inbound Remote File Folder (e.g.,
/lns-invoices
) is correctly set and that Land 'N' Sea has uploaded the 810 EDI files. -
Acknowledgment Not Sent: Confirm that the Outbound Remote File Folder (e.g.,
/lns-invoices
) is accessible and properly configured for sending acknowledgments. - Mapping Issues: Ensure required fields like SKU and Quantity are mapped correctly in the Mapping Dashboard.
Conclusion
With the Land 'N' Sea - Get Invoices integration, you can efficiently retrieve and process invoice data from 810 EDI files, generating accurate invoices in your Flxpoint system. Automated retrieval, data parsing, and acknowledgment features ensure timely updates and improved accuracy.