Need product IDs (or URLs) in product download

General ShopSite user discussion
Post Reply
dlundell
Posts: 95
Joined: Fri Aug 04, 2006 6:13 pm

Need product IDs (or URLs) in product download

Post by dlundell »

Hi,

I need to export my Shopsite product database, and I'm trying to figure out a way to include the product ID
(what really after is building a URL to the product, like abc.com/store/product1234.html).

I'm trying to export Shopsite data to submit to a feed aggregator. I've looked at using the data from the
Google product feed, as it has the URL, description, image names, etc. The one piece missing is a
SKU, which I need in order to tie the data back to our order mangement software (but I digress).

So... is it possible to get at the product ID in a Shopsite product download?

And if not, why isn't that included - it'd be pretty handy.

Thanks,

Don
robm
Posts: 463
Joined: Fri Aug 04, 2006 5:46 pm
Location: Connecticut
Contact:

Re: Need product IDs (or URLs) in product download

Post by robm »

Don,

If you set the Download Format to version 10.1, you can select "Product ID" as one of the download fields. This field was removed in version 10.2 and later, likely because it is not truly a unique field (numbers could be re-used if the database is cleaned, or products deleted).

Rob
LexiConn
[url=http://lexiconn.com]ShopSite Host[/url]
[url=http://lexiconn.com/whitepapers.html]How to Get the Most Out of ShopSite[/url]
Post Reply