Ascend RMS Integration

To connect Ascend RMS to provide an inventory feed you must generate an automatic report within your Point of Sale (POS) that sends CSV files throughout the day with the column headers UPC and QTY.

To Integrate Ascend RMS for Single Store:

1. Login to Ascend RMS
2. In the top toolbar click View > then Reports
3. Hit the SQL Query button
4. In the query field enter

   SELECT [UPC], [Quantity] as QTY from Products 
   WHERE Quantity > 0 AND hide = 0

5. Hit Execute to run the query
6. After executing you must then Save the query
7. Save the query as ShipEarly
8. To schedule the report to run and send automatically based on timing in the top Ribbon/Menu hit the Delivery button
9. 
10. Set the report to run at 9:00am, to run Daily every 1 day(s)
11. Select SFTP as the Delivery Method and Protocol
12. In the Host Address, type in sftp://inv-data.shipearlyapp.com/upload
13. Set the Port to 22
14. Get your SFTP login and password from ShipEarly by clicking on your company name in the top right > Inventory Settings
15. Ensure Ascend RMS is selected as your Inventory Software
16. Copy your Username and Password (will be different than what is shown below) and paste into Ascend RMS.
17. Ensure the data is set to CSV (Comma Separated Values)
18. Hit Save

Push Inventory Multiple Times Per Day

If you wish to sync your inventory information to ShipEarly more often than once a day (up to every two hours), copy this query the number of times you wish to update.

For example: If your store is open from 10:00 am to 8:00 pm and you wish to sync inventory information every two hours, create six copies of the query. Schedule these for delivery at 12:00 pm, 2:00 pm, 4:00 pm, 6:00 pm, 8:00 pm, and 11:00 pm (to ensure any changes made after close are accounted for).