Shopsite export

[gsadmin]

Whenever I export my products file, shopsite doesn't include the URL for the product or the image.

The export only offers this:

http://www."mydomainname".com/LHRIUSP100V10
(without .html at the end)

and

media/LHRIUSP100V10.jpg
(just this tail end of the address)

Is there a way to get shopsite to show the full url for both of these fields?

[Jim]

Which fields exactly are you referring to?
What method are you using to "export"? Utilities > Export Store or Utilities >Database > Download.

Steps on how you are "exporting" would be helpful.

[gsadmin]

Yes, Utilities >Database > Download.

If I export ALL shopsite fields I get the following list. The problem is that there is no basic product URL field available for export. There are separate .html pages created for each product, so I know that each one has an address ending in .html:

#Name
SKU
Sale Amount
More Information Text
Brand
Product Field 1
Product Field 3
Product Field 12
Price
Taxable
Tax Code
VAT
Weight
Quantity On Hand
Low Stock Threshold
Out Of Stock Limit
Ground Shipping
Second Day Shipping
Next Day Shipping
Shipping 3
Shipping 4
Shipping 5
Shipping 6
Shipping 7
Shipping 8
Shipping 9
Graphic
Product Image Size
Search Keywords
Search Make Page
Product Description
Option Text
Option Menu Text
Option Column Headers
Option Append SKU
Option Use Multi Menus
Option Select Default
Product Options
Customer Text Entry Box
Customer Text Entry Header
Customer Text Entry Columns
Customer Text Entry Rows
Cross Sell Products
Product On Pages
Add To Pages
Display More Information Page?
More Information Graphic
More Information Image Size
More Information Title
More Information Meta:Keywords
More Information Meta:Description
File name
Include In Sitemap
Sitemap Priority
More Information Product Cross Sell
More Information Global Cross Sell
More Information Image 1
More Information Image 2
More Information Image 3
More Information Image 4
More Information Image 5
More Information Image 6
More Information Image 7
More Information Image 8
More Information Image 9
More Information Image 10
More Information Image 11
More Information Image 12
More Information Image 13
More Information Image 14
More Information Image 15
More Information Image 16
More Information Image 17
More Information Image 18
More Information Image 19
More Information Image 20
More Information Extra Image Size
Template
Display Name?
Display SKU?
Display Price?
Display Graphic?
Sale On
Name Style
Name Size
Price Style
Price Size
SKU Style
SKU Size
Description Style
Description Size
Image Alignment
Text Wrap
Add to Cart Button
View Cart Button
Product Type
Display Order Quantity?
Display Ordering Options?
Use Add to Cart Image?
Add to Cart Image
Use View Cart Image?
View Cart Image
Product Download Location
Search Dest Type
Search Dest
Dimension Options
Dimension Text
Dimension Selected
FedEx Container
USPS Container
No Shipping Charges
Extra Handling Charge
QBImport
Minimum Quantity
Quantity Pricing
Qty Pricing Background Color
Qty Pricing Price and Comment Color
Qty Pricing On Sale Color
Qty Pricing Comment
Qty Pricing Number Price Breaks
Qty Pricing Ranges
Quantity Pricing Group
Display Quantity Pricing?
Variable Price?
Variable Name?
Variable SKU?
Google Base
GTIN (ISBN, UPC, EAN, or JAN)
Manufacturer Part Number (MPN)
Google Product Type
Google Product Category
Availability
Google Condition
Age Group
Gender
Google: Include Variant Options
Color Option
Size Option
Material Option
Pattern Option
Doba Information
Recurring Payments
Payment Interval
Regular Payment Amount
Ending Period
Bill On
Trial
Trial Payment Amount
Trial Periods
One-time Fee
One-time Payment Amount
Subproducts
Product Field 2
Product Field 4
Product Field 5
Product Field 6
Product Field 7
Product Field 8
Product Field 9
Product Field 10
Product Field 11
Product Field 13
Product Field 14
Product Field 15
Product Field 16
Product Field 17
Product Field 18
Product Field 19
Product Field 20
Product Field 21
Product Field 22
Product Field 23
Product Field 24
Product Field 25

[Jim]

The database does not contain the domain name information for you store. The authorized url is specified in the file <storeid>.auth (where <storeid> is the actual storeid assigned to your store). All files are referenced off of that url with pages being placed at the root of the authorized url and images based off of the media directory in the root of the url.
So if your storeid.auth file has the domain name of http://mystore.com/store all pages will be placed in the directory that corresponds to the domain name /store and all images will be in the /store/media/ directory or a sub directory of that. You can typically find the path on the server where the files will be by going to Preferences > Hosting services and then look near the bottom of the screen for the Output Directory: and Media Directory: values.

Since the urls will always be based off of the authorized url, there is no need to store the information in the database and since it isn't in the database it can't be downloaded with other data.

In your first post you said

The export only offers this:
http://www."mydomainname".com/LHRIUSP100V10
(without .html at the end)

The only way you would get a full url like that would be if you entered the complete url in some field, like the url for an image. If the page/product filename downloaded without the .html extension that is because no extension was entered with the filename. If the page file name or product moreinformation page file name is left blank then you will not get any thing in the download file. But when the page / moreinfo page is generated the file name will be created with pageXX.html or productXX.html where the XX is the database record number of the page or product.

If you need to have the full urls and not just the page file name or image name then you could download it as it currently is and use the concatenation feature in your spreadsheet to add the url to the domain as specified in the authorization file to the front of the field where the page file name or moreinfo page file name is found. For images make sure you add the /media between the domain url and the filename.