Vinosmith integrates with the Fond du Lac Warehouse (FDL). FDL is also known as Chilled Solutions (CS) in some markets.

The integration process involves the generation of two separate order files that need to be transmitted to FDL/CS via email or warehouse portal upload. Please contact your FDL/CS support representative for exact instructions.

Wine Setup

Your Wines must be entered into FDL/CS out of band from Vinosmith. The Code you use to reference the Wine at FDL must be either your top-level Wine Code -or- the Inventory-specific Warehouse Wine Code. You will need to be consistent and use the same wine identifying location for all wines in your portfolio and it's up to you to reconcile this with FDL/CS.

Please contact Vinosmith Support for additional information for any questions. 

Account Setup

Unlike Wines and requiring the Wine to exist at FDL/CS with a previously agreed upon Code; Accounts can be submitted on-the-fly to FDL via the export file. However, FDL does require each Account have a unique identifying field.

The Account Warehouse Code is the primary identifying field in Vinosmith that is transmitted to FDL for all deliveries. 

Important: the maximum length of this value is 10 characters.

You are required to generate a unique code of your choice and populate the Account: Warehouse Code field. Two common solutions:

1. The Account ID (the numeric value you can see in the URL of your browser. E.g. If the URL looks like "/rep/accounts/12345" then 12345 is the unique Account ID. You can copy this value from the URL and paste it into the Account: Warehouse Code field.

 

 

2. A combination of the Account Name and Shipping (not to exceed 10 characters) with any non-alphanumeric characters removed / not included. For example, if the Account Name is "Acme Wines" and the shipping street is "123 Main St" an example value would be "ACM123". In this case, the value is uppercased for aesthetics but it's not required.

Please Note: in some cases FDL requires an Value to be prefixed to all Account identifiers, Vinosmith can automate this aspect. For example: your Account Warehouse Code is "ABC123" but in FDL all of your accounts have a "XT" prefix. You would not need to actually have the Vinosmith Account Warehouse Code value be "XTABC123". Just "ABC123" and during order submission to FDL the "XT" value will be prefixed. If you need this functionality please contact Vinosmith Support via help@vinosmith.com

Important!

Once the Warehouse Code is generated and sent to FDL for the first time then FDL will lock-in the shipping address information for all subsequent deliveries. This means that if the shipping address changes for any reason you MUST generate a new Warehouse Code. For example: if the account has physically moved across town and the address changes then you would edit the Account and change its shipping address accordingly. In addition, you could then just append "A" (or any other character) to generate a new warehouse code. Please be careful not to exceed the 10 character limit.

How to Generate the FDL / CS Order Files

  1. Confirm Orders: during order confirmation choose the FDL or CS option for Deliver Via. 
  2. When you would like to generate a batch of one or more orders click on the Orders tab; in the left navigation, click on Pending Deliveries
  3. From the Pending Deliveries screen click on the Warehouse tab; you will see all of the Orders that you have recently confirmed. 
  4. For each order that you want to be included in the export file: click on the checkbox on the left
  5. Scroll down to the bottom of the screen and from the With Selected: action dropdown choose Fond du Lac - Download Detail.
  6. Transmit this file to FDL / CS as required (please see the above note about contacting your FDL/CS support representative for the exact submission flow)
  7. After FDL/CS has received the detailed file and confirmed receipt you then need to repeat the above process but this time choose Fond du Lac - Download Summary from the With Selected: action dropdown.
  8. Transmit the summary file to FDL/CS
  9. When the summary file has been confirmed by FDL/CS repeat the above order selection process and from the With Selected: action dropdown choose Mark as Processed (Delivery Status: Sent to Warehouse) to remove them from the Pending Deliveries screen.