[Thursday 24th of September 2026 09:41:13 AM] ORDER WEBHOOK STARTED - Order ID: 2287 [Thursday 24th of September 2026 09:41:13 AM] Fetching customer data for Order ID: 2287 [Thursday 24th of September 2026 09:41:13 AM] get_order_customer_data() - START - Order ID: 2287 [Thursday 24th of September 2026 09:41:13 AM] get_order_customer_data() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v2/orders/2287 [Thursday 24th of September 2026 09:41:13 AM] get_order_customer_data() - BigCommerce API call successful for Order ID: 2287 [Thursday 24th of September 2026 09:41:13 AM] get_order_customer_data() - Parsing order response for Order ID: 2287 [Thursday 24th of September 2026 09:41:13 AM] get_order_customer_data() - Customer object built - Customer ID: 0 | Name: Joe Sardo | Email: my_mechanic@ymail.com | Total: 59.4200 | Shipping: 14.50 [Thursday 24th of September 2026 09:41:13 AM] get_order_customer_data() - END - Order ID: 2287 [Thursday 24th of September 2026 09:41:13 AM] Customer data received: {"id":0,"email":"my_mechanic@ymail.com","address_1":"1974 Southwest Biltmore Street","address_2":"","city":"PORT SAINT LUCIE","state":"FL","country":"USA","zip":"34984","f_name":"Joe","l_name":"Sardo","contact_5":"my_mechanic@ymail.com","contact_1":"7728825427","contact_4":"Joe Sardo"} [Thursday 24th of September 2026 09:41:13 AM] Fetching shipping info for Order ID: 2287 [Thursday 24th of September 2026 09:41:13 AM] get_order_shipping_info() - START - Order ID: 2287 [Thursday 24th of September 2026 09:41:13 AM] get_order_shipping_info() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v2/orders/2287/shipping_addresses [Thursday 24th of September 2026 09:41:14 AM] get_order_shipping_info() - BigCommerce API call successful for Order ID: 2287 [Thursday 24th of September 2026 09:41:14 AM] get_order_shipping_info() - Shipping address retrieved for Order ID: 2287 | Name: Joe Sardo | Address: 1974 Southwest Biltmore Street, PORT SAINT LUCIE, Florida, 34984 [Thursday 24th of September 2026 09:41:14 AM] get_order_shipping_info() - END - Order ID: 2287 [Thursday 24th of September 2026 09:41:14 AM] Shipping info received: {"id":2186,"order_id":2287,"first_name":"Joe","last_name":"Sardo","company":"MY MECHANIC OF T.C LLC","street_1":"1974 Southwest Biltmore Street","street_2":"","city":"PORT SAINT LUCIE","zip":"34984","country":"United States","country_iso2":"US","state":"Florida","email":"my_mechanic@ymail.com","phone":"7728825427","items_total":2,"items_shipped":0,"shipping_method":"FedEx Ground","base_cost":"14.5000","cost_ex_tax":"14.5000","cost_inc_tax":"14.5000","cost_tax":"0.0000","cost_tax_class_id":2,"base_handling_cost":"0.0000","handling_cost_ex_tax":"0.0000","handling_cost_inc_tax":"0.0000","handling_cost_tax":"0.0000","handling_cost_tax_class_id":2,"shipping_zone_id":3,"shipping_zone_name":"United States","shipping_quotes":{"url":"https:\/\/api.bigcommerce.com\/stores\/caspfzrito\/v2\/orders\/2287\/shipping_addresses\/2186\/shipping_quotes","resource":"\/orders\/2287\/shipping_addresses\/2186\/shipping_quotes"},"form_fields":[]} [Thursday 24th of September 2026 09:41:14 AM] Resolved Customer ID: APONLINE [Thursday 24th of September 2026 09:41:14 AM] Building order object for Invoice: AP2287 [Thursday 24th of September 2026 09:41:14 AM] Order object built: {"WAREHOUSE":"A-HTM","INVOICE":"AP2287","ADDRESS1":"1974 Southwest Biltmore Street","ADDRESS2":"","C_ADDRESS1":"1974 Southwest Biltmore Street","C_ADDRESS2":"","C_CITY":"PORT SAINT LUCIE","C_COUNTRY":"USA","C_EMAIL":"my_mechanic@ymail.com","C_NAME":"Joe Sardo","C_STATE":"FL","C_ZIP":"34984","ShippingAmount":"14.50","CITY":"PORT SAINT LUCIE","EMAIL":"my_mechanic@ymail.com","ID":"APONLINE","NAME":"Joe Sardo","STATE":"FL","COUNTRY":"USA","ZIP":"34984","MEMO":"","DESCR":"BigCommerce Order - AP2287 - Customer APONLINE"} [Thursday 24th of September 2026 09:41:14 AM] Guest checkout detected (APONLINE) - skipping customer sync [Thursday 24th of September 2026 09:41:14 AM] Fetching products from BigCommerce for Order ID: 2287 [Thursday 24th of September 2026 09:41:14 AM] BigCommerce API call successful for Order ID: 2287 [Thursday 24th of September 2026 09:41:14 AM] Products received: 1 item(s) [Thursday 24th of September 2026 09:41:14 AM] Processing product SKU: ALL46404-30 | Qty: 2 | Price: 20.9900 [Thursday 24th of September 2026 09:41:14 AM] get_mpn() - START - Product ID: 47632 [Thursday 24th of September 2026 09:41:14 AM] get_mpn() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/47632 [Thursday 24th of September 2026 09:41:14 AM] get_mpn() - BigCommerce API call successful for Product ID: 47632 [Thursday 24th of September 2026 09:41:14 AM] get_mpn() - WARNING - MPN is empty for Product ID: 47632 [Thursday 24th of September 2026 09:41:14 AM] get_mpn() - END - Product ID: 47632 | MPN: [Thursday 24th of September 2026 09:41:14 AM] check_for_ebms_product() - START - SKU: ALL46404-30 [Thursday 24th of September 2026 09:41:14 AM] check_for_ebms_product() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/INVENTRY?%24filter=ID%20eq%20%27ALL46404-30%27 [Thursday 24th of September 2026 09:41:17 AM] check_for_ebms_product() - EBMS API call successful for SKU: ALL46404-30 [Thursday 24th of September 2026 09:41:17 AM] check_for_ebms_product() - SKU: ALL46404-30 found in EBMS [Thursday 24th of September 2026 09:41:17 AM] check_for_ebms_product() - END - SKU: ALL46404-30 | Found: true [Thursday 24th of September 2026 09:41:17 AM] SKU ALL46404-30 found in EBMS - checking prices [Thursday 24th of September 2026 09:41:17 AM] obtain_current_prices() - START - SKU: ALL46404-30 [Thursday 24th of September 2026 09:41:17 AM] obtain_current_prices() - Checking Motorstate for SKU: ALL46404-30 [Thursday 24th of September 2026 09:41:17 AM] check_for_ms_product() - START - SKU: ALL46404-30 [Thursday 24th of September 2026 09:41:17 AM] check_for_ms_product() - Calling Motorstate API - URL: https://api.motorstate.com/api/Product?partNumbers=ALL46404-30 [Thursday 24th of September 2026 09:41:17 AM] check_for_ms_product() - Motorstate API call successful for SKU: ALL46404-30 [Thursday 24th of September 2026 09:41:17 AM] check_for_ms_product() - SKU: ALL46404-30 found in Motorstate [Thursday 24th of September 2026 09:41:17 AM] check_for_ms_product() - END - SKU: ALL46404-30 | Found: true [Thursday 24th of September 2026 09:41:17 AM] obtain_current_prices() - SKU: ALL46404-30 found in Motorstate - Fetching prices [Thursday 24th of September 2026 09:41:17 AM] obtain_current_prices() - Motorstate API call attempt 1 for SKU: ALL46404-30 - URL: https://api.motorstate.com/api/Product?partNumbers=ALL46404-30 [Thursday 24th of September 2026 09:41:18 AM] obtain_current_prices() - Motorstate prices retrieved for SKU: ALL46404-30 - Base: 20.99 | Cost: 12.13 [Thursday 24th of September 2026 09:41:18 AM] obtain_current_prices() - Returning Motorstate prices for SKU: ALL46404-30 - Base: 20.99 | Cost: 12.13 [Thursday 24th of September 2026 09:41:18 AM] obtain_current_prices() - END - SKU: ALL46404-30 [Thursday 24th of September 2026 09:41:18 AM] SKU ALL46404-30 has existing EBMS prices - syncing BigCommerce price back (cost: 12.13, base: 20.99) [Thursday 24th of September 2026 09:41:18 AM] update_product_price() - START - Product ID: 47632 | Base: 20.99 | Cost: 12.13 [Thursday 24th of September 2026 09:41:18 AM] update_product_price() - Calling BigCommerce API PUT - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/47632 [Thursday 24th of September 2026 09:41:18 AM] update_product_price() - PUT payload: {"price":20.989999999999998436805981327779591083526611328125,"cost_price":12.1300000000000007815970093361102044582366943359375} [Thursday 24th of September 2026 09:41:18 AM] update_product_price() - Attempt 1 of 6 for Product ID: 47632 [Thursday 24th of September 2026 09:41:18 AM] update_product_price() - Price updated successfully for Product ID: 47632 - Base: 20.99 | Cost: 12.13 [Thursday 24th of September 2026 09:41:18 AM] update_product_price() - END - Product ID: 47632 | Result: success [Thursday 24th of September 2026 09:41:18 AM] BigCommerce price updated for Product ID: 47632 [Thursday 24th of September 2026 09:41:18 AM] get_product_inventory() - START - SKU: ALL46404-30 [Thursday 24th of September 2026 09:41:18 AM] get_product_inventory() - Calling Motorstate API - URL: https://api.motorstate.com/api/Product?partNumbers=ALL46404-30 [Thursday 24th of September 2026 09:41:19 AM] get_product_inventory() - Motorstate API call successful for SKU: ALL46404-30 [Thursday 24th of September 2026 09:41:19 AM] get_product_inventory() - Stock found for SKU: ALL46404-30 - Quantity: 66 | Running Total: 66 [Thursday 24th of September 2026 09:41:19 AM] get_product_inventory() - END - SKU: ALL46404-30 | Total: 66 [Thursday 24th of September 2026 09:41:19 AM] get_cf_id() - START - Product ID: 47632 [Thursday 24th of September 2026 09:41:19 AM] get_cf_id() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/47632/custom-fields [Thursday 24th of September 2026 09:41:19 AM] get_cf_id() - BigCommerce API call successful for Product ID: 47632 [Thursday 24th of September 2026 09:41:19 AM] get_cf_id() - Custom field found for Product ID: 47632 | Field: online_stock_level | CF ID: 47522 [Thursday 24th of September 2026 09:41:19 AM] get_cf_id() - END - Product ID: 47632 | CF ID: 47522 [Thursday 24th of September 2026 09:41:19 AM] Updating inventory for SKU ALL46404-30 - stock: 66, CF ID: 47522 [Thursday 24th of September 2026 09:41:19 AM] update_product_inventory() - START - Product ID: 47632 | Stock: 66 | CF ID: 47522 [Thursday 24th of September 2026 09:41:19 AM] update_product_inventory() - Calling BigCommerce API PUT - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/47632/custom-fields/47522 [Thursday 24th of September 2026 09:41:20 AM] update_product_inventory() - Inventory updated successfully for Product ID: 47632 | Stock: 66 [Thursday 24th of September 2026 09:41:20 AM] update_product_inventory() - END - Product ID: 47632 | Result: success [Thursday 24th of September 2026 09:41:20 AM] Inventory updated for SKU: ALL46404-30 [Thursday 24th of September 2026 09:41:20 AM] All products processed - Order details: [{"ID":"APONLINE","INVEN":"ALL46404-30","M_QUAN_VIS":2,"UNIT":"20.99","UNIT_MEAS":"EA"}] [Thursday 24th of September 2026 09:41:20 AM] Building payment record - Total: 59.4200 [Thursday 24th of September 2026 09:41:20 AM] Full order payload ready: {"WAREHOUSE":"A-HTM","INVOICE":"AP2287","ADDRESS1":"1974 Southwest Biltmore Street","ADDRESS2":"","C_ADDRESS1":"1974 Southwest Biltmore Street","C_ADDRESS2":"","C_CITY":"PORT SAINT LUCIE","C_COUNTRY":"USA","C_EMAIL":"my_mechanic@ymail.com","C_NAME":"Joe Sardo","C_STATE":"FL","C_ZIP":"34984","ShippingAmount":"14.50","CITY":"PORT SAINT LUCIE","EMAIL":"my_mechanic@ymail.com","ID":"APONLINE","NAME":"Joe Sardo","STATE":"FL","COUNTRY":"USA","ZIP":"34984","MEMO":"","DESCR":"BigCommerce Order - AP2287 - Customer APONLINE","Details":[{"ID":"APONLINE","INVEN":"ALL46404-30","M_QUAN_VIS":2,"UNIT":"20.99","UNIT_MEAS":"EA"}],"Payments":[{"TYPE":"Credit","ACTION":"XX7","AMOUNT":"59.42","CASH_ACNT":"01021-100","CHECK_NO":"APBC","CC_TYPE":"APBC"}]} [Thursday 24th of September 2026 09:41:20 AM] check_if_invoice_exists_in_ebms() - START - Invoice ID: AP2287 [Thursday 24th of September 2026 09:41:20 AM] check_if_invoice_exists_in_ebms() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARINV?%24filter=INVOICE%20eq%20%27AP2287%27 [Thursday 24th of September 2026 09:41:20 AM] check_if_invoice_exists_in_ebms() - EBMS API call successful for Invoice ID: AP2287 [Thursday 24th of September 2026 09:41:20 AM] check_if_invoice_exists_in_ebms() - Invoice ID: AP2287 not found in EBMS [Thursday 24th of September 2026 09:41:20 AM] check_if_invoice_exists_in_ebms() - END - Invoice ID: AP2287 | Found: false [Thursday 24th of September 2026 09:41:20 AM] Invoice AP2287 does not exist in EBMS - creating [Thursday 24th of September 2026 09:41:20 AM] create_ebms_invoice() - START - Invoice: AP2287 [Thursday 24th of September 2026 09:41:20 AM] create_ebms_invoice() - Order payload: {"WAREHOUSE":"A-HTM","INVOICE":"AP2287","ADDRESS1":"1974 Southwest Biltmore Street","ADDRESS2":"","C_ADDRESS1":"1974 Southwest Biltmore Street","C_ADDRESS2":"","C_CITY":"PORT SAINT LUCIE","C_COUNTRY":"USA","C_EMAIL":"my_mechanic@ymail.com","C_NAME":"Joe Sardo","C_STATE":"FL","C_ZIP":"34984","ShippingAmount":"14.50","CITY":"PORT SAINT LUCIE","EMAIL":"my_mechanic@ymail.com","ID":"APONLINE","NAME":"Joe Sardo","STATE":"FL","COUNTRY":"USA","ZIP":"34984","MEMO":"","DESCR":"BigCommerce Order - AP2287 - Customer APONLINE","Details":[{"ID":"APONLINE","INVEN":"ALL46404-30","M_QUAN_VIS":2,"UNIT":"20.99","UNIT_MEAS":"EA"}],"Payments":[{"TYPE":"Credit","ACTION":"XX7","AMOUNT":"59.42","CASH_ACNT":"01021-100","CHECK_NO":"APBC","CC_TYPE":"APBC"}]} [Thursday 24th of September 2026 09:41:20 AM] create_ebms_invoice() - Calling EBMS API POST - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARINV [Thursday 24th of September 2026 09:41:28 AM] create_ebms_invoice() - EBMS API call successful for Invoice: AP2287 [Thursday 24th of September 2026 09:41:28 AM] create_ebms_invoice() - Invoice created successfully in EBMS - Invoice: AP2287 - Response: {"@odata.context":"http:\/\/localhost:60530\/myebms\/HOO\/OData\/$metadata#ARINV\/$entity","Guid":"42504d50-3741-5634-424d-4e4943303030","AUTOID":"PMPBA74VBMNIC000","AUTHORIZED":0,"BAL_CUST_C":0,"BAL_CUST_P":-44.9200000000000017053025658242404460906982421875,"BAL_CUST_X":-44.9200000000000017053025658242404460906982421875,"BALANCE":-44.9200000000000017053025658242404460906982421875,"DISC_PERC":0,"DISCOUNT":0,"EST_F_CONV":0,"EST_F_SURC":0,"OVERDUE":0,"PERC_MARG":0,"SO_BALCUST":0,"SO_TAX":2.939999999999999946709294817992486059665679931640625,"TAX":0,"TOTAL_COST":0,"TOTAL_MARG":0,"TOTAL_PAID":59.4200000000000017053025658242404460906982421875,"TOTAL_S_SO":41.97999999999999687361196265555918216705322265625,"TOTAL_SO":59.4200000000000017053025658242404460906982421875,"TOTAL_W":0,"TTLPROCPMT":59.4200000000000017053025658242404460906982421875,"TOTAL":14.5,"FREIGHT":14.5,"HANDLING":0,"SHIPPING":14.5,"SUBTOTAL":0,"TOTAL_ITEM":0,"GRACE":"(None)","STATUS":"U","USER_NAME":"BLAYZER-API","TAX_TABLE":"","ADDRESS1":"1974 Southwest Biltmore Street","ADDRESS2":"","C_EMAIL":"my_mechanic@ymail.com","C_PHONE":"","CCNTCT_AID":"MSBGPE26K2A7OTQ0","CHARGE":"Due on Receipt","CHECK_DATE":"2026-09-24T00:00:00Z","CHECK_NO":" APBC","CITY":"PORT SAINT LUCIE","CNTCT_AID":"MSBGPE26K2A7OTQ0","COUNTRY":"USA","DIS_DATE":null,"DISCOUN":"(None)","DOWN_PAY":"23000-000","DUE_DATE":"2026-09-24T00:00:00Z","E_DATE":"2026-09-24T00:00:00Z","EC_RPT_ERR":"","EC_RPT_RUN":false,"EMAIL":"my_mechanic@ymail.com","IADDRESS":"1974 Southwest Biltmore Street , PORT SAINT LUCIE, FL 34984","ID":"APONLINE","IDCHARGE":"5CHDUREC","IDDISCOUNT":"DNONE","IN_LEVEL":"Retail","INV_DATE":"2026-09-24T00:00:00Z","INVOICE":"AP2287","MAN_FREIGH":true,"MAN_TAX":true,"NAME":"Joe Sardo","PHONE":"","PROCESS":"Default","STATE":"FL","TERMS":"Cash","TRACK_NUMS":"[]","ZIP":"34984","EXTERNALID":"","WAREHOUSE":"A-HTM","C_ADDRESS1":"1974 Southwest Biltmore Street","C_ADDRESS2":"","C_CITY":"PORT SAINT LUCIE","C_COUNTRY":"USA","C_ID":"APONLINE","C_NAME":"Joe Sardo","C_STATE":"FL","C_ZIP":"34984","DEF_DEPT":"100","DESCR":"BigCommerce Order - AP2287 - Customer APONLINE","INTERNALNT":"","JOB_ID":"","MEMO":"","PO_NO":"","SALESMAN":"","SALESMAN_Field":"","SHIP_DATE":"2026-09-24T00:00:00Z","SHIP_VIA":"BIGC","TO_B_SENT":false} [Thursday 24th of September 2026 09:41:28 AM] create_ebms_invoice() - END - Invoice: AP2287 [Thursday 24th of September 2026 09:41:28 AM] Invoice AP2287 created successfully [Thursday 24th of September 2026 09:41:28 AM] ORDER WEBHOOK COMPLETED - Order ID: 2287 | Invoice: AP2287 [Thursday 24th of September 2026 09:42:26 AM] ORDER WEBHOOK STARTED - Order ID: 2287 [Thursday 24th of September 2026 09:42:26 AM] Fetching customer data for Order ID: 2287 [Thursday 24th of September 2026 09:42:26 AM] get_order_customer_data() - START - Order ID: 2287 [Thursday 24th of September 2026 09:42:26 AM] get_order_customer_data() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v2/orders/2287 [Thursday 24th of September 2026 09:42:26 AM] get_order_customer_data() - BigCommerce API call successful for Order ID: 2287 [Thursday 24th of September 2026 09:42:26 AM] get_order_customer_data() - Parsing order response for Order ID: 2287 [Thursday 24th of September 2026 09:42:26 AM] get_order_customer_data() - Customer object built - Customer ID: 0 | Name: Joe Sardo | Email: my_mechanic@ymail.com | Total: 59.4200 | Shipping: 14.50 [Thursday 24th of September 2026 09:42:26 AM] get_order_customer_data() - END - Order ID: 2287 [Thursday 24th of September 2026 09:42:26 AM] Customer data received: {"id":0,"email":"my_mechanic@ymail.com","address_1":"1974 Southwest Biltmore Street","address_2":"","city":"PORT SAINT LUCIE","state":"FL","country":"USA","zip":"34984","f_name":"Joe","l_name":"Sardo","contact_5":"my_mechanic@ymail.com","contact_1":"7728825427","contact_4":"Joe Sardo"} [Thursday 24th of September 2026 09:42:26 AM] Fetching shipping info for Order ID: 2287 [Thursday 24th of September 2026 09:42:26 AM] get_order_shipping_info() - START - Order ID: 2287 [Thursday 24th of September 2026 09:42:26 AM] get_order_shipping_info() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v2/orders/2287/shipping_addresses [Thursday 24th of September 2026 09:42:26 AM] get_order_shipping_info() - BigCommerce API call successful for Order ID: 2287 [Thursday 24th of September 2026 09:42:26 AM] get_order_shipping_info() - Shipping address retrieved for Order ID: 2287 | Name: Joe Sardo | Address: 1974 Southwest Biltmore Street, PORT SAINT LUCIE, Florida, 34984 [Thursday 24th of September 2026 09:42:26 AM] get_order_shipping_info() - END - Order ID: 2287 [Thursday 24th of September 2026 09:42:26 AM] Shipping info received: {"id":2186,"order_id":2287,"first_name":"Joe","last_name":"Sardo","company":"MY MECHANIC OF T.C LLC","street_1":"1974 Southwest Biltmore Street","street_2":"","city":"PORT SAINT LUCIE","zip":"34984","country":"United States","country_iso2":"US","state":"Florida","email":"my_mechanic@ymail.com","phone":"7728825427","items_total":2,"items_shipped":0,"shipping_method":"FedEx Ground","base_cost":"14.5000","cost_ex_tax":"14.5000","cost_inc_tax":"14.5000","cost_tax":"0.0000","cost_tax_class_id":2,"base_handling_cost":"0.0000","handling_cost_ex_tax":"0.0000","handling_cost_inc_tax":"0.0000","handling_cost_tax":"0.0000","handling_cost_tax_class_id":2,"shipping_zone_id":3,"shipping_zone_name":"United States","shipping_quotes":{"url":"https:\/\/api.bigcommerce.com\/stores\/caspfzrito\/v2\/orders\/2287\/shipping_addresses\/2186\/shipping_quotes","resource":"\/orders\/2287\/shipping_addresses\/2186\/shipping_quotes"},"form_fields":[]} [Thursday 24th of September 2026 09:42:26 AM] Resolved Customer ID: APONLINE [Thursday 24th of September 2026 09:42:26 AM] Building order object for Invoice: AP2287 [Thursday 24th of September 2026 09:42:26 AM] Order object built: {"WAREHOUSE":"A-HTM","INVOICE":"AP2287","ADDRESS1":"1974 Southwest Biltmore Street","ADDRESS2":"","C_ADDRESS1":"1974 Southwest Biltmore Street","C_ADDRESS2":"","C_CITY":"PORT SAINT LUCIE","C_COUNTRY":"USA","C_EMAIL":"my_mechanic@ymail.com","C_NAME":"Joe Sardo","C_STATE":"FL","C_ZIP":"34984","ShippingAmount":"14.50","CITY":"PORT SAINT LUCIE","EMAIL":"my_mechanic@ymail.com","ID":"APONLINE","NAME":"Joe Sardo","STATE":"FL","COUNTRY":"USA","ZIP":"34984","MEMO":"","DESCR":"BigCommerce Order - AP2287 - Customer APONLINE"} [Thursday 24th of September 2026 09:42:26 AM] Guest checkout detected (APONLINE) - skipping customer sync [Thursday 24th of September 2026 09:42:26 AM] Fetching products from BigCommerce for Order ID: 2287 [Thursday 24th of September 2026 09:42:26 AM] BigCommerce API call successful for Order ID: 2287 [Thursday 24th of September 2026 09:42:26 AM] Products received: 1 item(s) [Thursday 24th of September 2026 09:42:26 AM] Processing product SKU: ALL46404-30 | Qty: 2 | Price: 20.9900 [Thursday 24th of September 2026 09:42:26 AM] get_mpn() - START - Product ID: 47632 [Thursday 24th of September 2026 09:42:26 AM] get_mpn() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/47632 [Thursday 24th of September 2026 09:42:27 AM] get_mpn() - BigCommerce API call successful for Product ID: 47632 [Thursday 24th of September 2026 09:42:27 AM] get_mpn() - WARNING - MPN is empty for Product ID: 47632 [Thursday 24th of September 2026 09:42:27 AM] get_mpn() - END - Product ID: 47632 | MPN: [Thursday 24th of September 2026 09:42:27 AM] check_for_ebms_product() - START - SKU: ALL46404-30 [Thursday 24th of September 2026 09:42:27 AM] check_for_ebms_product() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/INVENTRY?%24filter=ID%20eq%20%27ALL46404-30%27 [Thursday 24th of September 2026 09:42:27 AM] check_for_ebms_product() - EBMS API call successful for SKU: ALL46404-30 [Thursday 24th of September 2026 09:42:27 AM] check_for_ebms_product() - SKU: ALL46404-30 found in EBMS [Thursday 24th of September 2026 09:42:27 AM] check_for_ebms_product() - END - SKU: ALL46404-30 | Found: true [Thursday 24th of September 2026 09:42:27 AM] SKU ALL46404-30 found in EBMS - checking prices [Thursday 24th of September 2026 09:42:27 AM] obtain_current_prices() - START - SKU: ALL46404-30 [Thursday 24th of September 2026 09:42:27 AM] obtain_current_prices() - Checking Motorstate for SKU: ALL46404-30 [Thursday 24th of September 2026 09:42:27 AM] check_for_ms_product() - START - SKU: ALL46404-30 [Thursday 24th of September 2026 09:42:27 AM] check_for_ms_product() - Calling Motorstate API - URL: https://api.motorstate.com/api/Product?partNumbers=ALL46404-30 [Thursday 24th of September 2026 09:42:27 AM] check_for_ms_product() - Motorstate API call successful for SKU: ALL46404-30 [Thursday 24th of September 2026 09:42:27 AM] check_for_ms_product() - SKU: ALL46404-30 found in Motorstate [Thursday 24th of September 2026 09:42:27 AM] check_for_ms_product() - END - SKU: ALL46404-30 | Found: true [Thursday 24th of September 2026 09:42:27 AM] obtain_current_prices() - SKU: ALL46404-30 found in Motorstate - Fetching prices [Thursday 24th of September 2026 09:42:27 AM] obtain_current_prices() - Motorstate API call attempt 1 for SKU: ALL46404-30 - URL: https://api.motorstate.com/api/Product?partNumbers=ALL46404-30 [Thursday 24th of September 2026 09:42:27 AM] obtain_current_prices() - Motorstate prices retrieved for SKU: ALL46404-30 - Base: 20.99 | Cost: 12.13 [Thursday 24th of September 2026 09:42:27 AM] obtain_current_prices() - Returning Motorstate prices for SKU: ALL46404-30 - Base: 20.99 | Cost: 12.13 [Thursday 24th of September 2026 09:42:27 AM] obtain_current_prices() - END - SKU: ALL46404-30 [Thursday 24th of September 2026 09:42:27 AM] SKU ALL46404-30 has existing EBMS prices - syncing BigCommerce price back (cost: 12.13, base: 20.99) [Thursday 24th of September 2026 09:42:27 AM] update_product_price() - START - Product ID: 47632 | Base: 20.99 | Cost: 12.13 [Thursday 24th of September 2026 09:42:27 AM] update_product_price() - Calling BigCommerce API PUT - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/47632 [Thursday 24th of September 2026 09:42:27 AM] update_product_price() - PUT payload: {"price":20.989999999999998436805981327779591083526611328125,"cost_price":12.1300000000000007815970093361102044582366943359375} [Thursday 24th of September 2026 09:42:27 AM] update_product_price() - Attempt 1 of 6 for Product ID: 47632 [Thursday 24th of September 2026 09:42:27 AM] update_product_price() - Price updated successfully for Product ID: 47632 - Base: 20.99 | Cost: 12.13 [Thursday 24th of September 2026 09:42:27 AM] update_product_price() - END - Product ID: 47632 | Result: success [Thursday 24th of September 2026 09:42:27 AM] BigCommerce price updated for Product ID: 47632 [Thursday 24th of September 2026 09:42:27 AM] get_product_inventory() - START - SKU: ALL46404-30 [Thursday 24th of September 2026 09:42:27 AM] get_product_inventory() - Calling Motorstate API - URL: https://api.motorstate.com/api/Product?partNumbers=ALL46404-30 [Thursday 24th of September 2026 09:42:28 AM] get_product_inventory() - Motorstate API call successful for SKU: ALL46404-30 [Thursday 24th of September 2026 09:42:28 AM] get_product_inventory() - Stock found for SKU: ALL46404-30 - Quantity: 66 | Running Total: 66 [Thursday 24th of September 2026 09:42:28 AM] get_product_inventory() - END - SKU: ALL46404-30 | Total: 66 [Thursday 24th of September 2026 09:42:28 AM] get_cf_id() - START - Product ID: 47632 [Thursday 24th of September 2026 09:42:28 AM] get_cf_id() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/47632/custom-fields [Thursday 24th of September 2026 09:42:28 AM] get_cf_id() - BigCommerce API call successful for Product ID: 47632 [Thursday 24th of September 2026 09:42:28 AM] get_cf_id() - Custom field found for Product ID: 47632 | Field: online_stock_level | CF ID: 47522 [Thursday 24th of September 2026 09:42:28 AM] get_cf_id() - END - Product ID: 47632 | CF ID: 47522 [Thursday 24th of September 2026 09:42:28 AM] Updating inventory for SKU ALL46404-30 - stock: 66, CF ID: 47522 [Thursday 24th of September 2026 09:42:28 AM] update_product_inventory() - START - Product ID: 47632 | Stock: 66 | CF ID: 47522 [Thursday 24th of September 2026 09:42:28 AM] update_product_inventory() - Calling BigCommerce API PUT - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/47632/custom-fields/47522 [Thursday 24th of September 2026 09:42:28 AM] update_product_inventory() - Inventory updated successfully for Product ID: 47632 | Stock: 66 [Thursday 24th of September 2026 09:42:28 AM] update_product_inventory() - END - Product ID: 47632 | Result: success [Thursday 24th of September 2026 09:42:28 AM] Inventory updated for SKU: ALL46404-30 [Thursday 24th of September 2026 09:42:28 AM] All products processed - Order details: [{"ID":"APONLINE","INVEN":"ALL46404-30","M_QUAN_VIS":2,"UNIT":"20.99","UNIT_MEAS":"EA"}] [Thursday 24th of September 2026 09:42:28 AM] Building payment record - Total: 59.4200 [Thursday 24th of September 2026 09:42:28 AM] Full order payload ready: {"WAREHOUSE":"A-HTM","INVOICE":"AP2287","ADDRESS1":"1974 Southwest Biltmore Street","ADDRESS2":"","C_ADDRESS1":"1974 Southwest Biltmore Street","C_ADDRESS2":"","C_CITY":"PORT SAINT LUCIE","C_COUNTRY":"USA","C_EMAIL":"my_mechanic@ymail.com","C_NAME":"Joe Sardo","C_STATE":"FL","C_ZIP":"34984","ShippingAmount":"14.50","CITY":"PORT SAINT LUCIE","EMAIL":"my_mechanic@ymail.com","ID":"APONLINE","NAME":"Joe Sardo","STATE":"FL","COUNTRY":"USA","ZIP":"34984","MEMO":"","DESCR":"BigCommerce Order - AP2287 - Customer APONLINE","Details":[{"ID":"APONLINE","INVEN":"ALL46404-30","M_QUAN_VIS":2,"UNIT":"20.99","UNIT_MEAS":"EA"}],"Payments":[{"TYPE":"Credit","ACTION":"XX7","AMOUNT":"59.42","CASH_ACNT":"01021-100","CHECK_NO":"APBC","CC_TYPE":"APBC"}]} [Thursday 24th of September 2026 09:42:28 AM] check_if_invoice_exists_in_ebms() - START - Invoice ID: AP2287 [Thursday 24th of September 2026 09:42:28 AM] check_if_invoice_exists_in_ebms() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARINV?%24filter=INVOICE%20eq%20%27AP2287%27 [Thursday 24th of September 2026 09:42:29 AM] check_if_invoice_exists_in_ebms() - EBMS API call successful for Invoice ID: AP2287 [Thursday 24th of September 2026 09:42:29 AM] check_if_invoice_exists_in_ebms() - Invoice ID: AP2287 found in EBMS [Thursday 24th of September 2026 09:42:29 AM] check_if_invoice_exists_in_ebms() - END - Invoice ID: AP2287 | Found: true [Thursday 24th of September 2026 09:42:29 AM] Invoice AP2287 already exists in EBMS - patching [Thursday 24th of September 2026 09:42:29 AM] patch_ebms_invoice() - START - Invoice: AP2287 [Thursday 24th of September 2026 09:42:29 AM] patch_ebms_invoice() - Order payload: {"WAREHOUSE":"A-HTM","INVOICE":"AP2287","ADDRESS1":"1974 Southwest Biltmore Street","ADDRESS2":"","C_ADDRESS1":"1974 Southwest Biltmore Street","C_ADDRESS2":"","C_CITY":"PORT SAINT LUCIE","C_COUNTRY":"USA","C_EMAIL":"my_mechanic@ymail.com","C_NAME":"Joe Sardo","C_STATE":"FL","C_ZIP":"34984","ShippingAmount":"14.50","CITY":"PORT SAINT LUCIE","EMAIL":"my_mechanic@ymail.com","ID":"APONLINE","NAME":"Joe Sardo","STATE":"FL","COUNTRY":"USA","ZIP":"34984","MEMO":"","DESCR":"BigCommerce Order - AP2287 - Customer APONLINE","Details":[{"ID":"APONLINE","INVEN":"ALL46404-30","M_QUAN_VIS":2,"UNIT":"20.99","UNIT_MEAS":"EA"}],"Payments":[{"TYPE":"Credit","ACTION":"XX7","AMOUNT":"59.42","CASH_ACNT":"01021-100","CHECK_NO":"APBC","CC_TYPE":"APBC"}]} [Thursday 24th of September 2026 09:42:29 AM] patch_ebms_invoice() - Calling EBMS API PATCH - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARINV?%24filter=INVOICE%20eq%20%27AP2287%27 [Thursday 24th of September 2026 09:42:29 AM] patch_ebms_invoice() - EBMS API call successful for Invoice: AP2287 [Thursday 24th of September 2026 09:42:29 AM] patch_ebms_invoice() - WARNING - Empty response from EBMS for Invoice: AP2287 [Thursday 24th of September 2026 09:42:29 AM] patch_ebms_invoice() - END - Invoice: AP2287 [Thursday 24th of September 2026 09:42:29 AM] Invoice AP2287 patched successfully [Thursday 24th of September 2026 09:42:29 AM] ORDER WEBHOOK COMPLETED - Order ID: 2287 | Invoice: AP2287 [Thursday 24th of September 2026 09:44:42 AM] add_customer() - START - Customer ID: 589 | Name: Joe Sardo [Thursday 24th of September 2026 09:44:42 AM] add_customer() - Customer payload: {"id":589,"email":"my_mechanic@ymail.com","address_1":"1974 Southwest Biltmore Street","address_2":"","city":"PORT SAINT LUCIE","state":"FL","country":"USA","zip":"34984","f_name":"Joe","l_name":"Sardo","contact_5":"my_mechanic@ymail.com","contact_1":"7728825427","contact_4":"Joe Sardo"} [Thursday 24th of September 2026 09:44:42 AM] add_customer() - Customer fields parsed - ID: AP589 | Address: 1974 Southwest Biltmore Street, PORT SAINT LUCIE, FL 34984 | Email: my_mechanic@ymail.com [Thursday 24th of September 2026 09:44:42 AM] add_customer() - Calling EBMS API POST - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARCUST [Thursday 24th of September 2026 09:44:42 AM] add_customer() - POST payload: {"TREE_ID":"38","ADDRESS1":"1974 Southwest Biltmore Street","ADDRESS2":"","CITY":"PORT SAINT LUCIE","CONTACT_5":"my_mechanic@ymail.com","CONTACT_1":"7728825427","CONTACT_4":"Joe Sardo","COUNTRY":"USA","F_NAME":"Joe","ID":"AP589","L_NAME":"Sardo","STATE":"FL","ZIP":"34984"} [Thursday 24th of September 2026 09:44:43 AM] add_customer() - EBMS API call successful for Customer ID: AP589 [Thursday 24th of September 2026 09:44:43 AM] add_customer() - Customer created successfully in EBMS - ID: AP589 - Response: {"@odata.context":"http:\/\/localhost:60530\/myebms\/HOO\/OData\/$metadata#ARCUST\/$entity","Guid":"53464a38-364f-3141-434d-4e4943303030","AUTOID":"8JFSO6A1CMNIC000","CRED_LIM":0,"FC_RATE":1.5,"MIN_FC":1,"FULL_NAME":"Joe Sardo","ADDRESS1":"1974 Southwest Biltmore Street","ADDRESS2":"","BANK_ACCOU":"","BANK_DESCR":"","BANK_ROUTE":"","CASH":true,"CHARGE":"Due on Receipt","CHARGEDFLT":false,"CHARGEPYMT":true,"CHECK":true,"CITY":"PORT SAINT LUCIE","COUNTRY":"USA","CREDITCARD":true,"DEF_CLI_ID":"","DEF_FOB":"BIGC","DEL_REASON":"","DIRECTIONS":"","DISCOUNT":"(None)","E_DATE":"2026-09-24T00:00:00Z","EC_RPT_ERR":"","EC_RPT_RUN":false,"EMAIL":"my_mechanic@ymail.com","EMAIL_LIST":false,"F_NAME":"Joe","FRGHT_AMT":"Free","FRGHT_TYPE":"1FREE","GPS_ADD1":"","GPS_ADD2":"","GPS_CITY":"","GPS_STATE":"","GPS_ZIP":"","GRACE":"(None)","ID":"AP589","IDCHARGE":"5CHDUREC","IDDISCOUNT":"DNONE","IDGRACE":"GNONE","IN_LEVEL":"Retail","INACTIVE":false,"L_NAME":"Sardo","MAIL_LIST":false,"MEMO":"","NAMESTR":"(Joe Sardo)","OUT_CITY":false,"PHONE":"(772) 882-5427","SALESMAN":"","SAVINGS":"Checking","SHIP_TO":"","STATE":"FL","TREE_ID":" 38","TYPE":"WEBCUST","ZIP":"34984","CONID_1":"Phone","CONID_2":"Mobile Phone","CONID_3":"Fax","CONID_4":"Contact","CONID_5":"E-Mail","CONTACT_1":"(772) 882-5427","CONTACT_2":"","CONTACT_3":"","CONTACT_4":"Joe Sardo","CONTACT_5":"my_mechanic@ymail.com","EXTERNALID":""} [Thursday 24th of September 2026 09:44:43 AM] add_customer() - END - Customer ID: AP589 [Thursday 24th of September 2026 02:03:17 PM] add_customer() - START - Customer ID: 590 | Name: Burton Gillette [Thursday 24th of September 2026 02:03:17 PM] add_customer() - Customer payload: {"id":590,"email":"burton.gillette@vallen.com","address_1":"2100 The Oaks Parkway","address_2":"","city":"Belmont","state":"NC","country":"USA","zip":"28012","f_name":"Burton","l_name":"Gillette","contact_5":"burton.gillette@vallen.com","contact_1":"7043987118","contact_4":"Burton Gillette"} [Thursday 24th of September 2026 02:03:17 PM] add_customer() - Customer fields parsed - ID: AP590 | Address: 2100 The Oaks Parkway, Belmont, NC 28012 | Email: burton.gillette@vallen.com [Thursday 24th of September 2026 02:03:17 PM] add_customer() - Calling EBMS API POST - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARCUST [Thursday 24th of September 2026 02:03:17 PM] add_customer() - POST payload: {"TREE_ID":"38","ADDRESS1":"2100 The Oaks Parkway","ADDRESS2":"","CITY":"Belmont","CONTACT_5":"burton.gillette@vallen.com","CONTACT_1":"7043987118","CONTACT_4":"Burton Gillette","COUNTRY":"USA","F_NAME":"Burton","ID":"AP590","L_NAME":"Gillette","STATE":"NC","ZIP":"28012"} [Thursday 24th of September 2026 02:03:20 PM] add_customer() - EBMS API call successful for Customer ID: AP590 [Thursday 24th of September 2026 02:03:20 PM] add_customer() - Customer created successfully in EBMS - ID: AP590 - Response: {"@odata.context":"http:\/\/localhost:60530\/myebms\/HOO\/OData\/$metadata#ARCUST\/$entity","Guid":"44353256-4f42-3939-484d-4e4943303030","AUTOID":"V25DBO99HMNIC000","CRED_LIM":0,"FC_RATE":1.5,"MIN_FC":1,"FULL_NAME":"Burton Gillette","ADDRESS1":"2100 The Oaks Parkway","ADDRESS2":"","BANK_ACCOU":"","BANK_DESCR":"","BANK_ROUTE":"","CASH":true,"CHARGE":"Due on Receipt","CHARGEDFLT":false,"CHARGEPYMT":true,"CHECK":true,"CITY":"Belmont","COUNTRY":"USA","CREDITCARD":true,"DEF_CLI_ID":"","DEF_FOB":"BIGC","DEL_REASON":"","DIRECTIONS":"","DISCOUNT":"(None)","E_DATE":"2026-09-24T00:00:00Z","EC_RPT_ERR":"","EC_RPT_RUN":false,"EMAIL":"burton.gillette@vallen.com","EMAIL_LIST":false,"F_NAME":"Burton","FRGHT_AMT":"Free","FRGHT_TYPE":"1FREE","GPS_ADD1":"","GPS_ADD2":"","GPS_CITY":"","GPS_STATE":"","GPS_ZIP":"","GRACE":"(None)","ID":"AP590","IDCHARGE":"5CHDUREC","IDDISCOUNT":"DNONE","IDGRACE":"GNONE","IN_LEVEL":"Retail","INACTIVE":false,"L_NAME":"Gillette","MAIL_LIST":false,"MEMO":"","NAMESTR":"(Burton Gillette)","OUT_CITY":false,"PHONE":"(704) 398-7118","SALESMAN":"","SAVINGS":"Checking","SHIP_TO":"","STATE":"NC","TREE_ID":" 38","TYPE":"WEBCUST","ZIP":"28012","CONID_1":"Phone","CONID_2":"Mobile Phone","CONID_3":"Fax","CONID_4":"Contact","CONID_5":"E-Mail","CONTACT_1":"(704) 398-7118","CONTACT_2":"","CONTACT_3":"","CONTACT_4":"Burton Gillette","CONTACT_5":"burton.gillette@vallen.com","EXTERNALID":""} [Thursday 24th of September 2026 02:03:20 PM] add_customer() - END - Customer ID: AP590 [Thursday 24th of September 2026 02:07:02 PM] ORDER WEBHOOK STARTED - Order ID: 2288 [Thursday 24th of September 2026 02:07:02 PM] Fetching customer data for Order ID: 2288 [Thursday 24th of September 2026 02:07:02 PM] get_order_customer_data() - START - Order ID: 2288 [Thursday 24th of September 2026 02:07:02 PM] get_order_customer_data() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v2/orders/2288 [Thursday 24th of September 2026 02:07:02 PM] get_order_customer_data() - BigCommerce API call successful for Order ID: 2288 [Thursday 24th of September 2026 02:07:02 PM] get_order_customer_data() - Parsing order response for Order ID: 2288 [Thursday 24th of September 2026 02:07:02 PM] get_order_customer_data() - Customer object built - Customer ID: 590 | Name: Burton Gillette | Email: burton.gillette@vallen.com | Total: 62.6000 | Shipping: 37.08 [Thursday 24th of September 2026 02:07:02 PM] get_order_customer_data() - END - Order ID: 2288 [Thursday 24th of September 2026 02:07:02 PM] Customer data received: {"id":590,"email":"burton.gillette@vallen.com","address_1":"2100 The Oaks Parkway","address_2":"","city":"Belmont","state":"NC","country":"USA","zip":"28012","f_name":"Burton","l_name":"Gillette","contact_5":"burton.gillette@vallen.com","contact_1":"7043987118","contact_4":"Burton Gillette"} [Thursday 24th of September 2026 02:07:02 PM] Fetching shipping info for Order ID: 2288 [Thursday 24th of September 2026 02:07:02 PM] get_order_shipping_info() - START - Order ID: 2288 [Thursday 24th of September 2026 02:07:02 PM] get_order_shipping_info() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v2/orders/2288/shipping_addresses [Thursday 24th of September 2026 02:07:02 PM] get_order_shipping_info() - BigCommerce API call successful for Order ID: 2288 [Thursday 24th of September 2026 02:07:02 PM] get_order_shipping_info() - Shipping address retrieved for Order ID: 2288 | Name: Michelle Blanton | Address: 2110 East Galbraith Road, Cincinnati, Ohio, 45237 [Thursday 24th of September 2026 02:07:02 PM] get_order_shipping_info() - END - Order ID: 2288 [Thursday 24th of September 2026 02:07:02 PM] Shipping info received: {"id":2187,"order_id":2288,"first_name":"Michelle","last_name":"Blanton","company":"Patheon Pharmaceuticals c\/o Vallen","street_1":"2110 East Galbraith Road","street_2":"U-PAC056702821","city":"Cincinnati","zip":"45237","country":"United States","country_iso2":"US","state":"Ohio","email":"burton.gillette@vallen.com","phone":"7043987118","items_total":1,"items_shipped":0,"shipping_method":"FedEx 1-Day","base_cost":"37.0800","cost_ex_tax":"37.0800","cost_inc_tax":"39.9722","cost_tax":"2.8922","cost_tax_class_id":2,"base_handling_cost":"0.0000","handling_cost_ex_tax":"0.0000","handling_cost_inc_tax":"0.0000","handling_cost_tax":"0.0000","handling_cost_tax_class_id":2,"shipping_zone_id":3,"shipping_zone_name":"United States","shipping_quotes":{"url":"https:\/\/api.bigcommerce.com\/stores\/caspfzrito\/v2\/orders\/2288\/shipping_addresses\/2187\/shipping_quotes","resource":"\/orders\/2288\/shipping_addresses\/2187\/shipping_quotes"},"form_fields":[]} [Thursday 24th of September 2026 02:07:02 PM] Resolved Customer ID: AP590 [Thursday 24th of September 2026 02:07:02 PM] Building order object for Invoice: AP2288 [Thursday 24th of September 2026 02:07:02 PM] Order object built: {"WAREHOUSE":"A-HTM","INVOICE":"AP2288","ADDRESS1":"2100 The Oaks Parkway","ADDRESS2":"","C_ADDRESS1":"2110 East Galbraith Road","C_ADDRESS2":"U-PAC056702821","C_CITY":"Cincinnati","C_COUNTRY":"USA","C_EMAIL":"burton.gillette@vallen.com","C_NAME":"Michelle Blanton","C_STATE":"OH","C_ZIP":"45237","ShippingAmount":"37.08","CITY":"Belmont","EMAIL":"burton.gillette@vallen.com","ID":"AP590","NAME":"Burton Gillette","STATE":"NC","COUNTRY":"USA","ZIP":"28012","MEMO":"","DESCR":"BigCommerce Order - AP2288 - Customer AP590"} [Thursday 24th of September 2026 02:07:02 PM] Registered customer detected - checking EBMS for Customer ID: AP590 [Thursday 24th of September 2026 02:07:02 PM] check_for_customer() - START - Customer ID: 590 [Thursday 24th of September 2026 02:07:02 PM] check_for_customer() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARCUST?%24filter=ID%20eq%20%27AP590%27 [Thursday 24th of September 2026 02:07:02 PM] check_for_customer() - EBMS API call successful for Customer ID: 590 [Thursday 24th of September 2026 02:07:02 PM] check_for_customer() - Customer ID: 590 found in EBMS [Thursday 24th of September 2026 02:07:02 PM] check_for_customer() - END - Customer ID: 590 | Found: true [Thursday 24th of September 2026 02:07:02 PM] Customer AP590 found in EBMS [Thursday 24th of September 2026 02:07:02 PM] check_for_empty_info() - START - Customer ID: 590 [Thursday 24th of September 2026 02:07:02 PM] check_for_empty_info() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARCUST?%24filter=ID%20eq%20%27AP590%27 [Thursday 24th of September 2026 02:07:03 PM] check_for_empty_info() - EBMS API call successful for Customer ID: 590 [Thursday 24th of September 2026 02:07:03 PM] check_for_empty_info() - Customer record found for Customer ID: 590 - Checking ADDRESS1 field [Thursday 24th of September 2026 02:07:03 PM] check_for_empty_info() - ADDRESS1 is populated for Customer ID: 590 - No update needed [Thursday 24th of September 2026 02:07:03 PM] check_for_empty_info() - END - Customer ID: 590 | Empty Info: false [Thursday 24th of September 2026 02:07:03 PM] check_for_empty_pn() - START - Customer ID: AP590 [Thursday 24th of September 2026 02:07:03 PM] check_for_empty_pn() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARCUST?%24filter=ID%20eq%20%27AP590%27 [Thursday 24th of September 2026 02:07:03 PM] check_for_empty_pn() - EBMS API call successful for Customer ID: AP590 [Thursday 24th of September 2026 02:07:03 PM] check_for_empty_pn() - Customer record found for Customer ID: AP590 - Checking CONTACT_1 field [Thursday 24th of September 2026 02:07:03 PM] check_for_empty_pn() - CONTACT_1 is populated for Customer ID: AP590 - Value: (704) 398-7118 - No update needed [Thursday 24th of September 2026 02:07:03 PM] check_for_empty_pn() - END - Customer ID: AP590 | Empty PN: false [Thursday 24th of September 2026 02:07:03 PM] Fetching products from BigCommerce for Order ID: 2288 [Thursday 24th of September 2026 02:07:03 PM] BigCommerce API call successful for Order ID: 2288 [Thursday 24th of September 2026 02:07:03 PM] Products received: 1 item(s) [Thursday 24th of September 2026 02:07:03 PM] Processing product SKU: APPQPB9030 | Qty: 1 | Price: 20.9900 [Thursday 24th of September 2026 02:07:03 PM] get_mpn() - START - Product ID: 87421 [Thursday 24th of September 2026 02:07:03 PM] get_mpn() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/87421 [Thursday 24th of September 2026 02:07:03 PM] get_mpn() - BigCommerce API call successful for Product ID: 87421 [Thursday 24th of September 2026 02:07:03 PM] get_mpn() - WARNING - MPN is empty for Product ID: 87421 [Thursday 24th of September 2026 02:07:03 PM] get_mpn() - END - Product ID: 87421 | MPN: [Thursday 24th of September 2026 02:07:03 PM] check_for_ebms_product() - START - SKU: APPQPB9030 [Thursday 24th of September 2026 02:07:03 PM] check_for_ebms_product() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/INVENTRY?%24filter=ID%20eq%20%27APPQPB9030%27 [Thursday 24th of September 2026 02:07:04 PM] check_for_ebms_product() - EBMS API call successful for SKU: APPQPB9030 [Thursday 24th of September 2026 02:07:04 PM] check_for_ebms_product() - SKU: APPQPB9030 found in EBMS [Thursday 24th of September 2026 02:07:04 PM] check_for_ebms_product() - END - SKU: APPQPB9030 | Found: true [Thursday 24th of September 2026 02:07:04 PM] SKU APPQPB9030 found in EBMS - checking prices [Thursday 24th of September 2026 02:07:04 PM] obtain_current_prices() - START - SKU: APPQPB9030 [Thursday 24th of September 2026 02:07:04 PM] obtain_current_prices() - Checking Motorstate for SKU: APPQPB9030 [Thursday 24th of September 2026 02:07:04 PM] check_for_ms_product() - START - SKU: APPQPB9030 [Thursday 24th of September 2026 02:07:04 PM] check_for_ms_product() - Calling Motorstate API - URL: https://api.motorstate.com/api/Product?partNumbers=APPQPB9030 [Thursday 24th of September 2026 02:07:04 PM] check_for_ms_product() - Motorstate API call successful for SKU: APPQPB9030 [Thursday 24th of September 2026 02:07:04 PM] check_for_ms_product() - SKU: APPQPB9030 not found in Motorstate [Thursday 24th of September 2026 02:07:04 PM] check_for_ms_product() - END - SKU: APPQPB9030 | Found: false [Thursday 24th of September 2026 02:07:04 PM] obtain_current_prices() - SKU: APPQPB9030 not found in Motorstate - Skipping to EBMS [Thursday 24th of September 2026 02:07:04 PM] obtain_current_prices() - Checking EBMS for SKU: APPQPB9030 [Thursday 24th of September 2026 02:07:04 PM] check_for_ebms_product() - START - SKU: APPQPB9030 [Thursday 24th of September 2026 02:07:04 PM] check_for_ebms_product() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/INVENTRY?%24filter=ID%20eq%20%27APPQPB9030%27 [Thursday 24th of September 2026 02:07:04 PM] check_for_ebms_product() - EBMS API call successful for SKU: APPQPB9030 [Thursday 24th of September 2026 02:07:04 PM] check_for_ebms_product() - SKU: APPQPB9030 found in EBMS [Thursday 24th of September 2026 02:07:04 PM] check_for_ebms_product() - END - SKU: APPQPB9030 | Found: true [Thursday 24th of September 2026 02:07:04 PM] obtain_current_prices() - SKU: APPQPB9030 found in EBMS - Fetching prices [Thursday 24th of September 2026 02:07:04 PM] obtain_current_prices() - EBMS API call attempt 1 for SKU: APPQPB9030 - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/INVENTRY?%24filter=ID%20eq%20%27APPQPB9030%27 [Thursday 24th of September 2026 02:07:05 PM] obtain_current_prices() - EBMS prices retrieved for SKU: APPQPB9030 - Base: 20.99 | Cost: 9.44 [Thursday 24th of September 2026 02:07:05 PM] obtain_current_prices() - END - SKU: APPQPB9030 | Final prices - Base: 20.99 | Cost: 9.44 [Thursday 24th of September 2026 02:07:05 PM] SKU APPQPB9030 has existing EBMS prices - syncing BigCommerce price back (cost: 9.44, base: 20.99) [Thursday 24th of September 2026 02:07:05 PM] update_product_price() - START - Product ID: 87421 | Base: 20.99 | Cost: 9.44 [Thursday 24th of September 2026 02:07:05 PM] update_product_price() - Calling BigCommerce API PUT - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/87421 [Thursday 24th of September 2026 02:07:05 PM] update_product_price() - PUT payload: {"price":20.989999999999998436805981327779591083526611328125,"cost_price":9.4399999999999995026200849679298698902130126953125} [Thursday 24th of September 2026 02:07:05 PM] update_product_price() - Attempt 1 of 6 for Product ID: 87421 [Thursday 24th of September 2026 02:07:05 PM] update_product_price() - Price updated successfully for Product ID: 87421 - Base: 20.99 | Cost: 9.44 [Thursday 24th of September 2026 02:07:05 PM] update_product_price() - END - Product ID: 87421 | Result: success [Thursday 24th of September 2026 02:07:05 PM] BigCommerce price updated for Product ID: 87421 [Thursday 24th of September 2026 02:07:05 PM] get_product_inventory() - START - SKU: APPQPB9030 [Thursday 24th of September 2026 02:07:05 PM] get_product_inventory() - Calling Motorstate API - URL: https://api.motorstate.com/api/Product?partNumbers=APPQPB9030 [Thursday 24th of September 2026 02:07:05 PM] get_product_inventory() - Motorstate API call successful for SKU: APPQPB9030 [Thursday 24th of September 2026 02:07:05 PM] get_product_inventory() - SKU: APPQPB9030 not found in Motorstate response item [Thursday 24th of September 2026 02:07:05 PM] get_product_inventory() - END - SKU: APPQPB9030 | Total: 0 [Thursday 24th of September 2026 02:07:05 PM] get_cf_id() - START - Product ID: 87421 [Thursday 24th of September 2026 02:07:05 PM] get_cf_id() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/87421/custom-fields [Thursday 24th of September 2026 02:07:06 PM] get_cf_id() - BigCommerce API call successful for Product ID: 87421 [Thursday 24th of September 2026 02:07:06 PM] get_cf_id() - Custom field found for Product ID: 87421 | Field: online_stock_level | CF ID: 87551 [Thursday 24th of September 2026 02:07:06 PM] get_cf_id() - END - Product ID: 87421 | CF ID: 87551 [Thursday 24th of September 2026 02:07:06 PM] Updating inventory for SKU APPQPB9030 - stock: 0, CF ID: 87551 [Thursday 24th of September 2026 02:07:06 PM] update_product_inventory() - START - Product ID: 87421 | Stock: 0 | CF ID: 87551 [Thursday 24th of September 2026 02:07:06 PM] update_product_inventory() - Calling BigCommerce API PUT - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/87421/custom-fields/87551 [Thursday 24th of September 2026 02:07:06 PM] update_product_inventory() - Inventory updated successfully for Product ID: 87421 | Stock: 0 [Thursday 24th of September 2026 02:07:06 PM] update_product_inventory() - END - Product ID: 87421 | Result: success [Thursday 24th of September 2026 02:07:06 PM] Inventory updated for SKU: APPQPB9030 [Thursday 24th of September 2026 02:07:06 PM] All products processed - Order details: [{"ID":"AP590","INVEN":"APPQPB9030","M_QUAN_VIS":1,"UNIT":"20.99","UNIT_MEAS":"EA"}] [Thursday 24th of September 2026 02:07:06 PM] Building payment record - Total: 62.6000 [Thursday 24th of September 2026 02:07:06 PM] Full order payload ready: {"WAREHOUSE":"A-HTM","INVOICE":"AP2288","ADDRESS1":"2100 The Oaks Parkway","ADDRESS2":"","C_ADDRESS1":"2110 East Galbraith Road","C_ADDRESS2":"U-PAC056702821","C_CITY":"Cincinnati","C_COUNTRY":"USA","C_EMAIL":"burton.gillette@vallen.com","C_NAME":"Michelle Blanton","C_STATE":"OH","C_ZIP":"45237","ShippingAmount":"37.08","CITY":"Belmont","EMAIL":"burton.gillette@vallen.com","ID":"AP590","NAME":"Burton Gillette","STATE":"NC","COUNTRY":"USA","ZIP":"28012","MEMO":"","DESCR":"BigCommerce Order - AP2288 - Customer AP590","Details":[{"ID":"AP590","INVEN":"APPQPB9030","M_QUAN_VIS":1,"UNIT":"20.99","UNIT_MEAS":"EA"}],"Payments":[{"TYPE":"Credit","ACTION":"XX7","AMOUNT":"62.60","CASH_ACNT":"01021-100","CHECK_NO":"APBC","CC_TYPE":"APBC"}]} [Thursday 24th of September 2026 02:07:06 PM] check_if_invoice_exists_in_ebms() - START - Invoice ID: AP2288 [Thursday 24th of September 2026 02:07:06 PM] check_if_invoice_exists_in_ebms() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARINV?%24filter=INVOICE%20eq%20%27AP2288%27 [Thursday 24th of September 2026 02:07:06 PM] check_if_invoice_exists_in_ebms() - EBMS API call successful for Invoice ID: AP2288 [Thursday 24th of September 2026 02:07:06 PM] check_if_invoice_exists_in_ebms() - Invoice ID: AP2288 not found in EBMS [Thursday 24th of September 2026 02:07:06 PM] check_if_invoice_exists_in_ebms() - END - Invoice ID: AP2288 | Found: false [Thursday 24th of September 2026 02:07:06 PM] Invoice AP2288 does not exist in EBMS - creating [Thursday 24th of September 2026 02:07:06 PM] create_ebms_invoice() - START - Invoice: AP2288 [Thursday 24th of September 2026 02:07:06 PM] create_ebms_invoice() - Order payload: {"WAREHOUSE":"A-HTM","INVOICE":"AP2288","ADDRESS1":"2100 The Oaks Parkway","ADDRESS2":"","C_ADDRESS1":"2110 East Galbraith Road","C_ADDRESS2":"U-PAC056702821","C_CITY":"Cincinnati","C_COUNTRY":"USA","C_EMAIL":"burton.gillette@vallen.com","C_NAME":"Michelle Blanton","C_STATE":"OH","C_ZIP":"45237","ShippingAmount":"37.08","CITY":"Belmont","EMAIL":"burton.gillette@vallen.com","ID":"AP590","NAME":"Burton Gillette","STATE":"NC","COUNTRY":"USA","ZIP":"28012","MEMO":"","DESCR":"BigCommerce Order - AP2288 - Customer AP590","Details":[{"ID":"AP590","INVEN":"APPQPB9030","M_QUAN_VIS":1,"UNIT":"20.99","UNIT_MEAS":"EA"}],"Payments":[{"TYPE":"Credit","ACTION":"XX7","AMOUNT":"62.60","CASH_ACNT":"01021-100","CHECK_NO":"APBC","CC_TYPE":"APBC"}]} [Thursday 24th of September 2026 02:07:06 PM] create_ebms_invoice() - Calling EBMS API POST - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARINV [Thursday 24th of September 2026 02:07:13 PM] create_ebms_invoice() - EBMS API call successful for Invoice: AP2288 [Thursday 24th of September 2026 02:07:13 PM] create_ebms_invoice() - Invoice created successfully in EBMS - Invoice: AP2288 - Response: {"@odata.context":"http:\/\/localhost:60530\/myebms\/HOO\/OData\/$metadata#ARINV\/$entity","Guid":"494e5347-4f32-424f-484d-4e4943303030","AUTOID":"GSNI2OOBHMNIC000","AUTHORIZED":0,"BAL_CUST_C":0,"BAL_CUST_P":-22.629999999999999005240169935859739780426025390625,"BAL_CUST_X":-22.629999999999999005240169935859739780426025390625,"BALANCE":-22.629999999999999005240169935859739780426025390625,"DISC_PERC":0,"DISCOUNT":0,"EST_F_CONV":0,"EST_F_SURC":0,"OVERDUE":0,"PERC_MARG":0,"SO_BALCUST":0,"SO_TAX":4.53000000000000024868995751603506505489349365234375,"TAX":2.890000000000000124344978758017532527446746826171875,"TOTAL_COST":0,"TOTAL_MARG":0,"TOTAL_PAID":62.60000000000000142108547152020037174224853515625,"TOTAL_S_SO":20.989999999999998436805981327779591083526611328125,"TOTAL_SO":62.60000000000000142108547152020037174224853515625,"TOTAL_W":0,"TTLPROCPMT":62.60000000000000142108547152020037174224853515625,"TOTAL":39.969999999999998863131622783839702606201171875,"FREIGHT":37.0799999999999982946974341757595539093017578125,"HANDLING":0,"SHIPPING":37.0799999999999982946974341757595539093017578125,"SUBTOTAL":0,"TOTAL_ITEM":0,"GRACE":"(None)","STATUS":"U","USER_NAME":"BLAYZER-API","TAX_TABLE":"","ADDRESS1":"2100 The Oaks Parkway","ADDRESS2":"","C_EMAIL":"burton.gillette@vallen.com","C_PHONE":"(704) 398-7118","CCNTCT_AID":"7E5SS7EJRBA7F891","CHARGE":"Due on Receipt","CHECK_DATE":"2026-09-24T00:00:00Z","CHECK_NO":" APBC","CITY":"Belmont","CNTCT_AID":"7E5SS7EJRBA7F891","COUNTRY":"USA","DIS_DATE":null,"DISCOUN":"(None)","DOWN_PAY":"23000-000","DUE_DATE":"2026-09-24T00:00:00Z","E_DATE":"2026-09-24T00:00:00Z","EC_RPT_ERR":"","EC_RPT_RUN":false,"EMAIL":"burton.gillette@vallen.com","IADDRESS":"2110 East Galbraith Road U-PAC056702821, Cincinnati, OH 45237","ID":"AP590","IDCHARGE":"5CHDUREC","IDDISCOUNT":"DNONE","IN_LEVEL":"Retail","INV_DATE":"2026-09-24T00:00:00Z","INVOICE":"AP2288","MAN_FREIGH":true,"MAN_TAX":true,"NAME":"Burton Gillette","PHONE":"","PROCESS":"Default","STATE":"NC","TERMS":"Cash","TRACK_NUMS":"[]","ZIP":"28012","EXTERNALID":"","WAREHOUSE":"A-HTM","C_ADDRESS1":"2110 East Galbraith Road","C_ADDRESS2":"U-PAC056702821","C_CITY":"Cincinnati","C_COUNTRY":"USA","C_ID":"AP590","C_NAME":"Michelle Blanton","C_STATE":"OH","C_ZIP":"45237","DEF_DEPT":"100","DESCR":"BigCommerce Order - AP2288 - Customer AP590","INTERNALNT":"","JOB_ID":"","MEMO":"","PO_NO":"","SALESMAN":"","SALESMAN_Field":"","SHIP_DATE":"2026-09-24T00:00:00Z","SHIP_VIA":"BIGC","TO_B_SENT":false} [Thursday 24th of September 2026 02:07:13 PM] create_ebms_invoice() - END - Invoice: AP2288 [Thursday 24th of September 2026 02:07:13 PM] Invoice AP2288 created successfully [Thursday 24th of September 2026 02:07:13 PM] ORDER WEBHOOK COMPLETED - Order ID: 2288 | Invoice: AP2288 [Thursday 24th of September 2026 02:08:12 PM] ORDER WEBHOOK STARTED - Order ID: 2288 [Thursday 24th of September 2026 02:08:12 PM] Fetching customer data for Order ID: 2288 [Thursday 24th of September 2026 02:08:12 PM] get_order_customer_data() - START - Order ID: 2288 [Thursday 24th of September 2026 02:08:12 PM] get_order_customer_data() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v2/orders/2288 [Thursday 24th of September 2026 02:08:12 PM] get_order_customer_data() - BigCommerce API call successful for Order ID: 2288 [Thursday 24th of September 2026 02:08:12 PM] get_order_customer_data() - Parsing order response for Order ID: 2288 [Thursday 24th of September 2026 02:08:12 PM] get_order_customer_data() - Customer object built - Customer ID: 590 | Name: Burton Gillette | Email: burton.gillette@vallen.com | Total: 62.6000 | Shipping: 37.08 [Thursday 24th of September 2026 02:08:12 PM] get_order_customer_data() - END - Order ID: 2288 [Thursday 24th of September 2026 02:08:12 PM] Customer data received: {"id":590,"email":"burton.gillette@vallen.com","address_1":"2100 The Oaks Parkway","address_2":"","city":"Belmont","state":"NC","country":"USA","zip":"28012","f_name":"Burton","l_name":"Gillette","contact_5":"burton.gillette@vallen.com","contact_1":"7043987118","contact_4":"Burton Gillette"} [Thursday 24th of September 2026 02:08:12 PM] Fetching shipping info for Order ID: 2288 [Thursday 24th of September 2026 02:08:12 PM] get_order_shipping_info() - START - Order ID: 2288 [Thursday 24th of September 2026 02:08:12 PM] get_order_shipping_info() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v2/orders/2288/shipping_addresses [Thursday 24th of September 2026 02:08:12 PM] get_order_shipping_info() - BigCommerce API call successful for Order ID: 2288 [Thursday 24th of September 2026 02:08:12 PM] get_order_shipping_info() - Shipping address retrieved for Order ID: 2288 | Name: Michelle Blanton | Address: 2110 East Galbraith Road, Cincinnati, Ohio, 45237 [Thursday 24th of September 2026 02:08:12 PM] get_order_shipping_info() - END - Order ID: 2288 [Thursday 24th of September 2026 02:08:12 PM] Shipping info received: {"id":2187,"order_id":2288,"first_name":"Michelle","last_name":"Blanton","company":"Patheon Pharmaceuticals c\/o Vallen","street_1":"2110 East Galbraith Road","street_2":"U-PAC056702821","city":"Cincinnati","zip":"45237","country":"United States","country_iso2":"US","state":"Ohio","email":"burton.gillette@vallen.com","phone":"7043987118","items_total":1,"items_shipped":0,"shipping_method":"FedEx 1-Day","base_cost":"37.0800","cost_ex_tax":"37.0800","cost_inc_tax":"39.9722","cost_tax":"2.8922","cost_tax_class_id":2,"base_handling_cost":"0.0000","handling_cost_ex_tax":"0.0000","handling_cost_inc_tax":"0.0000","handling_cost_tax":"0.0000","handling_cost_tax_class_id":2,"shipping_zone_id":3,"shipping_zone_name":"United States","shipping_quotes":{"url":"https:\/\/api.bigcommerce.com\/stores\/caspfzrito\/v2\/orders\/2288\/shipping_addresses\/2187\/shipping_quotes","resource":"\/orders\/2288\/shipping_addresses\/2187\/shipping_quotes"},"form_fields":[]} [Thursday 24th of September 2026 02:08:12 PM] Resolved Customer ID: AP590 [Thursday 24th of September 2026 02:08:12 PM] Building order object for Invoice: AP2288 [Thursday 24th of September 2026 02:08:12 PM] Order object built: {"WAREHOUSE":"A-HTM","INVOICE":"AP2288","ADDRESS1":"2100 The Oaks Parkway","ADDRESS2":"","C_ADDRESS1":"2110 East Galbraith Road","C_ADDRESS2":"U-PAC056702821","C_CITY":"Cincinnati","C_COUNTRY":"USA","C_EMAIL":"burton.gillette@vallen.com","C_NAME":"Michelle Blanton","C_STATE":"OH","C_ZIP":"45237","ShippingAmount":"37.08","CITY":"Belmont","EMAIL":"burton.gillette@vallen.com","ID":"AP590","NAME":"Burton Gillette","STATE":"NC","COUNTRY":"USA","ZIP":"28012","MEMO":"","DESCR":"BigCommerce Order - AP2288 - Customer AP590"} [Thursday 24th of September 2026 02:08:12 PM] Registered customer detected - checking EBMS for Customer ID: AP590 [Thursday 24th of September 2026 02:08:12 PM] check_for_customer() - START - Customer ID: 590 [Thursday 24th of September 2026 02:08:12 PM] check_for_customer() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARCUST?%24filter=ID%20eq%20%27AP590%27 [Thursday 24th of September 2026 02:08:13 PM] check_for_customer() - EBMS API call successful for Customer ID: 590 [Thursday 24th of September 2026 02:08:13 PM] check_for_customer() - Customer ID: 590 found in EBMS [Thursday 24th of September 2026 02:08:13 PM] check_for_customer() - END - Customer ID: 590 | Found: true [Thursday 24th of September 2026 02:08:13 PM] Customer AP590 found in EBMS [Thursday 24th of September 2026 02:08:13 PM] check_for_empty_info() - START - Customer ID: 590 [Thursday 24th of September 2026 02:08:13 PM] check_for_empty_info() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARCUST?%24filter=ID%20eq%20%27AP590%27 [Thursday 24th of September 2026 02:08:13 PM] check_for_empty_info() - EBMS API call successful for Customer ID: 590 [Thursday 24th of September 2026 02:08:13 PM] check_for_empty_info() - Customer record found for Customer ID: 590 - Checking ADDRESS1 field [Thursday 24th of September 2026 02:08:13 PM] check_for_empty_info() - ADDRESS1 is populated for Customer ID: 590 - No update needed [Thursday 24th of September 2026 02:08:13 PM] check_for_empty_info() - END - Customer ID: 590 | Empty Info: false [Thursday 24th of September 2026 02:08:13 PM] check_for_empty_pn() - START - Customer ID: AP590 [Thursday 24th of September 2026 02:08:13 PM] check_for_empty_pn() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARCUST?%24filter=ID%20eq%20%27AP590%27 [Thursday 24th of September 2026 02:08:13 PM] check_for_empty_pn() - EBMS API call successful for Customer ID: AP590 [Thursday 24th of September 2026 02:08:13 PM] check_for_empty_pn() - Customer record found for Customer ID: AP590 - Checking CONTACT_1 field [Thursday 24th of September 2026 02:08:13 PM] check_for_empty_pn() - CONTACT_1 is populated for Customer ID: AP590 - Value: (704) 398-7118 - No update needed [Thursday 24th of September 2026 02:08:13 PM] check_for_empty_pn() - END - Customer ID: AP590 | Empty PN: false [Thursday 24th of September 2026 02:08:13 PM] Fetching products from BigCommerce for Order ID: 2288 [Thursday 24th of September 2026 02:08:13 PM] BigCommerce API call successful for Order ID: 2288 [Thursday 24th of September 2026 02:08:13 PM] Products received: 1 item(s) [Thursday 24th of September 2026 02:08:13 PM] Processing product SKU: APPQPB9030 | Qty: 1 | Price: 20.9900 [Thursday 24th of September 2026 02:08:13 PM] get_mpn() - START - Product ID: 87421 [Thursday 24th of September 2026 02:08:13 PM] get_mpn() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/87421 [Thursday 24th of September 2026 02:08:14 PM] get_mpn() - BigCommerce API call successful for Product ID: 87421 [Thursday 24th of September 2026 02:08:14 PM] get_mpn() - WARNING - MPN is empty for Product ID: 87421 [Thursday 24th of September 2026 02:08:14 PM] get_mpn() - END - Product ID: 87421 | MPN: [Thursday 24th of September 2026 02:08:14 PM] check_for_ebms_product() - START - SKU: APPQPB9030 [Thursday 24th of September 2026 02:08:14 PM] check_for_ebms_product() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/INVENTRY?%24filter=ID%20eq%20%27APPQPB9030%27 [Thursday 24th of September 2026 02:08:14 PM] check_for_ebms_product() - EBMS API call successful for SKU: APPQPB9030 [Thursday 24th of September 2026 02:08:14 PM] check_for_ebms_product() - SKU: APPQPB9030 found in EBMS [Thursday 24th of September 2026 02:08:14 PM] check_for_ebms_product() - END - SKU: APPQPB9030 | Found: true [Thursday 24th of September 2026 02:08:14 PM] SKU APPQPB9030 found in EBMS - checking prices [Thursday 24th of September 2026 02:08:14 PM] obtain_current_prices() - START - SKU: APPQPB9030 [Thursday 24th of September 2026 02:08:14 PM] obtain_current_prices() - Checking Motorstate for SKU: APPQPB9030 [Thursday 24th of September 2026 02:08:14 PM] check_for_ms_product() - START - SKU: APPQPB9030 [Thursday 24th of September 2026 02:08:14 PM] check_for_ms_product() - Calling Motorstate API - URL: https://api.motorstate.com/api/Product?partNumbers=APPQPB9030 [Thursday 24th of September 2026 02:08:14 PM] check_for_ms_product() - Motorstate API call successful for SKU: APPQPB9030 [Thursday 24th of September 2026 02:08:14 PM] check_for_ms_product() - SKU: APPQPB9030 not found in Motorstate [Thursday 24th of September 2026 02:08:14 PM] check_for_ms_product() - END - SKU: APPQPB9030 | Found: false [Thursday 24th of September 2026 02:08:14 PM] obtain_current_prices() - SKU: APPQPB9030 not found in Motorstate - Skipping to EBMS [Thursday 24th of September 2026 02:08:14 PM] obtain_current_prices() - Checking EBMS for SKU: APPQPB9030 [Thursday 24th of September 2026 02:08:14 PM] check_for_ebms_product() - START - SKU: APPQPB9030 [Thursday 24th of September 2026 02:08:14 PM] check_for_ebms_product() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/INVENTRY?%24filter=ID%20eq%20%27APPQPB9030%27 [Thursday 24th of September 2026 02:08:15 PM] check_for_ebms_product() - EBMS API call successful for SKU: APPQPB9030 [Thursday 24th of September 2026 02:08:15 PM] check_for_ebms_product() - SKU: APPQPB9030 found in EBMS [Thursday 24th of September 2026 02:08:15 PM] check_for_ebms_product() - END - SKU: APPQPB9030 | Found: true [Thursday 24th of September 2026 02:08:15 PM] obtain_current_prices() - SKU: APPQPB9030 found in EBMS - Fetching prices [Thursday 24th of September 2026 02:08:15 PM] obtain_current_prices() - EBMS API call attempt 1 for SKU: APPQPB9030 - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/INVENTRY?%24filter=ID%20eq%20%27APPQPB9030%27 [Thursday 24th of September 2026 02:08:15 PM] obtain_current_prices() - EBMS prices retrieved for SKU: APPQPB9030 - Base: 20.99 | Cost: 9.44 [Thursday 24th of September 2026 02:08:15 PM] obtain_current_prices() - END - SKU: APPQPB9030 | Final prices - Base: 20.99 | Cost: 9.44 [Thursday 24th of September 2026 02:08:15 PM] SKU APPQPB9030 has existing EBMS prices - syncing BigCommerce price back (cost: 9.44, base: 20.99) [Thursday 24th of September 2026 02:08:15 PM] update_product_price() - START - Product ID: 87421 | Base: 20.99 | Cost: 9.44 [Thursday 24th of September 2026 02:08:15 PM] update_product_price() - Calling BigCommerce API PUT - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/87421 [Thursday 24th of September 2026 02:08:15 PM] update_product_price() - PUT payload: {"price":20.989999999999998436805981327779591083526611328125,"cost_price":9.4399999999999995026200849679298698902130126953125} [Thursday 24th of September 2026 02:08:15 PM] update_product_price() - Attempt 1 of 6 for Product ID: 87421 [Thursday 24th of September 2026 02:08:15 PM] update_product_price() - Price updated successfully for Product ID: 87421 - Base: 20.99 | Cost: 9.44 [Thursday 24th of September 2026 02:08:15 PM] update_product_price() - END - Product ID: 87421 | Result: success [Thursday 24th of September 2026 02:08:15 PM] BigCommerce price updated for Product ID: 87421 [Thursday 24th of September 2026 02:08:15 PM] get_product_inventory() - START - SKU: APPQPB9030 [Thursday 24th of September 2026 02:08:15 PM] get_product_inventory() - Calling Motorstate API - URL: https://api.motorstate.com/api/Product?partNumbers=APPQPB9030 [Thursday 24th of September 2026 02:08:16 PM] get_product_inventory() - Motorstate API call successful for SKU: APPQPB9030 [Thursday 24th of September 2026 02:08:16 PM] get_product_inventory() - SKU: APPQPB9030 not found in Motorstate response item [Thursday 24th of September 2026 02:08:16 PM] get_product_inventory() - END - SKU: APPQPB9030 | Total: 0 [Thursday 24th of September 2026 02:08:16 PM] get_cf_id() - START - Product ID: 87421 [Thursday 24th of September 2026 02:08:16 PM] get_cf_id() - Calling BigCommerce API - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/87421/custom-fields [Thursday 24th of September 2026 02:08:16 PM] get_cf_id() - BigCommerce API call successful for Product ID: 87421 [Thursday 24th of September 2026 02:08:16 PM] get_cf_id() - Custom field found for Product ID: 87421 | Field: online_stock_level | CF ID: 87551 [Thursday 24th of September 2026 02:08:16 PM] get_cf_id() - END - Product ID: 87421 | CF ID: 87551 [Thursday 24th of September 2026 02:08:16 PM] Updating inventory for SKU APPQPB9030 - stock: 0, CF ID: 87551 [Thursday 24th of September 2026 02:08:16 PM] update_product_inventory() - START - Product ID: 87421 | Stock: 0 | CF ID: 87551 [Thursday 24th of September 2026 02:08:16 PM] update_product_inventory() - Calling BigCommerce API PUT - URL: https://api.bigcommerce.com/stores/caspfzrito/v3/catalog/products/87421/custom-fields/87551 [Thursday 24th of September 2026 02:08:16 PM] update_product_inventory() - Inventory updated successfully for Product ID: 87421 | Stock: 0 [Thursday 24th of September 2026 02:08:16 PM] update_product_inventory() - END - Product ID: 87421 | Result: success [Thursday 24th of September 2026 02:08:16 PM] Inventory updated for SKU: APPQPB9030 [Thursday 24th of September 2026 02:08:16 PM] All products processed - Order details: [{"ID":"AP590","INVEN":"APPQPB9030","M_QUAN_VIS":1,"UNIT":"20.99","UNIT_MEAS":"EA"}] [Thursday 24th of September 2026 02:08:16 PM] Building payment record - Total: 62.6000 [Thursday 24th of September 2026 02:08:16 PM] Full order payload ready: {"WAREHOUSE":"A-HTM","INVOICE":"AP2288","ADDRESS1":"2100 The Oaks Parkway","ADDRESS2":"","C_ADDRESS1":"2110 East Galbraith Road","C_ADDRESS2":"U-PAC056702821","C_CITY":"Cincinnati","C_COUNTRY":"USA","C_EMAIL":"burton.gillette@vallen.com","C_NAME":"Michelle Blanton","C_STATE":"OH","C_ZIP":"45237","ShippingAmount":"37.08","CITY":"Belmont","EMAIL":"burton.gillette@vallen.com","ID":"AP590","NAME":"Burton Gillette","STATE":"NC","COUNTRY":"USA","ZIP":"28012","MEMO":"","DESCR":"BigCommerce Order - AP2288 - Customer AP590","Details":[{"ID":"AP590","INVEN":"APPQPB9030","M_QUAN_VIS":1,"UNIT":"20.99","UNIT_MEAS":"EA"}],"Payments":[{"TYPE":"Credit","ACTION":"XX7","AMOUNT":"62.60","CASH_ACNT":"01021-100","CHECK_NO":"APBC","CC_TYPE":"APBC"}]} [Thursday 24th of September 2026 02:08:16 PM] check_if_invoice_exists_in_ebms() - START - Invoice ID: AP2288 [Thursday 24th of September 2026 02:08:16 PM] check_if_invoice_exists_in_ebms() - Calling EBMS API - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARINV?%24filter=INVOICE%20eq%20%27AP2288%27 [Thursday 24th of September 2026 02:08:17 PM] check_if_invoice_exists_in_ebms() - EBMS API call successful for Invoice ID: AP2288 [Thursday 24th of September 2026 02:08:17 PM] check_if_invoice_exists_in_ebms() - Invoice ID: AP2288 found in EBMS [Thursday 24th of September 2026 02:08:17 PM] check_if_invoice_exists_in_ebms() - END - Invoice ID: AP2288 | Found: true [Thursday 24th of September 2026 02:08:17 PM] Invoice AP2288 already exists in EBMS - patching [Thursday 24th of September 2026 02:08:17 PM] patch_ebms_invoice() - START - Invoice: AP2288 [Thursday 24th of September 2026 02:08:17 PM] patch_ebms_invoice() - Order payload: {"WAREHOUSE":"A-HTM","INVOICE":"AP2288","ADDRESS1":"2100 The Oaks Parkway","ADDRESS2":"","C_ADDRESS1":"2110 East Galbraith Road","C_ADDRESS2":"U-PAC056702821","C_CITY":"Cincinnati","C_COUNTRY":"USA","C_EMAIL":"burton.gillette@vallen.com","C_NAME":"Michelle Blanton","C_STATE":"OH","C_ZIP":"45237","ShippingAmount":"37.08","CITY":"Belmont","EMAIL":"burton.gillette@vallen.com","ID":"AP590","NAME":"Burton Gillette","STATE":"NC","COUNTRY":"USA","ZIP":"28012","MEMO":"","DESCR":"BigCommerce Order - AP2288 - Customer AP590","Details":[{"ID":"AP590","INVEN":"APPQPB9030","M_QUAN_VIS":1,"UNIT":"20.99","UNIT_MEAS":"EA"}],"Payments":[{"TYPE":"Credit","ACTION":"XX7","AMOUNT":"62.60","CASH_ACNT":"01021-100","CHECK_NO":"APBC","CC_TYPE":"APBC"}]} [Thursday 24th of September 2026 02:08:17 PM] patch_ebms_invoice() - Calling EBMS API PATCH - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARINV?%24filter=INVOICE%20eq%20%27AP2288%27 [Thursday 24th of September 2026 02:08:17 PM] patch_ebms_invoice() - EBMS API call successful for Invoice: AP2288 [Thursday 24th of September 2026 02:08:17 PM] patch_ebms_invoice() - WARNING - Empty response from EBMS for Invoice: AP2288 [Thursday 24th of September 2026 02:08:17 PM] patch_ebms_invoice() - END - Invoice: AP2288 [Thursday 24th of September 2026 02:08:17 PM] Invoice AP2288 patched successfully [Thursday 24th of September 2026 02:08:17 PM] ORDER WEBHOOK COMPLETED - Order ID: 2288 | Invoice: AP2288 [Thursday 24th of September 2026 03:02:21 PM] add_customer() - START - Customer ID: 591 | Name: Deborah Medina [Thursday 24th of September 2026 03:02:21 PM] add_customer() - Customer payload: {"id":591,"email":"l.erose823+80i69e@gmail.com","address_1":"212 Laura Creek","address_2":"","city":"Millerport","state":"WI","country":"USA","zip":"88349","f_name":"Deborah","l_name":"Medina","contact_5":"l.erose823+80i69e@gmail.com","contact_1":"4046346628","contact_4":"Deborah Medina"} [Thursday 24th of September 2026 03:02:21 PM] add_customer() - Customer fields parsed - ID: AP591 | Address: 212 Laura Creek, Millerport, WI 88349 | Email: l.erose823+80i69e@gmail.com [Thursday 24th of September 2026 03:02:21 PM] add_customer() - Calling EBMS API POST - URL: https://812252017121401.koblesystems.dev/myebms/HOO/OData/ARCUST [Thursday 24th of September 2026 03:02:21 PM] add_customer() - POST payload: {"TREE_ID":"38","ADDRESS1":"212 Laura Creek","ADDRESS2":"","CITY":"Millerport","CONTACT_5":"l.erose823+80i69e@gmail.com","CONTACT_1":"4046346628","CONTACT_4":"Deborah Medina","COUNTRY":"USA","F_NAME":"Deborah","ID":"AP591","L_NAME":"Medina","STATE":"WI","ZIP":"88349"} [Thursday 24th of September 2026 03:02:22 PM] add_customer() - EBMS API call successful for Customer ID: AP591 [Thursday 24th of September 2026 03:02:22 PM] add_customer() - Customer created successfully in EBMS - ID: AP591 - Response: {"@odata.context":"http:\/\/localhost:60530\/myebms\/HOO\/OData\/$metadata#ARCUST\/$entity","Guid":"4231524c-374d-464c-494d-4e4943303030","AUTOID":"LR1BM7LFIMNIC000","CRED_LIM":0,"FC_RATE":1.5,"MIN_FC":1,"FULL_NAME":"Deborah Medina","ADDRESS1":"212 Laura Creek","ADDRESS2":"","BANK_ACCOU":"","BANK_DESCR":"","BANK_ROUTE":"","CASH":true,"CHARGE":"Due on Receipt","CHARGEDFLT":false,"CHARGEPYMT":true,"CHECK":true,"CITY":"Millerport","COUNTRY":"USA","CREDITCARD":true,"DEF_CLI_ID":"","DEF_FOB":"BIGC","DEL_REASON":"","DIRECTIONS":"","DISCOUNT":"(None)","E_DATE":"2026-09-24T00:00:00Z","EC_RPT_ERR":"","EC_RPT_RUN":false,"EMAIL":"l.erose823+80i69e@gmail.com","EMAIL_LIST":false,"F_NAME":"Deborah","FRGHT_AMT":"Free","FRGHT_TYPE":"1FREE","GPS_ADD1":"","GPS_ADD2":"","GPS_CITY":"","GPS_STATE":"","GPS_ZIP":"","GRACE":"(None)","ID":"AP591","IDCHARGE":"5CHDUREC","IDDISCOUNT":"DNONE","IDGRACE":"GNONE","IN_LEVEL":"Retail","INACTIVE":false,"L_NAME":"Medina","MAIL_LIST":false,"MEMO":"","NAMESTR":"(Deborah Medina)","OUT_CITY":false,"PHONE":"(404) 634-6628","SALESMAN":"","SAVINGS":"Checking","SHIP_TO":"","STATE":"WI","TREE_ID":" 38","TYPE":"WEBCUST","ZIP":"88349","CONID_1":"Phone","CONID_2":"Mobile Phone","CONID_3":"Fax","CONID_4":"Contact","CONID_5":"E-Mail","CONTACT_1":"(404) 634-6628","CONTACT_2":"","CONTACT_3":"","CONTACT_4":"Deborah Medina","CONTACT_5":"l.erose823+80i69e@gmail.com","EXTERNALID":""} [Thursday 24th of September 2026 03:02:22 PM] add_customer() - END - Customer ID: AP591