PDBHub & The Retail Portal system is not just a way to get product data for your website! It can be configured as an inventory sync between your local POS system and your Shopify eCom website. Our Automated POS Inventory & Price Sync add-on functions allow you to automatically sync inventory and product prices from your POS system to your website using a variety of API or CSV inventory reporting routines.
As there are specific configuration files that will need to be setup, please contact your STN Project Manager if you wish to use this Automated CSV Feed system.
Supports Single or Multiple Inventory Locations.
Supported POS Systems:
| POS Platform | Method |
|---|---|
| Dynamics GP | CSV |
| eRegister Pro | API |
| Keystroke | CSV |
| Lightspeed Retail - R Series | API |
| Lightspeed Retail - X Series/Vend | API/CSV |
| Lightspeed Retail - S Series/ShopKeep | CSV |
| Merchant Plus! | CSV |
| Microsoft RMS | CSV |
| NCR Counterpoint POS | CSV |
| POSIM | CSV |
| Quickbooks POS | CSV |
| RAIN POS | API |
| Retail Management Hero | CSV |
| Retail Plus | CSV |
| Retail Pro | CSV |
| Retail Pro Prism | CSV |
| Retail STAR (CAM Commerce) | CSV |
| RunIt POS | CSV |
| VendHQ | CSV |
| Visual Retail Plus | CSV |
| WinRetail | CSV |
The CSV feed process that works as follows:
- You will need to install a third party FTP File Uploading application on your local computer. This will need to be installed on a machine where you can easily export POS Inventory Reports. See a list of supported ftp applications below.
- From your POS system, you will generate a standard inventory report with these fields: Item Number | Quantity on Hand | Price *. This report can be automatically generated, or manually generated, depending upon the capability of your POS system. Columns specifics may vary depending on your needs and qty of locations.
- The FTP Uploader will automatically feed the CSV reports to the web server. The FTP Uploader monitors a specific folder on your computer. Whenever you save a new version of your CSV inventory report, this application will send the inventory report to the webserver to be processed.
- Retail Portal will automatically process new CSV reports. When a new CSV has been uploaded, Retail Portal will update your web store product data in near-real time.
Scheduling inventory updates:
- For best results, we recommend that an automated POS Report Generation script be setup to create a new inventory report every 2-4 hours. Smaller stores have found a daily upload to be sufficient.
FTP Applications and setup costs:
- For automated upload, we recommend Fling FTP, Standard Edition from NCH Software for Windows Systems, and Yummy FTP Watcher from Yummy Software for Mac OS. Other automated FTP applications may work just as well.
- FileZilla is a free app that works great for manual uploads.
- STN will track and invoice for time required to configure and assist in the setup or ongoing maintenance of this system. Typically, setup and running instructions take 1-2 hours, but may vary depending upon the complexities of your particular store.
Operational Costs
- The Automated POS Inventory & Price Sync add-on cost is $40/month per Inventory Location.