I have created a schedule job to get commerce transactions from episerver commerce and process into our backend systems.

In development it appeared to be working fine – getting transactions from episerver commerce putting the information into a csv file

and then FTPing to a remote server (and this worked whether the job was run manually or via the schedule).  But it seemed only to have

worked because it was only getting the transactions which I had created on the development setup.

However, when I moved the schedule job to a test server where transactions have been done by other users, I noticed it was only picking-up

transactions which were created under my user and no others – and this was I presume because I am running the scheduler under the context of

an Administrator user (my user).

Obviously, this is a far from satisfactory situation – I need to get all transactions and not just those associated with a particular user – so my question is:

How do I get ALL transactions out of episerver commerce using a schedule job and not just the transactions created by the user which is being

used as the context to run the schedule job?  Note that if you run under the context of a no user, you get no transactions back.

Alternatively, how do I run a schedule job under the context of the user which runs the Commerce Manager tool as this can see ALL of the

transactions?  In other words, how do I run a schedule job under the context of a Commerce Manager user?

Relevant Code is:

Use this function to get PO's:

        public static List GetAllPurchaseOrdersCreatedBetweenDates(DateTime StateDate, DateTime EndDate)
        {
            List purchaseOrders = null;

            try
            {
                purchaseOrders = OrderRepository.Service.Load()
                                                   .Where(x => x.Created >= StateDate.Date && x.Created <= enddate.date) .orderbydescending(x=""> x.Created)
                                                   .ToList();

                if (purchaseOrders == null)
                {
                    Log.Error($"**** COMMERCE ERROR: EpiserverCommerceHelpers.GetAllPurchaseOrdersCreatedBetweenDates() is returning null");
                    throw new ApplicationException("EpiserverCommerceHelpers.GetAllPurchaseOrdersCreatedBetweenDates() is returning null");
                }

                if (purchaseOrders != null && purchaseOrders.Count == 0)
                {
                    Log.Error($"**** COMMERCE ERROR: EpiserverCommerceHelpers.GetAllPurchaseOrdersCreatedBetweenDates() is returning no purchase orders");
                    throw new ApplicationException("EpiserverCommerceHelpers.GetAllPurchaseOrdersCreatedBetweenDates() is returning no purchase orders");
                }
            }
            catch (Exception ex)
            {
                Log.Error($"**** COMMERCE ERROR: EpiserverCommerceHelpers.GetAllPurchaseOrdersCreatedBetweenDates() has thrown an exception: {ex.Message}");
            }

            return purchaseOrders;
        }

I use this function to set the user in the schedule code:

        public static string SetPrincipleUser(string Username = "")
        {
            try
            {
                // Manual triggering of a scheduled task will cause the task to run with the currently logged in user’s account and with access to that HttpContext
                // but triggering organically according to the schedule will cause the schedule to run under a limited permissions user and with no HttpContext.
                if (HttpContext.Current == null || PrincipalInfo.CurrentPrincipal.Identity.Name == string.Empty)
                {
                    // Running according to the schedule (not manual triggering)

                    string ScheduledJobPrincipleUser = (Username == string.Empty) ? ConfigurationManager.AppSettings["ScheduledJobPrincipleUser"] : Username;
                    if (!string.IsNullOrEmpty(ScheduledJobPrincipleUser))
                        // Run the scheduled task as a user specified from the web.config or from passed in Username without HttpContent (WORKS)
                        PrincipalInfo.CurrentPrincipal = UserImpersonation.Service.CreatePrincipal(ScheduledJobPrincipleUser);
                    else
                        // Run the scheduled task as an anonymous principal without HttpContext (Doesn't work but may do so if AnonymousScheduledJobPrincipleUser is created as a user)
                        PrincipalInfo.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("AnonymousScheduledJobPrincipleUser"), new[] { "Administrators" });
                }

                string CurrentUser = PrincipalInfo.CurrentPrincipal.Identity.Name;
                return (CurrentUser == string.Empty) ? string.Empty : $"{CurrentUser}";
            }
            catch
            {
                return string.Empty;
            }
        }