SETUP for the EasyForYou E-Shop (e-Commerce)

In this text, please replace AAAAA with your specific code.

(After your order confirmation, You will receive a e-mail with your specific code, COD licences and a link to download the EfyEshop.exe setup)

 A) Settings in the software EasyForYou (easywin.exe)
  1. Copy your licences files (EFYESHOP.COD, EFYMDBACCESS.COD, ...) files in c:\program files\EasyForYOu (do not copy the MDBaccess.TXT)
  2. Start EasyForYou and Check in menu File->Licence->Search for : EFYESHOP EFYCATEGORY EFYMDBACCESS EFYIMGDOC (The 4 licences must be present)
  3. Stop EasyForYou
  4. Copy your password file MdbAaccess.TXT in c:\program files\EasyForYou 
  5. Restart EasyForYou -> Easy prompt a message -> "New Password updated, please restart"
  6. Restart EasyForYou add and manage your categories, dont forget the checkbox "Show WEB"
  7. Start menu File->Products->Category and set the Category for each products you want to see on your e-Shop
  8. For Vista only :
    Execute the vista.bat
    Disable UAC (after setup it is more secure for your computer to enable UAC again)
    To disable UAC in Vista :
    Control Pannel
    Select user accounts
    Change security settings
    unselect the "Use User Account Control (UAC)..." Reboot
B) Settings on the IIS server (require minimum Windows XP-PRO or Win-2000)
  1. Start the setup with downloading the efyEshop.exe in your c:\temp folder. Execute efyEshop from your c:\temp folder.
  2. Check if IIS is working with your Explorer: Click this link http://127.0.0.1/SitesAsp/EasyForYou/site/eshop/testserver.asp
  3. If Ok, you will see the message "Hello, the ASP work fine :-)".
    If     not, then refer to the Microsoft web site link http://search.msn.com/results.aspx?FORM=SMCRT&q=how%20to%20setup%20iis
  4. Check if the includes files are visible with your Explorer: Click this link http://127.0.0.1/SitesAsp/EasyForYou/site/eshop/testinclude.asp 
  5. Create a new folder C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbAAAAA (dont forget to replace the AAAAA with your specific code) (respect the low case letters)
  6. Give the right to all the users (internet user IUSR_... also) to READ and WRITE in this folder, for your security DON'T give the right to DOWNLOAD or LIST this folder)

    For more possibility's, in the Folder Options, desactivate (UNCHECK) the field "Use simple file sharing"



    Note: Give also the right to read in the folder C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop

  7. Copy all the files, folder and SUB-Folders from
    C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbpqtcd
    to
    C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbAAAAA
  8. MOVE and replace all the files
    from
    c:\program files\easy for you\*.* (or the folder from your original easyforyou software)
    to
    C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbAAAAA
    (Don't forget to change your shortcut to start EasyForYou to your new location)
  9. IMPORTANT: Give the right to read and WRITE for the folder C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbAAAAA
    Click here to check if you have the rights to read and write in this folder ->
    http://127.0.0.1/SitesAsp/EasyForYou/site/eshop/testrights.asp?user=AAAAA

  10. In all the following links, change the user=AAAAA with your specific CODE, Try to start the Eshop with the link

    A) http://127.0.0.1/SitesAsp/easyforyou/site/eshop/testconnection.asp?user=AAAAA

    If the database-test connection work fine, you will see the message

    Test database: Easywin.mdb or easywin-ecommerce.mdb
    Test FileLocation = c:\inetpub\wwwroot\SitesAsp\easyforyou\site\eshop\users\mdbpqtcd\easywin.mdb* TestFileExist = True*
    Connection String = PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\SitesAsp\easyforyou\site\eshop\users\mdbAAAAA\easywin.mdb;Jet OLEDB:Database *

    Test Open OK
    Test Read in Database OK
    Test Write in Database OK
    Test Close OK

    Test database: EasyText.mdb
    Test FileLocation = c:\inetpub\wwwroot\SitesAsp\easyforyou\site\eshop\users\mdbpqtcd\easytext.mdb*
    TestFileExist = True*
    Connection String = PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\SitesAsp\easyforyou\site\eshop\users\mdbpqtcd\easytext.mdb;Jet OLEDB:Database *

    Test Open OK
    Test Read in Database OK
    Test Close OK

    Test e-commerce (in the link, select the language with lang=...FR,NL,EN,SP,DE,IT or PT)
    B) http://127.0.0.1/SitesAsp/easyforyou/site/eshop/default.asp?user=AAAAA&lang=EN
  11. To log inside the E-Shop or to place a order, take the customer reference and give a password in the software EasyForYou ->File->Cust. or Suppliers->Password
  12. If you place a new order in the eshop, the status from this order is CLOSED in EasyForYou, if you validate the order in the Eshop, the order change to status OPEN in Easyforyou.
  13. If you like, you can activate the automatic confirmation by email for you and for your customers.
    First install the free AspMail dll availaible on http://www.easy-for-you.com/download/aspemail.exe
    Setup the C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbAAAAA\initvar.inc and at the bottom input your email (sSender) and SMTP adress (sServer)
    Please check the ASPmail dll with http://127.0.0.1/SitesAsp/EasyForYou/site/eshop/testmailserver.asp?user=AAAAA (for your security, this asp is only availaible on demand)
C) Settings the design of your online products
  1. Setup your home page in C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbAAAAA\home.htm, if you like different language, translate your home page and make a copy like homeFR.htm, homeNL.htm, homeIT.htm, homeSP.htm, homeDE.htm, homeEN.htm
  2. Change the general layout and many different parameters from your in C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbAAAAA\initvar.inc (use a notepad editor)
  3. Change the back-ground design from your site with the C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbAAAAA\images\bg.gif (same than for the layout, il you like to work with one different backgroud for each different languages, please copy the bg.gif to bgFR.gif, bgNL.gif, bgEN.gif ...
  4. The picture showed in the eshop can be different than theese printed on the EFY documents, copy all your pictures in C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbAAAAA\images\ref-product.GIF or ref-productJPG
    If you want to show Thumbs (small pictures), create a small picture format (about 100 to 200 pixels) and copy in the thumbs folder1 C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbAAAAA\thumbs\ref-product.GIF or ref-productJPG (this will increase the speed of your e-commerce)
    The e-commere create automatically link's from the thumbs to the big picture. (click on a small picture and you see the big in a window)
    You can also illustrate your categories, same as for the products, create a picture with the REF-CATEGORIES.JPG or GIF and copy the picture to the folder C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbAAAAA\images.
  5. Two possibilities to include a long description for some of all your products:
    1) In Easyforyou, go to your menu File->Product and select a product. In the additional field, put a new variable including your description using this sintax :
    /DES:your long description including html tags like this.<br>For carriage return.Or<b>for bold</b>....
    You can also using a specific description for each different languages. In this case procede like this :
    /DESFR:Pour le texte en Franηais./DESNL:Voor u Nederlandse omschrijving./DESEN:For your English description...
    2) Second possibility, create a html file with a html editor for each description.
    Include your text, other pictures, html tag's and so on...Copy and name this file :
    C:\Inetpub\wwwroot\SitesAsp\EasyForYou\site\eshop\users\mdbAAAAA\images\ref-product.HTM
    You can also have a different long description for each different languages, in this case rename the file ref-product.HTM like this : ref-productFR.HTM for French, ref-productNL.HTM for Dutch...
    In case you want to insert some images, use this path : <img scr=users\mdbAAAAA\images\your-specific-image.jpg>
  6. In the folder images, You can also change the picture caddie.gif, trash.gif, bulletmenu.gif ... with your own pictures.
  7. To change the coulours of the titles, text size etc.. refer to the css folder.
  8. You can check all the E-Shop order from inside EasyForYou, in the file->document management, in the customer research fields, if you type EFY E-Order + RIGHT click mouse (to start the advanced search menu) on the search button + Search this keyword in advanced search menu.
  9. Do not modify the ASP files inside the eshop folder, if you do, the next update from EasyForYou, they will be replaced and erased.

  10. Calculate and parameterise the transport cost or Shipping charges.

    In the software EasyForYou

    1) In menu File->Products, create or use a product with reference TRA and description : Transport cost or Shipping charges, input the prices according the customer level.
    2) On the right side of the prices you can input a limit amount "Free from". If the sum of a order placed in the e-commerce is equal or higher than this amount, the shipping charges are FREE.

    ADVANCED possibilities to calculate the shipment charges according the Weight and destination of your products.

    1) In menu File->Products, Input the weight of your products.
    2) To create a specific decreasing price for a specific destination: In your menu File->Categories, create a category named "TRA" + with the country code. For example TRAFR for shipping to France and UNCHECK the boxfield "Visible E-Shop".
    3) In this category TRAFR input the description "Shipment for France" and click the plus (+) button to add a price … with a weight limit from … to … You can use different scales like in this sample :



    4) For the shipment prices to European communities, use TRAEUR as categories reference.
    5) For shipment prices to the rest of the world use TRAALL as categories reference.
    6) Some specific countries have different territories using the same prices levels as the "mother" countries. For example, if the shipment prices for Monaco or Andorra are the same as for France, create a category like TRAMC for Monaco and TRAAD for Andorra (MC is the country code of Monaco and AD for Andorra, all the country code are available in the table COU001)

    For this example of categories (TRAMC and TRAAD), in the "category mother e-Shop", simply type or select the "mother" country reference (TRAFR) to refer for the price calculation.



  11. Possibilities to offer a Free product or Gifts according the total amount of the order.

    Possibilities to offer a Free products or Gifts with this syntax in the additional field of the Files->Products in EasyForYou :

    Example for the product reference : BIC
    In the additional field of the Files->Products, put this syntax : /FREE:BIC>=100/
    This mean, in a order where the total amount is 100 EUR or more, the customer will receive one free product (reference : 'BIC') when confirming the order.


  12. General discount for the customer

    Do as follow to give a general discount regarding the total amount of the purchase.

    - In Easyforyou menu->File->Categories, create a new category with reference DIS, input the description in the different languages.
    - Uncheck the field "Visible E-Shop".
    - Select the "Type" -> "Margin" (in this case only, we use the margin as a discount percentage)
    - Click the + button to add a new line
    - Input the percent discount (in the Margin field) you want to give ("from" amount "to" amount) like in this example
    - To add a new line, press the key ENTER from your keyboard when the cursor is in the field "to".






  13. Using Size and Colors.

    How to use the size and color system : (at least version 7.5.452)

    In the e-shop:

    - In the file initvar.inc, set the variable bSizeAndColors = true

    In Easyforyou : Each size and colour is a separated product (needed to manage your inventory and barcodes)

    - In menu Products, (as example) , create a "generic" product reference : SHOES001
    - Input the description for your product: Nike - Airforce
    - Only in the generic product, put /CAT:Y in the additional field
    - Input the sales and purchases prices.
    - Dont forget to select a Category.
    - Save and click the menu "Edit->Copy"
    - Click the menu "Edit->Paste New", and type the new reference : SHOES001-39-RE (use the generic reference and type your SIZE and COLOR codes separated by "-" minus, in this example, we use 39 as size and RE for red)
    - As description, for example, type "Nike Air Force (39) (Red)"
    Right syntax : After the description, type ONE space + Open Bracket + Size + Close bracket + ONE space + open bracket + color + close bracket.
    - Create a new product for each size and color, so if you have 3 colors and 5 sizes, you will having 1 generic product for the price and 15 "size and color" products to manage exactly your stock quantyties.

    After this, try in the e-commerce to order a shoes.
    If you click the order button, the system will automatically first asking to make your choise for the size and color.

    Important note : To create your different size and colors products, you can also using Excel to "copy and paste" your products and after use the Import function from excell into easyforyou (menu Tools->Import data from Excel)

D) Settings the e-commerce ON-LINE
  1. Change the link 127.0.0.1 with your STATIC IP address.
    If you dont have a static IP address (you have a dynamic)

    Two possibilities :

    The first way (the best):
    1) on your server http://www.mysite.com , create a new folder "rwe" (with rigth for internet user to Reading, Writing and Execute)
    2) By FTP, copy the php (or ASP) files writeip.php and gotoeshop.php to the real server from your site in the new folder rwe (for example http://www.mysite.com/rwe).
    3) On your loca server, Create a new task named WriteIP in your Windows Task-Scheduller with the following command:

    "C:\Program Files\Internet Explorer\IEXPLORE.EXE" "http://www.mysite.com/rwe/writeip.php?write=pasword12345"
    In the plannification, execute this task every 10 minuts or more.

    (This task will create a text file (rwe/ip.txt) in the folder rwe of your site that content the dynamic IP adress from your local (server) computer. To check if it's work fine, type http://www.mysite.com/rwe/ip.txt in your explorer, if the system work, you will see your actually IP adress).

    4) Now the link to start your e-commerce will be :

    Http://www.mysite.com/rwe/gotoeshop.php?user=AAAAA&lang=EN
    (This gotoeshop.php will read the ip.txt file and automaticaly redirect the link to your local (server) computer that contain your e-commerce easyforyou and your products database.


    The Second way:
    1) Go to the web site http://www.whatismyip.com and replace 127.0.0.1 with your IP.
    2) Go to the web site :http://www.dyndns.org , http://www.no-ip.com or another web site to control automatically your DNS.

    Note: Some provider close all the ports between 1 and 1000 (also the port 80) on you adsl connection. In this case use port 8080 instead 80 with IIS.
    To change this on your local server, in Windows->Start->Parameters->Admin Tools->Internet Services (IIS)->Default Web site->Properties->Port TCP: 8080.
    After, change your link to the eshop with http://your.ip.adress:8080/SitesAsp/EasyForYou/site/eshop/....

E) Settings very helpful for your online helpdesk

  1. Go to the web site http://www.realvnc.com/download.html and install at least the free edition of Real VNC, so you can give a tempory password to give access on us to your desktop to setup Easyforyou or (and) the e-Commerce.
    www.gotomypc.com have more possibilities but it's not free.

F) Settings in case you have NOT your own server and you host the eshop on a shared hosting.

 ! In this case, this is important to first check if you have the last update version from your software EasyForYou.
Start Easyforyou and go to menu Tools->Update Software.

Setup the parameters in your folder …/users/mdbXXXXX :

 - Setup, to do only the first time

  1. In the file initvar.inc, set the parameter sSharedHosting = "BC1" (select the ledger where you want import the orders generated with the eshop)
  2. Create a folder (directory) …/users/mdbXXXXX/export on the server AND in your local computer c:\program files\easy for you\import (OR ...mdbXXXXX\export)
  3. When a customer validate or pay an order, the Eshop will create a file formatted in the shared hosting folder : BC1YYYY9999999-YYY.txt
    YYYY = Year
    9999999 = Order Number
    YYY destination ledger (parameter sSharedHosting in initvar.txt)
    (you will also receive a mail confirmation)
- To do, every time you add or change somethings in your products (prices, descriptions...).
  1. In EasyForYou->Click Menu Tools->Export E-Commerce, a file is generated in :
    c:\program files\easy for you\ OR ...\users\mdbXXXXX\easywin-ecommerce.mdb
  2. Use your ftp software or ftp connection (Type this in the internet explorer ftp://YourLogin:YourPassword@ftp.YourDomain.com ) to connect your hosting and upload the file easywin-ecommerce.mdb in the folder …/users/mdbXXXXX from the hosting

    Note : Dont forget to Upload your images and html descriptions from your local folder :
    c:\program files\easy for you\images, c:\program files\easy for you\thumbs
    OR
    ...\users\mdbXXXXX\images, ...\users\mdbXXXXX\thumbs

    Upload to your hosting in folder
    …/users/mdbXXXXX/images, …/users/mdbXXXXX/thumbs
    NOTE : Il you make some changes in your initvar.inc, dont forget also to Upload to your hosting in …/users/mdbXXXXX

- To do, every time you want to generate your orders :

  1. To create the file including your new customers on the server (…/users/mdbXXXXX/ArtEFY.mdb) , navigate to the link

    http://…/eshop/exportcustomers.asp?userx=XXXXX&password=PPPPP (after you put this link in your favourites)

    XXXXX = Your specific code
    PPPPP = The password of your database (available in AccessToMdb.txt)

  2. With your FTP connection, download FIRST the files ArtEFT.mdb inside your local folder c:\program files\easy for you\import OR …/users/mdbXXXXX/import.
  3. With a FTP connection, download the .TXT files from …/users/mdbXXXXX/export/*.txt inside your local folder c:\program files\easy for you\import (OR …/users/mdbXXXXX/import)
  4. Restart Easyforyou and press Shift-F2, the new customers will be added and orders will be created in the ledger (sSharedHosting = "BC1")

Note : all this process can be programmed in your Windows task scheduler.