Page 1 of 1

UPC Searching Admin & Frontend

Posted: Fri Jun 03, 2011 8:44 pm
by pitorian
Guys

Since I nearly have all items with UPC now, I would like to be able to add the stock/Inventory level update by searching the UPC any Idea how I add this into the search feature on the front end of the cart and the admin search box? would be a time saver.

Thanks

Chris

Re: UPC Searching Admin & Frontend

Posted: Sat Jun 04, 2011 12:45 am
by Martin
I had a very quick peek and it's not a simple job...

The upc is in the products table but the orders table doesn't copy that information across... The fix would require more than just this:
viewtopic.php?f=12&t=857&start=10#p4829

... instead you'd need to inner join the products table to the orderproducts table on the productid and then grab the upc field from the products table.


It's do-able with about 30 minutes spare...