List of items with no distributor

Posted by Scott @ Shuffle & Cut Games on March 26, 2006, 5:35 pm

Please log in for more thread options

When I started with RMS, I didn't use the distributor field - big
mistake. Now, I have approximately 1,000 items in my DB with no
distributor listed. I was wondering if there was a way to figure out
what all these items are, and preferably, a mass way of being able to
change them to reflect having a distributor.

I have found a few exports that seem to work using the wizards, but
simply can't find one that will allow me to see all the items without a
distributor.

On top of this, maybe there is a "master" export that literally has
every field available for an items. This export would solve my other
problem of needed to import items into a new database without copying
over quantity (easily editable to 0) or sales info.

Thanks!

Scott Gerhardt
Shuffle & Cut Games

Posted by Scott @ Shuffle & Cut Games on March 28, 2006, 2:02 am

Please log in for more thread options

Anyone with an idea on this one? (Read: *bump*)

P.S. Distributor = Supplier (figure everyone knows this)

Posted by Evan Culver on March 28, 2006, 1:26 pm

Please log in for more thread options

Scott,

SELECT * FROM Item WHERE SupplierID=0

-
Evan Culver
New West Technologies

> Anyone with an idea on this one? (Read: *bump*)

> P.S. Distributor = Supplier (figure everyone knows this)

Posted by Scott @ Shuffle & Cut Games on March 28, 2006, 4:15 pm

Please log in for more thread options

So nnce I get this data out (figured out this part, thank you for your
help) how do I get it back in post-corrected?