jdeck88 / ffcsa_scripts

publicly available scripts on FFCSA database
0 stars 1 forks source link

Bug with wrong vendor in output #26

Closed jdeck88 closed 4 months ago

jdeck88 commented 6 months ago

I'm filing the following as a bug.

Attached is a screenshot of order 2922280 which shows it placed on May 8th. It shows the salad mix belonging to Little Wings Farm in the invoice view.

However, when i download data for this fulfillment date as a CSV file (also attached) it shows the product as belonging to Small is Beautiful Farm. Search for order 2922280. John orders_list_view_full_farm_csa_10_May_2024 (2).csv Screen Shot 2024-05-10 at 1 26 50 PM (1)

jdeck88 commented 6 months ago

Hi John,

Thanks for the additional details. A ticket has already been created with this concern. For reference, the ticket number is LL2-2935.

Let me know if you have further questions or concerns.

All the best, Abby

jdeck88 commented 5 months ago

Here is a video showing the same issue, walking through quering customer "Golden" and querying for cilantro... cilantro from the wrong farm is returned from what we queried: https://www.loom.com/share/41000ae7182e4c82bf281fa9d43ac828?sid=e43277d2-f68d-4cd8-9d15-50657c2a15e7

jdeck88 commented 4 months ago

Carts are deleted after 14 days now. previously, carts could be left for months. This led to situations where a product was put in a cart, later run out of inventory, and then checked out. this applied to customers who may have stale cache. So, effectively this issue is solved. per conversation with Alison today