Jump to content

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 post
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 post
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?). 

Edited by Noodleman
Link to post
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 post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...