I need to change the barcode and commission information for my entire inventory and can't fighre out how.
Barcode: Right now, it says "none" for each item, but I'd like them to all be 3 of 9
Commission: Right now, they say not to allow commissions, but I want it to be defined by the sales rep
Any ideas on how to fix this?
Meralee, Give this a try:
UPDATE Item SET ComissionMode = 1, BarcodeFormat = 3
This will update all items in your database. Make sure you run a backup of your database before you run a SQL script.
This code is provided as is with no implied or expressed warrantee or guarantee.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required