sunshop v21.6

sunshop_v21.6nullified.zip

Name: sunshop_v21.6nullified
Size: 126 KB
Type: Compressed (zipped) Folder
Date modified: 8/19/2008 8:25 PM
Date created: 11/15/2002 2:03 AM
Date accessed: 11/15/2002 2:03 AM

sunshop26/import.txt

Import How-To
2001-2002 Turnkey Solutions.

In order to import products from a csv file or "comma delimited" file your file must meet the
following guidlines.

One: Your data cannot contain any commas other then the ones seperating the values or the data
will be inputed incorectly.

Two: Some versions of MySQL do not like the use of quotation marks or single quotes. If you get
any errors generated, this may be the cause of the problem.

Three: The general format for the files is as follows:
(If you wish to leave a field empty you may skip it but you must leave the empty space where it
belongs.)

Field Description Format
-------------------------------------------------------------------------------------------------------------------
1. Item ID Leave this blank as it will assign automatically Numbers Only
2. Category ID You can get this value after adding the category Numbers Only
3. Subcategory ID You can get this value after adding the subcategory Numbers Only
4. Title Product title Letters and Numbers
5. Image Name Image name, located in your products image directory Filename
6. Thumbnail Name Thumbnail image name, located in your products image directory Filename
7. Product Overview Overview of the product Letters and Numbers
8. Product Details Details of the product Letters and Numbers
9. Quantity In Stock Quantity of the products in stock Numbers Only
10. Number Sold Quantity of product sold Numbers Only
11. Price Product price (Leave out dollar sign) Numbers and Decimal Point
12. Weight Product weight (Important for shipping cost) Numbers and Decimal Point
13. Viewable? Would you like the product viewable to customers? "Yes" or "No"
14. Option Field 1 Option 1 field name (i.e. Colors) Letters and Numbers
15. Option Value 1 Values for option 1 (Seperate with "-"; i.e. Red-Blue-Green) Letters and Numbers
16. Option Field 2 Option 2 field name (i.e. Colors) Letters and Numbers
17. Option Value 2 Values for option 2 (Seperate with "-"; i.e. Red-Blue-Green) Letters and Numbers
18. Option Field 3 Option 3 field name (i.e. Colors) Letters and Numbers
19. Option Value 3 Values for option 3 (Seperate with "-"; i.e. Red-Blue-Green) Letters and Numbers
20. Pay Option 1 Price changes for option 1 (Seperate with "-"; i.e. 1.00-2.00) Letters and Numbers
21. Item SKU# Use this field to assign your own item number instead of above Letters and Numbers
-------------------------------------------------------------------------------------------------------------------

Basically your files will look something like this. Each product on its own line.

1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21

**Suggestion**
Excel files can be converted to csv files and visa versa.

sunshop26/sunshop_manual.txt

Thank you for purchasing SunShop.
Version 2.6 - Released 04-12-02
2001-2002 Turnkey Solutions.

----------------------------------------------
TABLE OF CONTENTS
----------------------------------------------

1. Before You Get Started.
A. MySQL Setup
B. Edit config.php
C. Uploading Your Files

2. Installation
- Step 1 thru 8

3. Administration
A. Registered Users
B. Categories / Subcategories
C. Products
D. Specials / Coupons
E. Transactions
F. Templates
G. Settings
H. Backup

4. Conclusion

----------------------------------------------
1. Before You Get Started
----------------------------------------------
A. Before you attempt to start the installation first make sure you have access to the
MySQL database. Ask your administrator to setup a database entitled "sunshop" or any
other name you may want to give. They should also give you a username and password to
use to access this database. You will need to set the database name, username and
password in the config.php file located in the admin directory.

B. After you collect your database information simply open the config.php file located in
the admin directory. You can use any text editor to make changes to this file. Make sure
all fields are correct and save the file. It is very important that there are no blank lines
following the last "?>" in the file. Simply put the curser after the "?>" and hit the
"Delete" key multiple times to make sure there are no trailing spaces or lines.

C. Login to the server where your files will be hosted and upload all files and folders.
**IMPORTANT** If your secure connection is on another server you will need to place
checkout.php, db_mysql.php and a copy of the config.php with the appropriate settings.

----------------------------------------------
2. Installation
----------------------------------------------
The installation file is located in the admin directory. Upload all of the files located in
the archive onto your server via FTP, edit the config.php file to your settings if you have
not already done so, then point your browser to the location of the admin directory on your
server and call up the file install.php. (i.e. www.drizware.com/sunshop/admin/install.php)

A. Step 1 cofirm the installation. You will need to read the license agreement and agree
in order to continue.

B. Step 2 will make sure you have the appropriate settings in the config.php file and it
will make sure it exists.

C. Step 3 will attempt to connect to the database using the config.php file. If it cannot
connect you will receive an error. If the connection is successful and the database given
does not exist it will try to create it. Otherwise, if the database already exists you will be
prompted to override the database. If this is the first installation attempt I suggest you
override the old database to ensure a clean install. You may not have access to override
the database in which case just continue without overriding.

D. Step 4 will attempt to setup the tables within the database. If errors are reported make
sure the tables do not already exist.

E. Step 5 will populate the tables for initial run of script.

F. Step 6 will collect all the general setting for proper script operation. Please make sure
all settings are correct before continuing.

G. Step 7 will make sure all settings are inputted successfully and collect the information
for the administrator setup. You will need to enter you license number at this point. It is
very important for verification purposes.

H. Step 8 is the final step. If you reach step 8 you are all done. Make sure you delete
install.php before you continue.

----------------------------------------------
3. Administration
----------------------------------------------

A. "Registered Users" - From here you can view, edit and delete registered users. You
can also email all users in the database at the same time using the "Email Users" function.

B. "Categories / Subcategories" - From here you can view, edit and add item categories
and subcategories to the database. When you delete categories and sub categories, be
aware that all items within hem will be erased.

C. "Products" - From here products can be viewed, edited and added. When viewing items you
can limit the number of items shown by selecting a specific category, or you can do a
search for items containing your search in the title. For importing items from a csv please
read the import.txt file. When exporting products you MUST allow php to write to the backup
directory by setting the chmod to "777".

D. "Specials / Coupons" - From here you can view, edit and add specials and coupons. When
adding a special, the description is not necessary but you may want to add something to
explain the sale. If the item you would like to run a special on is not listed it probably
already has a special associated with it. Coupons are case sensative so be sure to add them
as you would want your customers to input them.

E. "Transactions" - From here you can view all transactions and change their status. You
can also print transactions after the orders have been filled to keep for your own records.
It is a good idea to leave them up for a few weeks after they have been filled so that the
customer can view the status of their order when needed.

F. "Templates" - The templates are used throughout the site in different areas;
"checkoutno" is shown when a user who is not logged views their cart; "checkout" is
shown when a user who is logged in views their cart; "regusers" is shown when a non
logged in user, or a non user tries to view their account; "signup" is shown at the bottom
of the signup page; "shipmethod" is shown when ups real-time shipping calculating is
turned on; "shipaddressok" is shown when UPS real-time shipping calculating is not on.

G. "General Settings" - This is the main settings area that runs the whole cart. Every
setting in this is very important and you will be taken through each one.

"Shop Title" - This is the name of your shopping cart.

"Home Title" - This is the name of your main site people will return to when they are
done buying your products.

"Shop URL" - The URL of you shopping cart.

"Home URL" - The URL of your main site.

"Secure URL" - This part of the setup is very important. When you customers go to fill
out their credit card information, information will need to be passed through a secure
connection. The file checkout.php will need to be stored in the directory that this address
points to. Secure connections always start with the "https://" (notice the "s" after http) &
(make sure to add final "/"). If your secure connection is on a different server, you will
need to place checkout.php as well as a copy of db_mysql.php and config.php with the
appropriate changes made to it. You will also need to edit the first line of checkout.php to
reflect the location of the config.php file.

"Company Info" - The Company information area is self-explanatory. Make sure you fill
in all areas completely and accurately. The application runs fine as long as all fields are
supplied. You can choose to leave the phone number field empty.

"Shipping Settings" - If you would like your shipping costs to be automatically calculated
I recommend that you use the UPS function. If you select "Yes" to UPS all other
functions must be turned off, and vice versa for all other functions. The shipping table
calculates shipping cost based on your input and the fixed shipping rate uses a fixed
shipping cost per item, per pound or per order.

"Payment Options" - Here you must select the payment options you wish to accept.
"Tax Rate" - Select the tax rate for your state. People outside your state will not be
charged tax.

"View Stock Setting" - Select whether or not you want your inventory to be viewed by the
public when they select an item. You can also set whether or not items can be added to the
cart if the item quantity in stock is at 0.

"Shop Design" - These are also very important settings. Each one is explained
below.

Item Order - Select how you would like you products to be ordered.

Product Display - You may select whether you want items to be listed or if you want
to display product images.

Intro - Here you can choose whether you would like to display an intro message or
display the bestsellers.

CSS - The CSS is used to make all fonts and settings within the shopping cart similair
You can adjust these colors and settings in any way you choose. For a complete list of
values visit: http://www.drizware.com/.

Header - The header is the HTML code placed on every page. Be sure to leave all
leading "/" before all quotation marks. You may also choose to define a file for this.

Footer - The footer is displayed at the bottom of every page. You probably want
to leave this as it is. As well, be sure to leave all leading / before all quotation
marks. You may also choose to define a file for this.

Path To Product Pictures - This is the directory you will be storing your product
pictures. Be sure to set this correctly.

Image Settings: Here you will need to define the location of the images needed for the
shop. Defaults are packaged with sunshop and others are available via the client login.
You will also need to define the height and width for regular and thumbnail images.

Table Settings - Set these values to the 6 digit alphanumeric values of your
choice. For a complete list of values visit: http://www.drizware.com/ or you
can use actual colors like "red" or "blue".

H. "Backup" - Use this feature to create a sql file from the current database. Once
this ".sql" file is created you can import it later by running the sql commands
within the file. You must make sure that php has the ability to write to the backup
directory otherwise this feature will not work.

sunshop26/upgrade.txt

Thank you for purchasing SunShop.
Update Version 2.6 - Released 04-12-02
2001-2002 Turnkey Solutions.

To upgrade the from version 2.5 to 2.6 first run the file upgrade.php in the
main directory then simply replace the files on your server with the files
in this full version package. *IMPORTANT* You can leave your config.php
on your server intact as that information will not change. If you made
alterations to any of the older files you may want to back them up to you
local hard drive before doing so.

If you need to upgrade from version 2.4 download that package first and only
upload and run the upgrade.php script from that version. After you have done
that follow the steps above.

*PLEASE NOTE* - If you or we made any modifications to your script for
implementing your merchant account or for any other reason, please
talk to us before upgrading.

*Release Notes*
Below you will find a list of changes implemented in version 2.6.
Please remember this is a minor release. The next major release will
be soon.

1. There was an issue with the cookies on NT machines. That should be
fixed in this release.

2. All PHP tags have been changed to long tags.

3. The handling charge issue has been resolved where it displays only
the handling charge as the shipping price in some cases.

4. After signup then login you no longer get a error page.

5. Backslases have been removed from the item titles display in the admin
area.

6. Countries and states have been all moved into one location called
state-country.php located in the admin directory. Change this file as
you wish.

7. Company name field has been enlarged.

8. Fixed a minor security issue.

Files

wtn_release.nfo
sunshop26/checkout.php
sunshop26/global.php
sunshop26/import.txt
sunshop26/index.php
sunshop26/shipping.php
sunshop26/software_license.txt
sunshop26/sunshop_manual.txt
sunshop26/upgrade.php
sunshop26/upgrade.txt
sunshop26/wtn_release.nfo
sunshop26/admin/admin.php
sunshop26/admin/adminglobal.php
sunshop26/admin/config.php
sunshop26/admin/db_mysql.php
sunshop26/admin/index.php
sunshop26/admin/install.php
sunshop26/admin/login.php
sunshop26/admin/menu.php
sunshop26/admin/state-country.php
sunshop26/admin/backup/export.php
sunshop26/admin/images/disk_small.gif
sunshop26/admin/images/email_small.gif
sunshop26/admin/images/gear_small.gif
sunshop26/admin/images/house_small.gif
sunshop26/admin/images/info_dot_small.gif
sunshop26/admin/images/pallette_small.gif
sunshop26/admin/images/people_small.gif
sunshop26/admin/images/people_small2.gif
sunshop26/admin/images/pie_chart_small.gif
sunshop26/admin/images/star_small.gif
sunshop26/images/addtocart.gif
sunshop26/images/category.gif
sunshop26/images/catopen.gif
sunshop26/images/create.gif
sunshop26/images/cvv2.gif
sunshop26/images/go.gif
sunshop26/images/help.gif
sunshop26/images/login.gif
sunshop26/images/logo.gif
sunshop26/images/next.gif
sunshop26/images/options.gif
sunshop26/images/previous.gif
sunshop26/images/product.gif
sunshop26/images/quantity.gif
sunshop26/images/secure.gif
sunshop26/images/shopmore.gif
sunshop26/images/sub.gif
sunshop26/images/sunshop.gif
sunshop26/images/tellafriend.gif
sunshop26/images/tocheckout.gif
sunshop26/images/turnkeysolutions.gif
sunshop26/images/unitprice.gif
sunshop26/images/updatecart.gif
sunshop26/images/viewaccount.gif
sunshop26/images/viewcart.gif

Price: $0.00

• Tell a Friend
• Add Product Review