How to link Pages to Products in download

[Frank]

Is there a way to link pages and products database? I know the pages
download has the LINK field, but I don't see any ID or KEY in there that
would let me link, maybe only the product name. This info must be
somewhere.

Does anybody know?

[loren_d_c]

Via the pages upload file you can include the name of the product you
want to be on the page in the 'Link Products' field. If there is more
than one, put all of the product names you want on the page in that same
field and separate them by the | (pipe) character.

-Loren


Frank wrote:

Is there a way to link pages and products database? I know the pages
download has the LINK field, but I don't see any ID or KEY in there that
would let me link, maybe only the product name. This info must be
somewhere.

Does anybody know?

[Frank]

Ok, so I must make sure the product names are the same?
What if there are duplicate names with different SKU numbers

Thanks



"Loren" <loren_d_c@yahoo.com> wrote in message
news:bvdv4t$kj4$2@support.shopsite.com...

Via the pages upload file you can include the name of the product you
want to be on the page in the 'Link Products' field. If there is more
than one, put all of the product names you want on the page in that same
field and separate them by the | (pipe) character.

-Loren


Frank wrote:

Is there a way to link pages and products database? I know the pages
download has the LINK field, but I don't see any ID or KEY in there that
would let me link, maybe only the product name. This info must be
somewhere.

Does anybody know?

[Frank]

Oh I forgot. Also when I download the product and page databases, I can't
seem to link them other than this link field in the page table. I like to
download the products after I do updates using the shopsite backoffice, and
I like to know what pages (categories) they petain to. But some of my
product names are the same or duplicated with different SKU numbers. If the
sku was in the link field that would be better.

What to do?
Thanks again



"Loren" <loren_d_c@yahoo.com> wrote in message
news:bvdv4t$kj4$2@support.shopsite.com...

Via the pages upload file you can include the name of the product you
want to be on the page in the 'Link Products' field. If there is more
than one, put all of the product names you want on the page in that same
field and separate them by the | (pipe) character.

-Loren


Frank wrote:

Is there a way to link pages and products database? I know the pages
download has the LINK field, but I don't see any ID or KEY in there that
would let me link, maybe only the product name. This info must be
somewhere.

Does anybody know?

[loren_d_c]

I know that adding ~[SKU] (a tilde, then the SKU) after the product name
works in the Subproducts linking field in the Product upload, so try
this out in the Page upload in the case where you have products with
duplicate names but different SKU's.

-Loren



Frank wrote:

Ok, so I must make sure the product names are the same?
What if there are duplicate names with different SKU numbers

Thanks



"Loren" <loren_d_c@yahoo.com> wrote in message
news:bvdv4t$kj4$2@support.shopsite.com...

Via the pages upload file you can include the name of the product you
want to be on the page in the 'Link Products' field. If there is more
than one, put all of the product names you want on the page in that same
field and separate them by the | (pipe) character.

-Loren


Frank wrote:


Is there a way to link pages and products database? I know the pages
download has the LINK field, but I don't see any ID or KEY in there that
would let me link, maybe only the product name. This info must be
somewhere.

Does anybody know?

[loren_d_c]

BTW, I just tried it myself, and the [product name]~[SKU] format does
work in the Link Products field of the pages upload file, and in fact
the pages file from page download should already include the ~[SKU] if
the product linked to that page has an SKU. I tried this in v6.3.1,
should be the same in v7.

-Loren



Loren wrote:

I know that adding ~[SKU] (a tilde, then the SKU) after the product name
works in the Subproducts linking field in the Product upload, so try
this out in the Page upload in the case where you have products with
duplicate names but different SKU's.

-Loren



Frank wrote:

Ok, so I must make sure the product names are the same?
What if there are duplicate names with different SKU numbers

Thanks



"Loren" <loren_d_c@yahoo.com> wrote in message
news:bvdv4t$kj4$2@support.shopsite.com...

Via the pages upload file you can include the name of the product you
want to be on the page in the 'Link Products' field. If there is more
than one, put all of the product names you want on the page in that same
field and separate them by the | (pipe) character.

-Loren


Frank wrote:


Is there a way to link pages and products database? I know the pages
download has the LINK field, but I don't see any ID or KEY in there
that
would let me link, maybe only the product name. This info must be
somewhere.

Does anybody know?

[Frank]

Eeek, I am running version 5 of shopsite and I just see the name in the Link
field in pages. What can I do to get the SKU in there? Can you check with
your version 5?

Thanks

"Loren" <loren_d_c@yahoo.com> wrote in message
news:bve30b$lfr$2@support.shopsite.com...

BTW, I just tried it myself, and the [product name]~[SKU] format does
work in the Link Products field of the pages upload file, and in fact
the pages file from page download should already include the ~[SKU] if
the product linked to that page has an SKU. I tried this in v6.3.1,
should be the same in v7.

-Loren



Loren wrote:

I know that adding ~[SKU] (a tilde, then the SKU) after the product name
works in the Subproducts linking field in the Product upload, so try
this out in the Page upload in the case where you have products with
duplicate names but different SKU's.

-Loren



Frank wrote:

Ok, so I must make sure the product names are the same?
What if there are duplicate names with different SKU numbers

Thanks



"Loren" <loren_d_c@yahoo.com> wrote in message
news:bvdv4t$kj4$2@support.shopsite.com...

Via the pages upload file you can include the name of the product you
want to be on the page in the 'Link Products' field. If there is more
than one, put all of the product names you want on the page in that
same
field and separate them by the | (pipe) character.

-Loren


Frank wrote:


Is there a way to link pages and products database? I know the pages
download has the LINK field, but I don't see any ID or KEY in there
that
would let me link, maybe only the product name. This info must be
somewhere.

Does anybody know?

[loren_d_c]

I'm pretty sure the ~[SKU] functionality was not in v5, it was probably
added in about v6.1.

-Loren

P.S. You should consider upgrading, you are missing out on new features
that were in v6.0, v6.1, v6.2, v6.3, and v7.0. See (contains links to
new features in previous versions, too):
http://www.shopsite.com/help/7.0/en-US/ ... tures.html



Frank wrote:

Eeek, I am running version 5 of shopsite and I just see the name in the Link
field in pages. What can I do to get the SKU in there? Can you check with
your version 5?

Thanks

"Loren" <loren_d_c@yahoo.com> wrote in message
news:bve30b$lfr$2@support.shopsite.com...

BTW, I just tried it myself, and the [product name]~[SKU] format does
work in the Link Products field of the pages upload file, and in fact
the pages file from page download should already include the ~[SKU] if
the product linked to that page has an SKU. I tried this in v6.3.1,
should be the same in v7.

-Loren



Loren wrote:


I know that adding ~[SKU] (a tilde, then the SKU) after the product name
works in the Subproducts linking field in the Product upload, so try
this out in the Page upload in the case where you have products with
duplicate names but different SKU's.

-Loren



Frank wrote:


Ok, so I must make sure the product names are the same?
What if there are duplicate names with different SKU numbers

Thanks



"Loren" <loren_d_c@yahoo.com> wrote in message
news:bvdv4t$kj4$2@support.shopsite.com...


Via the pages upload file you can include the name of the product you
want to be on the page in the 'Link Products' field. If there is more
than one, put all of the product names you want on the page in that

same

field and separate them by the | (pipe) character.

-Loren


Frank wrote:



Is there a way to link pages and products database? I know the pages
download has the LINK field, but I don't see any ID or KEY in there
that
would let me link, maybe only the product name. This info must be
somewhere.

Does anybody know?