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
UPC Searching Admin & Frontend
-
Martin
- Site Admin
- Posts: 1854
- Joined: Wed Jun 17, 2009 6:30 pm
- Location: South Yorkshire UK
- Contact:
Re: UPC Searching Admin & Frontend
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...
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...