Hi René

We haven't ran Tea Commerce on a load balanced environment our self, so are not that familiar in that area. Could you give a bit more details about how this setup is - how many servers, frontend, backend, DB etc.

Regarding the local, stage and live environment - is that an Umbraco Cloud setup? Is there any load balancing done automatically by Umbraco Cloud maybe?

Kind regards

Anders

I think the problem is the shared DB. TC has a caching layer where most business objects are cached - stores, shipping methods, order statuses etc. The store object has the CurrentOrderNumber property. That is increased when an order is finalized and that value is saved to the DB.

But if the live environment has a cache where the value is 20 and 5 orders is finalized. Then the cache layer and DB value should be 25. If you then finalize an order on the dev environment which had 20 in the cache (if the dev environment was running at the same time as the live), then 21 would be saved to the DB. So now its out of sync because you use the same DB for the three environments.

Would it make more sense to run with separate DB? Another option is to override the StoreService in TC and not cache the Store object. But that would hit performance as the store object is used in almost everything in TC.

/A

Hi Anders,

thanks for the answer. I feared that would be your answer. It´s not an option at the moment to have 3 databases. So how do i override the StoreService so that it is not cached?

best regards René

Hi Anders,

thank you for the help. To help others i post the working code below. There is no way to only clear the orderNumber property, is there?

Best regards René

namespace customer.Models.Store

{ [SuppressDependency( "TeaCommerce.Api.Services.IStoreService", "TeaCommerce.Api" )] public class ClearCacheStoreService : IStoreService { private readonly IStoreRepository _repository;

    public ClearCacheStoreService(IStoreRepository repository, ICacheService cacheService)
    {
        _repository = repository;
    }

    public IEnumerable<TeaCommerce.Api.Models.Store> GetAll()
    {
        return _repository.GetAll();
    }

    TeaCommerce.Api.Models.Store IStoreService.Get(long storeId)
    {
        return _repository.Get(storeId);
    }
}

}

is working on a reply...