Major Additions - eCommerce for vB4.2.2+

Since 2006 I was serving community members with my Free Mods
But as this site will starts operating by the company,
I'm no willing to support them

** File Removed **


eCommerce
The complete eCommerce solution for vBulletin 4.2.2+
Supports Downloadable Products, Physical Products, Subscriptions, Services
Fully compatible with EU directive for collecting EU VAT from EU Citizens

I'm offering my hard work for free, without even a single copyright line in footer, expecting that some of you will appreciate the time that I spent for coding it and they will donate something.

Version 2.1.2 is the Commercial version which among other great features it has:

• No Copyright link
• Supports Donations
• Site Reviews
• Contact Us per product
• .......and many more features that really I don't remember them.

eCommerce is a fully featured Shopping Cart for vBulletin 4.x, with support for Downloadable & Pysical Products, Subscriptions and Services, without missing any feature even from commercial scripts. Installation is very easy, you just need sometime for the initial configuration. Last but not least eCommerce is currently the only cart available for vB4 which supports EU VAT to fullfill with EU directive for online sales (valid since Jan 1st, 2015). Going one step ahead it auto validates Business EU VAT id to exclude them of paying VAT.

*** IMPORTANT NOTICE ***

Since version 1.8.4 there is also a PRO version available at my site. Current Commercial version: 2.1.1


DEMO: http://www.teriakis.com/vb423/cart.php
Demo Accounts:
demouser1 / demopass1
demouser2 / demopass2
demouser3 / demopass3
Please note that Taxes and Shipping are not enabled in the demo. You can order the demo product with 0 price to be able to check the Client area.

*** ATTENTION ***

1. Report any Bug only on the link above. Reporting Bugs here will be ignored. This thread should be ONLY for questions. Thank you.
2. eCommerce is an update of microCART, with fixed all bugs that I found, many design issues corrected, and some new features added (the most important is the support for EU VAT). I decided to release a new product with different name as microCART had 2 versions (Lite and Pro) and I wanted to avoid system mess. Please note that I've the rights to release this addon. Actually the original code was mine.

1.- Highlights

• Supports Downloadable products
• Supports Physical products too!!
• Supports Subscriptions (Even Reccuring)
• Supports Services
• Ability to upgrade usergroup per product
• Unlimited depth levels of categories
• Unlimited Products
• Supports Renewals
• Ability to Add Orders manually
• Accept payments with PayPal, 2CO & ccBill (Credits for ccBill to kastak)
• Supports AddOns
• Support Product Option to Increase/Decrease the price
• Unlimited Screenshoots per product
• Unlimited Files per product, so the customers can download previous versions
• Unlimited Agreements
• Customers (and only those who have bought that product) can rate and review it.
• Admin can turn On/Off the Reviews per product
• Uses HTML Editor.
• Unlimited Tax levels.
• Shipping Zones with unlimited shipping choices per zone.
• Supports Delivery locations (unlimited depth, eg Country, State, Area with different setup for Tax and Shipping per category.
• Collect Customer details at Checkout.
• Auto Tax calculation.
• Auto Shipping calculation.
• Supports PDF Invoice creation.
• Since version 1.5.0 supports Donations with many featured
• New in ver.1.6.0: Donation Form Generator for auto include in Forum sidebar or get the code and add it to any HTML page even in different website.
  

2.- Installation

• Download and unzip eCommerce.zip file
• Upload all the files in your site keeping the same structure. eg cart.php must be on the same level as your forum.php
• CMOD 777 the directories:
  • ecommerce/photos
  • ecommerce/photos/categories
  • ecommerce/photos/medium
  • ecommerce/photos/thumbs
  • ecommerce/photos/tmp
  • ecommerce/pdf
  • ecommerce/pdf/fonts
  • ecommerce/pdf/images
• Login to your admincp and import product-microcart.xml

3.- Configuration

• First of all you need to setup eCommerce General Options. The most important option is to set the path to the directory where you'll store the files. For security reasons you must create a directory over the public area. Then write the full path in the options. Don't forget the trailing slash at the end. Example:
  • /home/username/downloads/
• Setup Usergroup permissions. Available options are:
  • Can access the store
  • Can order
  • Can Moderate (for furthure use)
• Setup Categories and Subcategories for your store.
• Setup your Agreements (at least one)
• Setup Taxes. Please note that since Jan 1st, 2015, you must collect EU VAT from your EU Clients even if your store is locating outside EU. If you follow this directive or not is not my problem.
• Setup Locations and assign them Tax and Shipping (but offcourse you can let them to None).
• Start adding products but from AddOns and Services. It will helps you to save time, as when at a later time you add a main product, you can choose the addons.

4.- Product Options (Configurations)

eCommerce supports configurable options. Not just simple text choices, but options that can increase/decrease the total price. That's why you need to pay extra attention on entering these options to avoid pricing mess.

First of all, you can find these options as "Extra Options" on the droplist on the right of each product (AdminCP). By choosing it you'll get a list of all available configurable options for the specific product. You can Edit and Delete it, or you can change the display order. Click "New Extra Option" to add one.

There is no need for explanation of title. Write there anything that you want. Examples of configuration options are: Color, Size, Ram, Hard disk etc. So let's write Size. In the box below you must add all the available options keeping the format:
Amount|Name

Examples:

• 0|Normal : This option dosen't changes the product's price and it will appears as: Normal
• 15.30|Large : This option increases the price by 15.30 and it will appears as: Large (+$15.30) ... The currency symbol is the one that you've setup. DON'T NEED TO ENTER CURRENCY SYMBOL HERE
• -7.50|Mini : This option decreases the price by 7.50 and it will appears as: Mini (-$7.50). ONCE MORE: DONT ADD CURRENCY SYMBOL.

5.- Product Terminology

• Price: Is the normal price that you're selling a product (eg 49.95)
• Discount: Is the amount that you're giving as discount. eg if you place 4.95 here the price will appear as $49.95 $45.00
• AddOns. Are products that someone can order in the same form (eg Installation, Brand Free etc).

6.- Understanding Shipping Zones

To understand Shipping fields (Base weight, Base fare, Extra weight, Extra fare), you must know how the companies (at least the most of them) are working. They're saying: Till 3 kilos the rate is $15. More than 3 kilos you must add $3 per 500gr (1/2 kilos). In this example you must setup:

1. Base weight 3000 (in grammars) or 3 (in kilos)
2. Base fare 15.00
3. Extra weight 500 (in grammars) or 0.5 (in kilos)
4. Extra fare 3.00
5. Please note to use the same as the definied in the general option weight unit. Setting in options kgr and here grammars is the best way to mess your shop.

7.- SEO Friendly URLs

eCommerce supports htaccess type SEO friendly URLs. The types are:

• store/1/my-category/ For Categories
• product/1/my-product/ For Products

If you want to enable them:

1. Upload .htaccess file to your forum directory
2. If you already have a .htaccess file in your installation add the 2 lines belon on it.
3. Enable SEO URLs in admincp-> eCommerce-> General Options

RewriteRule ^store/([^/]*)/ ./cart.php?do=main&catid=$1 [L,NC]
RewriteRule ^product/([^/]*)/ ./cart.php?do=viewproduct&productid=$1 [L,NC]

*** IMPORTANT ***

• You can change the words store and product with your own but in this case you must change the words in the product options.
• If you've the default .htaccess file that comes with vBulletin you need to add these 2 lines at the top, just after the line: RewriteEngine on

8.- Friedly notes

• Please let my copyright link in place. Thank you.

I wish you a huge amount of sales !!

[Johnny G]

Originally Posted by NickTheGreek

I'll see what I can add in the next major release but I'm not promising anything. I don't expect to have more than 15 installations, not because the mod is not good, but because the vBulletin market is so small in nowadays. Even for other very good addons and not so specific in use like this, have no more than 20-25 installations. That said, I'll focus only to add features mainly for my own use, and secondary common for all uses.

I had no idea the audience would be so small! Sorry dude

[HM666]

Upgrade did not work. I followed the info in THIS post and uploaded the files & when I went to import the product again I got this database error...

Database error in vBulletin 4.2.2:

Invalid SQL:
ALTER TABLE usergroup ADD ecommerce INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error   : Duplicate column name 'ecommerce'
Error Number  : 1060
Request Date  : Saturday, January 10th 2015 @ 12:50:25 AM
Error Date    : Saturday, January 10th 2015 @ 12:50:26 AM
Script        : http://lenmkaiser.com/xxxx/plugin.php?do=productimport
Referrer      : http://lenmkaiser.com/xxxx/plugin.php?do=productadd
IP Address    : xxx.xxx.xxx.xxx
Username      : LenKaiser
Classname     : vB_Database
MySQL Version : 5.5.40-cll

[TheAdminMarket]

Originally Posted by HM666

Upgrade did not work. I followed the info in THIS post and uploaded the files & when I went to import the product again I got this database error...

Database error in vBulletin 4.2.2:

Invalid SQL:
ALTER TABLE usergroup ADD ecommerce INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error   : Duplicate column name 'ecommerce'
Error Number  : 1060
Request Date  : Saturday, January 10th 2015 @ 12:50:25 AM
Error Date    : Saturday, January 10th 2015 @ 12:50:26 AM
Script        : http://lenmkaiser.com/xxxx/plugin.php?do=productimport
Referrer      : http://lenmkaiser.com/xxxx/plugin.php?do=productadd
IP Address    : xxx.xxx.xxx.xxx
Username      : LenKaiser
Classname     : vB_Database
MySQL Version : 5.5.40-cll

Don't know how the field ecommerce left out in your user table while the table prefix was wrong before. Connect with phpMyAdmin and remove the field "ecommerce" from your TABLE_PREFIX.user table. Then import the product.

[HM666]

Hmmmm ok I'll do that later on today, gonna get some shut eye right now.

[TheAdminMarket]

Originally Posted by HM666

Hmmmm ok I'll do that later on today, gonna get some shut eye right now.

1.- Just seen that you're not using table prefix. In my opinion this is not wise.
2.- Check the table usergroup and NOT user.

[ozzy47]

Why would it be "not wise" to use a table prefix? I never have used one on any of my sites, and have never ran into a issue.

[TheAdminMarket]

Originally Posted by ozzy47

Why would it be "not wise" to use a table prefix? I never have used one on any of my sites, and have never ran into a issue.

Is not a common situation, but it's a situation. There is a big I can say amount of coders who, when they're creating tables (eg user), are using:

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`....bla...bla...bla......

while professional coders are using:

CREATE TABLE IF NOT EXISTS `user`....bla...bla...bla......

What's the difference. Let's say that I'm following the first way and in the database there is already a table named "user". My code will drops that table and will create mine. So my script will works (because yes, same names, but structure is almost always different).

You, are following the second way. As you code will see that there is already a table with name "user" will bypass the creation of your code. So your script will not works.

This was very common problem some 10 years ago when Hosting providers were giving just one database in their hosting plans. Now, they're giving many, so most webmasters are using a database per script. If not, they're in risk at some day to try to install a script in the same database having tables with same names.

That's was the reason for exististin of TABLE_PREFIX.

[ozzy47]

That sounds logical. Thanks for the explanation.

[RichieBoy67]

Hey Christos! This is outstanding! I am going to use this at some point definitely! Really great work!

[HM666]

Originally Posted by NickTheGreek

1.- Just seen that you're not using table prefix. In my opinion this is not wise.
2.- Check the table usergroup and NOT user.

Ok that is where I'll check as for the table prefix since this is the only version of vBulletin that I'll be running on this site in this database its not a problem IMO. I had initially installed it as a dev site but have decided to do the site in vBulletin instead of straight web design as I have it now.