Ecomm Professional Shopping Cart System Setup Instructions

Revised 12/05/2004

 Professional Setup Instructions

Help Center Home

*Note - For experienced webmasters. There are really only 3 steps to setup.

1. Upload the pages and database. 2. Create a DSN to the db. 3. Login and fill-in the Company Information

Please read all of the instructions below BEFORE beginning. Thank You.

Support is available at www.ecommerce-carts.com.

Requirements are here. (you were advised, on the product details page, to read the requirements before purchasing Ecomm Professional Shopping Cart however, you may need to review them now)

  1. Download and unzip your package. 

    • It will Unzip to C:\Ecomm\EcommProV3 

    (do not edit these files. keep the original copy unedited in case you need a fresh copy)

    • Yes, I know this is done, but did you know the following? 

  2. Copy the scart folder ONLY to your web site folder.

    • Copy the scart folder into the root folder where you work on your web site.

      • e.g. possibly C:\Documents and Settings\YourProfile\My Documents\My Webs\scart

  3. Upload the database from C:\Ecomm\EcommProV3\database\ecommpro.mdb to your web site.

    The file ecommpro.mdb is your database.

    • The database should sit outside of your wwwroot on the web server in a secure folder.

      *Note - See the file structure in the image below.

      • The folders that sit above your wwwroot are not accessible by a URL. They are secure.

      • You must use an FTP (File Transfer Protocol) program to transfer files to them.

    • You should have a db folder on your web server already

    • If not create it above your wwwroot as shown below.

      *Note - If your web site's db folder is not named db this is OK. Use the folder they have setup for databases whatever it's name is. See your web site's help files for detailed information on using databases with your web site.

    • Create an ftp login account to the db folder and upload the database.

      *Note - You may need to login to your web site controls and create the db folder and an ftp account to access the db folder. Make sure the ftp Login Account has Write Access to the db folder. See your web site help for instructions on creating folders/directories and FTP uploading/publishing to your web site. Each site may somewhat vary.

  • Upload your database in one of two ways.

    1. You can download a free ftp program here.

    2. Or simply setup a Web Folder in My Network Places (Windows 2000, XP and Up)

      • To setup a web folder for FTP, open My Network Places.

      • Click Add Network Place.

      • Enter ftp://ftp.yourdomain.com.

      • Uncheck anonymous login Login.

      • Enter your login Id/UserName

      • Next Name it or accept the default name.

      • Click Finish - The folder will open

      • Enter your password, make sure the User Name is what you entered. If it is not type over what is there with the correct User Name.

      • You can now copy files to and from any other folders to your FTP web folder, just as you would copy to and from any other folders on your computer. The web folder becomes part of your file system. Open Windows Explore. Go to C:\Ecomm\Database and right click on the database file and click copy. Scroll down and open "My Network Places" then click on the FTP Folder that you setup. Then right click and click paste into the FTP web folder.

      • e.g. Copy and Paste or Drag and Drop

*Note - You can create a web folder to your wwwroot also. FrontPage will create a web folder when you publish. If it exists already you can open it from Windows Explore.

*Note - You must have an FTP account setup on the web server to be able to login. See your web server help for creating FTP accounts.

 

  1. Create a Data Source Name (DSN) on the web server.

    *Note - DSNs are not hard to implement. You've, most likely, just never done it.

    Basically, all you're doing is creating a name attached to your database.

    (since the db is outside of your root web, the DSN is used to make database connections from your .asp pages)

    • After uploading the database create a DSN on the web server.

    • In your web site controls look for ODBC DSNs. See the image below.

    • Yours is most likely different than the images below however, the method should be basically the same.

    • Click the ODBC DSNs Icon (see above)

    • Next, Select Microsoft Access Database.

    • Enter the Data Source Name ecommpro

    • From Microsoft Assess File Select the file that you uploaded (ecommpro.mdb).

    (see the image below)

    • Click Save

     

    • Your DSN setup is now complete. If the DSN fails see below, otherwise jump to step 5.

    • If another web site on your server is using the DSN ecommpro, you'll have to choose another name. You can add a 01 to the end. e.g. ecommpro01. You only need to change the DSN NOT the database name. DO NOT rename the file ecommpro.mdb.

    • Optionally, you don't have to add the 01, you could use your company name.

    e.g. mycompanydb  could be used as the DSN - DO NOT rename the file ecommpro.mdb.

    • If you DO have to change the DSN YOU MUST also edit the file objConn_Open.inc included in your shopping cart files at \My Webs\scart\admin\objConn_Open.inc.

      • To edit the objConn_Open.inc file perform the following.

        1. With notepad or an html editor open \My Webs\scart\admin\objConn_Open.inc 

        2. View html

        3. Where "DSN=ecommpro" enter the name that you used above when you created the DSN. (you can use ANY name as long as the DSN and the objConn_Open.inc file match)

          e.g. objConn.ConnectionString = "DSN=ecommpro01"

          OR

          e.g. objConn.ConnectionString = "DSN=mycompanydb"

        4. DO NOT use the file extension .mdb in the DSN. Use a name only.

        5. See the notes below if you have your own web server otherwise go to step 5.

       

      *Note - Most hosting companies allow you to create DSNs yourself however, sometimes you must ask them to do it for you in a support ticket or however you get your support. If possible put the database in place first. If your site doesn't support Access Databases and DSNs... move ASAP. 

       
      *Note - If you are using your own web server (included in Windows 2000 and XP) on your local computer (the one you're on now) see Windows Help files for creating a DSN or click here for a helpful page. Otherwise go to Setup step 5.

       

      *Note - You must also have an email component installed on your web server AND an Email Server available on the network that allows relay from your web server. Setting up an email server and web server are beyond the scope of these instructions.

       

      Instructions for setting up a DSN on your local computer:

      1. First create the folder C:\Inetpub\db

      2. Copy the ecommpro.mdb database to C:\InetPub\db 

      3. Create a "System DSN".

       

      • To Open the DSN Window go to Start > Run and type odbccp32.cpl click OK.

        (or click the preceding Link then click Open)

        This will bring up the ODBC DSN Window.

        OR

      • From Windows Control Panel > Administrative Tools > Data Sources (ODBC)

        (in Win98 it's in Windows Control Panel)

      • Once you have the odbc Window OPEN

      • Select the System DSN tab (top)  

      • Click Add

      • Double click "Driver do Microsoft Access(*.mdb) OR Microsoft Access Driver (*.mdb)" 

      • Type in ecommpro where it says Data Source Name

      • Click Select then browse to C:\InetPub\db and select the ecommpro.mdb

      • When you see your db file in the LEFT window pain Highlight it and Click OK

      • The DSN is now complete.

      • Re-boot

      More help is always available from www.ecommerce-carts.com

  2. Place a copy of your banner or logo image in the scart\images folder that is now in the folder (directory) that you work on your web site from. e.g. My Documents\My Webs\scart\images

    • The image must be less than 750 pixels wide. The height doesn't matter too much.

  3. Edit the header.asp pages to match your web site schema.

    e.g. change the table cell background colors to help blend the cart into your site schema.

    There's one for the scart folder and one for the admin pages in the admin folder:

    My Documents\My Webs\scart\header.asp

    My Documents\My Webs\scart\admin\header.asp

    • Note - You will not see the image displayed on the page in your html editor.

    • DO NOT MAKE ANY CHANGES TO THE IMG SRC html code.

    • Optionally, you can remove the img src and not use the image name from the database. You can then edit the header pages any way you like.

    • The header pages are include pages and are included on every page in Ecomm Professional.

  4. Now Upload/Publish your web including all files in the scart folder.

  5. When upload is complete login to your new Database Control Panel.

    • go to http://yourdomain.com/scart/admin/login.asp

    • Save that page to your Favorite Places for future logins.

    • Login Using UserName for the user name and Password for the password.

  6. Click the Server Test button.

    • Determine which email components are installed on your web server from the Test Page.

    • Return to Control Panel.

  7. Click the Company Info button in Control Panel.

  8. Enter YOUR COMPANY INFORMATION in the form fields.

  9. In the Banner/Logo input box, enter the file name of the file you copied the /scart/images folder in step 5. e.g. logo.jpg.

  10. Choose to charge Sales Tax or not and whether or not to Charge Your Local State Only.

  11. Enter your State Sales Tax Rate. e.g. .05 (point 05) is 5%.

  12. Set your Base Shipping Unit. 

    Ecomm Professional gives you the ability to fine tune your shipping rates. You don't want to charge too much and you don't want shipping to cost you either. You set a Base Shipping Unit in Control Panel. Then assign each item an x amount of Units. The Item's Units are multiplied by the Base Shipping Unit.

     

    Example 1:

    • First You Set the Base Shipping Unit at 10.00

    (this is done only once in the Database Control Panel. all Items use it)

    • An item cost $10.00 to ship across the USA

    • Set that Item's Shipping Units to 1. Shipping will be $10.00 for that Item

    Example 2:

    • First You Set the Base Shipping Unit at 10.00 (only once, no need if set in example 1)

    • An Item only cost $5.00 to ship across the USA

    • Set that Item's Shipping Units to (point 5) .5. Shipping will be $5.00 for that Item

      When Shipping Rates go up across the board, you simply change the Base Shipping Unit. 

      Think of the base shipping unit as the - shipping price - of one pound - across the USA.

       

    *Note - You can use any base shipping rate that you want. You can always adjust an Item's shipping by editing the Shipping Units field. Go to Edit Products in Control Panel.

     

  13. Choose whether or not to allow Mail-In Checks.

    • If you choose No to Mail-In checks there will be no place for a customer to enter a check number. That part (bottom) of the check_out.asp page will not show up in a browser.

  14. Under Web Site and Email Server enter the following information:

    • Your Web Site URL

      e.g. http://www.yourdomain.com - DO NOT PUT A SLASH " / "AT THE END

    • Your Secure Web Site URL

      e.g. https://www.yourdomain.com - DO NOT PUT A SLASH " / "AT THE END

    • Use Secure URL

      Choose Yes if you have a Security Certificate installed, otherwise choose No.

    • Email Address

      Enter the email address that you want the customer to receive their mail orders FROM

      e.g. orders@yourdomain.com. You should create this mail account in your POP3 accounts.

    • Email Server

      Enter the mail server that you use to setup your POP3 Accounts

      e.g. usually: mail.yourdomain.com

    • Email Component

      Choose an email component that tested as IS Installed on the Test page in step 9 or click the Email Component link to run the test again. Choose a component that IS Installed.

    • Enter a new Admin Login name - Used to Login to Control Panel - DO NOT FORGET IT!

    • Enter a new Password - Used to Login to Control Panel - DO NOT FORGET IT!

    • Retype the new Password - Used to Login to Control Panel - DO NOT FORGET IT!

    • Choose a Payment Gateway:

      Choose "None" if you do not yet have an account with either Authorize.Net or PayPal.

      Otherwise choose either AuthorizeNet or PayPal.

      If you choose PayPal enter your PayPal login email address and a name for the cart.

      e.g. My Company Name Products

      If you choose AuthorizeNet as your gateway enter your Authorize.Net LoginId and Transaction Key. The LoginId is the same one that you use to login to the Authorize.Net web site. The Transaction Key is generated from the Authorize.Net member login area. See Authorize.Net help on their site for more information about Transaction Keys.

      Set Test Mode = FALSE

       

      How PayPal works:

      • Open a bank account at a bank if you don't have one.

      • Go to PayPal and open a business account.

      • Enter your bank account information with PayPal under Add A Bank Account.

      • Login to your Paypal Account and click Profile.

      • Click on "Web Site Payment Preferences".

      • Turn On Auto Re-Direct and enter the following URL:

      • http://www.your-domain.com/scart/thanks.asp

      • Go to your shopping cart control panel company info page and choose PayPal for the gateway.

      • Enter your PayPal login email address and a Name for your cart.

      • A customer places items in their cart and clicks Check Out.

      • If they have an account with you they can login.

      • Otherwise they click Create New Account. This account is kept in your database.

      • Now they verify there info and enter alternate shipping if any.

      • One more step and they go to PayPal.

      • At that point they have two choices.

        1. If they have a PayPal Account they simply login.

        2. Or they click "This is the first time using PayPal".

      • At that point they are taken to a page that asks for their name, address and credit card info. However, the form is pre-populated. It will already have their name and address because EcomProV3 passes this info to that page.

      • All they really do there is enter their credit card information.

      • PayPal verifies the card and if successful will re-direct the user back to your thanks.asp page with a string that contains the info need to process the order on your end and send the emails to you and your customer.

      • The money sits in your PayPal account a couple of days until it clears then you login to PayPal and transfer the money to your bank account.

      • This is now the system that Ecommerce-Carts.com is using.

       

  15. Click the Update Information button at the bottom right of the page. (page reloads)

  16. Setup is now complete!

  17. Return to Database Control Panel in your shopping cart system.

  18. Click the Help button for instructions on adding products to your new

Ecomm Professional Shopping Cart System!

More setup instructions are included in your cart control panel. See Step 8 above. 

 

Or view them online at our web site here.

 

Top

License Agreement

Support is available at www.ecommerce-carts.com

Powered by: Ecommerce-carts.com