Send inventory and sales data to Specialized using S_Connect
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 or see the POS Data Share FAQ.
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.
a. FTP username and password
b. Account number
c. Location ID
Sherpa tip: The Location ID is not the same value as your account number.
Ascend
- Keep Ascend on the latest version; see the Install an Ascend update article.
- Configure a workstation or system email account; see the Set up email integration article.
- Keep vendor products up-to-date using Ascend-formatted updates (log into www.ascendrms.com); see the Import a large number of vendor products into Ascend article.
- Keep your inventory values accurate by performing regular cycle counts; see the Prepare for cycle counts article.
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).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.
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
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
• The reports save in the My Queries folder of Reports.