public void WillCreateANewCustomerInNetsuite()
{
var createCustomerRequest = new OrderToImport();
// General information
createCustomerRequest.Email = $"{Faker.Name.First()}{Faker.Name.Last()}@gmail.com";
createCustomerRequest.PhoneNumber = Faker.Phone.Number();
createCustomerRequest.Department = NetSuiteController.b2bDepartmentId;
createCustomerRequest.UserTypeId = NetSuiteController.generalContractor;
// Billing address
createCustomerRequest.BillingFirstName = Faker.Name.First();
createCustomerRequest.BillingLastName = Faker.Name.Last();
createCustomerRequest.BillingLine1 = Faker.Address.StreetAddress();
createCustomerRequest.BillingLine2 = "Apt B";
createCustomerRequest.BillingCity = Faker.Address.City();
createCustomerRequest.BillingState = Faker.Address.UsState();
createCustomerRequest.BillingZip = Faker.Address.ZipCode();
createCustomerRequest.BillingCountry = "US";
// Shipping Address
createCustomerRequest.ShippingFirstName = Faker.Name.First();
createCustomerRequest.ShippingLastName = Faker.Name.Last();
createCustomerRequest.ShippingLine1 = Faker.Address.StreetAddress();
createCustomerRequest.ShippingLine2 = "Room 104";
createCustomerRequest.ShippingCity = Faker.Address.City();
createCustomerRequest.ShippingState = Faker.Address.UsState();
createCustomerRequest.ShippingZip = Faker.Address.ZipCode();
createCustomerRequest.ShippingCountry = "US";
string customerId = NetSuiteController.GetNetSuiteCustomerId(createCustomerRequest);
Assert.NotNull(customerId);
}
public void WillGetNetSuiteItemIdBySku()
{
string sku = "69000";
string netsuiteItemId = "10268";
string result = NetSuiteController.GetNetSuiteItemIdBySku(sku);
Assert.Equal(netsuiteItemId, result);
}
public void WillGetSKUOfParentKit()
{
int?parentKitId = 3854678;
var sku = NetSuiteController.GetSKUOfParentKit(parentKitId);
Assert.Equal("GoogleWifiRouter2Pointsw/CharcoalHub", sku);
}
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);
}
}
public void WillGetTrackingNumbersByItemFulfillment()
{
string itemFulfillmentId = "71973675";
List <string> trackingNumbers = NetSuiteController.GetTrackingNumbersByItemFulfillment(itemFulfillmentId);
Assert.Equal("1Z7849523049857", trackingNumbers[0]);
Assert.Equal("1Z3897341903472", trackingNumbers[1]);
}
public void WillImportOrderToNetSuite()
{
OrderToImport importOrderRequest = CreateFakeOrderToImport();
string salesOrderId = NetSuiteController.ImportOrderToNetSuite(importOrderRequest);
OrderToImport netsuiteResponse = GetSalesOrderValues(salesOrderId);
// Billing address
Assert.Equal($"{importOrderRequest.BillingFirstName} {importOrderRequest.BillingLastName}", netsuiteResponse.BillingAddressee);
Assert.Equal(importOrderRequest.BillingLine1, netsuiteResponse.BillingLine1);
Assert.Equal(importOrderRequest.BillingLine2, netsuiteResponse.BillingLine2);
Assert.Equal(importOrderRequest.BillingCity, netsuiteResponse.BillingCity);
Assert.Equal(importOrderRequest.BillingState, netsuiteResponse.BillingState);
Assert.Equal(importOrderRequest.BillingZip, netsuiteResponse.BillingZip);
// Shipping address
Assert.Equal($"{importOrderRequest.ShippingFirstName} {importOrderRequest.ShippingLastName}", netsuiteResponse.ShippingAddressee);
Assert.Equal(importOrderRequest.ShippingLine1, netsuiteResponse.ShippingLine1);
Assert.Equal(importOrderRequest.ShippingLine2, netsuiteResponse.ShippingLine2);
Assert.Equal(importOrderRequest.ShippingCity, netsuiteResponse.ShippingCity);
Assert.Equal(importOrderRequest.ShippingState, netsuiteResponse.ShippingState);
Assert.Equal(importOrderRequest.ShippingZip, netsuiteResponse.ShippingZip);
Assert.Equal(importOrderRequest.CheckoutTypeId, netsuiteResponse.CheckoutTypeId);
Assert.Equal(importOrderRequest.CustomerId, netsuiteResponse.CustomerId);
Assert.Equal(importOrderRequest.Department, netsuiteResponse.Department);
Assert.Equal(importOrderRequest.IPAddress, netsuiteResponse.IPAddress);
Assert.Equal(importOrderRequest.Microsite, netsuiteResponse.Microsite);
Assert.Equal(importOrderRequest.Note, netsuiteResponse.Note);
Assert.Equal(importOrderRequest.SiteOrderNumber, netsuiteResponse.SiteOrderNumber);
Assert.Equal(importOrderRequest.PaymentMethodId, netsuiteResponse.PaymentMethodId);
// Items
foreach (var item in netsuiteResponse.Items)
{
if (item.ItemId != "484204" && item.ItemId != "348230")
{
throw new Exception($"Unexpected item id {item.ItemId}");
}
else if (item.ItemId == "484204")
{
Assert.Equal(importOrderRequest.Items[0].Quantity, item.Quantity);
Assert.Equal(importOrderRequest.Items[0].Rate, item.Rate);
Assert.Equal(importOrderRequest.Items[0].Amount, item.Amount);
Assert.Equal(importOrderRequest.Items[0].PersonalItem, item.PersonalItem);
}
else
{
Assert.Equal(importOrderRequest.Items[1].Quantity, item.Quantity);
Assert.Equal(importOrderRequest.Items[1].Rate, item.Rate);
Assert.Equal(importOrderRequest.Items[1].Amount, item.Amount);
Assert.Equal(importOrderRequest.Items[1].PersonalItem, item.PersonalItem);
}
}
}
public void WillGetCustomerNetSuiteId()
{
OrderToImport customerRequest = new OrderToImport();
customerRequest.Email = "*****@*****.**";
int expectedCustomerId = 17494445;
string netsuiteCustomerId = NetSuiteController.GetNetSuiteCustomerId(customerRequest);
Assert.Equal(expectedCustomerId, Convert.ToInt32(netsuiteCustomerId));
}
public void WillSetTaxableStatus()
{
BigCommerceCustomer customer = new BigCommerceCustomer();
customer.tax_exempt_category = "G";
OrderToImport netsuiteRequest = new OrderToImport();
bool expectedTaxableStatus = false;
NetSuiteController.SetTaxableStatus(customer, netsuiteRequest);
Assert.Equal(expectedTaxableStatus, netsuiteRequest.Taxable);
}
public void WillGetItemIsPersonalValue()
{
string netsuiteSalesOrderId = "72290158";
List <string> itemFulfillmentIdsImported = new List <string>();
var itemFulfillmentGroupsToImport = NetSuiteController.GetItemFulfillmentsNotImported(netsuiteSalesOrderId, itemFulfillmentIdsImported);
foreach (var itemGroup in itemFulfillmentGroupsToImport)
{
foreach (var line in itemGroup)
{
Assert.NotNull(line.IsPersonal);
}
}
}
public void WillSetCustomerName()
{
string firstName = "Morty";
string lastName = "Smith";
BigCommerceCustomer customer = new BigCommerceCustomer();
customer.first_name = firstName;
customer.last_name = lastName;
OrderToImport netsuiteRequest = new OrderToImport();
NetSuiteController.SetCustomerName(customer, netsuiteRequest);
Assert.Equal(firstName, netsuiteRequest.CustomerFirstName);
Assert.Equal(lastName, netsuiteRequest.CustomerLastName);
Assert.Equal(firstName + " " + lastName, netsuiteRequest.CustomerName);
}
public void WillCreateNetSuiteRequest()
{
BigCommerceController.customerId = 2;
Order order = CreateFakeBigCommerceOrder();
ShippingAddress shippingAddress = CreateFakeShippingAddress();
OrderToImport netsuiteRequest = NetSuiteController.CreateNetSuiteRequest(order, shippingAddress);
Assert.Equal(order.billing_address.email, netsuiteRequest.Email);
Assert.Equal(order.billing_address.phone, netsuiteRequest.PhoneNumber);
Assert.Equal(NetSuiteController.b2bDepartmentId, netsuiteRequest.Department);
Assert.Equal(order.ip_address, netsuiteRequest.IPAddress);
Assert.Equal("BB1-866", netsuiteRequest.NestProId);
Assert.Equal($"NP{order.id}", netsuiteRequest.SiteOrderNumber);
Assert.Equal(order.payment_provider_id, netsuiteRequest.AltOrderNumber);
Assert.Equal(NetSuiteController.micrositeId, netsuiteRequest.Microsite);
Assert.Equal(NetSuiteController.registered, netsuiteRequest.CheckoutTypeId);
Assert.Equal(Convert.ToDouble(order.base_shipping_cost), netsuiteRequest.SH);
Assert.Equal(order.billing_address.first_name, netsuiteRequest.BillingFirstName);
Assert.Equal(order.billing_address.last_name, netsuiteRequest.BillingLastName);
Assert.Equal(order.billing_address.street_1, netsuiteRequest.BillingLine1);
Assert.Equal(order.billing_address.street_2, netsuiteRequest.BillingLine2);
Assert.Equal(order.billing_address.city, netsuiteRequest.BillingCity);
Assert.Equal(NetSuiteHelper.GetStateByName(order.billing_address.state), netsuiteRequest.BillingState);
Assert.Equal(order.billing_address.zip, netsuiteRequest.BillingZip);
Assert.Equal(order.billing_address.country_iso2, netsuiteRequest.BillingCountry);
Assert.Equal(NetSuiteController.generalContractor, netsuiteRequest.UserTypeId);
Assert.Equal(shippingAddress.first_name, netsuiteRequest.ShippingFirstName);
Assert.Equal(shippingAddress.last_name, netsuiteRequest.ShippingLastName);
Assert.Equal(shippingAddress.street_1, netsuiteRequest.ShippingLine1);
Assert.Equal(shippingAddress.street_2, netsuiteRequest.ShippingLine2);
Assert.Equal(shippingAddress.city, netsuiteRequest.ShippingCity);
Assert.Equal(NetSuiteHelper.GetStateByName(shippingAddress.state), netsuiteRequest.ShippingState);
Assert.Equal(shippingAddress.zip, netsuiteRequest.ShippingZip);
Assert.Equal(shippingAddress.country_iso2, netsuiteRequest.ShippingCountry);
Assert.Equal(BigCommerceHelper.GetShippingMethodName(shippingAddress.shipping_method), netsuiteRequest.ShippingMethodName);
}
public void WillGetItemFulfillmentsNotImportedToNetSuite()
{
List <string> itemFulfillmentIdsImported = new List <string>();
var itemFulfillmentGroupsToImport = NetSuiteController.GetItemFulfillmentsNotImported(netsuiteSalesOrderId, itemFulfillmentIdsImported);
foreach (var itemFulfillmentGroup in itemFulfillmentGroupsToImport)
{
foreach (var itemFulfillment in itemFulfillmentGroup)
{
//Assert.Equal(itemFulfillmentIdOne, itemFulfillment.ItemFulfillmentId);
if (itemFulfillment.ItemFulfillmentId == itemFulfillmentIdOne)
{
Assert.Equal("R&L Carriers", itemFulfillment.Carrier);
Assert.Equal(trackingNumberOne, itemFulfillment.TrackingNumber);
if (itemFulfillment.SKU == "559LF-BLMPU")
{
Assert.Equal(1, itemFulfillment.Quantity);
}
else if (itemFulfillment.SKU == "SS114#01" || itemFulfillment.SKU == "C244EF#01" || itemFulfillment.SKU == "ST243E#01")
{
Assert.Equal(3, itemFulfillment.Quantity);
}
}
else if (itemFulfillment.ItemFulfillmentId == itemFulfillmentIdTwo)
{
Assert.Equal("UPS COLLECT", itemFulfillment.Carrier);
Assert.Equal(trackingNumberTwo, itemFulfillment.TrackingNumber);
if (itemFulfillment.SKU == "T14459-BL")
{
Assert.Equal(1, itemFulfillment.Quantity);
}
}
}
}
}
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);
}
}
