Version history / updates for Webstores 2000 program files

Report problems to: Support@webcortex.com (FREE)
Webcortex constantly make changes and improvements to Webstores 2000 files and tables. 
As a licensee you should keep close attention to the below version and update information, and decide whether or not you should implement  the suggested updates.
How does the updates works ?
(Please read carefully   A L L  below!)
We are posting here changes we made to Webstores 2000  since release.
Changes are made to the program files (*.ASP files) and to the Database tables.
Using the secure URL we sent you, when you made your purchase, Download the software again, extract / install files to some temporary location on your hard drive, then delete your current installation files and reinstall over.
(Make sure you delete your files before re installing, there where some issues with files not overwritten) 

**IMPORTANT**  **IMPORTANT** **IMPORTANT** 
1. All stores data (i.e. orders, customers, Design, Inventory, etc) are stored in database, If you overwrite the database file (i.e. Webstores2000.mdb) ALL stores information will be deleted and can not be restored! 
(To preserve your current stores data intact, simply overwrite the *.ASP files only)

2.Webstores 2000 developer and enterprise editions comes with open source code, if you made changes to the source code, it is your responsibility to make sure you are not overwriting your changes!

Note: All folders are relative to the %Webstores2000% root.

The below updates apply to ALL different editions of Webstores 2000 (If you are a trial user, then simply download the trial version again and overwrite your current installation).
File / Table name  In Folder / Database Action What Changed ? Changed Date
My_Customer_base.asp /www/admin Modified Minor bug fix 3/18/00
Store_Images_Themes (Table) Webstores 2000.mdb Added Support for themes creation by merchant 3/18/00
theme_manager.asp /www/admin Modified Support for themes creation by merchant 3/18/00
How_To_Themes.htm /www/docs Added Support for themes creation by merchant 3/18/00
index.html /www/docs Modified Support for themes creation by merchant 3/18/00
update_record_action.asp / Add_New_Customer.asp /www/admin Modified Create new customer : Do not allow NULL Password! 3/29/00
Ship_Orders.asp /www/admin Modified make bigger, fix buton oid# 3/29/00
My_Customer_base.asp /www/admin Modified export files: customers_of _and ==> to: customer of to 3/29/00
/wsql/Admin/include/sub.asp, line 993 /www/admin Modified when viewing an order that contains gift in the store manager
   Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.
3/29/00
Show Big Cart line 193 /www/stores_app Modified 3/29/00
update_reords_action.asp (stroes_app) /www/stores_app Modified When modifying My Account, enable customer check / un check the
  "express shopping" link
3/29/00
orders_details.asp change PO from bold to regualr /www/admin Modified 3/29/00
sub.asp /www/stores_app and /www/admin Modified ESD - Gift appear as a file to download - Fixed: Sub.asp invoice module, both in admin and stores_app 3/29/00
Past orders.asp - fixed select query in stores_app /www/stores_app Modified Past orders.asp - fixed select query in stores_app 3/29/00
Browse_sub_departmets.asp
   Browse_masters.asp
  Browse_departmets.asp
/www/stores_app Modified When browsing departments/ sub departments etc. do not see item images ... 3/29/00
/www/stores_app and /www/admin Modified Fix the refresh problem, massive find and replace for:
<a href="../docs/index.html"><img border="0" src="images/middle/help.gif"></a>

with:
<a href="JavaScript:location.reload()"><font face="Arial" color="White" size="2">Refresh</font></a>
3/29/00
/www/stores_app and /www/admin Modified Massive find & replace :
value="Edit"
with:
value="Update"
3/29/00
/www/stores_app and /www/admin Modified Massive find & replace :
value="Modify"
with:
value="Update"
3/29/00
Zone_mamger.asp change: value="Add Region" => value="Add"  /www/admin Modified Zone_mamger.asp change: value="Add Region" => value="Add"  3/29/00
design_page.asp : value="Go" to value="Edit Page Layout/  Content" /www/admin Modified design_page.asp : value="Go" to value="Edit Page Layout/  Content" 3/29/00
Item_Edit.asp value="Edit Item" => value="Update Item" /www/admin Modified 3/29/00
Design Section.asp /www/admin Modified value="Update" => value="Edit" 3/29/00
/www/admin Modified Template same yes no add yes: no: 3/29/00
/www/admin Modified theme_manager.asp added theme #4 & #5 3/29/00
/www/admin Modified reate_store_Action.asp fixed bck update query 3/29/00
Add more images to admin /www/admin Modified Add more images to admin 3/29/00
Added two more themes: images to /images_themes/ folder,
records to tables: sys_themes sys_themes_colors
/www/admin Added Added two more themes: images to /images_themes/ folder,
records to tables: sys_themes sys_themes_colors
3/29/00
Webstores 2000 Version 2.01 Webstores 2000 Version 2.01 Webstores 2000 Version 2.01 3/29/00
Gift Wrapping.asp /www/admin Modified Fixe the currency symbol 3/29/00
Sub line 978 /www/admin Modified international currency format fix 3/29/00
Reports Total1.asp /www/admin Modified international currency format fix 3/29/00
in orders.asp change query sql_select_orders to join with transaction table…Also updated reports_total1.asp /www/admin Modified Display only orders that resulted from users clicks on "Process Order" buttn, i.e. only orders
that have record in the transaction table …
3/29/00
in theme_manager, change so that there is no defalut theme selected ...

added error to the sys messages table table changed code in theme_manager.asp
/www/admin Modified in theme_manager, change so that there is no defalut theme selected ...

added error to the sys messages table table changed code in theme_manager.asp
3/30/00
update_record_action.asp modify from select .. case to if .. Then /www/admin Modified update_record_action.asp modify from select .. case to if .. Then 3/30/00
Fix sub.asp in admin, sending emails … /www/admin Modified Fix sub.asp in admin, sending emails … 3/30/00
Fix order_details.asp to include reduce in inventory items /www/admin Modified Fix order_details.asp to include reduce in inventory items 3/30/00
Description of the change, including locations and file names... 4/12/00
Past_orders.asp change to display only orders that processd by the user all the way through 4/12/00

 

scalability fix: create_instance.asp in stores_app directory 4/12/00
Coupon update fix:Update the coupon quantityies only after we insert in to the transaction table !
check_out_action.asp
sql_update_coupon
4/12/00
when coupon is greater then grand total then set grand total to zero: /stores_app/check_out_action.asp 4/12/00
Sys_messages table: change Message_Id fied from AutoNumber to Integer 4/12/00
stores_app/register_action.asp - close record set 4/12/00
update_record_action.asp when adding a new customer: check for unique User_Id both admin and stores_app 4/12/00
Delete get_cust_info sub from sub.asp  4/12/00
delete spaces from sub.asp 4/12/00
in /admin/ items.asp delete the button "next level" 4/12/00
stores_app/master_departments.asp disallow to select multiple  4/12/00
admin/order_details.asp fixed to include the quanitity updated only when verified! 4/12/00
Database: Delete "Active" field from ALL tables 4/12/00
fix the ' problem with queries in the admin ...with Replace(, "'", "''")
Files: store_settings.asp ; coupon_action.asp ; update_records_action.asp
inventory_action.asp
4/12/00
New_Coupon.asp add currency symbol.. plus verification code coupon_action.asp check for coupon_id and error checking! 
also added message in sys_messages
4/12/00
New_Promotion.asp add currency symbol.. plus verification code Promotion_action.asp error checking! 
Promotion_manager.asp: discount in bold ... 
replace " :" to ":"
4/12/00
massive find & Replace <title>Close</title> with <title>Webstores 2000 E-Commerce Manager</title> 4/12/00
TBF (To be Fixed) Orders_total field in sore_customers table is not updated, check that it is working with customers group 4/12/00
update_recrds_action.aso in admin , when modifying customer id info make sure PASSWOR AND PASSWORD_CONFirm is samealso in stores_app 4/12/00
modify_customer.asp change password field type to password type="Password"

region appear twice: Fixed in admin/sub.asp line 833 display_cust_form
4/12/00
Browse_sub_department.asp Browse_departments.asp and browse_master.aspfix layout for image and desc
add : </tr><tr> and colspan="2"
4/12/00
insert_object_p.asp - enlarge the text area field 4/12/00
admin_export_download.asp - > clean the <%= %> 4/12/00
reports_Order_Break_down.asp reports_best_sellers.asp
past_orders.asp
End_date = DateAdd("d",1,Request.Form("End_date"))

Also check the oid and cid validity
4/12/00
reports_total1.asp fixed query: sql_Purchases_totals removed the inner join! 4/12/00
Sub.asp stores_app Display_Cust_Form validate fields! Also sub.asp (copy fields from sub.asp in stores_app.asp) 4/12/00
Create_New_Customer_Group.asp validate data, fix the region_all to All value customers_groups.asp make it bold... 4/12/00
admin/ store_settings.asp Security_Add and Security_Add.asp file (validation) 4/12/00
/stores_app/ Recipiet_fax_in.asp deleted! /Docs/left_side.html /Docs/right_side.html ; /Docs/index_old.html 4/12/00
Show_Big_Cart.asp => Change text 4/12/00
Color_Picker.asp changed code 4/12/00
save_cart_action.asp 4/12/00
modify_my_account.asp stores_app budget to include currency format  4/12/00
reports_order_break_down.asp in /admin/ replaced quiries 4/12/00
reports_total1.asp fix all bugs!!! 4/12/00
Changed the License agreement file, both on site and software 4/12/00
changed the /doc/ docs files to include the new license agreement 4/12/00
changed the /doc/ docs files to include the new license agreement 4/12/00
/admin/order.asp remove data for query when orders by oid or cid 4/12/00
Payment.asp, sub.asp. recipiet.asp and various of other files... 
fix the <font color="<%= text_color %>" face="<%= text_face %>" size="<%= text_size %>"> problem
4/12/00
Table Store_Pages.asp Added Field: Hide_In_Store_Admin 4/14/00
After Login Goto Login_Thank_You.asp, changed: Populate_Center.asp, Check_Out_Action.asp and Login_Thank_You.asp 4/14/00
Design_Page.asp change query to reflect not all pages should be edited! 4/14/00
Add Objet: Create_Object.asp Check Out Link change also create_instance.asp (added: case 21 call create_instance_Links_Check_Out) 4/14/00
Scalability Updates: 4/14/00
Remove Display_Cust_Form from Sub.asp
Added file: Display_Cust_Form.ASP
Modify file Modify_my_Account.asp
4/14/00

Added Fields to Store_Settings.asp Hide_Header1, Hide_Header2, etc.

Modify store.asp , add if . .else block to hide/display the different sections

In admin modify: template_same.asp: to update the Hide section fields...

4/14/00
Remove Create_Invoice (Cart_Type,Soid) from sub.asp 
And Create_Cart (Cart_Type,Soid) from sub.asp
Added file: Create_Invoice.asp
modify files: Payment.asp, Recipiet.asp, Show_Big_Cart.asp
4/14/00
Cart Action 0 and null values ... Cart_Action.asp
' Shopping cart filed must be numeric!
4/15/00
Added to 4/15/00
Fix The Bogus Date Problem, user can not enter a bogus date, in stores_app folder... 4/15/00
Widley fix of the ' problem acrosss stores_app files ... 4/15/00
Move the email query to email.asp file, change check_out_action.asp and register_action.asp to affect that! 4/15/00
Imroved queries in store_settings.asp and session.asp 4/16/00
theme_manger.asp change from delete =>insert to update, so we are not overwriting the content any more! 4/16/00
Search.asp fixed table too width! 4/16/00
Added Store wizard!
Folder admin/wizard, a 15 step easy store creation wizard !
4/17/00
/admin/Error_template.asp just improved layout! 4/19/00
Sub.asp  on send mail: error handling! TBF
Register Action, write the record for shipping then update! TBF  
Add in  - The ability to change the promotion so that it supports different prices for different customers TBF 
update theme_manager.asp to add the "theme checked" functionality /www/admin

Store_Settings

Added update theme_manager.asp make the radio button checked after update button pushed

add column "Store_Theme" in table Store_Settings to store and retrieve theme_id

4/28/00
update add_new_customer.asp, company.asp to add the red R by the required fields /www/admin Added add red R mark to remain the users for the required fields 4/28/00
validate_form.asp /www/Stores_App/include Added add date validation  4/28/00
add data type "date" in Function form_error_handler on the page of sub.asp /www/admin/include Added add date error handler 4/28/00
update item_edit.asp to check non-date value enter

update item_add_edit.asp to check non-date value enter

 

/www/admin Modified update fields special_start_date and special_end_date

update fields promotion_date_start and promotion_date_end

4/28/00
update new_promotion.asp and new_coupon.asp to check empty and not date value entry /www/admin Modified handle error when an empty or non-date entry for associated fields 4/30/00
   
/stores_app/sub.asp line 430 change from If Group_Cid <> 0 Then to If Group_Cid <> "" Then  4/20/00
theme_manager.asp checked the radio box of the store theme 4/29/00
Database change: added field : store_theme to stire the theme number in  store_settings table! 4/29/00
import_ images.asp, change from comma delimited to pipe delimited 4/26/00
admin/sub.asp error_handler add support for date check! 4/29/00 
admin/item_edit.asp check for date type 4/29/00 
store_Item_attributes table added fields : Attribute_sku and Attribute_hidden 4/30/00
Item_attributes.asp,  Item_add_attributes.asp, inventory_action.asp modified to support new table 4/30/00
Also in the same instance changed: browse_items_detail.asp and browse_items.asp and cart_action.aspto acomodate  the fact each attribute can have a hidden sku and hidden values 4/30/00
Added to store_shopping_cart and store_transactions table fileds: Item_Attribute_skus, Item_Attribute_hiddens => memo! to acomodate the attributes skus and hidden values... 4/30/00
change Create_Invoice in /admin/sub.asp to accomodate the atribute skus changes! 4/30/00
Added field to store_items:  Item_Remarks 
changed file item_edit.asp to accomodate new field Item_Remarks 
changed Create_Invoice in /admin/sub.asp to accomodate the new field Item_Remarks it will be seen only in the admin section
Accomodate upload items from text files on the new Item_Remarks  field 4/30/00
Accomodate upload items attributes  from text files on the new Attribute_sku and Attribute_hidden fields 4/30/00
import_items.asp added field Item_Remarks  4/30/00
import_items_action.asp import and insert the Item_Remarks  value! 4/30/00
Order_details.asp view in invoice and in detailed format! 4/30/00
Shipping Class # 6 can't check out fised: Shipping_Options in sub.asp 5/1/00
Cart_action.asp ; create_cart.asp: fixed items attributes update problem 5/11/00
These are major updates, most files are changed  
Start major bug fixes all across store admin 5/28/00
Fix all data validation issues: number/date/max/min/etc.... 5/29/00
Improve Store Designer to support custom designs 6/5/00
Improve Store Inventory Items to support moving back and forward within store catalog, add items directly edit items directly visa SKU search 6/5/00
Added Support for MS SQL Server 7.0 from the same source code as MS Access.
These are major updates, most files are changed
6/5/00
Fix rounding Problem of grand total 

check_out_action.asp change from Cint to CDbl in expression: 
Grand_Total = CDbl(Total) + CDbl(Tax) + CDbl(Shipping_Method_Price) - CDbl(Coupon_amount)

6/23/00
Support for image in shopping cart create_cart.asp 06/29/00
Fixed add content bug in admin/insert_object_p.asp, fixed stores_app/store.asp 07/18/00
FROM NOW ON WEBSTORES 2000 IS AT VERSION 2.1 

Important !

Notes for current users:

We recommend to install the new version and build the stores from scratch, it may take some time but is the best way to upgrade.

Other wise if you whish to preserver your old database please do the following:

Keep a copy of your old database file, Install the new version (with new database). 

Import a table called "store_dept" from new database to old database.

RE build your store departments using new version department builder.

Re assign items to store departments.

 

07/22/00
Major change, modify about a dozen files in /admin/ folder, changes in store navigation system, now support unlimited store departments hierarchy... 07/22/00
Replaced store wizard images and buttons, modify to support new catalog hierarchy 07/24/00
Price by feature matrix added, added new table to database and modify source code. 08/20/00
User definable fields added: added fields to store_items and modify the shopping cart code. 08/20/00
Added by "store departments" and zone rate matrix for better tax collection support in Webstores 2000, also added tax exempt per customer 08/20/00
FROM NOW ON WEBSTORES 2000 IS AT VERSION 2.50, this upgrade is not free see web site purchase section for details  
Webstores 2000 version 2.50 announced.

Improved store departments hierarchy & navigation

Improved Sales tax calculation method

Improved Pricing model

Improved support for installation problems

 

 
File / Field name  In Folder / Table Action What Changed ? Changed Date
move_items.asp stores_app modified sql_select_items query fixed 09/24/2000
store_dept_add.asp admin modified added sql statement: sql_check, line 4. 09/24/2000
register_action.asp stores_app modified remove code for processing shipping register form 09/24/2000
register_shipping_action.asp stores_app added added to process form: register_shipping.asp 09/24/2000
order_detail.asp admin modified added code to reduce items quantities upon user selection 09/24/2000
reports_best_sellers.asp admin modified added code to display report per verified - non verified or all orders 09/24/2000

 

store_settings.asp stores_app modified

 

added session variable: Inventory_Reduce, used to reduce inventory amount real time 09/24/2000

 

inventory_managment.asp admin

 

modified changes to support Inventory Reduced as defined by merchant 09/24/2000

 

check_out_action.asp stores_app

 

modified added code to support Inventory Reduced as defined by merchant 09/24/2000

 

Inventory_Reduce store_settings table added added field to DB to support Inventory Reduced as defined by merchant 09/24/2000

 

error.asp stores_app modified Support for any type of error : Not defined error... 09/24/2000

 

         
cart_action.asp stores_app modified

 

Added support for Quantity_Minimum, set a minimum to # of items that can be orderd 09/24/2000
login_mall_admin_action.asp Mall_Admin modified User Id / Passowrd Fixed 10/18/2000
Table: Mall_Items_Limit Table: Mall_Items_Limit

 

Added For mall edition \ webstores enterprise mega mall only: Support for limiting # of items each store can have 10/18/2000
session.asp stores_app/include modified

 

For mall edition \ webstores enterprise mega mall only: Support for limiting # of items each store can have 10/18/2000

 

table: sys_messages table: sys_messages Added record Added error message for store exceeds # of items allowed 10/18/2000

 

Forgot_thank_you.asp stores_app/ Modified Do not display the users password on the screen, instead email it to the customer 10/18/2000

 

check_out_action.asp admin Modified

 

Do not display the users password on the screen, instead email it to the customer 10/18/2000

 

File / Field name  In Folder / Table Action What Changed ? Changed Date
WEBSTORES 2000 IS NOW VERSION 3.0!
Note for current users: we have made extensive changes in WebStores 2000 code and file structure, upgrades from 2.5 are NOT possible...
ALL ASP FILES ALL ASP FILES Modified Convert text to variables to support multi language 01/04/2001
store settings store settings table Added Added more fields to support multi currencies, multi language, store locale and other localization features 01/04/2001

 

         
Copyright © 1998 - 2000 Webcortex Corporation. All rights reserved. Company
 or product names referenced may be the trademark or registered trademark of
 their respective companies

Refund/Payment policy | Open source code policy | License Agreement