| Order Control |
| Current Orders |
|
View all of your current unfilled / unfinished orders here. You may manage all of
the notes, shipping, and other details of an order by approving orders step by step.
|
| Archive Orders |
|
If you want to see any previously filled orders, we have them stored here for referencing by
customer receipts (no credit card data) or by owners & customer service.
|
| Discount Club |
|
Manage Discount Club Memberships & associated purchases & credits with this utility.
|
| Coupon Codes Table |
|
Edit coupon codes here.
|
| Ordering Grids & more |
|
Ordering Grids are designed specifically to change data only. If you change a price,
it will not be reflected in the final total of the order. Shipping Grids are set up
to allow quick price changes associated with the shipping classes assigned.
Download JAVA 1_3_1 (Java 2 v.1_3_1) needed for MSIE 6.0 browser.
|
| Reporting |
| Daily Cart Stats |
|
Search the cart statistics over a time period based on your time and date selections.
This reporting runs off a secondary database which is not backed up.
Data is automatically deleted that is over 70 days old.
|
| Current Day Stats |
|
This will show your current number of unique visitors, page views, referral pages & cart stats.
|
| Today's UniqueUser Cart Stats |
|
This will show you the Total Hit count as it relates to number of users with cart items and hitting the purchase page.
|
| Search Stats on Item Basis |
|
|
| User Accounts |
| Admin Accounts |
|
Admin Accounts are controlled by the designated "super-user" account for this cart.
|
| Error Control |
| Error List [Delete All Errors] |
This is an error control feature which shows you on a current basis if any errors have occurred on the
site and this allows either yourself or us to troubleshoot the errors and explain what is occurring in the
site if customers are experiencing problems.
|
| Brand Control |
| CSV Upload & Export Table/Columns |
|
Manage Brand data online via CSV file. You may upload any number of columns to update the table (LIVE)
All data in Related Items or Specials must be pipe "|" delimited for those columns.
Be sure to have all columns listed in order as they show up in the corresponding page.
|
| Brands Add/Edit/Delete |
Edit specific Brand data & select main image via this web-form utility.
|
| Brands Grid: w/Call or Email for Price Quote |
Edit specific Brand data online in the grid format for quick updates.
This also allows you to type "Phone" or "Email" for the price quote functionality.
Download JAVA 1_3_1 (Java 2 v.1_3_1) needed for MSIE 6.0 browser.
|
| Special Items |
|
Manage all Brand SPECIALS through the web-based control for associating
specific items with your selected Brand.
|
| Related Items |
|
Manage all Brand RELATED ITEMS through the web-based control for associating
specific items with your selected Brand.
|
| Category Control |
| CSV Upload & Export Table/Columns |
|
Manage Category data online via CSV file. You may upload any number of columns to update the table (LIVE)
All data in Related Items or Specials must be pipe "|" delimited for those columns.
Be sure to have all columns listed in order as they show up in the corresponding page.
|
| Category Add/Edit/Delete |
|
Add, Edit, Delete specific category information, including pictures with this utility.
|
| Category Grid |
Edit specific Category data online for quick updates via this utility.
Download JAVA 1_3_1 (Java 2 v.1_3_1) needed for MSIE 6.0 browser.
|
| Special Items |
|
Manage all Category SPECIALS through the web-based control for associating
specific items with your selected category.
|
| Related Items |
|
Manage all Category RELATED ITEMS through the web-based control for associating
specific items with your selected category.
|
| Product Control |
| Add/Edit Product(s) |
|
Edit products in a web based form, which allows you to select the Brand, Category, create
size, color, and & misc attributes which can be tied to prices & inventory. Allows you to
also upload HTML includes, images, and create your meta keywords & descriptions. This is a
very robust utility.
|
| Delete Product(s) |
|
Use this tool to list item numbers, separated by commas, to delete items in your databas.
|
| Related Items Editor - Unassigned List |
|
This allows you to search and assign specific products as Related Items to the current product
you are on. Once you associate this relationship, you may also edit the data & prices of those
selected Related Items.
|
| Product Grid |
|
Used in conjunction with all Related Items and Specials selection interfaces for editting prices
and respective product data.
If you need to actually edit a product online and just want to search for it in the
Product Grid, you can use this utility to find and edit a product to quickly update the database.
|
| Item Descriptions Upload & Export Table/Columns |
|
This allows you to UPLOAD and EXPORT any data in the PRODUCTS table. You may select the columns
to update with a CSV file by uploading to the Products_Test table. If successful, you may COPY to production
from Products_Test. Related Items must be uploaded with pipes "|" separating Stock Numbers.
Do not upload: blank fields, commas, or single quotes.
|
| Item Selectors (Color/Sizes/Prices/Inventory) Upload & Export Table/Columns |
|
This allows you to UPLOAD and EXPORT any data in the PRODUCTS_ATTRIBS table (first through Products_Attribs_Test).
You may export your products to CSV Excel file by just clicking on the EXPORT ALL button in this utility.
|
| Manage Specials:
Daily,
Weekly,
Monthly |
|
This section allows you to post a special for by specified date, by week number, and by month.
You will want to post these LinkBlks from your home page.
|
| Product / Brands / Categories Page Creator / Index |
|
This site index tool creates pages for Product, Brands, & Categories to allow the search engines to index your cart.
Pages are created in the /Products,/Brands, & /Categories directories. Search engines will spider the
Brands & Categories listed from the homepage, while Products will be spidered from any
product search / related output to their respective individual pages.
|
| HTML Tracker & HTML File Creator |
|
Use the [HTML Tracker] to update the HTTP_URL column in the database, which goes through the
/TEXT/ folder matching up Item Numbers with [ITEM_NO].htm in the directory. When this happens
the file name associated with the item number will be added into the column in the database.
FOR HTML FILE CREATOR - You must first upload your [ItemsHTML.CSV] file to your data directory.
The COLUMNS SHOULD BE AS SUCH: ITEM_NO,DESCRIPTION
NO single quotes ' are allowed, replace with &lsquot;
NO commas , are allowed, replace with ,
Then run [HTML Creator utility].
|
| Create Products Tables Backup |
|
This utility will back up your products to a back-up set of tables, which will allow you to
make sure you can back-out of any changes that you make to live data in the product editors.
|
| Restore Products Tables Backup |
|
This utility will restore the latest copy of the PRODUCTS table which was overwritten
by a "Products_Test" table copy to production. If you screw up an import from TEST,
run this utility to go back to your most recent version of PRODUCTS.
|
| Product Images & Files |
| Image Tracker:
Large /
Small |
|
This is the critical part of making images show up in the search results.
If either the Large or Small Image Tracker is not run after a product table
OVERWRITE, you will see that the images will not show up. If images are
uploaded, this utility must be run in order to update the database.
|
| Orphaned Images:
Large /
Small |
|
When you have a lot of images and you need to make sure the name of the file matched
the product item number, this tool will show you which files are "orphaned" or could not
be matched up to a product number.
|
| Root File Access (Owner Access Only) |
|
This allows the owner of the site (currently sfazekas) to have web-based, root access
to the server for viewing and uploading files. This will trigger a 404 error response
if the logged in user is not the owner.
|
| Website /GFX/ Dir. Uploads |
|
This directory is reserved for website template graphics and misc. graphics not used in
small pics or large pics directories.
|
| /SMPICS/ Dir. Uploads |
|
This directory is for uploading of SMALL images, which are used in showing search SUMMARY
output product images in search results.
|
| /LGPICS/ Dir. Uploads |
|
This directory is for uploading of LARGE images, which are used in showing individual
product images in full-detail pages.
|
| Content Management |
| Content Tool - Arrows |
|
Content Editting tool which allows you to Add/Delete content linked from
arrows on the front page and corresponding content pages.
|