MySQL Backend to Quikstore

What is it: The Quikstore Backend automatically stores customer and order details in a MySQL Database and allows the store owner to view invoices and various reports through a user friendly web based interface.

Why was it developed: I have been using Quikstore for over 4 years and have developed many web sites using its diverse features, but one feature always missing was a Backend Tool for the store owner to view their orders and see trends. After several of my clients requested this tool I finally developed it with the help of Rick, from Quikstore.

Features:

• Integrates with existing Quikstore installation.
• Automatically imports customer and invoice data into MySQL database during Quikstore's checkout process.
• Can import existing orders into MySQL database (Note: existing orders must be in Quikstore's default log format)
• Web Based Interface
  • Password protected
  • User friendly
  • Designed for Store Owners to use with little computer knowledge
• View Daily Orders
• List Orders between certain dates
• View or print Invoices
• View Monthly Totals
  • Gross Sales
  • Net Sales
  • Sales tax
  • Top selling products
  • etc.
• View Top Selling Products
  • Filter by date range
• View Top Selling Customers
  • Filter by state
  • Filter by date range
  • Filter by dollar amount or quantity sold
• View all orders placed by a customer
• View email addresses
  • easily send email to all your customers using Outlook or another email program
• View customers broken down by State
• See store trends
• Keep Track of Shipped Items (option)
  • Mark Invoice when items shipped
  • Shipped Date
  • List orders marked as shipped or not shipped
• Output Comma Delimited Files (CSV) for input into other programs (Excel, accounting software) (option)
• plus more...

View Screen Shots

Requirements: Quikstore, PERL Modules DBD::mysql and DBI, PHP and one MySQL database.

Why was it developed: My Quikstore clients where looking to increase their search engine ranking for all their inner store pages. By driving the shopping cart with a MySQL database and PHP, each product page has its own search engine friendly html page (including Page Title and Meta Tags) , even though it is really dynamically generated from a database.

• Product ID, Name, Description, Size, Weight, etc
• Add, Edit or Delete Products and Categories
• Includes Image Uploader
  • Frontend Automatically creates a product thumbnail image for you!
• Mark products as In Stock, Sold Out or Hide from web site.
• Category pages automatically created with thumbnail images and opening category paragraph.
  • X by X grid of thumbnails
  • Previous and next pages
• Toolbar automatically created from categories placed in MySQL database
• Optimize pages for search engines
  • Every product has its own .htm page driven from MySQL database
  • Every Product page has its own HTML Title and Meta Tags
  • Every Category page has its own HTML Title and Meta Tags
• Froogle Feed Generator (option)
• Print Entire Product Catalog
• Password protected for security
• Uses PHP and ModRewrite
• plus much more....

See http://www.lewiestanning.com for an example of a site I have done using this tool.

View Screen Shots

Requirements: Quikstore, PERL Modules DBD::mysql and DBI, PHP and one MySQL database.

The module allows store owners to offer a robust, professional Gift Registry feature with their Quikstore shopping cart.

Customers can create a free Gift Registry account for weddings, birthdays, etc. Registry owner adds pertinent registry information to their account, including event information and adds desired products (including quantity) to their registry using a Quikstore shopping cart. They can return at any time to view the status of their registry and/or modify their registry.

Customers can search for an existing Gift Registry by last name or by state. Once selected, all registry products including their desired quantity's are displayed just alike a normal Quikstore shopping cart. Customers can choose to have the shipping address of the Registry Owner automatically filled in during the checkout process. Registry inventory is updated accordingly after checkout.

Module includes Admin Area for store owner to maintain registry accounts.

View Screen Shots

Requirements: Quikstore, PERL Modules DBD::mysql and DBI, PHP and one MySQL database. This module relies heavily on session-cookies.

The module allows someone to order a Gift Card for any dollar amount. The Gift Card number is instantly included in the Order Receipt email. After the card is ordered, the purchaser is presented with a web page to Email the Gift Card to someone with a personalized message.

A Gift Card can be applied to any online order and any remaining balance stays on the card for a future order. Gift Cards are redeemed on the View Cart Page and the Order Total is instantly adjusted accordingly. If the final Order Total is zero, any credit card module is bypassed.

A Gift Card Admin area is included in case the store owner needs to adjust the Gift Card balance (e.g. if an item is returned)

Requirements: Quikstore, PERL Modules DBD::mysql and DBI, PHP and one MySQL database

View Screen Shots

The module goes in the Quikstore plug-ins directory. The module also requires quite a bit of modification to the existing Quikstore Shopping Cart files (quikstore.cgi, view_cart.html, receipt_page.html, Customer_email.html). If you are extremely familiar with perl and making modifications to the quikstore.cgi file you can probably install it yourself, but I highly recommend letting me install the module for you.