Need to change barcode and commission info. for entire inventory

- M
- Meralee
  
  Contact options for registered users
posted
16 years ago

Tue, Sep 4, 2007 4:22 PM

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?

Loading thread data ...

- R
- rsakry
  
  Contact options for registered users
Vote on answer
posted
16 years ago

Tue, Sep 4, 2007 6:28 PM

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.

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.