main top header image show network and world montage
clear spacer image
Main Menu
Home
News
About Us
Tutorials
Forums
Contact Us
Newsletter
Search
Recommend Us
Tools Menu
Order Web Hosting
Register Domain Name
Transfer Domain Name
Who Owns Domain?
Domain Suggestions
Manage Domain Name
Search Engine Submit
Free Files
Submit Trouble Ticket
 


clear spacer image Home arrow Tutorials arrow Website E-commerce Store Planning Worksheet
Website E-commerce Store Planning Worksheet Print

Store Planning Worksheet

 

This worksheet is designed to be used over the phone as a communication piece with Xtreme Web Hosts. Don't worry if you can't fill it out completely on your own, though try to figure the number of products, products with options, and categories before we talk. When completed this allows us to give you an accurate price quote for your store. It should be used in conjunction with the Website Planning Worksheet and the Website Design and Maintenance Contract.

 

Store Name:

1.

Store-Building Software
___ Paypal Links (smaller stores 5 to 10 products)
___ Cube Cart (small to medium stores - see a demo here http://cubedemo.xtremewebhosts.com )
___ OS Commerce Shopping Cart (small to very large stores supporting thousands of items - see a demo here http://oscdemo.xtremewebhosts.com )
___ Other

2.

Type of Sale
___Retail (sale to end user)
___Wholesale, business-to-business (to resellers or manufacturers)
___ Desire to do both

3.

Products 

Type of Products:

How many products (separate SKU numbers) do you plan for your store? _____.

Do these SKU numbers represent different colors or sizes for the same product? Yes___   No___

Options (color, size, etc.).
This number of products ______ has an average of ___ options each.
Did you count each of the options as a different product above?
___Yes ___No

4.

Product Photos 
A substantial part of the cost of developing a store is in preparing the product photos. But, of course, they are often what motivate people to purchase.

Number of product photos ________

Format: ___Prints ___Transparencies ___Digitized (scanned)
___Web Ready (digitized, sized, optional border, JPEG or GIF format)

5.

Product Information Format
Typical product information needed (depending upon the complexity of your site): SKU, Product Name, Product Description, Weight, Price, Picture File Name, Category, Subcategory, Related product SKUs for cross-selling, color/size option of SKU, other descriptive fields (such as ISBN for books), etc. These will usually be fields in a spreadsheet or database.  Have a look at our demos for examples - links above

Database Format
__Not currently in database or spreadsheet __Excel __FileMaker Pro __Access __Foxpro __Sybase __Oracle ___MS SQL __postgresql __mysql __Other_________________

6.

Categories of Products
The larger the store, the more categories you'll need. Site menus and search engines use these categories to group products so shoppers can find them quickly. We'll need a list of these from you. You'll also need to put the category and subcategory(ies) in fields in your database.

Number of Main Categories or "Departments" ______

 

Total number of Subcategories in all "departments _____

7.

Sketch Your Preferred Product Page Layout(s)
on the other side of this form. Show preferred placement of: (1) product photo, (2) product name, (3) product SKU, (4) product description, (5) price, and (6) order button.  Also, have a look at our demos to see if these pre-existing formats are acceptable to you - links above.

8.

Shipping

Shipping Options Offered
___Ground ___2nd Day ___Overnight

Carrier:
___UPS ___FedEx ___Airborne ___Postal Service __Other

Shipping Calculation Method
___Disable shipping calculation
___Link to UPS or other shipper shipping cost calculator (not available with Paypal)
___Flat Rate for all items (e.g., up to three books for $8)
___Price Threshold (e.g., $8 for orders between $25 and $50)
___Weight Threshold (e.g., $8 for orders weighing between 10 and 12 pounds
___Shipping Price specified for Each Item (useful for items with special packing or crating)
___Other

Shipping Areas or Zones (6 included at no extra charge). Many merchants start with UPS zones and then average them so there are 3 or 4 zones for the continental US or other major market area. In the US, you will probably also have zones for Canada, and Alaska/Hawaii. For international customers state: "We will calculate the exact shipping amount and charge it to your card prior to shipping."

9.

Sales Tax (one state table at no extra charge)

States or Counties where collection is required

 

Percent Sales Tax

 

10.

Payment Transaction

Payment Methods Allowed
___Visa ___MasterCard ___American Express ___Discover___
COD ___Purchase Order ___Reseller Account No. ___
Other:___________________________________

Credit Card Authorization

__ Paypal will handle Credit Card Authorization
___Real-time on-line credit card authorization (recommended if you're setting up a Web business from scratch)
___Desktop credit card processing after order is received (begin here if you have an existing Merchant Credit Card Account) 

11.

Secure Order Reception
This is accomplished with a SSL Certificate. You'll need to provide us with your SSL Certificate (optional but more professional).  If you are using Paypal, this is not required.
___View completed order in Web browser and print out orders on printer (for low volume stores)
___Download order file for transfer to accounting system (for higher volume stores. Interchange offers a tab-delimited file. You'll need to have a programmer write a macro to import into your order fulfillment software.)

12.

Accounting and Inventory

Accounting Program Used
___QuickBooks ___Peachtree ___Mail Order Manager ___Other

Do you want to integrate Web orders with accounting program? (special programming probably required) ___Yes ___Maybe Later ___No

 

Do you want to integrate Web orders with an inventory program? ___Yes ___No (special programming is required)

13.

Special Order Form Instructions
___Gift wrapping
___Gift card inscription
___Shipping instructions
___Other

14.

Names of "Regular" Pages.
Product pages are usually designed on the basis of templates. "Regular" pages must be hand-designed using HTML, with custom photo insertion, etc. As such, they are more expensive. Typical "regular" pages are your "home" page, FAQ, about the company, articles, newsletters, and (sometimes) ordering instructions.

___Welcome/Menu
___About the Company
___FAQ
___Newsletter
___Other:

15.

Response Forms (besides the order form) 
You may have a form where shoppers can ask questions, subscribe to a newsletter, get customer support, etc. We do not include your ordering system here. You may not need a structured feedback form; an e-mail response link may be all that is necessary.

Number of response forms (up to 20 fields each) _____

Purpose of response form(s):

16.

Web Hosting
Due to the complexity of installing and hosting store-building software and relational databases, it is important that you accept our recommendations for Web hosting services. We charge for the additional time expended installing and configuring stores on Web hosting services other than those we recommend. On the other hand, we have shopped for the best cost/performance/reliability in Web hosting services. We do resell hosting to meet your needs, but have you arrange your own contract with approved hosting services if you do not host with us.
Web Hosting Service:
_____Xtreme Web Hosts (preferred by us)

________________________ other (you designate or request)

17.

Digital Certificate of Site Security
SSL Secure Servers use a Digital Certificate signed by a recognized authority (currently VeriSign or Thawte) which tells the shopper's Web browser that the store is what it purports to be. The configuration of some Web hosting services requires each store to have its own Digital Certificate (at a cost of several hundred dollars per year). Others allow store owners to use the server's digital certificate. If you need a separate Digital Certificate, for an additional fee, we will interface with VeriSign and Thawte for you, saving you a considerable hassle.  We also sell SSL certificates for as low as $39 per year.

18.

Globalization
Once your store appears on the Web you will have a global business. You will get orders from other countries, since many countries are not able to purchase these items locally. How will you make your site more comfortable for international customers?
___Link to currency exchange calculator (Your credit card company handles exact exchange rates)
___Provide multiple languages for product names, product descriptions, order form details (name, address, phone), shipping instructions
___Provide instructions about international shipping options
___Provide international shipments with "International Air Waybill," "Commercial Invoice," or "Shipper's Export Declaration (SED)" as required. (You may obtain more information about requirements from your postal office or courier shipping service.)
___Prefer to use exchange rates of the e-commerce software

19.

Other

 

 

This form outlines our company's plans for our online store.

Signature______________________________________ Date_______________


Last Updated ( Monday, 06 December 2004 )
 
Professional Web Site Design & Hosting Service - References Available by Request

© 2008 Xtreme Web Hosts - Professional web site hosting, business website hosting and domain names
Joomla! is Free Software released under the GNU/GPL License.
Today is:   Thursday, 28 August 2008 21:21