Database Upload/Download Fields

ShopSite uses specific names to identify fields (columns) in the Product and Page tables. When you upload or download a simple delimited text file, ShopSite will use the first line of the text file to identify the fields.

If you import your table files into a third-party application that uses different field names than the ones used by ShopSite, you can configure a Field Map on the Download Options screen to specify the field order, as well as give fields different names in the downloaded file.

When you import a simple delimited text file into ShopSite, you will need to specify which ShopSite field name to associate with the fields in your table. Any fields not associated with a ShopSite field will be ignored in the upload.

Each ShopSite table field should contain data of one of the following types:

• Text fields, like Name and Product Description, do not have default values. You can put almost any text in these fields, including HTML tags.
• Numeric fields, like Price and Weight, accept only numeric values. You can include numeric and decimal separators (such as 1,234.56), but not currency symbols.
• Checkboxes must be either checked or unchecked.
• Pull-down menus, such as product Name Style, accept only the specified values, and are case-sensitive; your entry must match exactly with one of the values listed.
• Lists, such as Add To Pages, accept names of pages or products, separated by a pipe symbol ( | ).
• Image fields, such as page and product graphics, require the name of a graphic file in the store’s media directory, or the full path name to a graphic file in another directory, or the full URL to an image. If no graphic is specified, the field must contain none.

ShopSite will not be able to import information into a table field if the data is not in the correct type format. If you are concerned about potential errors, you should only include the fields you want to modify in your upload file. ShopSite will not modify fields that are not included in the upload file.

The following is a complete list of all fields you can include in a simple delimited text upload file, with information about what the field is used for.

• Product Upload Fields
• Advanced Options Fields
• Page Upload Fields

Product Upload Fields

Name - The name of the product.

Field Type:	Short Text
Default Value:	No default; you must set a value
Possible Values:	You can enter any text for the name of the product, including HTML tags.

SKU - The "Stock Keeping Unit" number for the product

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any alphanumeric string

Price - The price of the product.

Field Type:	Numeric entry (no currency symbol)
Default Value:	0.00
Possible Values:	Any numeric value in standard currency format, but no currency symbol. You can include numeric and decimal separators, such as 1,234.56.
Comment:	The currency symbol and price formatting are controlled by the settings on the Preferences Locale screen. You can set a sale price for a product with the Sale Amount field.

Sale Amount - A reduced price for the product, or a percentage by which to reduce the Price.

Field Type:	Numeric or percentage
Default Value:	Null; there is no default value
Possible Values:	Any numeric value, but no currency symbol. You can include numeric and decimal separators. To use a percentage off the Price, enter a number and a percent sign, such as 10%.
Comment:	The Sale Amount value is only used if the Sale On field is set to "checked."

Taxable - Indicates whether ShopSite should calculate sales tax for this product.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not calculate sales tax for this product.
Comment:	Tax rates must be set on Commerce Setup Sales Tax screen.

Weight - The shipping weight of the product, used to calculate shipping costs if shipping by weight is selected for the store.

Field Type:	Numeric
Default Value:	0
Possible Values:	Any integer or decimal number.
Comment:	This field is only valid if you have shipping by weight selected as the shipping option for the store. Do not include a unit of measurement (pounds, ounces, kilograms, etc.), but assume the same unit for all products.

Quantity On Hand - The number of units of this item currently in stock.

Field Type:	Numeric
Default Value:	0
Possible Values:	Any integer, or an integer preceded by a plus or minus sign.
Comment:	If this field is just an integer, it will replace the current value for this product. However, if this field contains a plus or minus sign (for example, +5), then this value will be added to the quantity already in the database. For example, if the Quantity On Hand for a product is 8 and you upload a value of -10, the resulting quantity will be -2.
Note:	If you are maintaining your database in a spreadsheet program, such as Quattro Pro or Excel, you will probably have to set the cell/column to be a text-only label field to get the program to accept a plus sign without treating it as an operator.

Low Stock Threshold - the value at which the merchant is sent an e-mail message indicating that stock of this product is getting low.

Field Type:	Numeric
Default Value:	Null; there is no default value
Possible Values:	Any integer

Out Of Stock Limit - the value at which the merchant is sent an e-mail message indicating that this product is out of stock.

Field Type:	Numeric
Default Value:	Null; there is no default value
Possible Values:	Any integer

Ground Shipping
Second Day Shipping
Next Day Shipping - The charge to ship this product by each of these methods.

Field Type:	Numeric
Default Value:	0
Possible Values:	Any numeric value in standard currency format, but no currency symbol. You can include numeric and decimal separators, such as 1,234.56.
Comment:	Each of these three fields is present only if Base Shipping or Base Plus Shipping is selected as the shipping option for the store and the specific method is enabled (checked).

Shipping 3
Shipping 4
Shipping 5
Shipping 6
Shipping 7
Shipping 8
Shipping 9 - The charge to ship the product by each of these custom shipping methods.

Field Type:	Numeric
Default Value:	0
Possible Values:	Any numeric value in standard currency format, but no currency symbol. You can include numeric and decimal separators, such as 1,234.56. The merchant can change the name of these shipping methods, but you must use the names given here when uploading a products database.
Comment:	Each of these fields is present only if Base Shipping or Base Plus Shipping is selected as the shipping option for the store and the specific method is enabled (checked). The merchant can change the name of these shipping methods, but you must use the names given here when uploading a products database.

Graphic - The pathname to a graphic file for the product.

Field Type:	Text entry
Default Value:	"none"
Possible Values:	The name of a graphic file in the store’s media directory, or the full path name to a graphic file in another directory, or the full URL to an image.

Product Image Size - The number correlating to the resized image category to use for the product image.

Field Type:	Text entry
Default Value:	2, though this might be different if image sizes have been modified. Determining possible image sizes is done here.
Possible Values:	0 (Original image), 1 (Medium/More Info image), 2 (Small/Thumbnail image), or 3 (Extra Small/Cart image), though this might be different if image sizes have been modified. Determining possible image sizes is done here.

Search Keywords - Enter keywords that you want the store search function to match on for this product, in addition to the product Name, Description, SKU, Ordering Options Menus, and More Info Page Text. (You can select which fields to use for search on the Preferences > Search Settings screen.)

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	A space-separated list of words.

Search Make Page - The URL of the search destination for this product, if the Search Dest? field is set to "specified."

Field Type:	Restricted text entry
Default Value:	Null; there is no default value
Possible Values:	A fully-qualified URL.

Product Description - Text describing the product.

Field Type:	Text entry
Default Value:	Null; there is no default value
Possible Values:	Any text string, including HTML tags, if desired. It is best to avoid the use of single and double quotation marks.

Option Text - Text to appear on the shopping cart above any Ordering Options pull-down menus for this product.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text string, including HTML tags, if desired.

Option Menu Text - Text for the contents of pull-down menus for Ordering Options for this product.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Choices to appear in pull-down menus.
Comment:	Separate options with |n|, and separate groups of options with |n||n|

Option Append SKU - Whether or not the SKU for each option is appended to the Product SKU.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that only the product SKU will be used for all product options.

Option Use Multi Menus - Whether or not Cascading Menus are used.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that Cascading Menus will not be used.

Option Select Default - The text that will appear at the top of an option's drop-down menu, before an option is selected.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text string, including HTML tags, if desired.

Advanced Options - Special consideration should be taken with the following fields, as they pertain to the Advanced Ordering Options in ShopSite. Each of these fields is a header that can contain any number of rows. The Menu1 header should begin with a bang (!Menu1). Each row after the header row should end with a double pound (##), and the entire section should end with a double bang (!!).

Menu1
Menu2
Menu3
Menu4 - The names of the specific options. These fields should corresponds with the information in the Option Menu Text field.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text string, including HTML tags, if desired.

Use - Whether or not the row will show up as an option that the customer can select.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that the field will not be shown in the Advanced Options drop-down list for the product option.

AppText - The text that will be appended to the default Product Name.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text string, including HTML tags, if desired.

SKU - The text that will be appended to (or replace) the default Product SKU, depending on how the Option Append SKU is set.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any alphanumeric string

PriceMod - The change in price to the default Product Price.

Field Type:	Numeric entry (no currency symbol)
Default Value:	0.00
Possible Values:	Any numeric value in standard currency format, but no currency symbol. You can include numeric and decimal separators, such as 1,234.56, as well as how the value modifies the product's price. (See the Special Rules table of the Advanced Ordering Options page for more information)
Comment:	The currency symbol and price formatting are controlled by the settings on the Preferences Locale screen. The modified price of the product option will never go lower than zero.

WeightMod - The change in weight to the default Product Weight.

Field Type:	Numeric
Default Value:	0
Possible Values:	Any integer or decimal number, as well as how the value modifies the product's weight. (See the Special Rules table of the Advanced Ordering Options page for more information)
Comment:	This field is only valid if you have shipping by weight selected as the shipping option for the store. Do not include a unit of measurement (pounds, ounces, kilograms, etc.), but assume the same unit for all products. The modified weight of the product will never go less than zero.

QtyOnHand - The number of this product option that are on hand. Inventory for the default Product will be disabled if this field is used

Field Type:	Numeric
Default Value:	0
Possible Values:	Any integer, or an integer preceded by a plus or minus sign.
Comment:	If this field is just an integer, it will replace the current value for this product. However, if this field contains a plus or minus sign (for example, +5), then this value will be added to the quantity already in the database. For example, if the Quantity On Hand for a product is 8 and you upload a value of -10, the resulting quantity will be -2.
Note:	If you are maintaining your database in a spreadsheet program, such as Quattro Pro or Excel, you will probably have to set the cell/column to be a text-only label field to get the program to accept a plus sign without treating it as an operator.

LowStock - The number on hand of this product option where a warning that there is low stock of this item should be given.

Field Type:	Numeric
Default Value:	Null; there is no default value
Possible Values:	Any integer

OutOfStock - The number on hand of this product option where an alert that the item is out of stock should be displayed.

Field Type:	Numeric
Default Value:	Null; there is no default value
Possible Values:	Any integer

Image - The path and name of the image for this product option.

Field Type:	Text entry
Default Value:	"none"
Possible Values:	The name of a graphic file in the store’s media directory, or the full path name to a graphic file in another directory, or the full URL to an image.

Customer Text Entry Box - Indicates whether a customer text entry box for this product should appear in the shopping cart.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked. Setting a unchecked value indicates there will be no customer comments box for this product on the shopping cart page.

Customer Text Entry Header - Text to be displayed above the customer text entry box.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text string, including HTML tags, if desired.

Customer Text Columns - Number of columns (characters) wide the text entry box should be.

Field Type:	Numeric
Default Value:	40
Possible Values:	any positive integer.

Customer Text Rows - number of rows (characters) high the text entry box should be.

Field Type:	Numeric
Default Value:	4
Possible Values:	any positive integer

Cross Sell Products - A list of products, assigned to this product, which will appear in product cross-sell listings.

Field Type:	Restricted Value Text Entry
Default Value:	Null; there is no default value
Possible Values:	A complete list of product names assigned as this product's cross-sell products, separated by a |.

Product On Pages - A complete list of store pages on which this product should appear. This replaces the existing list, so the product will only appear on the pages listed here (use Add To Pages to add pages to the existing list).

Field Type:	Restricted Value Text Entry
Default Value:	Null; there is no default value
Possible Values:	A complete list of page names that this product will appear on, separated by a |.
Comment:	Do not use this if you are already using Add To Pages. The Product Links field in the pages database performs a similar function.

Add To Pages - A list of store pages this product should be added to. This is not a full list (see Product On Pages), but a list of pages to add to the existing list.

Field Type:	Restricted Value Text Entry
Default Value:	Null; there is no default value
Possible Values:	A list of page names to add to the existing list of names of pages that this product will appear on, separated by a |.
Comment:	This field was formerly called In These Pages (which is also a valid field name in current versions). Do not use this if you are already using Product On Pages. The Product Links field in the pages database performs a similar function.

Display more information page? - Indicates whether a More Information page exists for this product.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that there is no More Information Page for this product.

More Information Text - Descriptive text to appear on the More Information page for this product.

Field Type:	Text entry
Default Value:	Null; there is no default value
Possible Values:	Any text string, including HTML tags, if desired.

More Information Graphic - An image file to be displayed on the More Information Page for this product.

Field Type:	Text entry
Default Value:	"none"
Possible Values:	The name of a graphic file in the store’s media directory, or the full path name to a graphic file in another directory, or the full URL to an image. Note that you can use any type of media file; you are not restricted to graphic file formats.

More Information Image Size - The number correlating to the resized image category to use for the More Information image.

Field Type:	Text entry
Default Value:	1, though this might be different if image sizes have been modified. Determining possible image sizes is done here.
Possible Values:	0 (original image), 1 (Medium/More Info image), 2 (Small/Thumbnail image), or 3 (Extra Small/Cart image), though this might be different if image sizes have been modified. Determining possible image sizes is done here.

More Information Title - The text to use in the HTML title for the More Information Page.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value.
Possible Values:	Any text string. Do not use reserved characters (&, ", ’, <, >, etc.).

More Information Meta:Keywords - The list of keywords to be included in the HTML meta keywords tag.

Field Type:	Text entry
Default Value:	Null; there is no default value.
Possible Values:	Any text string. Do not use reserved characters (&, ", ’, <, >, etc.).

More Information Meta:Description - The description text to be included in the HTML meta description tag.

Field Type:	Text entry
Default Value:	Null; there is no default value.
Possible Values:	Any text string. Do not use reserved characters (&, ", ’, <, >, etc.).

More Information Image 1
More Information Image 2
More Information Image 3
...
More Information Image 25 - The URL(s) for the Extra More Info Image Field(s).

Field Type:	Text entry
Default Value:	Null; there is no default value.
Possible Values:	Any valid URL.

More Info Extra Image Size - The size that the extra more info images will use, determined from a drop-down list.

Field Type:	Drop-down List Selection Box
Default Value:	3, though this might be different if image sizes have been modified. Determining possible image sizes is done here.
Possible Values:	0 (Original image), 1 (Medium/More Info image), 2 (Small/Thumbnail image ), 3 (Extra Small/Cart image), though this might be different if image sizes have been modified. Determining possible image sizes is done here.

File name - A file name for the More Information Page.

Field Type:	Text entry
Default Value:	Null; there is no default value.
Possible Values:	Any valid file name ending in .htm or .html.
Comment:	If you do not provide a name for the More Information page, ShopSite will give it a name, such as page1.html.

Include In Sitemap - Whether or not to include this product in a Google Sitemap.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked. Setting an unchecked value indicates that the product should not be included in a sitemap.

Sitemap Priority - The sitemap priority ranking for the product.

Field Type:	Limited Text Entry
Default Value:	Google Default
Possible Values:	Google Default (rank assigned by Google), 0.0 - 1.0 (single decimal increments, higher number has higher priority).

Template - The name of a product template to be used to format the product information.

Field Type:	Text entry (case-sensitive)
Default Value:	The name of the product template for your selected theme.
Possible Values:	Any valid product template name. If you have uploaded a custom template, you may use that name.
Comment:	See the Product Templates help for details about built-in templates.

Display Name? - Indicates whether to display the product name.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not display the name of this product.

Display SKU? - Indicates whether to display the product SKU.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not display the SKU of this product.

Display Price? - Indicates whether to display the product price.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not display the price of this product.

Display Graphic? - Indicates whether to display the product graphic.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not display the graphic for this product.

Sale On - Indicates whether to display the product sale price.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that this product is not on sale.
Comment:	Note that this field has no effect if a Sale Price has not been set for the product.

Name Style - Sets the font properties for the product name.

Field Type:	Restricted Value Text Entry
Default Value:	Bold
Possible Values:	Bold Italic Typewriter Plain

Name Size - Sets the font size for the product name.

Field Type:	Restricted Value Text Entry
Default Value:	Normal
Possible Values:	Normal Big Small

Price Style - Sets the font properties for the product price.

Field Type:	Restricted Value Text Entry
Default Value:	Bold
Possible Values:	Bold Italic Typewriter Plain

Price Size - Sets the font size for the product price.

Field Type:	Restricted Value Text Entry
Default Value:	Normal
Possible Values:	Normal Big Small

SKU Style - Sets the font properties for the product SKU.

Field Type:	Restricted Value Text Entry
Default Value:	Plain
Possible Values:	Bold Italic Typewriter Plain

SKU Size - Sets the font size for the product SKU.

Field Type:	Restricted Value Text Entry
Default Value:	Normal
Possible Values:	Normal Big Small

Description Style - Sets the font properties for the product description.

Field Type:	Restricted Value Text Entry
Default Value:	Plain
Possible Values:	Bold Italic Typewriter Plain

Description Size - Sets the font size for the product description.

Field Type:	Restricted Value Text Entry
Default Value:	Normal
Possible Values:	Normal Big Small

Image Alignment - Sets the alignment of the product image in relation to other product information.

Field Type:	Restricted Value Text Entry
Default Value:	Left
Possible Values:	Left Right Center

Text Wrap - Indicates whether product information text should wrap around the product image or continue in a column beside it.

Field Type:	Restricted Value Text Entry
Default Value:	On -- product information wraps around the product image.
Possible Values:	On Off

Add to Cart Button - Sets the text of the Add to Cart button that appears next to this product.

Field Type:	Text Entry
Default Value:	[Add to Cart]
Possible Values:	Any text string, including HTML tags, if desired. You can use a graphic for this button by entering the name of a graphic file in your media directory. You can remove this button by setting this field to a null value (empty quotation marks).

View Cart Button - Sets the text of the View Cart button that appears next to this product.

Field Type:	Text Entry
Default Value:	[View Cart]
Possible Values:	Any text string, including HTML tags, if desired. You can use a graphic for this button by entering the name of a graphic file in your media directory. You can remove this button by setting this field to a null value (empty quotation marks).

Product Type - Indicates whether the product requires physical shipping or is a digital download.

Field Type:	Restricted text entry
Default Value:	"Tangible"
Possible Values:	Either "Tangible" to indicate a product that requires physical shipping or "Download" to indicate a product that can be downloaded after purchase. If you are selling a product that can be downloaded but which also has a component that must be shipped, set this field to "Download."

Display Order Quantity? - Indicates whether to display a box for the user to enter a quantity on the product page in the store.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not display a quantity field for this product on the product page.
Comment:	If ordering options are defined for this product, they will always be displayed on the order form page.

Display Ordering Options? - Indicates whether to display ordering options for the product on the product page in the store.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. This field must be set to unchecked if you don't want ShopSite to display the ordering options for this product on the product page.
Comment:	A quantity box is always displayed on the order form page.

Use Add to Cart Image? - Defines which field is the source for the [Add to Cart] button for this product.

Field Type:	Radio button
Default Value:	0
Possible Values:	0 (use value of the Add to Cart Button field) 1 (use value of the Add to Cart Image field)

Add to Cart Image - The name of a file in the store’s media directory to be used for the [Add to Cart] button for this product.

Field Type:	Text entry
Default Value:	"none"
Possible Values:	The name of a file in the store’s media directory.
Comment:	The value for this field is used only if Use Add to Cart Image? is set to 1.

Use View Cart Image? - Defines which field is the source for the [View Cart] button for this product.

Field Type:	Radio button
Default Value:	0
Possible Values:	0 (use value of the Add to Cart Button field) 1 (use value of the View Cart Image field)

View Cart Image - The name of a file in the store’s media directory to be used for the [View Cart] button for this product.

Field Type:	Text entry
Default Value:	"none"
Possible Values:	The name of a file in the store’s media directory.
Comment:	The value for this field is used only if Use View Cart Image? is set to 1.

Product Download Location - The name of a file in the download directory that customers can access after purchasing this digital download product.

Field Type:	Text entry
Default Value:	Null; there is no default value
Possible Values:	The name of any file in the store’s digital download directory.

Search Dest Type - Indicates whether a search destination has been selected from the standard options or specified as a URL.

Field Type:	Restricted text
Default Value:	"selected"
Possible Values:	"selected" to indicate that the search destination is one of the standard options and is identified in the Search Dest field, or "specified" to indicate that the search destination is a URL, which is given in the Search Make Page field.

Search Dest - Identifies the selected search destination for this product.

Field Type:	Restricted text
Default Value:	"Store"
Possible Values:	One of four values to indicate how this product should be listed and linked on a search results page: Store - ShopSite will list and link to every page in your store that contains the matching product More Info - ShopSite will only create one entry for the product on the search results page and the link will take the customer to the product’s More Info page. Made - ShopSite will create a new page to display just this product. Use this option if you don’t want to include the product on any store pages but you want it to be found in a search. None - The product cannot be found by search. You can include the product on store pages, but it will not be indexed for the customer search function.

Dimension Options - Indicates whether shipping box dimensions are provided for this product.

Field Type:	Restricted Numeric
Default Value:	1 (ship by weight only)
Possible Values:	1, 2, or 3. 1 indicates that this product is shipped by weight only, and no box dimensions are provided. 2 means that box dimensions are provided in the Dimensions Text field. 3 means that this product uses one of the standard box dimensions, identified in the Dimensions Selected field.

Dimension Text - The shipping box dimensions for this product, if the Dimensions Options field is set to 2.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value
Possible Values:	The box dimensions, in the form LxWxH (length by width by height), for example 20x20x24.

Dimension Selected - The dimensions of one of the shipping boxes configured on the Shipping screen.

Field Type:	Restricted Text Entry
Default Value:	The first box dimensions configured on the Shipping screen. This value is ignored if the Dimensions Options field is not set to 1.
Possible Values:	A text string to match one of the configured shipping box dimensions.

FedEx Container - The name of the FedEx container to use for this product, if FedEx shipping is configured.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value
Possible Values:	A text string to match one of the configured FedEx container names.

USPS Container - The name of the USPS container to use for this product, if USPS shipping is configured.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value
Possible Values:	A text string to match one of the configured USPS container names.

No Shipping Charges - Indicates whether shipping charges should be charged for this product.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should charge for shipping this product.
Comment:	Digital download products often have no shipping charges, or you can use this field to offer free shipping on a product, or you can use this field for products that have no shipping charges, such as gift certificates.

Extra Handling Charge - The amount of special handling charge for this product, if any.

Field Type:	Numeric entry (no currency symbol)
Default Value:	0
Possible Values:	Any numeric value in standard currency format, but no currency symbol. You can include numeric and decimal separators.

QBImport - Information to categorize this product when product and order information is imported into QuickBooks.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value.
Possible Values:	QuickBooks formatted name/value pairs (e.g. [#TYPE=PART#][#ACCNT=Sales:ShopSite#]). The first field identifies the QuickBooks Item Type to be assigned to this product. Valid values are: PART - a non-inventory part item INVENTORY - an inventory part item SERV - a service item OTHC - an "other" charge item null - use the setting from the QuickBooks configuration screen in ShopSite The second field identifies the QuickBooks account to use to track sales of this product. The default value is Sales:ShopSite.

Minimum Quantity - The minimum number of products a customer will be allowed to purchase.

Field Type:	Numeric
Default Value:	0
Possible Values:	Any positive integer

Quantity Pricing - Information to create a quantity pricing table for this product.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value.
Possible Values:	checked or unchecked. If you were using a previous version of ShopSite, the old formatting (where all quantity pricing fields are in the same cell) still works, but you are encouraged to switch to the new format (where each field is placed in its own cell). The old format is listed below for reference purposes: Variable number of values separated by a | symbol or |n|, in this format: CHECKED|n|X|n|COMMENT|n|COLOR1|COLOR2|COLOR3|n|Q|PRICE|SALE|n| . The values are: The first value is CHECKED if Quantity Pricing is enabled for this product, otherwise it is n, and the rest of this field can be ignored. The second value (X) sets the number of price breaks. Note that this is the maximum number used for this product, but the actual number of price breaks in use may be less. . The COMMENT value is the comment that will appear below the Quantity Pricing table on store pages. The COLOR values set the color for the quantity row, price and comment row, and on sale row in the table, respectively. The Q value is the starting quantity for a quantity range. The PRICE value is the price per unit for this quantity range. The SALE value is the sale price for this quantity range. The Q|PRICE|SALE|n| is repeated for each quantity range.

Qty Pricing Background Color - The background color of the quantity pricing table for this product.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value.
Possible Values:	"#XXXXXX", where each 'X' is a hexadecimal value (0-9, A-F)

Qty Pricing Price and Comment Color - The price and comment color of the quantity pricing table for this product.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value.
Possible Values:	"#XXXXXX", where each 'X' is a hexadecimal value (0-9, A-F)

Qty Pricing On Sale Color - The "on sale" color of the quantity pricing table for this product.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value.
Possible Values:	"#XXXXXX", where each 'X' is a hexadecimal value (0-9, A-F)

Qty Pricing Comment - A comment about this product on the quantity pricing table.

Field Type:	Text Entry
Default Value:	Null; there is no default value.
Possible Values:

Qty Pricing Number Price Breaks - The number of price breaks to expect for the quantity pricing table of this product.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value.
Possible Values:	Any number 2-10.

Qty Pricing Ranges - The ranges of the price breaks for the quantity pricing table for this product.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value.
Possible Values:

Quantity Pricing Group - The name of the quantity pricing group (if any) to which this product belongs.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any configured product quantity pricing group name.

Display Quantity Pricing? - whether or not to display a quantity pricing table for this product.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked (display quantity pricing table), unchecked (do not display quantity pricing table)
Comment:	Quantity Pricing must also be enabled to display a quantity pricing table.

Variable Price? - Indicates whether the product has variable pricing enabled.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked.
Comment:	A product with variable price should also have a regular price. The regular price acts as a "lowest allowed price," and ShopSite will not allow a customer to pay less than the regular price for the product.

Variable Name? - Indicates whether the product has variable name enabled.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked.
Comment:	A product must have variable price enabled for variable name to work.

Variable SKU? - Indicates whether the product has variable SKU enabled.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked.
Comment:	A product must have variable price enabled for variable SKU to work.

Google Merchant Center - Indicates whether or not the product should be included when submitting a feed to Google Product Search/Google Merchant Center.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked (include in Google Product Search feed), unchecked (do not include in Google Product Search feed)

Brand - The product brand name, required for Google Product Search/Google Merchant Center feeds.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text. Do not use reserved characters (&, ", ’, <, >, etc.).

GTIN (ISBN or UPC) - The product ISBN or UPC, required for Google Product Search/Google Merchant Center feeds.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text. Do not use reserved characters (&, ", ’, <, >, etc.).

MPN (Manufacturer Part Number) - The product MPN, required for Google Product Search/Google Merchant Center feeds.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text. Do not use reserved characters (&, ", ’, <, >, etc.).

Google Product Type - The Google Product Search/Google Merchant Center product type value.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any Product Type name permitted by Google Merchant Center.

Google Condition - The condition of the product, according to Google Product Search/Google Merchant Center guidelines.

Field Type:	Restricted Text Entry
Default Value:	New
Possible Values:	New, Used, Refurbished

Doba Information - Product information downloaded from a Doba watch list.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any Doba Item ID
Comment:	This field is only used by Doba products. Changing this field will prevent ShopSite from associating this product with the correct Doba product.

Subproducts - The names of any products to be grouped under this product.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	A list of any of the names of products in the store. Separate product names with |. If the names of products in your store are not unique, you can use both the product name and SKU by preceding the SKU with a tilde (~), like this: Product Name1~SKU1|Product Name2~SKU2|Product Name3~SKU3 Note that it is valid to list a product as a subproduct of itself.

Product Field 1
Product Field 2
Product Field 3
...
Product Field 25 - Text fields that can be used in custom templates for ShopSite Pro stores .

Field Type:	Text Entry
Default Value:	Null; there is no default value.
Possible Values:	Any text string, including HTML tags, if desired. This information can only be retrieved and used by a custom product template. It will not appear in any of the standard ShopSite themes or templates.

Page Upload Fields

Name - The name of the page

Field Type:	Text Entry
Default Value:	No default; you must set a value.
Possible Values:	Any text string, including HTML tags, if desired. It is best to keep this short.

File name - The file name of the published page.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any valid file name ending in .htm or .html.

Title - The text to use in the HTML title for the page.

Field Type:	Restricted Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text string. Do not use reserved characters (&, ", ’, <, >, etc.).

Display Name? - Indicates whether ShopSite should display the page name.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not display the name of this page.
Comment:	If the Page Graphic includes the name of the page, you might not want to also display the page name as text.

Graphic - A graphic to be displayed on the page

Field Type:	Text Entry
Default Value:	"none"
Possible Values:	The name of a graphic file in the store’s media directory, or the full path name to a graphic file in another directory, or the full URL to an image.

Display Graphic? - Indicates whether ShopSite should display the product graphic.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not display the graphic for this page.

Text 1 - Text to be displayed below the page name and graphic, but above any products or page links.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text string, including HTML tags, if desired. It is best to avoid the use of single and double quotation marks.

Text 2 - Text to be displayed below any products and page links, but above the page footer.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text string, including HTML tags, if desired. It is best to avoid the use of single and double quotation marks.

Text 3 - Text to be displayed below the page footer.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text string, including HTML tags, if desired. It is best to avoid the use of single and double quotation marks.

Link Name - The text that will appear as the link to this page on other pages in the store.

Field Type:	Text Entry
Default Value:	Defaults to the value of the Name field for the page.
Possible Values:	A short text string.

Link Graphic - The graphic that will appear as the link to this page on other pages in the store.

Field Type:	Text Entry
Default Value:	"none"
Possible Values:	The name of a graphic file in the store’s media directory, or the full path name to a graphic file in another directory, or the full URL to an image.

Link Text - Descriptive text for this page that will appear next to the Link Name and Link Graphic.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	A short text string, including HTML tags, if desired.

Text Wrap - Indicates whether the link name and text should wrap under the link graphic or continue in a column next to it.

Field Type:	Restricted Value Text Entry
Default Value:	On
Possible Values:	On Off

Page Links - A complete list of store pages on which a link to this page should appear. This replaces the existing list, so the link will only appear on the pages listed here (use Links To Page to add pages to the existing list).

Field Type:	List of pages
Default Value:	Null; there is no default value
Possible Values:	A list of any pages that should contain links to this page. Separate each page name with a pipe ( | ).

Product Links - A complete list of products which should be included on this page. Products not included in this list will not be displayed on the page.

Field Type:	List of products
Default Value:	Null; there is no default value
Possible Values:	A list of any products that should appear on this page. Separate product names with |.
Comment:	This field is similar to the Product On Pages field in the Products database.

Links To Page - A list of pages to which a link to this page should be added. If a page which already has a link to this page is excluded from this list, the link will remain on that page.

Field Type:	List of pages
Default Value:	Null; there is no default value
Possible Values:	A list of any pages that should contain links to this page. Separate page names with |.
Comment:	This field was formerly called Link Location (which is also a valid field name in current versions). Do not use this field if you are already using Page Links.

Template - The page template to use to format this page.

Field Type:	Text (case-sensitive)
Default Value:	The name of the page template for your selected theme.
Possible Values:	Any valid page template name. If you have uploaded a custom template, you may use that name.
Comment:	See the Page Templates help for details about built-in templates.

Item Alignment - Sets the alignment of products and page links within columns.

Field Type:	Restricted Text Entry
Default Value:	Left aligned
Possible Values:	Left aligned Right aligned Centered Staggered; Start left Staggered; Start right
Comment:	The Staggered alignment options are only functional in some page templates.

Columns - The number of columns that ShopSite should use to display products.

Field Type:	Restricted Text Entry
Default Value:	One column
Possible Values:	One column Two columns Three columns Four columns Five columns

Page Link Columns - The number of columns that ShopSite should use to display page links.

Field Type:	Restricted Text Entry
Default Value:	One column
Possible Values:	One column Two columns Three columns Four columns Five columns

Display column borders? - Indicates whether ShopSite should put a thin border around columns used to display products and page links.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not display column borders on this page.

Page Width - Sets the percentage of the browser window that ShopSite should use to display the page.

Field Type:	Restricted Text Entry
Default Value:	100% wide
Possible Values:	100% wide 90% wide 85% wide 75% wide 65% wide 50% wide

Display Universal Header? - Indicates whether the store’s universal header should be displayed on this page.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not display the store’s universal header on this page.

Display Universal Footer? - Indicates whether the store’s universal footer should be displayed on this page.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not display the store’s universal footer on this page.

Text Color - Sets the color of non-link text on the page.

Field Type:	Text and hex code entry
Default Value:	Black-True (#000000)
Possible Values:	A hexadecimal color value or a string value.
Comment:	You can enter color values in two ways: a hex value preceded by a pound sign, or as a text string that matches exactly with one of the entries used in the drop-down boxes on the Add Page screen, including color name, parentheses and the # in front of the hex value.

Background Color - The background color for the page.

Field Type:	Text and hex code entry
Default Value:	White-True (#FFFFFF)
Possible Values:	A hexadecimal color value or a string value.
Comment:	You can enter color values in two ways: a hex value preceded by a pound sign, or as a text string that matches exactly with one of the entries used in the drop-down boxes on the Add Page screen, including color name, parentheses and the # in front of the hex value.

Link Color - The color of unvisited links on the page.

Field Type:	Text and hex code entry
Default Value:	Blue-True (#0000FF)
Possible Values:	A hexadecimal color value or a string value.
Comment:	You can enter color values in two ways: a hex value preceded by a pound sign, or as a text string that matches exactly with one of the entries used in the drop-down boxes on the Add Page screen, including color name, parentheses and the # in front of the hex value.

Visited Link Color - The color of visited links on the page.

Field Type:	Text and hex code entry
Default Value:	Red-True (#FF0000)
Possible Values:	A hexadecimal color value or a string value.
Comment:	You can enter color values in two ways: a hex value preceded by a pound sign, or as a text string that matches exactly with one of the entries used in the drop-down boxes on the Add Page screen, including color name, parentheses and the # in front of the hex value.

Active Link Color - The color of links as the user is clicking on them.

Field Type:	Text and hex code entry
Default Value:	Bright_Green_4 (#00FF00)
Possible Values:	A hexadecimal color value or a string value.
Comment:	You can enter color values in two ways: a hex value preceded by a pound sign, or as a text string that matches exactly with one of the entries used in the drop-down boxes on the Add Page screen, including color name, parentheses and the # in front of the hex value.

Background Image - An image to be used as a background for the page.

Field Type:	Text Entry
Default Value:	"none"
Possible Values:	The name of a graphic file in the store’s media directory, or the full path name to a graphic file in another directory, or the full URL to an image.

Meta:Keywords - The list of keywords to be included in the HTML meta keywords tag.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text string. Do not use reserved characters (&, ", ’, <, >, etc.).

Meta:Description - The description text to be included in the HTML meta description tag.

Field Type:	Text Entry
Default Value:	Null; there is no default value
Possible Values:	Any text string. Do not use reserved characters (&, ", ’, <, >, etc.).

Search Products - Indicates whether ShopSite should put a product search box on this page.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not display a product search box on this page.

Index - Indicates whether ShopSite should index the products on this page so that they can be found in a product search.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that ShopSite should not index the products on this page for searching.

Include In Sitemap - Whether or not to include this page in a Google Sitemap.

Field Type:	Checkbox
Default Value:	unchecked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that the page should not be included in a sitemap.

Sitemap Priority - The sitemap priority ranking for the page.

Field Type:	Limited Text Entry
Default Value:	Google Default
Possible Values:	Google Default (rank assigned by Google), 0.0 - 1.0 (single decimal increments, higher number has higher priority).

Order - Sets the sort order for products and page links on this page.

Field Type:	Restricted Text Entry
Default Value:	None
Possible Values:	None Ascending Descending

Products Sort Field - Sets the sort field for products on this page.

Field Type:	Restricted Text Entry
Default Value:	Name
Possible Values:	Name SKU Price Product Description

Pages Sort Field - Sets the sort field for pages links on this page.

Field Type:	Restricted Text Entry
Default Value:	Name
Possible Values:	Name Link Name

Products First - Indicates whether ShopSite should display products before page links on this page.

Field Type:	Checkbox
Default Value:	checked
Possible Values:	checked or unchecked. Setting a unchecked value indicates that products and page links should be intermixed on the page.

Number Products - The maximum number of products per page.

Field Type:	Numeric
Default Value:	0 (unlimited products per page)
Possible Values:	Any integer.
Comment:	When there are more than this number of products assigned to the page, ShopSite will automatically generate additional pages to accommodate all the products.

Page Field 1
Page Field 2
Page Field 3
...
Page Field 25 - Text fields that can be used in custom templates for ShopSite Pro stores.

Field Type:	Text Entry
Default Value:	Null; there is no default value.
Possible Values:	Any text string, including HTML tags, if desired. This information can only be retrieved and used by a custom page template. It will not appear in any of the standard ShopSite themes or templates.

ShopSite Help and Resource Center Last updated: March 01, 2010 Give Feedback

ShopSite Shopping Cart Software