Tracking Items Sold
I am trying to keep track of how many of each item is sold off the website. The following is what I have attempted already.
I have already setup a column in my "items" table to track this called "InventorySold".
I tried to use DataAssist update single record in the confirm page but it did not update.
I tried the same thing on the checkout_success before the page loads but it did not work either.
Any ideas on what I might have done wrong or suggestions on the correct way to do this?
Thanks.