Denver Research

Just wondering if this is possible and if not something to consider for future versions or updates.  The ability to have your General Manager be able to alter Product info such as Description, price ,etc without access to inventory levels.

It would be great if there was an "Admin Product Control" and a "Manager Product Control".  Manager Product Control would look exactly like the Admin Product Control minus the ability to directly alter inventory levels.  So Managers could change the Category of an item and send it to clearance Category for instance, or adjust prices for price increases from manufacturers and so on.  Have the ability to make changes so the owner doesn't but also not have access to change the inventory levels on a whim with no record.  Just a thought.

My store has 1,000's of sunglasses and for the start of 2016 most companies have done price hikes on existing products.  I only have my 1 POS at my store so having to make these changes there while trying to ring up customers can become a nightmare and literally take me a week or more.  I am hoping to (if it's ok) put the program on my laptop and upload the entire database so I can do this from home so I could work on it all night. 

If I go through and make all the price changes I need to the products on my laptop can I then save it and upload it to my POS system without it altering ANY inventory levels?  Just changing the prices? 

And also, if during the time I was home changing prices I received a new style at the store and we created a new product for it if I uploaded the new prices to the POS system the next day would it basically erase this newly added product from the database OR simply overwrite just the price changes to the product without affecting anything new added in in the meantime?

Hopefully that was explained clear enough.

I'm also thinking ahead since I am considering opening 2 stores and having a mobile unit I would like the ability to have a master program on my home laptop for price changes, etc and I can update all the POS Systems with the master program but not affect current inventory levels at each store or any inventory that just that 1 store might have that might not be in the Master database at all, and have the upload basically delete that one off product all together.

Thanks

Just from using this program now for 3 years there's one field you may want to consider adding under

REPORTS > PRODUCTS > SOLD PRODUCTS DETAIL

and that is the field for "PROFIT."  Nearly every other possible choice is in there and other reports show you your profit for the sale, however this detailed report has everything except it.  And other reports will show you profit but won't show you other important fields such as final selling price.  So, just something to consider is adding Profit to "Sold Products Detail" and that would have literally every important field under one report.  I find myself having to either use a calculator to find profit using that report or going back and forth between 2 reports. 

Just an idea for future updates that I am sure other users would also appreciate.

Something I just realized that I think could be fixed and honestly should be fixed if possible.  Any manager that has the ability to "Add New Product" (but not enough security for Product Control to actually edit current stock quantity) could get in a new shipment, in our case picture a $500 Ferrari Edition Sunglass.  They create a "new product" for it and give it the right price and all the details.  I have them start the STOCK quantity at ZERO so they can "adjust stock" afterwards and then I have a paper trail within the REPORTS that I can print out to compare it to the packing slip and my list of orders.

However, if a manager creates a new product and for stock uses -1 (negative one) they could still go and check in the inventory under "inventory adjust" and have a report showing they actually checked one in inventory.  Then since that $500 pair has a stock now in the system of 0 after they scanned it in (up from -1), they could steal it and the inventory count would still be spot on and there would be a paper trail showing they scanned in the new order properly.  It wouldn't be until someone started asking "hey, where's that new Ferrari frame at?" and then searching the reports to see if it was sold, etc.  The whole time with the inventory count being spot on.  And in our case with thousands upon thousands of sunglasses certain $300 pairs would go unnoticed as long as the inventory count is spot on and they were checked in.

My thoughts should be with "Add New Product" either the inability to go with negative numbers or simply no ability to change STOCK at all.  Any owner would want the product trail of that being left zero and then scanning them in later during "inventory adjust".

So I have an issue that came up.  We do inventory daily and compare the numbers for a Category (ie: Ray Ban) to the physical count.  Upon doing a complete Category print-out to evaluate my current stock levels I notice a particular $200 pair to have a -1 qty.  When I fixed it and made it 0, and then counted my physical inventory now I am short 1 pair.  I have been checking through my records and do not find an issue with the shortage report, returns or stock adjustments.  I am trying to figure out ways through the sales window product could have reached a -1 qty.  No one but myself has access to "Product Edit" in order to physically change quantity without there being a record.

Any ideas on where I can start looking? 

I love the fact you can build a product from parts however I am noticing one flaw that perhaps may have been overlooked?  Not sure if there is a reason it was done the way you have it now but I will explain.

As example, let's say you build a product called "MACHINE" and it is built from 2 bolts, 2 washers and 1 pipe.  The parts are all inventoried and counted on a daily basis.  Well let's say you want to have this product, called "MACHINE" on the shelf for a customer to buy so you have to go take 2 washers, 2 bolts and 1 pipe from your stock and build it.  Well now when employees go to check the stock of washers, bolts and pipes they are coming up short on their inventory count (because they are currently being used to create the machine product).  I see when it sells the individual parts are now removed from inventory however if you are using the parts to sell separately as well as parts of something bigger than inventory count will be off.  It may look like you have 20 bolts and 20 washers to sell to customers but when you check the box it's empty because you have 10 MACHINE products sitting on the shelf.

Here's just my 2 cents and perhaps there is a reason why it is not done like this.  Let's say you build that machine product from those parts listed but you have not added any machines yet to inventory, so therefore it doesn't affect your actual inventory count of loose bolts, washers and pipes.  As soon as you ADD 1 Machine Product to inventory then it should deduct the parts from inventory right then and there, because they are being used to create the larger product.  Therefore individual inventory count of the parts (that are also being sold to customers) is not off.

Any input on this? 

...(continued in next post)

I have another issue that has arose and not sure if you may have an idea why it is happening.

My manager has checked in inventory on 8/15/14 and I am holding the printed off report in my hand for Inventory Adjust and it has that date on it.  I now want to go back and make sure something else was checked into inventory later in the day (after she already printed off the report I am holding).  When I go to reports and select Inventory>Adjust and select the correct date and hit OK it comes up with nothing.  So I also tried a wider range selecting the day before til the day after (8/14 - 8/16) and it still is coming up with 0.00.  I know things were added to inventory that day (8/15) as I have the report in my hand however nothing is coming up.  Any idea on why that is or what I could try to do to retrieve that information?  Thank you

EDIT:  Another thing that happened is it has decided to take all past inventory "Shortage" and move it all to the date 8/18/14.  So products that I have used the Inventory Shortage button to remove from inventory over the past year and a half have all moved to 8/18/14.  When I run a report for that specific date it is filled with hundreds of "shortage" products.  Any reason why it did that that you can think of?  Thank you

So let's say I go to Product Control and delete a product that (as an example) was sold last year on May 1st, 2013 for $100.  The product has been discontinued this year so I delete it from the database (deleting helps keep the inventory reports to a minimum when printed daily).

Last year on May 1st (2013) I theoretically do $1,000 in sales.

Now that I have deleted this Product that was sold last year on May 1st, does it alter the total sales when searching using "reports"?  So if I delete the $100 item that sold last May 1st and run a report of total sales that day will it still remain at the true $1,000? or will it now give me a total sales for that day of $900?

Just curious whether it pulls the sales from items sold that day or if it goes off of Z-Reports. Thank you.

(I tend to over-explain my question to a point of simplicity ... sorry)