SLG IT Support

To explain the dropship setup process, I am using the last vendor I set for dropship (CUTBUK)

For setting up any vendor for dropship you would need the following information. None of the below information could be ignored. If any information is missing then first get it from the Merch team and then proceed with the setup process.

Vendor name: CUTTER & BUCK CANADA

Vendor address :
Unit 2, 175 Westcreek Blvd
Brampton
Ontario
L6T 5S6

Vendor contact details :
Name: Shane Brett
Email: [email protected]
Address: 416-460-6167

The setup must be first completed in OD UAT (sandbox3) and the routing process must be tested. If there are multiple vendors being configured then each vendor must be set individually and the testing process must be repeated for each vendor separately. Do not try to skip this step or try shortcuts in setup or combine steps for setup, or have single order used for testing. This process is important to be followed as in for each vendor setup (no exceptions). If not followed then there is a good chance of routing issues which can have the potential to stop the order processing in OD.

Also please ensure you follow the change management process each time you are trying to set up the vendor for dropship. Please find some sample CRs which were created earlier
https://golftown.freshservice.com/itil/changes/555
https://golftown.freshservice.com/itil/changes/554
https://golftown.freshservice.com/itil/changes/542
https://golftown.freshservice.com/itil/changes/538


The process to setup up a dropship vendor is divided into two major sections
1. Setup in OD
2. Setup in Integrations

Setup in OD: Following are the steps included in this step.

Setup a new CMS->Store
CUTBUK
sporting life store: false

Setup new PIM->Inventory->Inventory Location
CUTBUK
Shipping center
LocationType: DROPSHIP

Setup new Config->OMS->Shipping Centers
CUTBUK
Days of processed shipment to show: 180
Enable pickup in store workflow
Enable ship to store workflow
Invoicing Task: True

Set Shipping Center in Inventory location CUTBUK

Setup new Config->Order Routing Rules->Order Routing Rules
Copy an existing rule of OPTISH and make relevant changes for CUTBUK

Set the routing priority for CUTBUK
Config->Extensibility->Custom Fields
Update the custom field "ManufactureCode" for Order Line Items and add CUTBUK in it

There is a video file for the above steps which is saved in the following location

Setup in Integrations: Following are the steps included in this step.

Connect to 10.34.85.92
Open the SQL query page for [Attunity_RPro_Web] database
Run the below script
INSERT INTO [dbo].[tbConstants] ([CONSTANT_KEY],[CONSTANT_VALUE],[CONSTANT_DESCRIPTION]) VALUES ('DROPSHIP','ACIBRA','Vendor code to be used as drop ship store location in OMS')

Download the original SQL script file (110-Create Table tbConstants.sql) from the below bit bucket link
https://bitbucket.org/gt_integration/integration-service-helper/src/master/Service%20Configuration%20Handler/cdc-attunity-rpro-web/110%20tbConstants/

Add the relevant above script in the script file (110-Create Table tbConstants.sql) and save it.