Page 1 of 1

More Database questions SS4.1

PostPosted: Fri Aug 23, 2002 12:41 pm
by Andrew G
Question #1: I downloaded my products database I notice that the In These
Pages field is <empty> for all my products. Isn't that the field that
determines what categories I am showing my products in? Is that data
excluded from the down load for some reason(did i make a mistake) or is it
available somewhere else?

Question #2: would the itemnum variable used in the order anywhere html
string correspond to the numbers which would be produced by downloading the
product database and adding an ID key in a database? I guess i can find this
one out myself so never mind haha

Andrew

Re: More Database questions SS4.1

PostPosted: Fri Aug 23, 2002 1:40 pm
by Barney Stone
The page assignments can be uploaded in either Pages or Products, but
ShopSite actually only stores then in Pages, so they don't get downloaded in
Product downloads.

If at all possible, you are much better off using ShopSite 6+ and using SKUs
in your Order Anywhere tags instead of product ID numbers. If the product
IDs get out of synch, your customer will end up with the wrong product in
the shopping cart!

- Barney Stone, President
Stone Edge Technologies, Inc.
215-641-1837
www.ECommerceUtilities.com


"Andrew G" <andy@electroline4u.com> wrote in message
news:ak635r$d5n$1@support.shopsite.com...
Question #1: I downloaded my products database I notice that the In These
Pages field is <empty> for all my products. Isn't that the field that
determines what categories I am showing my products in? Is that data
excluded from the down load for some reason(did i make a mistake) or is it
available somewhere else?

Question #2: would the itemnum variable used in the order anywhere html
string correspond to the numbers which would be produced by downloading
the
product database and adding an ID key in a database? I guess i can find
this
one out myself so never mind haha

Andrew


Re: More Database questions SS4.1

PostPosted: Fri Aug 23, 2002 2:09 pm
by loren_d_c
The products are downloaded from the database in the order they appear in that
database, but there may be non-consecutive record numbers due to deletes, etc.
If you want to find out what record number belongs to a particular product,
there are a couple of answers in solution S04174 in the ShopSite Knowledgebase
(http://support.shopsite.com/kbase).

-Loren



Andrew G wrote:

Question #1: I downloaded my products database I notice that the In These
Pages field is <empty> for all my products. Isn't that the field that
determines what categories I am showing my products in? Is that data
excluded from the down load for some reason(did i make a mistake) or is it
available somewhere else?

Question #2: would the itemnum variable used in the order anywhere html
string correspond to the numbers which would be produced by downloading the
product database and adding an ID key in a database? I guess i can find this
one out myself so never mind haha

Andrew