static void Main() { Log.Logger = new LoggerConfiguration() .WriteTo.File(logPath) .CreateLogger(); Log.Information("Program started"); try { // Call the Orders API to get orders that are in 'Awaiting Fulfillment' status JArray ordersAwaitingFulfillment = BigCommerceController.GetOrdersAwaitingFulfillment(); if (ordersAwaitingFulfillment.Count() == 0) { Log.Information("No orders to import"); return; } ImportOrdersToNetSuite(ordersAwaitingFulfillment); if (ordersMissingProId.Count > 0) { AlertB2BTeam(); } } catch (Exception ex) { Log.Error($"Error: {ex}"); string title = "Error in NestProOrderImporter"; string text = $"Error message: {ex.Message}"; string color = "red"; TeamsHelper teamsMessage = new TeamsHelper(title, text, color, errorLogsUrl); teamsMessage.LogToMicrosoftTeams(teamsMessage); } }
public static string GetNestProId() { RestClient client = new RestClient($@"https://api.bigcommerce.com/stores/v68kp5ifsa/v2/customers/{customerId}"); RestRequest request = BigCommerceHelper.CreateNewGetRequest(); IRestResponse customerApiResponse = client.Execute(request); BigCommerceCustomer parsedCustomer = JsonConvert.DeserializeObject <BigCommerceCustomer>(customerApiResponse.Content); string nestProId = ""; if (parsedCustomer.form_fields == null) { string errorMessage = $"No Nest Pro Id found for Big Commerce customer {customerId}"; string title = "Error in ImportOrdersToNetSuite"; string color = "red"; TeamsHelper teamsMessage = new TeamsHelper(title, errorMessage, color, Program.errorLogsUrl); teamsMessage.LogToMicrosoftTeams(teamsMessage); } else { foreach (var formField in parsedCustomer.form_fields) { if (formField.name.ToLower().Contains("nest pro id")) { nestProId = formField.value; } } } return(nestProId); }
private static void ImportOrdersToNetSuite(JArray ordersAwaitingFulfillment) { try { foreach (var order in ordersAwaitingFulfillment) { Order parsedOrder = JsonConvert.DeserializeObject <Order>(order.ToString()); if (parsedOrder.is_deleted == true) { Log.Information($"Skipping order {parsedOrder.customer_id} because it is marked as deleted/archived."); continue; } BigCommerceController.customerId = parsedOrder.customer_id; int bigCommerceOrderId = parsedOrder.id; Log.Information($"bigCommerceOrderId Id {bigCommerceOrderId}"); // Get the shipping information string shippingAddressUrl = parsedOrder.shipping_addresses.url; ShippingAddress customerShippingAddress = BigCommerceController.GetCustomerShippingAddress(shippingAddressUrl); // Format the request object to send to CreateCustomerRESTlet OrderToImport netsuiteRequest = NetSuiteController.CreateNetSuiteRequest(parsedOrder, customerShippingAddress); if (netsuiteRequest.NestProId == "") { // We alert these to B2B so they can contact the customer ordersMissingProId.Add(bigCommerceOrderId); continue; } netsuiteCustomerId = NetSuiteController.GetNetSuiteCustomerId(netsuiteRequest); netsuiteRequest.CustomerId = Convert.ToInt32(netsuiteCustomerId); // Call the Products API to get the products on the order string productsUrl = parsedOrder.products.url; netsuiteRequest.Items = BigCommerceController.GetProductsOnOrder(productsUrl); NetSuiteController.SetNetSuiteItemIdAndPersonalItemFlag(netsuiteRequest); // Import order to Netsuite string netsuiteOrderId = NetSuiteController.ImportOrderToNetSuite(netsuiteRequest); // Set the Big Commerce status to 'awaiting shipment' and add the NetSuite order ID to 'staff notes' BigCommerceController.SetOrderStatus(bigCommerceOrderId, netsuiteOrderId); } } catch (Exception ex) { Log.Error($"Error: {ex}"); string title = "Error in ImportOrdersToNetSuite"; string text = $"Error message: {ex.Message}"; string color = "red"; TeamsHelper teamsMessage = new TeamsHelper(title, text, color, errorLogsUrl); teamsMessage.LogToMicrosoftTeams(teamsMessage); } }
private static void AlertB2BTeam() { var ordersMissingProIdJSON = JsonConvert.SerializeObject(ordersMissingProId); var warningMessage = $"The following orders cannot import because the customer is missing a Nest Pro ID: {ordersMissingProIdJSON}"; Log.Warning(warningMessage); string title = "Error Importing Nest Pro Orders"; string text = warningMessage; string color = "red"; TeamsHelper teamsMessage = new TeamsHelper(title, text, color, nestTeamUrl); teamsMessage.LogToMicrosoftTeams(teamsMessage); }
static void Main() { Log.Logger = new LoggerConfiguration() .WriteTo.File(logPath) .CreateLogger(); Log.Information("Program started"); try { // Pull orders in 'Awaiting Shipment' and 'Partially Shipped' status JArray ordersAwaitingShipment = BigCommerceController.GetOrdersByStatus(awaitingShipmentStatusId); JArray partiallyShippedOrders = BigCommerceController.GetOrdersByStatus(partiallyShippedStatusId); // Merge the two JArray's JArray allOrdersAwaitingShipments = MergeJArrays(ordersAwaitingShipment, partiallyShippedOrders); // Create shipments in Big Commerce if any new item fulfillments are found in NetSuite if (allOrdersAwaitingShipments.Count() == 0) { Log.Information("No shipments to import"); return; } ImportShipmentsToBigCommerce(allOrdersAwaitingShipments); return; } catch (Exception ex) { Log.Error("Error: {@ex}", ex); string title = "Error in NestProShipments"; string text = $"Error message: {ex.Message}"; string color = "red"; TeamsHelper teamsMessage = new TeamsHelper(title, text, color, teamsUrl); teamsMessage.LogToMicrosoftTeams(teamsMessage); } }
public static void ImportShipmentsToBigCommerce(JArray allOrdersAwaitingShipments) { try { foreach (var order in allOrdersAwaitingShipments) { Order parsedOrder = JsonConvert.DeserializeObject <Order>(order.ToString()); BigCommerceController.bigCommerceOrderId = parsedOrder.id; Log.Information($"Big Commerce Order Id: {BigCommerceController.bigCommerceOrderId}"); // Query NetSuite to get any matching item fulfillments string netsuiteSalesOrderId = parsedOrder.staff_notes; /* Get a list of NetSuite item fulfillment ids (partially shipped orders only) that already exist * in Big Commerce to exclude so we do not create duplicate shipments. */ List <string> importedItemFulfillmentIds = new List <string>(); if (parsedOrder.status.ToLower() == "partially shipped") { importedItemFulfillmentIds = BigCommerceController.GetImportedItemFulfillments(); } var itemFulfillmentGroupsToImport = NetSuiteController.GetItemFulfillmentsNotImported(netsuiteSalesOrderId, importedItemFulfillmentIds); // Skip line if no item fulfillments are found if (itemFulfillmentGroupsToImport.Count() == 0) { Log.Information($"No item fulfillments to import."); continue; } // Send each item fulfillment group to Big Commerce as a Shipment foreach (var itemFulfillmentGroupToImport in itemFulfillmentGroupsToImport) { Log.Information($"Itfil ID: {itemFulfillmentGroupToImport.Key}"); BigCommerceController.currentItemFulfillment = itemFulfillmentGroupToImport; Shipment shipmentToCreate = BigCommerceController.CreateShipmentRequest(itemFulfillmentGroupToImport); // Big Commerce will throw exception if shipment does not have a tracking number if (shipmentToCreate.TrackingNumber == "") { Log.Warning($"No tracking numbers found. Shipment not created."); continue; } // Create the Shipment in Big Commerce try { Shipment shipmentCreated = BigCommerceController.PostShipmentToBigCommerce(shipmentToCreate); Log.Information($"shipment id {shipmentCreated.ShipmentId} created."); } catch (Exception ex) { string errorMessage = $"Error Posting Shipment To Big Commerce. Error: {ex}"; Log.Error(errorMessage); string title = "Error in NestProShipments PostShipmentToBigCommerce"; string text = errorMessage; string color = "yellow"; TeamsHelper teamsMessage = new TeamsHelper(title, text, color, Program.teamsUrl); teamsMessage.LogToMicrosoftTeams(teamsMessage); } } } } catch (Exception ex) { string errorMessage = $"Error in ImportShipmentsToBigCommerce. Error: {ex}"; Log.Error(errorMessage); string title = "Error in NestProShipments ImportShipmentsToBigCommerce"; string text = errorMessage; string color = "red"; TeamsHelper teamsMessage = new TeamsHelper(title, text, color, Program.teamsUrl); teamsMessage.LogToMicrosoftTeams(teamsMessage); } }