CWR as a Source
July 2, 2026
Summary
CWR (CWR Wholesale Distribution) is a marine, outdoor, and electronics distributor connected to Flxpoint over FTP with basic authentication. One connection powers every job: Get Inventory Primary reads both a catalog file and an inventory file, Get Inventory Secondary reads only the inventory file, Send Fulfillment Requests writes orders as CSV to CWR's /in folder (CWR must enable the feed first), and Get Shipments reads tracking from the /out/shipping folder.
What this integration does
Get Inventory (Primary)
Imports the full CWR catalog – reads both the inventory file (stock & pricing) and the catalog file (product details, images, dimensions)
Get Inventory (Secondary)
Reads only the inventory file to refresh SKU, quantity, and pricing on a more frequent schedule
Send Fulfillment Requests
Writes orders as CSV files to CWR's /in folder for fulfillment – CWR must enable the feed first
Get Shipments
Pulls tracking and invoice data from the /out/shipping folder and links it back to fulfillment requests
How to connect - credentials you need
Go to Sources, click +, choose CWR, then create a New Connection and enter the FTP details CWR provided. Click Test Connection, then Save Connection.
FTP HostRequired
The CWR FTP server address. Enter
The same host is used for every CWR job.
edi.cwrdistribution.com.FTP PortRequired
Enter
Standard FTP port.
21.FTP UsernameRequired
Your CWR FTP username.
Provided by CWR – request it from your CWR account rep.
FTP PasswordRequired
The password paired with your FTP username.
Provided by CWR.
Don't have FTP credentials? They come directly from your CWR Wholesale Distribution account rep – contact CWR before configuring the source. If Test Connection returns a
403 Forbidden, your credentials may have expired or Flxpoint's IP may need to be whitelisted by CWR. Flxpoint's outbound IP addresses are 52.44.101.151 and 52.1.186.211 – give these to CWR directly so you don't need to request them separately.Important - read before configuring
CWR must be notified to enable the Send Fulfillment Requests feed
Send FR writes order CSV files to CWR's /in directory. Please ensure CWR is ready to accept new orders. Contact CWR to enable FR processing before testing live orders – files written before activation are silently ignored.
Don't enable Archive on both Get Inventory Primary and Secondary – pick one
This is already limited at the system level: the Archive setting can be enabled either on Get Inventory Primary or on Get Inventory Secondary, never both – even if you wanted to. Let one job manage archival – typically Primary, since it reads the full catalog.
Primary reads two files; Secondary reads only the inventory file
Get Inventory Primary reads /out/inventory.csv (SKU-level stock and pricing) plus /out/catalog.csv (product details, images, dimensions). Get Inventory Secondary reads only /out/inventory.csv – run it on a more frequent schedule for quantity and price refreshes, and reserve Primary for full catalog syncs.
Multi-warehouse stock defaults to a single "Combined" column
By default CWR's FTP feed combines all warehouse stock into one quantity column. Separating warehouse-level quantities requires custom configuration – contact Flxpoint Support to discuss multi-warehouse mapping for your CWR feed.
Mapping - fields to know
| CWR Field | Maps To – Notes |
|---|---|
| Parent SKU | Maps to Cwr Part Number. Links product variants; the primary product identifier. |
| Title | Maps to Title. Product name / title. |
| Description | Maps to Full Description. Detailed product description. |
| Categories | Up to three levels (Category One, Two, Three). |
| All Images | Direct Copy. Product images (large size preferred) are copied directly. |
| Dimensions | Maps to Box Length/Width/Height, Shipping Weight. |
| Pricing | Maps to Your Cost, Map, Mrp. |
| Quantity | Maps to Qty/ Quantity Available to Ship. Warehouse-level stock; defaults to a single Combined column. |
| Returnable / Harmonization Code / Country of Origin | Extra fields exposed in the CWR Product Feed template – map for compliance filtering (e.g. Do Not Import rules). |
| Uppercase Title / Installation Guide URL / FCC ID | Additional CWR-specific attributes available for mapping. |
| Case Qty NJ / Case Qty FL / 3rd Party Marketplaces | Warehouse case quantities and marketplace eligibility flags. |
Reads only
/out/inventory.csv to refresh SKU, Quantity, and Pricing (price, map, msrp) plus client-specific price tiers – it does not pull catalog details, images, or dimensions (those come from Primary). Run it on a more frequent schedule than Primary. Custom rules can adjust incoming data (e.g. prefix incoming SKUs with ELC). A File Read Error usually means a missing file or unexpected format – verify the FTP folder and that headers match sku, qty, price.| CSV Field | Notes |
|---|---|
| Order ID | Maps to the Flxpoint Fulfillment Request Number. Files are written to /in as CWR_{source_id}_{poID}.csv. |
| SKU | Product identifier for each line item. |
| Quantity | Order item quantity. |
| Name / Street Address / Address 2 / City / State / Zip / Country | Ship-to address for the order. |
| ShipVia | Shipping method – must use a valid CWR shipping code (see the shipping FAQ). |
| Comment for CWR / Packing Slip Comment | Optional notes passed to CWR and printed on the packing slip. |
| Signature Required | Flags whether the shipment requires a signature. Custom fields and auto acknowledgements are not supported over FTP. |
| CWR Field | Maps To – Notes |
|---|---|
| Customer PO | Read from CWR's /out/shipping folder; matches the shipment to the originating Fulfillment Request (FR#) – the PO sent during Send FR. |
| Tracking Number | Enables tracking; also used to group multiple shipments for one order. |
| Carrier & Method | Identifies the shipping carrier and service used. |
| Quantity | Number of items shipped (supports partial shipments). |
| Invoice Information | Invoice data captured from the shipment file, when available. |
Common issues
FTP connection failing – 403 Forbidden across CWR and other sources
A
403 Forbidden (Unsuccessful HTTP response 403 - Forbidden) usually means your FTP credentials expired, changed, or were suspended – or Flxpoint's IP needs to be whitelisted by CWR. Click Test Connection in the CWR source settings; if the credentials are correct but the error persists, contact CWR to confirm your FTP access is active and Flxpoint's IP is not blocked.Orders written to CWR's /in folder but not being processed
The FTP write succeeds on Flxpoint's side, but CWR ignores the files until their team activates order processing for your account. Contact CWR to confirm the order feed is enabled. Also verify the CSV contains the required fields (Order ID, SKU, Quantity, full shipping address) and that
ShipVia uses a valid CWR shipping code.Wrong cost when the same SKU is linked to both CWR and Keystone
When a SKU is sourced from both CWR and Keystone (e.g.
CWR43463, CWR55431), Flxpoint routes to the lowest-cost source by default, which can surface an unexpected cost. Review the source-level pricing rule for dual-sourced SKUs and, where costs differ significantly, set an explicit routing-priority rule instead of relying on automatic cheapest-source selection.Truck-freight or remanufactured items importing when they should be excluded
CWR's feed includes truck-freight and remanufactured fields but no named "non-returnable" indicator. Create Post-Mapping Workflow Do Not Import rules using the truck-freight and remanufactured fields, and use the Returnable field to filter out items where Returnable is false or empty. These rules must be set at the CWR source level – a single cross-source rule isn't supported because field names vary by supplier.
FAQs
What FTP credentials do I need to connect CWR?▸
CWR provides all FTP credentials directly – a Username and Password. Enter them in the FTP (Basic Auth) connection using host edi.cwrdistribution.com on port
21 with the FTP protocol (not SFTP or FTPS). Credentials come from your CWR account rep; if you don't have them, contact CWR Wholesale Distribution before configuring the source.What fields does CWR expose that most other sources don't?▸
Beyond standard product data, CWR's mapping template exposes Returnable, Harmonization Code, Country of Origin, Uppercase Title, Installation Guide URL, Case Qty NJ, Case Qty FL, 3rd Party Marketplaces, and FCC ID. These are useful for compliance filtering – for example using Returnable for Do Not Import rules, or FCC ID for electronics certification. Note that CWR has no "Non-Returnable" field by name – filter using the Returnable field directly.
What does Send Fulfillment Requests write to CWR's FTP?▸
Send FR converts Flxpoint Fulfillment Requests to CSV and saves them to CWR's
/in directory, one file per order named CWR_{source_id}_{poID}.csv. Required fields include Order ID, Quantity, SKU, Name, Street Address, Address 2, City, State, Zip, Country, ShipVia, Comment for CWR, Packing Slip Comment, and Signature Required. Auto Acknowledgements are not supported – CWR doesn't return an acknowledgement over FTP, so FR status is managed manually or via Get Shipments.How does Get Shipments work for CWR?▸
Get Shipments reads files from the
/out/shipping folder on CWR's FTP, grouping shipments by Customer PO and Tracking Number. It matches CWR's shipment files to Flxpoint Fulfillment Requests using the PO number sent during Send FR. If a shipment file is missing or delayed, shipments won't import until CWR writes the file to the shipping folder.Where can I find CWR's shipping methods and rates?▸
CWR's current shipping options and rates are published at the CWR Shipping Update. Map the appropriate
ShipVia value to your Flxpoint shipping methods in the Send FR mapping template. CWR does not support real-time rate shopping over the FTP integration.