jbringolf Posted July 14, 2020 Share Posted July 14, 2020 Creating a POS front end for an existing store. Does anyone have a document which shows which tables "must" be updated to maintain the stock levels. Appears after a 5 minute search to be Inventory AND option_matrix but was hoping someone had it already documented. Thank you Link to comment Share on other sites More sharing options...
Noodleman Posted July 14, 2020 Share Posted July 14, 2020 no documentation exists to cover this. CubeCarT_inventory and matrix tables (if used) are your answer though. Link to comment Share on other sites More sharing options...
jbringolf Posted July 14, 2020 Author Share Posted July 14, 2020 Excellent - thank you. Followup - Looks like the inventory is straight forward, Decrement stock_level but the option_matrix appears to have records with the same product_code which are not accurate. Is it simply using product_code where the status = 1 to decrement that stock_level. I assume you need to do both since there are no trigger on the database tables. Link to comment Share on other sites More sharing options...
Noodleman Posted July 14, 2020 Share Posted July 14, 2020 it's a lot more complex when it comes to matrix, depends on what is tracking levels and option combinations. product code is not a required field in matrix so cannot be reliably used. product code for matrix options also doesn't enforce uniqueness (is that a word?). Link to comment Share on other sites More sharing options...
jbringolf Posted July 14, 2020 Author Share Posted July 14, 2020 Ops - sorry I meant product_id Link to comment Share on other sites More sharing options...
Noodleman Posted July 14, 2020 Share Posted July 14, 2020 not granular enough for matrix as your tracking option combinations. it can get quite complex. I've about 800 lines of code to manage the matrix levels specifically within the Ebay solution, which essentially does what you are working on... sync with external system on a 1-1 relationship. Link to comment Share on other sites More sharing options...
jbringolf Posted July 14, 2020 Author Share Posted July 14, 2020 Thank you - appreciate the assistance. Link to comment Share on other sites More sharing options...
Noodleman Posted July 15, 2020 Share Posted July 15, 2020 you can match on product_id and hash, but depending on the system you are using, know what hashes to use can be a little tricky. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.