Downloading Drop Ship Vendors (ECSV)
Purpose: Use this menu option to send vendors to CWCollaborate or Locate for drop ship fulfillment.
In this topic:
• Downloading Vendors to CWCollaborate
• Downloading Vendors to Locate
• Download Drop Ship Vendors Screen
Downloading Vendors to CWCollaborate
This option builds and transmits a file to CWCollaborate containing vendor information for all vendors for which you use CWCollaborate to process drop ship orders. Only vendors whose Drop ship output field on the Second Create Vendor Screen is set to Collaborative Shipping are eligible to be sent to CWCollaborate. This option does not update vendors who are already in the CWCollaborate database.
Other ways to create a vendor in CWCollaborate: You can also transfer vendor information to CWCollaborate when you send a purchase order for a vendor who was not already in the CWCollaborate database; when vendor information is transferred with a purchase order, CWCollaborate updates the vendor information in the CWCollaborate database.
Transferred vendor information: The vendor information transferred to CWCollaborate through this menu option is from the Vendor table, with the exception of Vendor e-mail address, which is from in the Vendor Contact Table.
Special characters: You cannot use special characters, such as apostrophes, when creating a vendor in CWCollaborate. CWSerenade vendor names which include apostrophes can be passed to CWCollaborate and will display with apostrophes, but cannot be used for the Search function on CWCollaborate screens.
When you use this option to send vendors to CWCollaborate:
• The NEWVEN report recaps the number of new vendors sent from CWSerenade to CWCollaborate.
• The NewVendorInfoError log contains a list of errors that occurred during the transmission of new vendors from CWSerenade to CWCollaborate. For vendors whose information is already established in the CWCollaborate database, transferred information is logged as an error record in the NewVendorInfoError log file.
Vendor Load Upload Error email: If one or more of the vendor records contains errors and cannot be loaded into the CWCollaborate database, CWCollaborate sends a Vendor Load Upload Error email to the email address defined in the Error acknowledgement field on the retailer preferences screen in CWCollaborate.
From: |
collaborate@EXAMPLE.com |
To: |
Bernadette Miranda |
Subject: |
Vendor Load Uupload Error |
Errors encountered when loading vendors. See error log for details. |
|
For more information: See the CWCollaborate Configuration and Reference Guide for more information on how vendor information is sent from CWSerenade to CWCollaborate.
This option sends new or updated vendor information to Locate’s Supplier Direct Fulfillment module through the CreateDSVendor message. Only vendors whose Drop ship output field on the Second Create Vendor Screen is set to Locate Drop Shipping are eligible to be sent to Locate.
The information sent to Locate includes:
• vendor code and description
• contact name and email address
• vendor address
Afterward, you can use the Locate screens to set vendor preferences, change carrier assignments, and set up vendor users.
Locate creates each new vendor in active status, and automatically assigns the vendor to all active carriers.
Other ways to create vendors in Locate: You can create a new vendor in the Locate database by using the Create Vendor screen. You can also create a vendor by sending a purchase order for the vendor; however, when you create a new vendor this way, the only information sent from CWSerenade about the vendor is the vendor code, name, and email address. You will need to complete the remaining setup for the vendor through the Locate Edit Vendor screen.
Transferred vendor information: The vendor information transferred to Locate through this menu option is from the Vendor table, with the exception of Vendor e-mail address, which is from in the Vendor Contact Table.
Updating an existing vendor: If the vendor record already exists in Locate and you or the vendor have updated the record there, processing the vendor download overwrites the existing information in Locate.
For more information: See the Locate Operations Guide for more information on the contents of the CreateDSVendor message, and see the Locate online help for more information on completing vendor setup in Locate.
Download Drop Ship Vendors Screen
How to display this screen: Enter ECSV in the Fast path field at the top of any menu or select Download Drop Ship Vendors from a menu.
Screen Option |
Procedure |
Send vendor information to CWCollaborate or Locate |
Select Submit to submit the batch job which transfers vendor information to CWCollaborate or Locate. |
