making items available on website

Posted by Craig on December 15, 2006, 4:35 pm

Please log in for more thread options

Is there a way to 'make items available on the website' other than going
into each items properties under the Options Tab and checking the box? I
would like to make quite a few items available at one time if possible.
Thanks for any help.
Craig

Posted by Jeff @ Check Point Software on December 15, 2006, 5:03 pm

Please log in for more thread options

: quoted-printable

Craig,

Backup first!!

This will set _all_ items as available for web sales except those that =
are marked inactive.

UPDATE Item
SET WebItem =3D 1 WHERE Inactive =3D 0

Otherwise, if only doing some items, you need to set a criteria for =
which items.

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment(s). If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Is there a way to 'make items available on the website' other than =
going=20
into each items properties under the Options Tab and checking the box? =
I=20
would like to make quite a few items available at one time if =
possible.=20
Thanks for any help.
Craig=20

------=_NextPart_000_0465_01C72051.D97BD680
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Craig,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Backup first!!</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>This will set _all_ items as available for =
web sales=20
except those that are marked inactive.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>UPDATE Item</FONT></DIV>
<DIV><FONT color=3D#008000>SET WebItem =3D 1 WHERE Inactive =3D =
0</FONT></DIV>
<DIV><FONT color=3D#008000></FONT><FONT =
color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Otherwise, if only doing some items, you need =
to set a=20
criteria for which items.</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment(s).  If you are not =
using a=20
reader, follow<BR>the link below to setup Outlook Express.  Click =
on "Open=20
with newsreader"<BR>under the MS Retail Management System on the =
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Craig" <<A=20
=
pets.com</A>>=20
wrote in message <A=20
=
@TK2MSFTNGP02.phx.gbl</A>...</DIV>Is=20
there a way to 'make items available on the website' other than going =
<BR>into=20
each items properties under the Options Tab and checking the box? I =
<BR>would=20
like to make quite a few items available at one time if possible. =
<BR>Thanks=20
for any help.<BR>Craig <BR><BR></BLOCKQUOTE></BODY></HTML>

------=

Posted by ABH Development on December 19, 2006, 5:40 pm

Please log in for more thread options

I'm kind of new to RMS, so bear with me. i assume that when you say you want
to make the items available on the website you are using an eCommerce
solution? What solution are you using?

"Craig" wrote:

> Is there a way to 'make items available on the website' other than going

> into each items properties under the Options Tab and checking the box? I

> would like to make quite a few items available at one time if possible.

> Thanks for any help.

> Craig

Posted by Dominic on December 20, 2006, 3:27 am

Please log in for more thread options

Criag

The SQL statement suggested should be executed through SO
Adminstrator...

This should work with whatever eCommerce product you are using since
they should all use the RMS SQL tables.

Plug: If you had been using NitroSell eCommerce there is a 'block fill'
tool that does all of this for you and 1001 other things at the same
time - stitching data together, fill one field with another's data,
etc.
So, ABH Development, you can strike NitroSell off the list of probable
eCommerce solutions that Craig is using! ;o)

Posted by kosmoscentral on December 20, 2006, 7:26 pm

Please log in for more thread options

Craig wrote:

> Is there a way to 'make items available on the website' other than going

> into each items properties under the Options Tab and checking the box? I

> would like to make quite a few items available at one time if possible.

> Thanks for any help.

> Craig

Craig there are only a few RMS eCommerce solutions out there and you'll
have to decide what's best for you. You can do a search within this
news group for RMS eCommerce and study up a bit. Here is a link you
can start with.
http://groups.google.com/group/microsoft.public.pos/browse_thread/thread/1bc8b18e1f136d3d/6706da2449a75948?lnk=gst&q=rms+ecommerce&rnum=1#6706da2449a75948

Kosmos Central has a great solution that integrates with RMS, you can
read about it here:
http://www.kosmoscentral.com/ecommerce/rms-shopping-cart/

Kosmos RMS eCommerce Solution:
1) Complete ownership
2) Portability to any hosted server
3) Online stores 100% customizable
4) Gift Card Gateway Capability
5) X-Cart Compatibility http://www.x-cart.com - over 1 million shopping
carts sold.
6) Web Integrator 2.3 (supports RMS Headquarters: ship from one
location)
7) Froogle Module available for automatic uploads
8) RMS Newsletter Management Integration
9) Advanced Search Capability
10) Automatic Scheduled Downloading of Orders to RMS
11) SSL and Payment Gateway
12) Best Seller and Featured Categories Options
13) Advanced Shipping Options
14) No incidental per item costs; unlimited items, no hidden fees.
15) Hosting: Unlimited emails, webmail access, webmaster tools

Coming Soon:
RMS OSCommerce Solution
Web Integrator 3.0 (ship from any location with RMS HQ)

Alex