Centrally manage Cashiers and Sales Reps

How are your stores connected?

I have four stores and we use a VPN to connect the stores to HQ. Iam lucky in that all of my locations are served by the same cable company, so my traffic never really hits 'the internet' - it stays on the cable providers' network at all times. My response time for a ping is rarely over 70ms from the furthest store.

I am able to connect to any store database from the HQ location and rarely do I have any issues when I do.

This is what the folks at MS would call an 'unsupported configuration'. It would be useless for any sort of extended use and it is slower by far than connecting to a database on your LAN.

I only use it for occassions just like you've described, but it does work.

Tom

Hi Tom,

We have Point-to-Point private circuits to each store. The issue is we have employee turnover and employees move between stores often. We need a way to easily create and remove cashiers and sales reps at all stores.

Thank you,

Bradley

"Terrible Tom" wrote:

With a dedicated WAN like that, you should be able to reconfigure Store Operations to connect to the server at whichever store you need to connect. I have a batch file (found the idea on the Google archive of this group) that asks me which database I want to connect to then launches SO Manager for that store.

I had to manually configure my system for each store, export the SO Admin Config registry key, then use the batch file to select the registry key for you.

You'll probably want to use IP addresses instead of names for the server name.

Tom

Try Retail Realm's Global Cashiers and Global Sales Reps add-ins. These programs are included in their Miscellaneous Utilities for HQ.

Greg Digital Retail Solutions

I don't know if this is the best way...but..I do normally manage my cashiers thru a query... and pass it to a worksheet Style 51...

here's how to add a cashier to all stores you desire....

------------------------------------------------------------------------------------------ INSERT INTO [Cashier]([HQID], [LastUpdated], [Number], [StoreID], [Name], [Password], [FloorLimit], [ReturnLimit],[CashDrawerNumber], [SecurityLevel], [Privileges]) Select 0, '11-12-2006', 'ME', StoreID,'MYSELF','IRENE',0, 0,

0, 3, 5140382 from Configuration

------------------------------------------------------------------------------------------ Note: this query is with security activated options. There are some fields /options in Store that I have hide / prevent cashiers from modifying or viewing it.

------ Now, if you want to remove the cashier...You don't have to delete those codes because past transactions are using those cashier codes . What I suggest is to run another query to change the passowrd and update the security level, in a way that even the old cashier even if they know the password would not be able to gain access to the system.

1) update cashier set privileges=0 where number='7' and password='taty123'

2)update cashier set password='invalid' where number='7' and password='taty123'

Just try to ponder on it and see if it helps.

"Bradley" wrote: