public bool UpdateOrder(IUnitOfWork db, ShippingDTO shipping)
{
_log.Info("Update order: id=" + shipping.OrderId + ", orderId=" + shipping.AmazonIdentifier + ", marketId=" + shipping.MarketOrderId);
IList <OrderItemDTO> orderItems;
if (shipping.IsFromMailPage)
{
orderItems = db.OrderItems.GetByOrderIdAsDto(shipping.OrderId)
//Remove canceled items with 0 price
.Where(m => m.ItemPrice > 0 || m.QuantityOrdered > 0).ToList();
}
else
{
orderItems = db.OrderItems.GetByShippingInfoIdAsDto(shipping.Id)
//Remove canceled items with 0 price
.Where(m => m.ItemPrice > 0 || m.QuantityOrdered > 0).ToList();
}
var allItemWasUpdated = true;
foreach (var item in orderItems)
{
_log.Info("OrderItem, itemId=" + item.ItemOrderIdentifier);
DateTime?orderDate = null;
if (shipping.OrderDate.HasValue)
{
orderDate = shipping.OrderDate.Value.ToUniversalTime();
}
var shippingDate = shipping.ShippingDate.ToUniversalTime();
if (orderDate.HasValue && shippingDate < orderDate)
{
shippingDate = orderDate.Value.AddHours(2);
}
var result = _api.UpdateOrder(shipping.MarketOrderId,
item.ItemOrderIdentifier,
shippingDate,
shipping.TrackingNumber,
ShippingUtils.FormattedToMarketCurrierName(shipping.ShippingMethod.CarrierName, shipping.ShippingMethod.IsInternational, MarketType.eBay));
_log.Info(String.Format("Order date: {0}, shipping date: {1}", orderDate, shippingDate));
allItemWasUpdated = allItemWasUpdated && result.IsSuccess;
if (result.IsSuccess)
{
_log.Info("Order was updated");
}
else
{
_log.Info("Order update errors: ErrorCode=" + result.ErrorCode + ", Message=" + result.Details);
}
}
return(allItemWasUpdated);
}
private bool UpdateOrder(IUnitOfWork db, ShippingDTO shipping)
{
_log.Info("Update order: id=" + shipping.OrderId + ", orderId=" + shipping.AmazonIdentifier + ", marketId=" + shipping.MarketOrderId);
IList <OrderItemDTO> orderItems;
if (shipping.IsFromMailPage)
{
orderItems = db.OrderItems.GetByOrderIdAsDto(shipping.OrderId)
//Remove canceled items with 0 price
.Where(m => m.ItemPrice > 0 || m.QuantityOrdered > 0).ToList();
}
else
{
orderItems = db.OrderItems.GetByShippingInfoIdAsDto(shipping.Id)
//Remove canceled items with 0 price
.Where(m => m.ItemPrice > 0 || m.QuantityOrdered > 0).ToList();
}
OrderHelper.PrepareSourceItemOrderId(orderItems);
orderItems = OrderHelper.GroupBySourceItemOrderId(orderItems);
DateTime?orderDate = null;
if (shipping.OrderDate.HasValue)
{
orderDate = shipping.OrderDate.Value.ToUniversalTime();
}
var shippingDate = shipping.ShippingDate.ToUniversalTime();
if (orderDate.HasValue && shippingDate < orderDate)
{
shippingDate = orderDate.Value.AddHours(2);
}
var result = _api.SubmitTrackingInfo(shipping.MarketOrderId,
shipping.TrackingNumber,
MarketUrlHelper.GetTrackingUrl(shipping.TrackingNumber, shipping.ShippingMethod.CarrierName),
shipping.ShippingMethod,
shipping.ShippingMethod.Name,
ShippingUtils.GetShippingType(shipping.ShippingMethodId),
ShippingUtils.FormattedToMarketCurrierName(shipping.ShippingMethod.CarrierName, shipping.ShippingMethod.IsInternational, _api.Market),
shippingDate,
orderItems,
shipping.MessageIdentifier.ToString());
if (result.Status == CallStatus.Success)
{
_log.Info("Order was updated");
}
else
{
_log.Info("Order update errors: Message=" + result.Message);
/*
* Walmart.Api.WalmartException: No response, statusCode=InternalServerError.
* Details: <?xml version="1.0" encoding="UTF-8" standalone="yes"?><ns4:errors xmlns:ns2="http://walmart.com/mp/orders" xmlns:ns3="http://walmart.com/mp/v3/orders" xmlns:ns4="http://walmart.com/"><ns4:error><ns4:code>INVALID_REQUEST_CONTENT.GMP_ORDER_API</ns4:code><ns4:field>data</ns4:field><ns4:description>Unable to process this request. The Line: 4 of PO: 4576930294354 is in SHIPPED status</ns4:description><ns4:info>Request content is invalid.</ns4:info><ns4:severity>ERROR</ns4:severity><ns4:category>DATA</ns4:category><ns4:causes/><ns4:errorIdentifiers/></ns4:error></ns4:errors> ---> System.Net.WebException: The remote server returned an error: (400) Bad Request.
*/
}
return(result.Status == CallStatus.Success);
}
private bool UpdateOrder(IUnitOfWork db, ShippingDTO shipping)
{
_log.Info("Update order: id=" + shipping.OrderId + ", orderId=" + shipping.AmazonIdentifier + ", marketId=" + shipping.MarketOrderId);
IList <OrderItemDTO> orderItems;
if (shipping.IsFromMailPage)
{
orderItems = db.OrderItems.GetByOrderIdAsDto(shipping.OrderId)
//Remove canceled items with 0 price
.Where(m => m.ItemPrice > 0 || m.QuantityOrdered > 0).ToList();
}
else
{
orderItems = db.OrderItems.GetByShippingInfoIdAsDto(shipping.Id)
//Remove canceled items with 0 price
.Where(m => m.ItemPrice > 0 || m.QuantityOrdered > 0).ToList();
}
OrderHelper.PrepareSourceItemOrderId(orderItems);
orderItems = OrderHelper.GroupBySourceItemOrderId(orderItems);
DateTime?orderDate = null;
if (shipping.OrderDate.HasValue)
{
orderDate = shipping.OrderDate.Value.ToUniversalTime();
}
var shippingDate = shipping.ShippingDate.ToUniversalTime();
if (orderDate.HasValue && shippingDate < orderDate)
{
shippingDate = orderDate.Value.AddHours(2);
}
var carrierName = shipping.ShippingMethod.CarrierName;
if (!String.IsNullOrEmpty(shipping.CustomCurrier))
{
carrierName = shipping.CustomCurrier;
}
var result = _api.SubmitTrackingInfo(shipping.MarketOrderId,
shipping.TrackingNumber,
MarketUrlHelper.GetTrackingUrl(shipping.TrackingNumber, carrierName),
shipping.ShippingMethod.Name,
ShippingUtils.GetShippingType(shipping.ShippingMethodId),
ShippingUtils.FormattedToMarketCurrierName(carrierName, shipping.ShippingMethod.IsInternational, _api.Market),
shippingDate,
orderItems);
if (result.Status == CallStatus.Success)
{
_log.Info("Order was updated");
}
else
{
_log.Fatal(_api.Market + ": Order update errors: Message=" + result.Message + ", Order=" + shipping.MarketOrderId);
/*
* Walmart.Api.WalmartException: No response, statusCode=InternalServerError.
* Details: <?xml version="1.0" encoding="UTF-8" standalone="yes"?><ns4:errors xmlns:ns2="http://walmart.com/mp/orders" xmlns:ns3="http://walmart.com/mp/v3/orders" xmlns:ns4="http://walmart.com/"><ns4:error><ns4:code>INVALID_REQUEST_CONTENT.GMP_ORDER_API</ns4:code><ns4:field>data</ns4:field><ns4:description>Unable to process this request. The Line: 4 of PO: 4576930294354 is in SHIPPED status</ns4:description><ns4:info>Request content is invalid.</ns4:info><ns4:severity>ERROR</ns4:severity><ns4:category>DATA</ns4:category><ns4:causes/><ns4:errorIdentifiers/></ns4:error></ns4:errors> ---> System.Net.WebException: The remote server returned an error: (400) Bad Request.
*/
if (StringHelper.ContainsNoCase(result.Exception?.Message, "doesn't have enough quantity to ship requested quantity"))
{
var allUpdated = true;
//Send update by one items
foreach (var orderItem in orderItems)
{
var oneItemResult = _api.SubmitTrackingInfo(shipping.MarketOrderId,
shipping.TrackingNumber,
MarketUrlHelper.GetTrackingUrl(shipping.TrackingNumber, carrierName),
shipping.ShippingMethod.Name,
ShippingUtils.GetShippingType(shipping.ShippingMethodId),
ShippingUtils.FormattedToMarketCurrierName(carrierName, shipping.ShippingMethod.IsInternational, _api.Market),
shippingDate,
new List <OrderItemDTO>()
{
orderItem
});
if (oneItemResult.Status == CallStatus.Success)
{
_log.Info("Order item " + orderItem.SKU + " was updated");
}
else
{
if (!StringHelper.ContainsNoCase(oneItemResult.Exception?.Message, "is in SHIPPED status") &&
!StringHelper.ContainsNoCase(oneItemResult.Exception?.Message, "qtyAvailableToShip :: 0"))
{
allUpdated = false;
_log.Fatal(_api.Market + ": Order item \"" + orderItem.SKU + "\" update errors: Message=" + oneItemResult.Message + ", Order=" + shipping.MarketOrderId);
}
}
}
if (allUpdated)
{
result = CallResult <DTOOrder> .Success(new DTOOrder());
}
}
}
return(result.Status == CallStatus.Success);
}
protected override DocumentInfo ComposeDocument(IUnitOfWork db,
long companyId,
MarketType market,
string marketplaceId,
IList <string> asinList)
{
Log.Info("Get orders");
var shippingMethodList = db.ShippingMethods.GetAllAsDto().ToList();
var fromDate = Time.GetAppNowTime().AddDays(-7);
var shippingLabels = db.OrderShippingInfos.GetOrdersToFulfillAsDTO(market, marketplaceId)
.Where(sh => sh.ShippingDate > fromDate).ToList();
var shippingInfoIds = shippingLabels.Select(i => i.Id).ToList();
Shippings = db.OrderShippingInfos.GetFiltered(sh => shippingInfoIds.Contains(sh.Id)).ToList();
shippingLabels = PrepareOrderShippings(db, shippingLabels);
var mailLabels = db.MailLabelInfos.GetInfosToFulfillAsDTO(market, marketplaceId)
.Where(sh => sh.ShippingDate > fromDate).ToList();
var mailInfoIds = mailLabels.Select(i => i.Id).ToList();
MailInfoes = db.MailLabelInfos.GetFiltered(m => mailInfoIds.Contains(m.Id)).ToList();
mailLabels = PrepareMailShippings(db, mailLabels);
var allShippings = shippingLabels;
allShippings.AddRange(mailLabels);
if (asinList != null)
{
allShippings = allShippings.Where(sh => asinList.Contains(sh.AmazonIdentifier)).ToList();
}
if (allShippings.Any())
{
var orderMessages = new List <XmlElement>();
var index = 0;
var merchant = db.Companies.Get(companyId).AmazonFeedMerchantIdentifier;
foreach (var shipping in allShippings)
{
index++;
Log.Info("add order " + index + ", shippingId=" + shipping.Id);
var shippingMethod = shippingMethodList.FirstOrDefault(m => m.Id == shipping.ShippingMethodId);
string shippingService = String.Empty;
if (string.IsNullOrEmpty(shipping.ShippingService)) //NOTE: this options using Mail Labels, todo: make join
{
if (shippingMethod != null)
{
shippingService = shippingMethod.Name;
}
Log.Info("shipping service=" + shippingService);
}
else
{
shippingService = shipping.ShippingService;
}
OrderHelper.PrepareSourceItemOrderId(shipping.Items);
shipping.Items = OrderHelper.GroupBySourceItemOrderId(shipping.Items);
var carrier = shippingMethod?.CarrierName;
if (!String.IsNullOrEmpty(shipping.CustomCurrier))
{
carrier = shipping.CustomCurrier;
}
orderMessages.Add(FeedHelper.ComposeOrderFulfillmentMessage(index,
shipping.AmazonIdentifier,
shipping.ShippingDate,
shipping.OrderDate,
ShippingUtils.FormattedToMarketShippingService(shippingService, shippingMethod.IsInternational),
shippingMethod != null ? ShippingUtils.FormattedToMarketCurrierName(carrier, shippingMethod.IsInternational, market) : String.Empty,
shipping.TrackingNumber,
shipping.Items));
if (shipping.IsFromMailPage)
{
MailInfoes.First(m => m.Id == shipping.Id).MessageIdentifier = index;
}
else
{
Shippings.First(o => o.Id == shipping.Id).MessageIdentifier = index;
}
}
Log.Info("Compose feed");
var document = FeedHelper.ComposeFeed(orderMessages, merchant, Type.ToString());
return(new DocumentInfo
{
XmlDocument = document,
NodesCount = index
});
}
return(null);
}
