Jump to content
jbringolf

POS Front End

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

Share this post


Link to post
Share on other sites

no documentation exists to cover this. CubeCarT_inventory and matrix tables (if used) are your answer though. 

Share this post


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.

Share this post


Link to post
Share on other sites
Posted (edited)

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

Share this post


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. 

Share this post


Link to post
Share on other sites

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. 

Share this post


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...