User has LL order 5cb8270ac that failed due to products_not_connected. An example product is Borba Blunt - Hybrid (2g) / (10 per case)
In the order, here's the data for the line item for Borba Blunt - Hybrid (2g) / (10 per case)
{
"id": 23802871,
"batch": 89997,
"notes": "",
"order": "948e5fe1-4453-41f1-ab89-e942de0de3e9",
"on_sale": false,
"product": 1029774,
"facility": null,
"order_id": 3698020,
"position": 0,
"quantity": "20.0000",
"is_packed": false,
"is_sample": false,
"packed_at": null,
"packed_by": null,
"bulk_units": 2,
"hide_batch": false,
"sale_price": {
"amount": 0,
"currency": "USD"
},
"frozen_data": {
"product": {
"sku": "Batch#: 2202846GRPBOHY",
"name": "Borba Blunt - Hybrid (2g) / (10 per case)",
"price": "40.00",
"sale_price": "0.00",
"retail_price": "0.00",
"unit_of_measure": "Unit",
"wholesale_price": "60.00",
"unit_denomination": "1",
"base_units_per_unit": null,
"sell_in_unit_of_measure": 1,
"suggested_wholesale_price": "60.00"
}
},
"is_backorder": false,
"package_tags": null,
"sold_by_case": true,
"unit_multiplier": 10,
"unit_of_measure": "Unit",
"ordered_unit_price": {
"amount": 40,
"currency": "USD"
},
"is_medical_line_item": false
}
You can see that the LL id for the product here is 1029774
In Distru, there is already a link between Borba Blunt - Hybrid (2g) / (10 per case) and Distru product Pharmicated - Pre-Rolls (Flower) - Borba Blunt (Hybrid) - 2g (Distru ID: 620540).
However, on the Distru product, the LL product ID is 980594.
The product in our cache with ID 980594 has the following attrs:
{
"id": 980594,
"sku": "SKU: Batch#: 2202846GRPBOHY",
"name": "Borba Blunt - Hybrid (2g) / (10 per case)",
"brand": 2437,
"parent": null,
"seller": 9238,
"dropped": null,
"license": {
"id": 10135,
"type": "Medical",
"number": "PAAA-4YD0-6CTM",
"display_type": "Medical",
"classification": "Processor"
},
"strains": [
23014
],
"tagline": null,
"category": 14,
"featured": false,
"modified": "2022-05-16T08:38:06.111466-06:00",
"quantity": "180.0000",
"drop_date": null,
"grow_type": null,
"last_edit": "2022-06-23T12:18:34.243288-06:00",
"created_on": "2022-04-04T12:17:54.765825-06:00",
"sale_price": {
"amount": 0,
"currency": "USD"
},
"coming_soon": false,
"description": "<p style=\"\">March 3rd 2021 is a day that none of at Pharmicated will ever forget. In remembrance of that day and in honor of the spirit of Jacob Borba, we are proud to introduce the Borba Blunt! This 2 gram blunt filled with a premium smoke blend is sure to leave you feeling phenomenal!</p><p style=\"\"><br></p><ul style=\"\"><li style=\"\">1 Unit = 10 Blunts</li><li style=\"\"><br></li></ul><p><br></p><p><br></p><p> <br></p>",
"image_count": 2,
"display_name": "Borba Blunt - Hybrid (2g) / (10 per case)",
"external_ids": {},
"is_ancillary": false,
"manufacturer": 9238,
"product_line": 30466,
"reserved_qty": "0.0000",
"retail_price": {
"amount": 0,
"currency": "USD"
},
"sub_category": 65,
"listing_state": "Archived",
"maximum_order": null,
"minimum_order": "1.0000",
"show_quantity": false,
"children_count": 0,
"extern_acct_id": null,
"extern_sts_ids": [],
"threshold_value": 0,
"unit_multiplier": 10,
"unit_of_measure": "Unit",
"wholesale_price": {
"amount": 60,
"currency": "USD"
},
"discount_percent": 0,
"threshold_action": "unavailable",
"featured_on_deals": false,
"unit_denomination": {
"id": 1,
"name": "One",
"label": "1",
"value": "1.00000"
},
"cost_of_goods_sold": null,
"product_data_items": [
{
"spec_type": "cannabinoids",
"text_value": "",
"dosage_unit": "%",
"decimal_value": "30.49",
"max_decimal_value": "0.00"
},
{
"spec_type": "thc",
"text_value": "",
"dosage_unit": "%",
"decimal_value": "25.55",
"max_decimal_value": "0.00"
},
{
"spec_type": "terpenes",
"text_value": "",
"dosage_unit": "%",
"decimal_value": "1.06",
"max_decimal_value": "0.00"
}
],
"available_inventory": 180,
"base_units_per_unit": null,
"inventory_management": 1,
"is_medical_line_item": false,
"price_schedule_price": {
"amount": 60,
"currency": "USD"
},
"AVAILABLE_FOR_SAMPLES": false,
"display_listing_state": "Archived",
"extern_income_acct_id": null,
"s2s_conversion_amount": "1.0000",
"strain_classification": "hybrid",
"reverse_threshold_value": null,
"sell_in_unit_of_measure": "Case",
"reverse_threshold_action": "",
"allow_fractional_quantities": false,
"has_deals_eligible_children": false,
"low_inventory_alert_threshold": "100.0000",
"should_alert_on_low_inventory": false,
"strain_classification_display": "Hybrid"
}
fetched_at | 2022-06-23 18:20:52.792365
inserted_at | 2022-06-08 21:21:55.732343
updated_at | 2022-06-23 18:20:52.792434
The same named product (ID: 1029774) from the order has these attrs:
{
"id": 1029774,
"sku": "Batch#: 2202846GRPBOHY",
"name": "Borba Blunt - Hybrid (2g) / (10 per case)",
"brand": 2437,
"parent": null,
"seller": 9238,
"dropped": null,
"license": {
"id": 10135,
"type": "Medical",
"number": "PAAA-4YD0-6CTM",
"display_type": "Medical",
"classification": "Processor"
},
"strains": [
23014
],
"tagline": null,
"category": 14,
"featured": false,
"modified": "2022-06-13T13:09:58.852516-06:00",
"quantity": "160.0000",
"drop_date": null,
"grow_type": null,
"last_edit": "2022-06-13T13:09:58.804726-06:00",
"created_on": "2022-05-10T14:40:51.742361-06:00",
"sale_price": {
"amount": 0,
"currency": "USD"
},
"coming_soon": false,
"description": "<p style=\"\">March 3rd 2021 is a day that none of at Pharmicated will ever forget. In remembrance of that day and in honor of the spirit of Jacob Borba, we are proud to introduce the Borba Blunt! This 2 gram blunt filled with a premium smoke blend is sure to leave you feeling phenomenal!</p><p style=\"\"><br></p><ul style=\"\"><li style=\"\">1 Unit = 10 Blunts</li><li style=\"\"><br></li></ul><p><br></p><p><br></p><p> <br></p>",
"image_count": 2,
"display_name": "Borba Blunt - Hybrid (2g) / (10 per case)",
"external_ids": {},
"is_ancillary": false,
"manufacturer": 9238,
"product_line": 30466,
"reserved_qty": "50.0000",
"retail_price": {
"amount": 0,
"currency": "USD"
},
"sub_category": 65,
"listing_state": "Available",
"maximum_order": null,
"minimum_order": "1.0000",
"show_quantity": false,
"children_count": 0,
"extern_acct_id": null,
"extern_sts_ids": [],
"threshold_value": 0,
"unit_multiplier": 10,
"unit_of_measure": "Unit",
"wholesale_price": {
"amount": 60,
"currency": "USD"
},
"discount_percent": 0,
"threshold_action": "unavailable",
"featured_on_deals": false,
"unit_denomination": {
"id": 1,
"name": "One",
"label": "1",
"value": "1.00000"
},
"cost_of_goods_sold": null,
"product_data_items": [
{
"spec_type": "cannabinoids",
"text_value": "",
"dosage_unit": "%",
"decimal_value": "35.93",
"max_decimal_value": "0.00"
},
{
"spec_type": "thc",
"text_value": "",
"dosage_unit": "%",
"decimal_value": "30.40",
"max_decimal_value": "0.00"
},
{
"spec_type": "terpenes",
"text_value": "",
"dosage_unit": "%",
"decimal_value": "1.24",
"max_decimal_value": "0.00"
}
],
"available_inventory": 110,
"base_units_per_unit": null,
"inventory_management": 1,
"is_medical_line_item": false,
"price_schedule_price": {
"amount": 60,
"currency": "USD"
},
"AVAILABLE_FOR_SAMPLES": false,
"display_listing_state": "Available",
"extern_income_acct_id": null,
"s2s_conversion_amount": "1.0000",
"strain_classification": "hybrid",
"reverse_threshold_value": null,
"sell_in_unit_of_measure": "Case",
"reverse_threshold_action": "",
"allow_fractional_quantities": false,
"has_deals_eligible_children": false,
"low_inventory_alert_threshold": "100.0000",
"should_alert_on_low_inventory": false,
"strain_classification_display": "Hybrid"
}
fetched_at | 2022-06-22 19:30:41.240605
inserted_at | 2022-06-08 21:21:55.73012
updated_at | 2022-06-22 19:30:41.240666
I compared the two products side by side and noticed:
- The one linked to our Distru product in app was listed as ARCHIVED, while the one on the order was listed as AVAILABLE
- The one linked to our Distru product in app had
SKU: Batch#: 2202846GRPBOHYas the SKU, while the one on the order hadBatch#: 2202846GRPBOHY - The one on the order was created a month later than the one mapped in Distru
It is likely that they for some reason archived all their existing products that we previously mapped, and recreated them all again with different prices/quantities
So even though in our linked products the NAME is still the same, they are entirely different products in LL
- Talk to the customer to figure out what they want to do, they may need to remap everything
- Maybe we can expose the
AVAILABLE/ARCHIVEDlisting detail field in the UI to make this more obvious next time, as this is the only field I see being the tangible difference in this case