Jump to content

POS Front End


jbringolf

Recommended Posts

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

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...