The Arcive of Official vBulletin Modifications Site.

microCART: Shopping System for vB4 · **Released**: 01-06-2011

microCART 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.

Edit: Please note - Currently this mod is only compatible with vBulletin 4.1.9 and below, if your using vBulletin 4.1.10 then the modifications current version released here (1.1.4) is not suggested for use. - TheLastSuperman

1.- Highlights

Supports Downloadable products
Since version 1.0.3 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
PayPal & 2CO payments
Since version 1.0.4 support payments with ccBill (Credits to kastak)
Supports AddOns
Support Special Deals
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.
Since version 1.0.5 support multiple Tax levels.
Since version 1.0.5 support Shipping Zones with unlimited shipping choices per zone.
Since version 1.0.5 supports Delivery locations (unlimited depth, eg Country, State, Area with different setup for Tax and Shipping per category.
Since version 1.0.5 customer must enter his details to finalize the order.
NEW!! Since version 1.0.6 supports Auto Tax calculation.
NEW!! Since version 1.0.6 supports Auto Shipping calculation.
NEW!! Since version 1.0.5 supports Invoice creation.
NEW!! Comming Soon Block.

2.- Installation

Download and unzip microCART.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:
- microcart
- microcart/photos
- microcart/photos/thumbs
- microcart/photos/tmp
- microcart/editor/files
- microcart/editor/flash
- microcart/editor/media
- microcart/editor/photos
- microcart/pdf
- microcart/fonts
- microcart/images
Login to your admincp and import product-microcart.xml

3.- Configuration

First of all you need to setup microCART 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. Please note that, as a way to bypass the limitation of having vB editor in admincp, I've moved the product descriprion, system messages and agreements to fronend. But only those who can moderate can access this area, and only for modifying the text. Nothing more.
Setup Categories and Subcategories for your store.
Setup your Agreements (at least one)
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.
To work properly with HTML editor you need to edit settings.php locating at: microcart/editor/assetmanager/ and set the corrects paths.

4.- Product Options (Configurations)

In version 1.0.3 has been added support for 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
Special (Bundle) price. Currently not in use
AddOns. Are products that someone can order in the same form (eg Installation, Brand Free etc).
Special Bundle. Currently not in use

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:

Base weight 3000 (in grammars) or 3 (in kilos)
Base fare 15.00
Extra weight 500 (in grammars) or 0.5 (in kilos)
Extra fare 3.00
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.- Friedly notes

Please let my copyright link in place. Thank you.
When rating, please remember that you're rating the script and not me as a person. Thank you.
Don't spam this thread with comments about my personality. Comment my work only. Thank you.

8.- Demo

http://www.totally-scripts.com
This is not a demo but shop in action.

9.- Warning

The included HTML Editor is commercial, so you can use it ONLY within microCART directory.

UPGRADING

To upgrade just upload the new files then follow 2.- Installationwith Allow Overwrite set to YES

CHANGE LOG

Added Comming Soon Block
Added view users invoice within admincp
Added usergroup controled discounts
Added stock level control
Added coupon system
Changed the invoice system to work better.
Added forum home side block. (Download the product-microcart_forum_block.xml and Install like a new product)
MICROCART_114_01022011.zip has no affects added to my account
MICROCART_114_240211.zip has a fade in affect on my accounts pages.
added some java for the my accounts page and the product view page. So you dont have to re-fresh the page all the time. Updated: 28/02/2011
Fixed the problem with the euro within the add-on options.

BUG FIX

Fixed error within the admin php file on line 23.
Updated the forum side block ( Please let me know if you are still having problems with this. Updated Date 22nd Fed 2011)
fixed problem with the prices. UPDATED Date 22nd Apr 2011 to upgrade just upload the files as its only the cart.php and microcart/functions.php files that have been updated.
Fixed problem with the add-ons prices. Updated 25th Apr 2011 to upgrade just upload the cart.php file
cart.php updated again to fix the problem with the add-ons when changing the qty within the cart.
Fixed problem with edit invoices in admincp
Fixed a problem with large price formats.
Fixed problem with option prices (11-05-2011)
Updated the files for the new editor not tested Updated 13/06/2011.

Arabic Language File Download Here

Hornstar · #12 01-09-2011, 07:47 AM

This looks very good. Very impressed with how many features this has.

Dadoo · #13 01-09-2011, 08:48 AM

Hi Micheal, it appears product-microcart.xml is missing in your archive..

So, it's not said in your topic, but in fact, we have to download microCart 1.1.1 from this topic, then download your archive (update29122001.zip) and update the product.

Am i right ?

EDIT : I have that error when i try to acces to any link starting by : microcart_admin.php?do=***

Quote:

Parse error: syntax error, unexpected $end in localhost\admincp\microcart_admin.php on line 2218

2218 is the last line of this file..

Exactly same problem than Adem Genc

I tried in local with Wamp and Xamp (differents versions of Apache, PHP and Mysql, same result..)

wh1t3dr3am · #14 01-09-2011, 02:01 PM

Hi Micheal,why i got an error like this?How to fix it ? Thx

Code:

SELECT * FROM microcart_usercoupon WHERE userid=1 AND valid=1;

MySQL Error   : Table 'ogiazic_vbulletin.microcart_usercoupon' doesn't exist

Dadoo · #15 01-09-2011, 04:39 PM

I don't understand....

I've an DB error who said :

PHP Code:


			
Invalid SQL:
INSERT INTO vb411microcart_products
                                           SET categoryid = '1',
                                               name = 'Test product',
                                               type = '1',
                                               status = '1',
                                               code = '',
                                               manufacturer = '',
                                               description = 'Content of test product',
                                               features = 'custom text <span style="font-weight: bold;">bold text</span><span style="font-weight: bold;">Second test</span>
',
                                               price = '130',
                                               discountprice = '10',
                                               specialprice = '20',
                                               renewal = '0',
                                               license = '1',
                                               dlperiod = '365',
                                               demolink = '',
                                               forumlink = 'http://localhost/showthread.php?1-pr%E9sentation-du-dadoo',
                                               bugslink = 'http://localhost/showthread.php?1-pr%E9sentation-du-dadoo',
                                               reviews = '1',
                                               agreement = '0',
                                               frontpage = '1',
                                               flagship = '1',
                                               isbundle = '0',
                                               addons = '',
                                               extras = '0',
                                               promousergroup = '0',
                                               weight = '700',
                                               image = 'admincp0.jpg',
                                                          userstocklevel = '1',
                                                          stocklevel = '0',
                                                          discount_usergroups = '';

MySQL Error   : Unknown column 'userstocklevel' in 'field list'

When i look XML product file, i see :

PHP Code:


			
        CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."microcart_products` (
          `id` int(11) NOT NULL auto_increment,
          `name` varchar(100) NOT NULL,
          `categoryid` int(11) NOT NULL,
          `type` tinyint(1) NOT NULL default '1',
          `status` int(11) NOT NULL default '1',
          `code` varchar(100) NOT NULL,
          `manufacturer` varchar(100) NOT NULL,
          `price` decimal(10,2) NOT NULL default '0.00',
          `discountprice` decimal(10,2) NOT NULL default '0.00',
          `specialprice` decimal(10,2) NOT NULL default '0.00',
          `renewal` decimal(10,2) NOT NULL default '0.00',
          `description` mediumtext NOT NULL,
          `features` mediumtext NOT NULL,
          `forumlink` varchar(50) NOT NULL,
          `demolink` varchar(50) NOT NULL,
          `bugslink` varchar(150) NOT NULL,
          `license` int(11) NOT NULL,
          `dlperiod` int(11) NOT NULL,
          `addons` varchar(255) NOT NULL,
          `extras` int(5) NOT NULL default '0',
          `promousergroup` int(11) NOT NULL,
          `agreement` tinyint(1) NOT NULL default '0',
          `reviews` tinyint(1) NOT NULL default '0',
          `isbundle` tinyint(1) NOT NULL default '0',
          `frontpage` tinyint(1) NOT NULL default '0',
          `flagship` tinyint(1) NOT NULL default '0',
          `image` varchar(30) NOT NULL,
          PRIMARY KEY  (`id`),
          KEY `categoryid` (`categoryid`),
          KEY `name` (`name`)
        ) ENGINE=MyISAM
        ");

It seems followings tables are missing into installation file..

PHP Code:


			
userstocklevel = '1',
stocklevel = '0',
discount_usergroups = '';

micheal332001 · #16 01-09-2011, 05:19 PM

Quote:

Originally Posted by Dadoo

Hi Micheal, it appears product-microcart.xml is missing in your archive..

So, it's not said in your topic, but in fact, we have to download microCart 1.1.1 from this topic, then download your archive (update29122001.zip) and update the product.

Am i right ?

EDIT : I have that error when i try to acces to any link starting by : microcart_admin.php?do=***

2218 is the last line of this file..

Exactly same problem than Adem Genc

I tried in local with Wamp and Xamp (differents versions of Apache, PHP and Mysql, same result..)

I will have a look at the code and XML file to make sure every thing is right.

Quote:

Originally Posted by wh1t3dr3am

Hi Micheal,why i got an error like this?How to fix it ? Thx

Code:

SELECT * FROM microcart_usercoupon WHERE userid=1 AND valid=1;

MySQL Error   : Table 'ogiazic_vbulletin.microcart_usercoupon' doesn't exist

I will look into it

Quote:

Originally Posted by Dadoo

I don't understand....

I've an DB error who said :

PHP Code:


			
Invalid SQL:

INSERT INTO vb411microcart_products

                                           SET categoryid = '1',

                                               name = 'Test product',

                                               type = '1',

                                               status = '1',

                                               code = '',

                                               manufacturer = '',

                                               description = 'Content of test product',

                                               features = 'custom text <span style="font-weight: bold;">bold text</span><span style="font-weight: bold;">Second test</span>

',

                                               price = '130',

                                               discountprice = '10',

                                               specialprice = '20',

                                               renewal = '0',

                                               license = '1',

                                               dlperiod = '365',

                                               demolink = '',

                                               forumlink = 'http://localhost/showthread.php?1-pr%E9sentation-du-dadoo',

                                               bugslink = 'http://localhost/showthread.php?1-pr%E9sentation-du-dadoo',

                                               reviews = '1',

                                               agreement = '0',

                                               frontpage = '1',

                                               flagship = '1',

                                               isbundle = '0',

                                               addons = '',

                                               extras = '0',

                                               promousergroup = '0',

                                               weight = '700',

                                               image = 'admincp0.jpg',

                                                          userstocklevel = '1',

                                                          stocklevel = '0',

                                                          discount_usergroups = '';



MySQL Error   : Unknown column 'userstocklevel' in 'field list'

When i look XML product file, i see :

PHP Code:


			
        CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."microcart_products` (

          `id` int(11) NOT NULL auto_increment,

          `name` varchar(100) NOT NULL,

          `categoryid` int(11) NOT NULL,

          `type` tinyint(1) NOT NULL default '1',

          `status` int(11) NOT NULL default '1',

          `code` varchar(100) NOT NULL,

          `manufacturer` varchar(100) NOT NULL,

          `price` decimal(10,2) NOT NULL default '0.00',

          `discountprice` decimal(10,2) NOT NULL default '0.00',

          `specialprice` decimal(10,2) NOT NULL default '0.00',

          `renewal` decimal(10,2) NOT NULL default '0.00',

          `description` mediumtext NOT NULL,

          `features` mediumtext NOT NULL,

          `forumlink` varchar(50) NOT NULL,

          `demolink` varchar(50) NOT NULL,

          `bugslink` varchar(150) NOT NULL,

          `license` int(11) NOT NULL,

          `dlperiod` int(11) NOT NULL,

          `addons` varchar(255) NOT NULL,

          `extras` int(5) NOT NULL default '0',

          `promousergroup` int(11) NOT NULL,

          `agreement` tinyint(1) NOT NULL default '0',

          `reviews` tinyint(1) NOT NULL default '0',

          `isbundle` tinyint(1) NOT NULL default '0',

          `frontpage` tinyint(1) NOT NULL default '0',

          `flagship` tinyint(1) NOT NULL default '0',

          `image` varchar(30) NOT NULL,

          PRIMARY KEY  (`id`),

          KEY `categoryid` (`categoryid`),

          KEY `name` (`name`)

        ) ENGINE=MyISAM

        ");

It seems followings tables are missing into installation file..

PHP Code:


			
userstocklevel = '1',

stocklevel = '0',

discount_usergroups = '';

I will check this as it would not be there as it would be in the upgrade code.
I'll have to look at the XML file before I can tell what's up.

WEBDosser · #17 01-09-2011, 05:32 PM

tagged

Dadoo · #18 01-10-2011, 03:24 AM

Quote:

Originally Posted by micheal332001

I will check this as it would not be there as it would be in the upgrade code.
I'll have to look at the XML file before I can tell what's up.

Thanks a lot Micheal, otherwise i have finished French translation of microCART 1.1.4.

I have to verify some details and then i will release it.
Is it possible to put the XML file in first post for a better visibility ?

micheal332001 · #19 01-10-2011, 05:59 AM

Quote:

Originally Posted by Dadoo

Thanks a lot Micheal, otherwise i have finished French translation of microCART 1.1.4.

I have to verify some details and then i will release it.
Is it possible to put the XML file in first post for a better visibility ?

I should have the fix for this later today and will re-upload it when done and let you all know when its ready.

And yes m8 when you release it in a post i will then add it to the top for everyone to see.

micheal332001 · #20 01-10-2011, 06:58 AM

Sorry all i did forget to put the product xml file within the zip file but its there now.

micheal332001 · #21 01-10-2011, 07:05 AM

Hi all

Im sorry for the problems you had with the missing product xml file.
I have now uploaded the new files with the product xml file within the zip file now.

If you installed version says it version 1.1.4 change this to version to 1.1.1 and then import the product xml file with overright set to yes.
This will then installed version 1.1.4 and put the new database tables in.

If you have the table name stocklevel within the database table microcart_products then change the version to 1.1.2

If you have the table name discount_usergroups and stocklevel within the database table microcart_products then change the version to 1.1.3

If you have the database tables microcart_coupon and microcart_usercoupon and the above already there then you dont need to change the version.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09682 seconds Memory Usage 2,488KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (6)bbcode_php (6)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (2)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (6)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

2 благодарности(ей) от:
mohammadxxx, Romamo

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!