Update WC stock from new FM batch

[tombola]

• [x] Get skus from FM batches awaiting upload
• [x] Add product_id and large_variation_id from WC to fm:aquisitions
• [x] Get WC stock value for each sku
• [x] Add batch stock value to WC>sku:stock value
• [x] Batch update WC WC>sku:stock
• [x] Check successful
• [x] Update FM data
  • [x] batch awaiting_upload = False
  • aquisitions (?) stock value (ref)
• Return status/success to user *
• #10

---

* Could use a card to update user in FM, might be less annoying than custom dialog.

[tombola]

@fredvitalseeds I am finding it difficult to trace exactly how packeting_batches and large_batches in the VS database relate, or are connected to Products and Product Variations and stock values in woocommerce.

[fredvitalseeds]

They don't relate, but are both related to SeedLots by lot number.

Large batches only used for large packets, they need to connect to 'variations' endpoint.

Packeting batches for small packets, they connect to 'products' endpoint

On Tue, 3 Jan 2023, 16:30 Tom Readings, @.***> wrote:

@fredvitalseeds https://github.com/fredvitalseeds I am finding it difficult to trace exactly how packeting_batches and large_batches in the VS database relate, or are connected to Products and Product Variations and stock values in woocommerce.

— Reply to this email directly, view it on GitHub https://github.com/vitalseeds/vs-data-api/issues/3, or unsubscribe https://github.com/notifications/unsubscribe-auth/AZNHIY7KFBTHF3OGPT5OKXLWQRH2FANCNFSM6AAAAAATPRWRJQ . You are receiving this because you were mentioned.Message ID: @.***>

[tombola]

Notes on the above (from discussion).

• Focus on regular packets first (stock held on main product)
• We need to store product_id, regular_variation_id and large_variation_id on acquisitions table
  • the URL for the WC API endpoint for variation requires both the ‘parent’ product id and the variation ID

[tombola]

I have stock updating on WC based on packets in new batch (VS database).

Just need to correct the 'awaiting_upload' status in FM (should be simple) and the functionality is complete.

Will need some wrapping up and testing on PCs mind.

[fredvitalseeds]

Legend :)

Scores:

Tom 12, filemaker 11

On Tue, 10 Jan 2023, 21:11 Tom Readings, @.***> wrote:

I have stock updating on WC based on packets in new batch (VS database).

Just need to correct the 'awaiting_upload' status in FM (should be simple) and the functionality is complete.

Will need some wrapping up and testing on PCs mind.

— Reply to this email directly, view it on GitHub https://github.com/vitalseeds/vs-data-api/issues/3, or unsubscribe https://github.com/notifications/unsubscribe-auth/AZNHIY44D33RXKWPCHOEKYDWRXGABANCNFSM6AAAAAATPRWRJQ . You are receiving this because you were mentioned.Message ID: @.***>

[tombola]

All working well on the office machine.