In HQ, how do you send to the stores a change in a customer's account type? Client changed a customer to revolving in HQ, but updates only happened at one of the stores. At another store the client's customer has 2 entries, one revolving and the other not. A store data upload worksheet is run every night to each store. What could be going on here?
Thanks, Matt
The customer data go on store database only after a data upload worksheet.. but only records with TIMESTAMP changed after the previous data upload.. or after current data upload.. I had five stores with global customers .. and the stores are in a ray (?? circle?? ! bad dictionary! :() of 30/40 km. All customers each time that go in different store protest because the score of fidelity card isn't update..
Now.. the solution is to get data from all stores after they close.. and in the night a SQL-BATCH change the 'LastUpdated' flag of hq customer table.. and in the morning (5.. 6am) the stores process new data upload... (it's more fast.. because in the night the stores closed)
bye antonio
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.