Send inventory and sales data to Specialized using S_Connect

Written By Ascend knowledge base (Administrator)

Updated at June 19th, 2023

S_Connect allows you to display your shop's product availability on Specialized.com. Send your inventory and sales information from Ascend to easily update your information on the Find Nearby page.

For more information on the Specialized S_Connect program, or for support, contact your Specialized rep.

System setup

Specialized

  • Opt-in to the S_Connect data share service in your Specialized B2B account. Make note of the credentials provided for your Specialized account.
    1. FTP username and password
    2. Account number
    3. Location ID
      Note: The Location ID is not the same value as your account number.

Ascend

Schedule data feeds

(multi-store retailers) Reports must be saved & scheduled separately for each location.

  1. Save the Specialized_SConnect_Inventory_v2 and Specialized_SConnect_Sales_v2 queries to your server computer (log into www.ascendrms.com).
  2. Run each query. Follow the directions below for each:

Note: see the Run a custom query article for details on running queries.

Specialized_SConnect_Inventory query: 

  1. Navigate to Ascend > Reports.
  2. On the toolbar click SQL Query.
  3. Paste the Specialized_SConnect_Inventory query into the query window.
  4. On the toolbar, click Save and enter "Spec_SConnect_Inventory_<LocationName>" and click OK
    Screenshot of SQL Query pop up
  5. On the toolbar click Delivery.
  6. Set the following delivery parameters:
    • Inventory Export: Time: 11:30 PM
    • Recurrence Pattern: Daily, Every 1 day(s) 
    • Delivery Method: FTP/SFTP
      • Host Address: sftp://sftp.rcrm.pro:22 
      • Protocol: SFTP - SSH-File Transfer Protocol 
      • Login: Provided by S_Connect
      • Password: Provided by S_Connect
    • Report Parameters: As CSV
      Screenshot of Schedule Report Delivery window with As CSV button selected

Specialized_SConnect_Sales query: 

  1. Navigate to Ascend > Reports.
  2. On the toolbar click SQL Query.
  3. Paste the Specialized_SConnect_Sales query into the query window.
  4. On the toolbar, click Save and enter "Spec_SConnect_Sales_<LocationName>" and click OK.
  5. On the toolbar click Delivery.
  6. Set the following delivery parameters:
    • Inventory Export: Time: 11:30 PM
    • Recurrence Pattern: Daily, Every 1 day(s)
    • Delivery Method: FTP/SFTP Host Address: sftp://sftp.rcrm.pro:22
      • Protocol: SFTP - SSH-File Transfer Protocol
      • Login: Provided by S_Connect
      • Password: Provided by S_Connect
    • Report Parameters: Last 3 days, As CSV
      Screenshot of Schedule Report Delivery window with As CSV button selected
    • The reports save in the My Queries folder of Reports.

KB22-119