customers show up in manager but not POS?

The customer(s) aren't set as global. Go to FILE, CONFIG, OPTIONS, CUSTOMER OPTIONS. You should enable GLOBAL CUSTOMERS FOR MULTI-STORE and NEW CUSTOMERS DEFAULT AS GLOBAL CUSTOMERS. Then, you may need to run a SQL QUERY to flip the Global Customer flags on for existing customer records (In SO Admin enter "Update Customer SET GlobalCustomer = 1").

And finally, don't let your cashiers change the CUSTOMER IS A GLOBAL/ENTERPRISE CUSTOMER flag when they enter NEW customer records.

Scott

"ksk> We recently started experiencing a problem where certain customers at random

Scott thanks for the reply - but I don't believe this is the problem.

We already have both of these settings set this way in Manager, and have since we set up Store ops coming up on a few years ago. We never have had this problem before, it has just started.

I checked to make sure and all of our customers in the store are currently set as global customers.

Any other ideas?

Thanks, Kevin

"Lum> The customer(s) aren't set as global. Go to FILE, CONFIG, OPTIONS, CUSTOMER

Are the "customers" that DO show in SO and DON'T show in HQ defined as GLOBAL? Go into POS and look at the CUSTOMER OPTIONS tab for the PROPERTIES of the records.

If not, then my opinion is that the person (presumably a cashier) that created the record unchecked the CUSTOMER IS A GLOBAL/ENTERPRISE CUSTOMER flag when the record was created in POS by mistake. If the box is not checked try checking it and waiting for the next connection cycle.

If you run the query (UPDATE CUSTOMER SET GLOBALCUSTOMER = 1) against the SO database all of the flags will be set properly.

Scott

"ksk> Scott thanks for the reply - but I don't believe this is the problem. >

This has absolutely nothing to do with Headquarters. I checked the customer table in the Store Ops database, and every customer in the table has the 'Global Customer' property set to = 1, so they are all global. Certain of those customers show up in Store Operations manager when I go in and search for customers from the list of customers. However when i log into POS, and go to set a customer on a transaction, those same customers that are visible in store ops Manager, are not showing up to choose from in the list of available customers. Same store database. Again, this has nothing to do with the HQ database.

Any other ideas?

Thanks, Kevin

"Lum> Are the "customers" that DO show in SO and DON'T show in HQ defined as

We recently started experiencing a problem where certain customers at random would show up when searching for customers in the customer list in store ops manager, but will not show up in the list to select from when in POS. We reindex the database regularly. Any idea what could possibly be causing this? Thanks for the help

Kevin

Thanks for the reply -

We haven't made any changes to any find option settings, or to any of the DB settings in Admin, I double-checked and they are all fine. Also the database is not running offline mode either, so I'm not sure what is causing this to happen.

It has never happened prior to this, just started recently. And the customers that are suddenly not appearing in POS are customers that have been in the store DB for many months.

Any other possible ideas?

Thanks for the help Kevin

"Jeff @ Check Po> Kevin,

| Connect | look at the database and server names on both machines.

If you haven't re-indexed the db from Store Ops Administrator, that fixed a similar problem we were having.

-CP

File | Connect | look at the database and server names on both machines.

newsgroup reader to

File | Connect | look at the database and server names on both machines.

newsgroup reader to

kskinne, Could I ask you the osql command to reindex? I have all other tasks scheduled, but haven't been able to figure that one out. Craig

Craig insert the following line into a OSQL command line, as the query string:

sp_msforeachtable @command1 = 'DBCC DBREINDEX ([?])

The sp_msforeachtable is a stored procedure in the master DB that allows you to run the reindex command as shown above, on every table in the DB you specify in your OSQL command line

Hope this helps Kevin

"Craig" wrote:

I hate to be a pest, but this is a little over my head. I know how to make a batch file, but really don't know that much about writing Osql commands. If you would be so kind as to elaborate I would be grateful. Craig

This is a command line in our batch file:

OSQL -U sa -P password -S servername -Q "sp_msforeachtable @command1 = 'DBCC DBREINDEX ([?])"

replace password with your sa password, and replace servername with the name of your server. If you google 'OSQL' you can also find a lot of sites that explain in more data how to use OSQL to run SQL queries

hth kevin

"Craig" wrote:

Thanks Kevin, this will really beat having to remember to reindex on a regular basis after backing up. Just to clarify, this command will reindex the entire database? Thanks again. Craig