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 !!

[ozzy47]

TBH, I have never seen Dave charge anything. I see him download all new released mods, and checks them on his own.

He will also tell you exactly where the issue lies, and how to correct it if necessary.

[Dave]

Oh stop it guys.
I enjoy looking for security mistakes in plugins in my free time.

Also this is more of a reason to use this plugin instead of the old outdated MicroCART.

[ozzy47]

Believe me Dave, if half the users here knew what you did, they would appreciate it also.

[HM666]

@Nick it looks great! Thanks for the release!

[HM666]

Found a problem in the installation files: you have this:

ecommerce/pdf
ecommerce/fonts
ecommerce/images

For the CHMOD'S when its actually this:

ecommerce/pdf
ecommerce/pdf/fonts
ecommerce/pdf/images

Have a problem. Cannot change anything past the original options.

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT * FROM ecommerce_categories WHERE parentid=0 GROUP BY id, name, displayorder ORDER BY displayorder ASC, name ASC;

MySQL Error   : Table 'lenmkais_vbulletin4.ecommerce_categories' doesn't exist
Error Number  : 1146
Request Date  : Thursday, January 8th 2015 @ 06:28:43 PM
Error Date    : Thursday, January 8th 2015 @ 06:28:43 PM
Script        : http://lenmkaiser.com/xxxx/ecommerce_admin.php?do=categories
Referrer      : http://lenmkaiser.com/xxxx/index.php?do=savenavprefs&nojs=0&navprefs=vbulletin_0,vbulletin_1,vbulletin_2,vbulletin_3,vbulletin_4,vbulletin_5,vbulletin_6,vbulletin_7,vbulletin_8,vbulletin_9,vbulletin_10,vbulletin_11,vbulletin_12,vbulletin_13,vbulletin_14,vbulletin_15,vbulletin_16,vbulletin_17,vbulletin_18,vbulletin_19,vbulletin_20,vbulletin_21,vbulletin_22,vbulletin_23,vbulletin_24,vbulletin_25,vbulletin_26,vbulletin_27,vbulletin_28,vbulletin_29,vbulletin_30,vbulletin_31,vbulletin_32,vbulletin_33,vbulletin_34,microsupport_0,ecommerce_0,vbcms_0,reviews_0,vbprojecttools_0,_0,postthanks_0,rbs_0
IP Address    : xxx.xxx.xxx.xxx
Username      : LenKaiser
Classname     : vB_Database
MySQL Version : 5.5.40-cll

[TheAdminMarket]

Originally Posted by HM666

Have a problem. Cannot change anything past the original options.

[CODE]Database error in vBulletin 4.2.2:

Where did you got this message? Trying to import the product or what?

[TheAdminMarket]

As I seen is from ecommerce_admin.php file. I have updated my installation and trying the Categories menu and it works fine.

[Barbaro]

also problems

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT * FROM ecommerce_categories WHERE parentid=0 GROUP BY id, name, displayorder ORDER BY displayorder ASC, name ASC;

MySQL Error   : Table 'blogerxd_blog.ecommerce_categories' doesn't exist
Error Number  : 1146
Request Date  : Thursday, January 8th 2015 @ 08:33:40 PM
Error Date    : Thursday, January 8th 2015 @ 08:33:40 PM
Script        : http://blogerxd.com/admincp/ecommerce_admin.php?do=categories
Referrer      : http://blogerxd.com/admincp/index.php?do=nav
IP Address    : xxxxxxxxx
Username      : xxxxxxxxx
Classname     : vB_Database
MySQL Version : 5.5.40-cll

[HM666]

Originally Posted by NickTheGreek

Where did you got this message? Trying to import the product or what?

As I said when I click on the Categories link in the AdminCP. The only links that work in the AdminCP is General Options, Payment Gateways & Email Options & Templates. I've imported the product with no problem. Apparently the script is calling a database table that is not there its the same in every link that does not work. It is putting the wrong prefix in front of the table automatically. I do not have any prefix for my database tables.

Originally Posted by NickTheGreek

As I seen is from ecommerce_admin.php file. I have updated my installation and trying the Categories menu and it works fine.

I downloaded the package again and overwrote that file and it still does not work.

Could this be because of the issues that Dave reported earlier? I'm running PHP 5.4.26

[Barbaro]

Originally Posted by HM666

As I said when I click on the Categories link in the AdminCP. The only links that work in the AdminCP is General Options, Payment Gateways & Email Options & Templates. I've imported the product with no problem. Apparently the script is calling a database table that is not there its the same in every link that does not work. It is putting the wrong prefix in front of the table automatically. I do not have any prefix for my database tables.



I downloaded the package again and overwrote that file and it still does not work.

Could this be because of the issues that Dave reported earlier? I'm running PHP 5.4.26

I spend equal