Retail Pro 9 Inventory Report Upload

Overview

Modern Retail can integrate your website with Retail Pro Version 9 using a simple inventory report.  This articles describes how this report can be created and uploaded to Modern Retail for processing.

Creating Report

The report that needs to be create in Retail Pro is called ON HAND: By Item and can be easily created in Retail Pro 9 Reports.  Below are the steps you take to create this report.

1. Start the Retail Pro 9 Reports application.
   
   
   
2. Click on the Reports icon to start the report viewer.
   
   
   
3. Select Merchandise and then double-click on the ON HAND: by Item report.
   
   
   
4. If you would like to narrow the products you sell online to specific products, like from a particular store, hit Report Filter and select the appropriate criteria.
   
   
   
   
5. Select Run when you're ready to create the report.
   
   
   
6. Once the report has been created, hit the Export button and be sure to select Excel (Text Only) as the export format.
   
   
   
7. Once the report has been exported to Excel, go to the File menu and select Save As.
   
   
   
8. Enter a File Name and select CSV (Comma delimited) next to Save as type.  Make sure you note where you save the file as you will need it when uploading it to Store Manager.
   

 

Uploading

Using Modern Retail's Store Manager website, you can upload the Retail Pro report you created and saved above.

1. Login to Store Manager by entering your E-mail Address and Password.
2. Once you've been logged into Store Manager, go to Website > POS Integration > Inventory Upload.
3. Click the Upload button at the top of the page and browse to the location where you saved the On Hand inventory report above.
4. Depending upon the size of the file being uploaded it can take anywhere from a few seconds to a couple of minutes to upload your file to Store Manager.  The status indicator will let you know how your upload is progressing.  Once the upload has been completed it will automatically be processed and your inventory will be sent to your website.

That's it! Creating the file in Retail Pro and uploading it to Store Manager is all you need to do to update the inventory on your website.  You can perform this process as often as you like, but many retailers create a habit of doing it when they first get into the store in the morning.