+ What databases are used for In-Store and Store Center locally?
Store Center uses SQL Express 2008 R2 and MS SQL Server, while InStore uses SQLite.
+Do we have to open up ports before installing Store Center or InStore?
You do not have to open up ports for installation. However, we run the Storecenter WCF (Windows Communication Foundation) service on port 8736, and Store Center listens on port number 6969. If these ports are used by some other programs, we may have to handle the configuration accordingly.
+ What are the prerequisites for installing Store Center and InStore?
You require Microsoft .Net 3.5 SP1 Framework and a custom setup built in-house.
+What registry entries are created while installing Store Center and InStore?
Instore and StoreCenter ClicOnce Installer:
+What service does Store Center and InStore use?
Store Center and InStore currently use the .Net 3.5 SP1 service
+How does the data flow to cloud?
Store Center and InStore have a local database that store all the transactions happening on the POS. During a specified interval, this data is synced to the Capillary Cloud through our InTouch APIs.
+What connectivity protocols are used by Store Center and InStore?
Store Center communicates with the InStore application through TCP/IP, while it communicates with the Capillary Cloud through HTTP.
The InStore application communicates with the Capillary Cloud through HTTP, but it can be configured to communicate through HTTPS as well.
+Is there an encryption done while transferring the data?
Currently the data is transferred without any encryption.
+Should SQLite also be installed if MSSQL Express is already installed?
You do not have to install Sqlite for Instore. InStore installation by default contains Sqlite. For Store Center, if the database is already installed, you must point the Store Center to that database server.
+How do the older and newer Store Center Installers differ?
While installing Store Center using the older Installer (ClicOnce), you must first install SQLExpress. If there is no SQL Express installed prior to running the new installer, it installs SQLExpress 2008 R2 automatically.
+What version of SQLite is currently used?
The SQLite version currently used is 188.8.131.52
+Which features are still available when InStore is offline?
The following table lists which features are still accessible when InStore is offline.
|Capture Return Transaction||No|
|Advanced Customer Search||No|
|Customer Summary||Yes||Limited, depending on the Clienteling and Non Clienteling versions. |
|View Call Tasks||Yes||Call tasks are synced on a nightly basis. On syncing, call tasks can be viewed offline too.|
|Close/Change Call Task Status||No|
|View/Edit Customer Notes||No|
|View/Edit Customer Preferences||No|
|View Transaction History Screen||No|| |
|View Interaction History||No|| |
|Intelligent Notifications||Yes||Limited Capability. Some notifications are available only when Instore is online, while some are available when InStore is offline.|
|Customer Feedback||No|| |
|View Store Terminal Report||No|| |
|View Points Balance||Yes*|| *The points balance is based on last sync completion. Points data might be outdated. |
|View Customer Active Coupons||Yes*|| *The active coupons list is based on last sync completion. The active coupons list might be outdated.|
|Customer Profile - Refresh||No || |
| Product Search||No|| This is a Clienteling feature.|
| Reminder Notification||Yes|| |
| Gift Cards (Redeem/Recharge)||No|| |
| Mobile Change Request||Yes || |
| Email Change Request||Yes|| |
| Subscription||No|| |
| Referral||No|| |