Shopping Cart Module

Web Developer, Jon Holmquist, has years of experience in programming and database design. He has applied his experience to create a comprehensive suite of Shopping Cart programs for developers to use in their own projects. It consists of an "online store" front-end: web applications that can be integrated into a new or existing website to allow shoppers to select and purchase products. It also provides back-end, secure, database management tools, including data entry and search tools.

This suite of website pages streamlines the online buying process by allowing users to access content data with dynamic pages that display product lines by category. Users can then "drill down" from the category detail to the product list and finally to the product detail to see all of the product options. From the product detail level the user chooses options to add to their shopping cart. After the shopping cart is complete, the user "checks out" by logging in to an existing account or signing up for a new one. They see the order totals on the order payment page, choose their payment method and submit their order.

Some of the most common Shopping Cart database tables includes:

• Affiliates - defines affiliate companies with which you trade business referrals
• Accounts - defines customer information
• Contacts - stores incoming messages from Contact Us page
• Product Categories - Grouping for products display
• Products - defines items, services, physical description, cost - high level
• Brands - defines store brands
• Product Attributes - versions,model, size,colors, style
• Product Options - various choices for attributes - e.g.large, medium, small
• Product Addon - additional purchasable items not necessary related to product
• Product Discounts - defines price discount percentage, min, max ranges
• Orders - relates account, shipments, invoices
• Orders Lines- relates line items to orders
• Payment Methods - defines payment types, relates to Payments table
• Product Taxes - defines various tax rules
• Invoices - defines invoice, relates to order table
• Invoice Lines - invoice line items - relates to invoice table
• Shipping Methods - define shipping types
• Shipping Notes - text messages related to shipping rules
• Shipping Rates - defines the various shipping rates
• Store Info - general store information
• Gift Certificates - defines gift certificates and coupons
• Certificate Redemptions - tracks the redemption of certificates and coupons
• Page Text - used for indexing and searching web pages

Please contact us for questions or more information about our Shopping Cart tools.