eCommerce for vB4.2.2+

[TheAdminMarket]

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 (http://www.christos.teriakis.com). 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 ***



Report any Bug only on the link above. Reporting Bugs here will be ignored. This thread should be ONLY for questions. Thank you.
eCommerce is an update of microCART (https://vborg.vbsupport.ru/showthread.php?t=256723), 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 (https://vborg.vbsupport.ru/member.php?u=224908))
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:

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

Upload .htaccess file to your forum directory
If you already have a .htaccess file in your installation add the 2 lines belon on it.
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 !!

[hoangserip]

Thank You Very Much NickTheGreek

[RichieBoy67]

Nice to see you again! I love this! Great work!

[Dave]

AdminCP file doesn't work because PHP shorttags are used at some places which is not enabled on all servers, all instances of <? need to be replaced by <?php in order to make it work on all servers.

[joeychgo]

re: physical products

Does this support the choice of size / color? ie T-Shirt, Black, XL

[TheAdminMarket]

re: physical products

Does this support the choice of size / color? ie T-Shirt, Black, XL

Yes it supports any type.

[TheAdminMarket]

AdminCP file doesn't work because PHP shorttags are used at some places which is not enabled on all servers, all instances of <? need to be replaced by <?php in order to make it work on all servers.

Have changed them now. Thank you. I'll release the new file with some other changes a bit later today.

[TheAdminMarket]

A security risk found and reported by DAVE (https://vborg.vbsupport.ru/member.php?u=386389) (Thank you Dave) in the assetmanager, plus some other variables in the code that had left unvalidated. All have fixed immediatelly, and the update version 1.1.0 has been released.

To Update:
1.- REMOVE COMPLETELLY the directory ecommerce/editor/assetmanager/
2.- Upload cart.php, cart_gateway.php and clientarea.php to your forum directory
3.- Upload ecommerce_admin.php to your admincp
4.- Import product-ecommerce.xml just to update the version number.

Once again I want to thank DAVE (https://vborg.vbsupport.ru/member.php?u=386389) for his help. After 10 years and 50+ addon releases is the first one who contact me to report these issues instead to report them for addon removal.

[ozzy47]

Yeah Dave is a awesome dude, he usually contacts the developer first. I go to him quite often with concerns, and to have him check code for me. :)

[TheAdminMarket]

Yeah Dave is a awesome dude, he usually contacts the developer first. I go to him quite often with concerns, and to have him check code for me. :)

Yeap. Very Professional approach of his side. Next time before releasing anything I'll send the files to him for checking. Hope that his rates are not like Calorie (the ex-moderator here) who on 2007 she asked me $200 per file. And it was for vbClubs an addon with 44 files !!

[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. :o
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,vbull etin_3,vbulletin_4,vbulletin_5,vbulletin_6,vbullet in_7,vbulletin_8,vbulletin_9,vbulletin_10,vbulleti n_11,vbulletin_12,vbulletin_13,vbulletin_14,vbulle tin_15,vbulletin_16,vbulletin_17,vbulletin_18,vbul letin_19,vbulletin_20,vbulletin_21,vbulletin_22,vb ulletin_23,vbulletin_24,vbulletin_25,vbulletin_26, vbulletin_27,vbulletin_28,vbulletin_29,vbulletin_3 0,vbulletin_31,vbulletin_32,vbulletin_33,vbulletin _34,microsupport_0,ecommerce_0,vbcms_0,reviews_0,v bprojecttools_0,_0,postthanks_0,rbs_0
IP Address : xxx.xxx.xxx.xxx
Username : LenKaiser
Classname : vB_Database
MySQL Version : 5.5.40-cll

[TheAdminMarket]

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]

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.

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]

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

[TheAdminMarket]

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

Let me uninstall a testing installation and install it again, because, as for me it works fine.

[HM666]

Okie dokie. If you need a login or something on my site let me know. Oh and also there is a database error when I click on the link in the menu to view the shop on the web page. I've disabled the shop tab for now.

[TheAdminMarket]

Okie dokie. If you need a login or something on my site let me know. Oh and also there is a database error when I click on the link in the menu to view the shop on the web page. I've disabled the shop tab for now.

Really don't know what can be wrong in your installation. For me works fine. I had a demo installation. It was working. Then I uploaded the files that changed in version 1.1.0. Worked fine. Now I uninstalled the mod and I installed it again. I can move to all menus in admincp without any problem or database error.

If you haven't entered any data, maybe is better to completely uninstall the addon, remove (or rename) the ecommerce folder and start with a fresh installation?

If still have problems PM connection details to your installation but I'll look on them in 10 hours. Now is 22:00pm here, not a good time to connect to sites :)

[TheAdminMarket]

@Barbaro
@HM666

Did you had microCART installed in your sites? Even if I've renamed the important files and database table names, you never know.

[HM666]

@Barbaro
@HM666

Did you had microCART installed in your sites? Even if I've renamed the important files and database table names, you never know.

Yeah I did have it installed and it was working ok. I uninstalled it and deleted the files from it.

[Dave]

The problem here is that the installation script in product-ecommerce.xml creates tables like vb4x_ecommerce_agreements, but the files use ecommerce_agreements, without the vb4x_ prefix.

Table names in the installation script needs to be changed.

[HM666]

The problem here is that the installation script in product-ecommerce.xml creates tables like vb4x_ecommerce_agreements, but the files use ecommerce_agreements, without the vb4x_ prefix.

Table names in the installation script needs to be changed.

Ah that makes sense :) I'm sure Nick will fix it after some rest :)

[Nirjonadda]

I hate any mod from Christos Teriakis, Its more then dead projects because he/she like to change username or support website name.

[ozzy47]

I hate any mod from Christos Teriakis, Its more then dead projects because he/she like to change username or support website name.

Then you have no reason to use it, if you do not like it. :)

[Johnny G]

I hate any mod from Christos Teriakis, Its more then dead projects because he/she like to change username or support website name.

Nick has stepped in, and brought to life a very good, but dead product. He's done a superb job, IMO. If you don't like it, don't download it, don't mark it as installed, and maybe don't comment?

[TheLastSuperman]

I hate any mod from Christos Teriakis, Its more then dead projects because he/she like to change username or support website name.

Nick is Christos from what I recall, needless to say if you're not happy with a coder and/or his products or services you should not be using them, if you do then the need to comment is no longer your prerogative - you can certainly still comment but we'll all just ignore it, the same as you should their mods due to the iffy'ness they've shown in the past if you feel that way.

[TheAdminMarket]

I need to apologize for my childish mistake which caused problems and waste of time for you. In my effort to make the code more solid and understandable I remove all database version changes and I replaced them with a screendump from phpMyAdmin. At that point I did the mistake as I forgot to change the table prefix. Novice mistake but I did it.

I've released version 1.2.0 which will build the correct tables. To upgrade:

1.- Clicking Edit on the right of the product

2.- Replace the uninstall code with the code below.

$vbulletin->db->query_write("
DROP TABLE
`vb4x_ecommerce_categories`, `vb4x_ecommerce_products`,
`vb4x_ecommerce_product_photos`, `vb4x_ecommerce_product_files`,
`vb4x_ecommerce_product_types`, `vb4x_ecommerce_carts`,
`vb4x_ecommerce_orders`, `vb4x_ecommerce_payments`,
`vb4x_ecommerce_agreements`, `vb4x_ecommerce_domains`,
`vb4x_ecommerce_product_fields`, `vb4x_ecommerce_invoices`,
`vb4x_ecommerce_locations`, `vb4x_ecommerce_taxes`,
`vb4x_ecommerce_zones`, `vb4x_ecommerce_zone_fares`,
`vb4x_ecommerce_customers`, `vb4x_ecommerce_coupon`,
`vb4x_ecommerce_usercoupon`
");


3.- Unistall the product
4.- Import the new product-ecommerce.xml file.

Once again sorry for troubles,

[ozzy47]

Christos, things like this happen to developers all the time. we rush to get things out, to the members, and mistakes are made. No worries brother. :)

[TheAdminMarket]

No. This time is not a bug fix update :) . Just added some design improvments that I found very useful for myself, hope that you'll also like them even if you'll not finally use them.


As you maybe seen there was a global option to show the cart (options, addons and buynow button) above the tabs or as a seperate tab. This was good but not the best. Now I move this setting per product. So when you add a product you can decide if you want the cart above the tabs or as a seperate tab.
The other improvment is on the view item page. As is now the page looks good if its a complete item with options, addons, links, screenshots, reviews etc. But what about if the item is something simple? eg Installation service... what reviews to show here, or what screenshots etc. That's why I build a new template which has a minimal interface. So, if you want for a specific product to use this minimalist template just select YES to "Use Simple Template?"
This is a correction. I cached some missing template names.
To upgrade:

Upload ecommerce_admin.php to admincp directory
Upload functions.php to ecommerce/ directory
Upload cart.php and clientarea.php to forum directory
Import the product-ecommerce.xml
Thank you

[Johnny G]

Lovely mod, Nick. Downloaded and installed!!

I've an idea for your next iteration of the product. Drop shipped products, where you'd need to have:
forums own item code,
suppliers item code,
suppliers email address which is sent with the order once checkout is done,
forum sale price to customer,
forum cost price from supplier,
any configurable tax per item,
any configurable PayPal surcharge,
any configurable postage per item.

If you can add that, you'll have THE best forum shopping plugin around.

[TheAdminMarket]

Lovely mod, Nick. Downloaded and installed!!

I've an idea for your next iteration of the product. Drop shipped products, where you'd need to have:
forums own item code,
suppliers item code,
suppliers email address which is sent with the order once checkout is done,
forum sale price to customer,
forum cost price from supplier,
any configurable tax per item,
any configurable PayPal surcharge,
any configurable postage per item.

If you can add that, you'll have THE best forum shopping plugin around.

....lol... My dear Johnny, this should not be only the best forun shopping plugin but even the best PHP script at all :)

1.- Have forgot to write in details that comparing with micrCART I've added email templates for: New Order (Successful payment), New Order (Declined Payment), Invoice still unpaid (in case of declined payment), Renewal Reminder and Subscription expired. So it's easy to send a copy of them to someone else.

2.- What it means "forum" cost, sale etc?

3.- Tax per item is in my plans, but why shipping per item? Do you plan to ship item by item and not a parcel with all items?

4.- PayPal subcharge can also be add in the meaning: From xx to xxx price a standard amount and then a percentage for the rest. Or in the way that PayPal works, can't remember right now.

[Johnny G]

Haha! Touch?! ;)

1. If you can have each product send a mail to a different address, e.g. if we drop ship tyres and clothing, we'll have different suppliers for the tyres than we could for shirts.
So if we could have a supplier email that sent the following, and had it configurable per product.
Purchaser:
Address:
Items bought:

That way, the shop would automate a lot of the forum selling activities. I think a lot of forums use drop shipping.

2. Forum cost is the cost to us to buy the part. Example:
A shirt might cost us ?4.50 to buy, but we sell it at ?6.00 if the mail that's sent outputs both, it makes the accounting easier.

3. We have a wide range of product sizes - as mentioned, so shipping costs vary a lot for us.

4. I think PayPal charge 3 or 4%

Thanks!

[TheAdminMarket]

Haha! Touch?! ;)

1. If you can have each product send a mail to a different address, e.g. if we drop ship tyres and clothing, we'll have different suppliers for the tyres than we could for shirts.
So if we could have a supplier email that sent the following, and had it configurable per product.
Purchaser:
Address:
Items bought:

That way, the shop would automate a lot of the forum selling activities. I think a lot of forums use drop shipping.

2. Forum cost is the cost to us to buy the part. Example:
A shirt might cost us ?4.50 to buy, but we sell it at ?6.00 if the mail that's sent outputs both, it makes the accounting easier.

3. We have a wide range of product sizes - as mentioned, so shipping costs vary a lot for us.

4. I think PayPal charge 3 or 4%

Thanks!

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.

[joeychgo]

Yes it supports any type.

Any type? So it can process product variables?

[TheAdminMarket]

Any type? So it can process product variables?

Can you be a bit more specific to avoid misunderstandings? What options to do you want to add?

[Johnny G]

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 (https://vborg.vbsupport.ru/showpost.php?p=2531426&postcount=32) 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]

Upgrade did not work. I followed the info in THIS (https://vborg.vbsupport.ru/showpost.php?p=2531426&postcount=32) 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]

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]

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]

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.

[HM666]

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.

WOW that is a good point I never thought about that personally and have never run into anyone doing that. I'll keep that in mind in the future.

[TheAdminMarket]

WOW that is a good point I never thought about that personally and have never run into anyone doing that. I'll keep that in mind in the future.

Unfortunatelly I've bad experiance from this :( And you know where is the dammit problem? That it takes time to understand what's going wrong. In my bad experiance the table "users" has been overwritten from aeDating script (I'll never forget the name of this script). I was getting errors in some queries about the users table but I was seeing it to exists. It tooks many days(!!) to understand that that table "users" was not from my forum script (I think was phpbb) but from aeDating.

vBulletin knew that problems that's why did a very wise thing. The common naming for tables were "users", "usergroups", "threads", "posts". But they named them in singular giving an extra security.

If at anytime you see the dataschema of any script using the "DROP TABLE" and then "CREATE TABLE" just go away. For sure the developer is not good.

[HM666]

I'll keep that in mind. BTW dropping the tables & that field from the usergroup table fixed my issue :)

[knikio]

hi
I using vb 4.2.2 PL3
I just finished installing this add-on.
And this is the error message I getting in my site

Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\mysite\cart.php on line 437

[TheAdminMarket]

Edit the file cart.php at line 437
Replace:

$bbcode_parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());

With:

$bbcode_parser = new vB_BbCodeParser($vbulletin, fetch_tag_list());

But I suggest you to put at the top of your config file (just after <?php) the line:

define('SKIP_ALL_ERRORS', true);

It will solves the peace of your mind from dozens similar message not only coming from my mod, or other mods, but even from vBulletin code.

EDITED: Read this from vb.com forums:
http://www.vbulletin.com/forum/forum/vbulletin-announcements/vbulletin-announcements_aa/4000121-vbulletin-4-2-2-full-has-been-released

[TheAdminMarket]

....added above........

[knikio]

Thank you NickTheGreek For your quick reply.
It fixed my problem

[TheAdminMarket]

Version 1.4.0 released with some bug fixes, design corrects and a new feature.

Fixed wrong link PAY INVOICE
Fixed missing values passing to PayPal when paying the invoice
Fixed 2 deprecated errors
Redesigned the pay invoice template
Added Delete Invoice (works only if the invoice is unpaid). To upgrade:

Upload cart.php and clientarea.php to your forum directory
Upload ecommerce/functions.php to ecommerce directory
Upload ecommerce/images/delete.gif to ecommerce/images
Import product-ecommerce.xml By the chance I want to thank you kastak (https://vborg.vbsupport.ru/member.php?u=224908) for the ccBill payment gateway. Sorry haven't noticed before that this payment gateway has been coded by him.

Christos

[TheAdminMarket]

An uncleared input found when user submits installation URL and has been fixed. Please download version 1.4.1 and upload clientarea.php. Optionally import product-ecommerce.xml to update your version number.

[concepts]

Where do I go to change the Paypal Logo under the Payment Partners block? I do no see these blocks in the ecommerce options. I want to upload a PNG file instead of gif, however I can not find this module to change the extension anywhere in the admincp.

Thanks, and this is an AMAZING MOD!!! I'm very much impressed!

[Code Geass]

Can it support CashU & UKash ?

If not please make it support it :)

Thanks in advance.

[TheAdminMarket]

Where do I go to change the Paypal Logo under the Payment Partners block? I do no see these blocks in the ecommerce options. I want to upload a PNG file instead of gif, however I can not find this module to change the extension anywhere in the admincp.

Thanks, and this is an AMAZING MOD!!! I'm very much impressed!

Unfortunately it can't be change automatically. You must upload your desired image at:
ecommerce/images/ and then modify the templates:

ecommerce_payment_gateways (Is the block on the sidebar)
ecommerce_pay_invoice
ecommerce_preview (These 2 templates are for the checkup procedure).

[TheAdminMarket]

Can it support CashU & UKash ?

If not please make it support it :)

Thanks in advance.

What's these? :confused: :)

[Code Geass]

CashU: https://www.cashu.com

UKash: https://www.ukash.com

OneCard: https://www.onecard.net/customer/home.html?siteLanguage=en

[TheAdminMarket]

Hello all,

I've post an idea in my site to extend the functionality of eCommerce. You can read and vote for it (you must register to vote):
http://www.christos.teriakis.com/issue/7-Donations

Christos

[concepts]

Hello all,

I've post an idea in my site to extend the functionality of eCommerce. You can read and vote for it (you must register to vote):
http://www.christos.teriakis.com/issue/7-Donations

Christos

That looks great! And will nicely replace my other donations platform. I will register and vote for this shortly, would love to try it out!

Thanks for all the hard work Nick!

[Charis]

Thank you.
CMOD 777 the directories:
...
ecommerce/fonts
Do you mean: "ecommerce/pdf/fonts"

[TheAdminMarket]

Thank you.
CMOD 777 the directories:
...
ecommerce/fonts
Do you mean: "ecommerce/pdf/fonts"

Yes, sorry. HM666 (https://vborg.vbsupport.ru/member.php?u=522966) has already reported it but as it has a problem on the same post, I focused in the problem and I forgot it.

[TheAdminMarket]

Finally I went ahead and I started working for the donations feature as I also want it for my own use. But still I'm expecting your suggestions.

As you can see in the attached screenshots I took care even for small details to have it working smoothly. As you can see I added a setting even for the style of the message that will appears in the form (if you activate it).

[Charis]

Does "offline payments" work?
Should I see the "Offline Payments Information" under the "PayPal" in the sidebar?

[TheAdminMarket]

Does "offline payments" work?
Should I see the "Offline Payments Information" under the "PayPal" in the sidebar?

No, not there Charis (just now I realized who are you:D ). Only during the checkout procedure as payment option.

[Charis]

Could you add a field for "Δ.Ο.Υ." (IRS division) in checkout form?
I think that "Requirent!!" should be red and bold.

[HM666]

Donations look pretty good. :)

I do have a request for the mod though if you are able and have the time. I would like to see if the invoices could be modified a bit. In the product column could we have a field that can be manually put into the invoice? So basically I have a custom client, I have my own codes for things and prices for custom work that I won't post on the site directly but i want my custom clients to login to the site and have an account where I send them invoices for work performed that is not an actual product on my site. This could also be used for quoting the client as well after they have an account and are an established client. Did that make sense? I'm not really awake yet so I might be babbling lol.

EDIT: I also have another issue that I need to sort. What code can I use to have a box appear only on the first page of the shop? i want to put my description above the categories on only the first page of the shop. Adding the descriptions in the description field proved to be not an acceptable format for me. I can add the code for my box but it shows on ALL the cart pages, I only want it to show on the first one. I've attached 2 screen shots. The first one shows the box I've created that I need to only have show on the first page and the second one shows how my categories end up when adding descriptions. The descriptions get cut off and it throws everything out of whack and looks horrible.

[TheAdminMarket]

@HM666

1.- Invoice is a section that I plan to check/modify at the end. I also don't like it and don't know why Michael has changed it. My original invoice was pretty nice.

2.- Yes I can add it.

[TheAdminMarket]

Could you add a field for "Δ.Ο.Υ." (IRS division) in checkout form?
I think that "Requirent!!" should be red and bold.
I'll add it as "VAT division" or "VAT office".

[TheAdminMarket]

i want to put my description above the categories on only the first page of the shop.
Added: http://demo.teriakis.com/vb4x/cart.php

The descriptions get cut off and it throws everything out of whack and looks horrible.
Try to change values at ecommerce.css Check td.category and maybe #itemwrapper

[HM666]

@HM666

1.- Invoice is a section that I plan to check/modify at the end. I also don't like it and don't know why Michael has changed it. My original invoice was pretty nice.


ok great! :)

Added: http://demo.teriakis.com/vb4x/cart.php

No, I'm sorry that I have already done that, I do NOT want it showing on every page when you click on a category. I need code that will only include it on the very first page. This page I want the box to show (http://lenmkaiser.com/vb/vb4/cart.php) but on this page I do NOT want it to show (http://lenmkaiser.com/vb/vb4/shop/15/web-site-maintenance/). I only want it showing on the first page with the top level categories. All I need is code to put into the template I already have code for the box :)

[TheAdminMarket]

Could you add a field for "Δ.Ο.Υ." (IRS division) in checkout form?

Added

I think that "Requirent!!" should be red and bold.
Added

[TheAdminMarket]

No, I'm sorry that I have already done that, I do NOT want it showing on every page when you click on a category.

Changed

[HM666]

Changed

Awesome! How do I get it lol? Let me know when you update the zip or attach it somewhere. :)

[TheAdminMarket]

Awesome! How do I get it lol? Let me know when you update the zip or attach it somewhere. :)

I believe that in 6-8 hours from now I'll be able to release ver. 1.5.0.

[TheAdminMarket]

In version 1.5.0 I've also improved the Payment Partners sidebar clock:

Added ccBill and Offline payments as they were missing.
Chanfed .gif images to .png as this format is more popular and easy to replace.
Changed the templates with the new icons.See the attached screenshot.

[concepts]

In version 1.5.0 I've also improved the Payment Partners sidebar clock:

Added ccBill and Offline payments as they were missing.
Chanfed .gif images to .png as this format is more popular and easy to replace.
Changed the templates with the new icons.See the attached screenshot.

Nice! Can't wait! Does this version include the donations add-on you created?

[TheAdminMarket]

Nice! Can't wait! Does this version include the donations add-on you created?
Yes.

[TheAdminMarket]

Hello all,

I'm happy to release eCommerce ver.1.5.0 which supports Donations. It's not a simple donations box, but a fully working addon implented to work smoothly with eCommerce sharing the eCommerce settings.

I'm not good on listing features as I'm not writting down them when I'm adding them. But the most important are:
Can be turn On/Off as not all sellers want to accept Donations especially if all their products are commercial.
You can build a donation goal list just by checking which of your products you want to appear there. eg if you've commercial and free products you can set only your free products to accept donations.
You can set donations amounts or leave the setting empty. In thise case an input box will appears on the form and the user can sets his desired amount.
Donations (if enabled) are appearing at Postbit
Admin can Adds/Edit/Delet Donations
Tomorrow I'll release a new version which will allows you to auto generate donation form for:
Forum Sidebar
vb CMS (if enabled)
Any PHP/HTML pageIn addition to Donations I've added some features that have been requested by users:
Welcome message appearing in the main page of your shop
ccBill and Offline payments icons added in Payment Gateways block in sidebar. In addition I changed all gif images with png as they're more popular. This is for those who want to change images
Added one more field in customer table "Vat Office". This is a need for EU customers along with their VAT id.Maybe I added more, but not really remember them now :rolleyes:

To upgrade:
Download the latest 1.5.0 version
Upload ALL files from upload directory. Sorry but more than 20 files have been modified plus many others have added (including images), so it should be a waste of time to try uploading one by one 30 files. If you want to save some time don't upload the folder "editor" inside ecommerce folder.
Inport product-ecommerce.xml and don't forget to check "Overwrite".Finally, spent some seconts to rate eCommerce. Any rating... but rate. It's just seconds.

Thank you
Christos

[concepts]

Just updated, the only thing is I do not have the "Donate for" dropdown, nor the text above it... is there something I am missing? I only see the "Your name, leave a message, and amount.

Edit** I may have done something wrong in the uploads... trying again...

[TheAdminMarket]

Just updated, the only thing is I do not have the "Donate for" dropdown, nor the text above it... is there something I am missing? I only see the "Your name, leave a message, and amount.

Edit** I may have done something wrong in the uploads... trying again...

You must check the settings. By default "Donate for" is set to No.

[concepts]

Whenever I attempt to delete donations.. I receive the following error

Database error in vBulletin 4.2.2:

Invalid SQL:
UPDATE user SET ecommerce_donations=ecommerce_donations-1, ecommerce_donationsamount=ecommerce_donationsamoun t-100.00 WHERE userid=1;

MySQL Error : BIGINT UNSIGNED value is out of range in '(`ruofficialboard`.`user`.`ecommerce_donations` - 1)'
Error Number : 1690
Request Date : Thursday, January 15th 2015 @ 08:47:37 PM
Error Date : Thursday, January 15th 2015 @ 08:47:37 PM
Script : http://www.ruofficial.com/admincp/ecommerce_admin.php?do=donations&action=delete&id=2
Referrer : http://www.ruofficial.com/admincp/ecommerce_admin.php?do=donations
IP Address : 216.205.224.10
Username : SBOfficial
Classname : vB_Database
MySQL Version : 5.5.36-cll-lve


**Edit** I am at work using "net2ftp" as I cannot access my programs here. So maybe that is the case as it's not as functional uploading a large amount of files, I guess I will re install this 'officially' when home, either way, this ROCKS!

[TheAdminMarket]

**Edit** I am at work using "net2ftp" as I cannot access my programs here. So maybe that is the case as it's not as functional uploading a large amount of files, I guess I will re install this 'officially' when home, either way, this ROCKS!

Ok. It's 23:00pm here and I was working almost 16 hours today so I need some sleep. I'll be again online in 8 hours.

[HM666]

Upgraded the mod, but the welcome box does not work. Am I missing something? I put the text in the box and it does not show. http://lenmkaiser.com/vb/vb4/cart.php

On the invoices when you redo that part I wanted to also ask for the ability to add fields myself to it. Like for instance you have an Tax & Shipping Information area I would like a Client Information area as well where I could add my own fields or have these fields plus the ability to add extra fields if needed in the future...

Account Number
Email Address
Web Site URL
Web Site Name
Client Name
Date

Also if you select a product from the drop down list in the invoice page it does not automatically add the amount in the price field of the product nor does it add the price after you put a quantity in. Is it possible to get it to automatically add that price and then if the quantity is more than 1 it adds that price together reflecting the total amount in the "Item Price" box. For instance if my product is $5.00 and I put the quantity at 3 it should automatically add it together and put $15.00 in the Item Price field and then automatically put the total. If that is too much coding or impossible to do that is fine I understand.

Also, yeah I know I'm full of ideas right now lol, but is it possible to add a simple support ticket system to the e-commerce mod where they could submit a ticket based on an item they purchased form the store or based on custom work from an invoice or if they are an ongoing client they could submit a support ticket if there was a problem with their web site?

[TheAdminMarket]

Also, yeah I know I'm full of ideas right now lol, but is it possible to add a simple support ticket system to the e-commerce mod where they could submit a ticket based on an item they purchased form the store or based on custom work from an invoice or if they are an ongoing client they could submit a support ticket if there was a problem with their web site?

You most probably mean something like this:
https://vborg.vbsupport.ru/showthread.php?t=282069&highlight=freelancer

:D

[TheAdminMarket]

Hello,

Here is the new version 1.6.0 maybe the last one with new features. Sure should be immediatelly updates for bug fixes, but I can't promise anything about new features.

What's new in version 1.6.0

Added a Donation form generator. What you can do with this:
Automatically add a donations form in Forum sidebar
Get the generated HTML code and add it to any page even in different website.
Unfortunatelly widget creation for vB CMS is not possible as vBulletin seems that something changed again there. It also changed the way to create a Forum block but this was easy to find. The problem with CMS widgets is that I was unable to create a block even manually. Like that they have disabled PHP and HTML type widgets. So I gave up to this.
Corrected the new payment gateway images in the checkout templates.How to upgrade:

Download version 1.6.0
Upload ecommerce_admin.php to your admincp directory
Upload upload/includes/xml/cpnav_ecommerce.xml to includes/xml/ directory
Import product-ecommerce.xml from admincp and don't forget to click overwrite.Christos

[HM666]

I still do not see the message box on the first page, its not working. I've typed the info into the Welcome Message field and saved it numerous times. It still does not show. I upgrade to the 1.6.0 version.

You most probably mean something like this:
https://vborg.vbsupport.ru/showthread.php?t=282069&highlight=freelancer

:D

Actually not quite but close. This is pretty much what I've looked for. I'm sure other people have other ideas on how they want to run their sites etc. But this has always been my thoughts.

This is gonna be long, remember you asked lol. :)

Things important for me in running my business:

1. Having a Forum and having one login for everything, hence the reason I am trying to get the store, forum, cms, etc set up. (vBulletin offers this obviously)
2. Having the CMS in place for articles, manuals, my portfolio, my list of services, and other information about my business. (vBulletin offers this obviously)
3. Having a downloadable products store.
4. Having a private support ticket system for members/clients.
5. Having a invoice system where I can invoice or quote past clients.
6. Having a subscription service where I can have a skin club with more basic skins for business type sites. This they pay XXXX a month or 3 months, 6, 12 etc. (This I will use the built in vBulletin feature for it works exactly the way I need it to but I have an adult design site in wings that I'm working on and will need this feature in a shopping cart to use CCBill).
7. Having a client area where they can view their account details, download links, products, input their web site URL, and pick up and answer their support tickets.

Store:

1. Downloadable products allowed with "hidden" downloads where they are secure and cannot be accessed without paying for the item.
2. Products that can be shipped. I offer my clients the option of me shipping them a backup of their site via postal mail on a DVD. This works great for clients who do not have fast internet connections or time to sit and download several gigs of files for ever in a day just have their backup. So there would be a shipping charge as well as the charge for the DVD.
3. Demo link
4. Screenshots
5. Pretty much what you have done so far. It works perfectly for what I need really.

Invoice/Quote System:

1. An invoice/quote system that allows me to input extra fields if I need them.
2. I should be able to send this invoice/quote to a client who is a member of my site and already has a verified account.
3. Unlimited invoice/quote rolls/fields so if the client wants quite a lot of work done (which does happen) then I can add rolls to the invoice to add the new items.
4. The following fields would be required client information:
***a) Client Name
***b) Client Email address
***c) Client Web Site URL
***d) Client Account Number (and this could even be a built in feature where it assigned an account number automatically but that is not really a deal breaker, I base my account numbers on the client's name, web site name and some random numbers)
***e) Client Web Site Name
***f) Date of invoice/quote.
5. The following fields would be required for adding products to the invoice:
***a) Item Name (This would give the option of a field I could add myself or I could choose a service from the drop down of the things that are sold in my shop)
***b) Quantity (this would be a manual edit for obvious reasons)
***c) Price (to be put in automatically if the item is an item in my store - this amount would automatically calculate if the quantity is more than 1)
***d) Item Discount (Yeah ok I see the good int his although I probably may not use it all that often it maybe helpful in the future)
***e) Deposit (This would be an amount that the client has put down on a job. This would be subtracted from the total amount due automatically)
***f) Total (Should automatically total everything up in the roll.)
***g) Subtotal, Total, Discount, amount due total should automatically calculate.

Tax & Shipping I really personally do not need but I do see why it should be there for those who may not be using this for downloadable products.

Payment information is fine as it is.

Private Support Ticket System:

I would need the following in a support ticket system:

1. A private system where a client or customer from the shop can submit a ticket.
2. The tickets need the following items:
***a) The ability to add my own fields but ultimately I would like at least the following fields for a client to fill out that are mandatory for them...
******1. Name
******2. Web URL
******3. Email Address
******4. Site software (This would probably work better as a drop down field where I can add which software I support)
******5. A description field so the client could type out the issue they are having.
***b) The added ability to allow clients & me to upload attachments within the support area so we can attach screen shots or files for each each describing the problem.
***c) A FAQ (For me this is not mandatory but nice, right now I do not have a FAQ list made up for a support area but I'm sure i could think of one)
***d) The ability to have an estimated time frame for answers that I can add a message to.
***e) The ability to have a status on the tickets:
******1. Open
******2. Closed
******3. Working
***f) The ability to assign tickets to workers if I eventually hire others.
***g) A built in chat feature with a nice bar at the bottom right of the web page. I believe there are several chat scripts thought that might do this.

Client Area:

This area is for logged in clients/customers only.

1. The client area needs the following:
***a) A place to put their web site link per item they purchased in the shop. I would like it to validate the link if possible but I realize that may not be possible.
***b) A list of all the items they have purchased with information on the purchases:
******1. Date purchased
******2. Item Name
******3. Quantity purchased
******4. Length of license
******5. Upgrade link (if applicable)
***c) A place for their support tickets.

The client area you have is pretty much what I would need with just the support tickets added.

[TheAdminMarket]

I still do not see the message box on the first page, its not working. I've typed the info into the Welcome Message field and saved it numerous times. It still does not show. I upgrade to the 1.6.0 version..

Have you manually modified the template ecommerce_main (you can see it in red color in template list)? Most probably yes as I seen in your screenshot. Keep in mind that manually modified templates are not updating when you import a product xml file. You must revert it and then import product-ecommerce.xml

Please let me know
Christos

[HM666]

Have you manually modified the template ecommerce_main (you can see it in red color in template list)? Most probably yes as I seen in your screenshot. Keep in mind that manually modified templates are not updating when you import a product xml file. You must revert it and then import product-ecommerce.xml

Please let me know
Christos


GRRRRRRRR Ok. :(

EDIT: ok that worked thanks. :)

[knikio]

hi
When a user performs "Submit URL".
He always gets the message "Invalid data specified".
And the URL is correct.
Thanks

[TheAdminMarket]

hi
When a user performs "Submit URL".
He always gets the message "Invalid data specified".
And the URL is correct.
Thanks

My bad, sorry. I've started adding a check there for valid installation of your product (and not just a vaild domain name), but I left it unfinished.

Please upload the attached file.

Sorry again.

[knikio]

It works :D
thank you very much

[TheAdminMarket]

A new version (1.6.1) just release fixing a bug reported by knikio (https://vborg.vbsupport.ru/member.php?u=190526)(Thank you).

This bug was showing an "Invalid data" message when the user was submitting an Installation URL even if the URL was correct. It was my mistake as I've left there some unfinished code. I'll make the "Submit URL" more professioanl by checking:
If the URL is not only valid but also if there is an installation of your product there.
When the user changes the installation URL the system will checks if the product has really remove from the old domain.To upgrade:
Download version 1.6.1
Upload clientarea.php in your installation
Optional import product-ecommerce.xml to update your version.*** IMPORTANT NOTICE ***


Since this version there is also a PRO version available. Like most other mods here. The only difference is that the PRO version is still 100% Free but available for download only in my site. Other than this, the version here should be always available for download and updated for any reported bug.

Version 1.7.0 ("Pro") should be available in some hours and should has an extra tab in product page "Ask a Question". See the attached screenshot.

Version 1.8.0 ("Pro") should be available tomorrow and will has a sidebar block "Rate and Review our store".

Thank you
Christos

[Manoel J?nior]

I registered in your Forum and look forward to posting beyond the PRO version.

[Manoel J?nior]

Chris,

In this product there is the possibility the user need not put your personal details like address for example?

Reason: All of my products are virtual, no need to send them by post and so there is no user's address need.

[TheAdminMarket]

Chris,

In this product there is the possibility the user need not put your personal details like address for example?

Reason: All of my products are virtual, no need to send them by post and so there is no user's address need.

Hello Manoel,

Firstly thank you for registred in my site. As for your request now, I can understand perfectly your problem, and actually this was the way that the mod was working before. There was a setting in options to collect or not client details.

The reason that I've changed it is because effective since Jan 1st 2015, all online shops selling electronic (downloadable) products, must collect EU VAT from their EU Citizens.

Maybe your shop is outside EU and maybe you'll never have a EU citizen client. But that fields must be there "just in case".

Anyway, I'll see what I can do in the upcoming version (1.8.0) tomorrow. What I'm thinking is to bring back the setting, but this will still shows the fields, just it will removes the "Requirent check".

Christos

[Manoel J?nior]

Hello Manoel,

Firstly thank you for registred in my site. As for your request now, I can understand perfectly your problem, and actually this was the way that the mod was working before. There was a setting in options to collect or not client details.

The reason that I've changed it is because effective since Jan 1st 2015, all online shops selling electronic (downloadable) products, must collect EU VAT from their EU Citizens.

Maybe your shop is outside EU and maybe you'll never have a EU citizen client. But that fields must be there "just in case".

Anyway, I'll see what I can do in the upcoming version (1.8.0) tomorrow. What I'm thinking is to bring back the setting, but this will still shows the fields, just it will removes the "Requirent check".

Christos
Thank you for Chris explanation,

I am Brazilian and would never have an EU client, does not have the control panel disable these options?

Thank U

[knikio]

Hi
I AM using eCommerce 1.7.0
When a user submit a question in the "Ask a Question"
When they click on the send button
All they get is a white screen.
Thank you again for your help

[HM666]

Hi
I AM using eCommerce 1.7.0
When a user submit a question in the "Ask a Question"
When they click on the send button
All they get is a white screen.
Thank you again for your help

I would think you should be asking on his site since that is where you got that version from.

[ozzy47]

And since it states in the first post.

*** ATTENTION ***


Report any Bug only on the link above. Reporting Bugs here will be ignored. This thread should be ONLY for questions. Thank you.

[Johnny G]

Love this product, so slick compared to other shop products. Thanks!!

One thing, if you get a chance in another release. Could you possibly add the option to send a notification email?

For example, can the shop send an email to shop@ ..... once an order is received (as well as have a separate paypal@.... address). That one tweak would be huge for us. Will pay for the tweak if needed.

[TheAdminMarket]

Love this product, so slick compared to other shop products. Thanks!!

One thing, if you get a chance in another release. Could you possibly add the option to send a notification email?

For example, can the shop send an email to shop@ ..... once an order is received (as well as have a separate paypal@.... address). That one tweak would be huge for us. Will pay for the tweak if needed.

Johnny, please post it at:
http://www.christos.teriakis.com/issuelist/2-eCommerce?issuetypeid=feature

[Charis]

Thank you for the new pro (but free) version, 1.8.1.

[HM666]

Chris I would love to register at your site but I have not idea what the question means it makes no sense at all to me. That could possible be one reason why you are not getting a lot of people signing up. Possibly pick a question that people can actually guess a little easier and it might help.

[TheAdminMarket]

Chris I would love to register at your site but I have not idea what the question means it makes no sense at all to me. That could possible be one reason why you are not getting a lot of people signing up. Possibly pick a question that people can actually guess a little easier and it might help.

Sorry for this but nobody reported something like this before :confused:
eg: Which is the 11-4 Month of the Year?
The correct answer is: July (11-4=7)

By asking "Which is the 7th month of the year" it can be easily break by bots that's why I'm always using calculations. And I can say that I've 0 spam. Not now which is normal with a few registrations but even when I had 2000+ members.

[HM666]

Sorry for this but nobody reported something like this before :confused:
eg: Which is the 11-4 Month of the Year?
The correct answer is: July (11-4=7)

By asking "Which is the 7th month of the year" it can be easily break by bots that's why I'm always using calculations. And I can say that I've 0 spam. Not now which is normal with a few registrations but even when I had 2000+ members.

Ok registered. :) Its probably just the Greek to English translation that is causing the confusion because the first question I got made absolutely no sense whatsoever. So some of those may need to be looked over to ensure the translation makes sense.

[puertoblack2003]

Ok registered. :) Its probably just the Greek to English translation that is causing the confusion because the first question I got made absolutely no sense whatsoever. So some of those may need to be looked over to ensure the translation makes sense.

and i thought i was stupid. :p But after reading and re-reading i figured it out.. :)

[ozzy47]

I can't stand the Q & A stuff, I got something I am working on Christos, that so far in a week of testing, has not let any spammers through.

I turned off all the mods I recommend, and have no captcha or questions to answer. Once it is in a better state, I'll PM you on OzzModz.

[Marv]

You know what? I?m pissed. Not just a little bit, no, I?m REALLY pissed! So pissed like a thermonuclear strike ruins the whole day..

Just installed this one out of couriosity and this goddamn mod is so f..king great that I bite my backside to the bone, that I don?t have a single item that I could sell there :D (What the heck are you all offering in there?)

Really a nice piece of software, kudos Christos :up:

Nominated!

[puertoblack2003]

You know what? I?m pissed. Not just a little bit, no, I?m REALLY pissed! So pissed like a thermonuclear strike ruins the whole day..

Just installed this one out of couriosity and this goddamn mod is so f..king great that I bite my backside to the bone, that I don?t have a single item that I could sell there :D (What the heck are you all offering in there?)

Really a nice piece of software, kudos Christos :up:

Nominated!

well I'm glad you're pissed :D this is indeed a nice software

[Max Taxable]

I can't stand the Q & A stuff, I got something I am working on Christos, that so far in a week of testing, has not let any spammers through.

I turned off all the mods I recommend, and have no captcha or questions to answer. Once it is in a better state, I'll PM you on OzzModz.Continuing to make good on our credo, "The Era of Big Spam is Over."

[HM666]

and i thought i was stupid. :p But after reading and re-reading i figured it out.. :)

LOL yeah I had to as well. Had the read it a couple of times to comprehend it. The first one though it did not matter how many times I read it. :(

I can't stand the Q & A stuff, I got something I am working on Christos, that so far in a week of testing, has not let any spammers through.

I turned off all the mods I recommend, and have no captcha or questions to answer. Once it is in a better state, I'll PM you on OzzModz.

Awesome! I'm sure it will be useful. :)

[TheAdminMarket]

eCommerce has been updated with the latest free version 1.8.4. As there are 6 releases (1.7.0, 1,.8.0, 1.8.1, 1.8.2, 1.8.3, 1.8.4) since the last version here (1.6.1), I suggest you to give a look (there is no need for registration) to:

http://www.christos.teriakis.com/forums/2-News-and-Announcements

and read the new features, bug fixes, upgrading instructions etc.

The current (Commercial) version is: 2.1.1

[HM666]

Problem with the latest update. I have a weird lightbox that I have not asked for in the product page now after doing the update. I've attached a screen shot. Its an adult site so everyone is forewarned. Its all the way at the bottom. I do not understand why its there I have no images for this item.

[TheAdminMarket]

Problem with the latest update. I have a weird lightbox that I have not asked for in the product page now after doing the update. I've attached a screen shot. Its an adult site so everyone is forewarned. Its all the way at the bottom. I do not understand why its there I have no images for this item.

Is better to give me the link to that page. Is this a product's page? Didn't understood anything from the screenshot other than the popup.

[HM666]

<a href="http://webdesignfetish.com/product/1/web-maintenance-bronze-plan/" target="_blank">http://webdesignfetish.com/product/1...e-bronze-plan/</a> here is the link. It shows at the bottom of the product pages.

[TheAdminMarket]

http://webdesignfetish.com/product/1/web-maintenance-bronze-plan/ here is the link. It shows at the bottom of the product pages.

1.- Right click is disabled and can't see the code.
2.- Also I can't see anywhere my copyright link

[HM666]

1.- Right click is disabled and can't see the code.
2.- Also I can't see anywhere my copyright link

I did not take out the copyright link. I installed it the way it came I have not edited the copyright link at all. Taht was there before i ungraded as well.

I disabled the product right click mod. Please try again.

Here is the bottom portion of the code for the main template the copyright stuff is still there.

<br />
<script type="text/javascript" src="ecommerce/jquery/skinable_tabs.min.js"></script>
<script type="text/javascript">
$('.tabs_holder').skinableTabs({
effect: 'basic_display',
skin: 'skin4',
position: 'top'
});
</script>
<script type="text/javascript">
$('.tabs_feedback').skinableTabs({
effect: 'basic_display',
skin: 'skin4',
position: 'top'
});
</script>
{vb:raw copyright}
{vb:raw footer}
</body>
</html>

[TheAdminMarket]

I did not take out the copyright link. I installed it the way it came I have not edited the copyright link at all. Taht was there before i ungraded as well.

I disabled the product right click mod. Please try again.

It's missingg the file:
http://webdesignfetish.com/css/lightbox.css

But in general there are duplicated files. eg jquery, lightbox

[HM666]

I have lightbox already installed and working in another area of the site. I moved the files back where it should be and its the same result. And I added the code into my header for the lightbox stuff but I still have the same problem.

[TheAdminMarket]

Here is the bottom portion of the code for the main template the copyright stuff is still there.


Sorry, I uploaded ver.1.8.4 instead 1.8.0
1.8.1+ versions are commercial, so please redownload the zip file and upload just the file:
ecommerce/functions.php

I believe that the page mess will goes out if you remove from ecommerce_view_product template the referrence for lightbox.

Tomorrow (now is 23:00pm here), I'll install this version to see if I've the same issue.

[HM666]

Well that fixed the link :) But i still have a randon ghost loading lightbox :(

[TheAdminMarket]

What I believe that messes your page is that you're calling:

<script src="http://webdesignfetish.com/js/jquery-1.11.0.min.js" type="text/javascript"></script>
<script src="http://webdesignfetish.com/js/lightbox.min.js" type="text/javascript"></script>
<link href="http://webdesignfetish.com/css/lightbox.css" rel="stylesheet" />

most probably at headinclude template, but also:

<link rel="stylesheet" type="text/css" href="ecommerce/lightbox/lightbox.css" />
<script type="text/javascript" src="ecommerce/jquery/jquery-1.10.2.min.js"></script>
<script type="text/javascript" src="ecommerce/jquery/jquery-ui.js"></script>
<script type="text/javascript" src="ecommerce/lightbox/lightbox-2.6.min.js"></script>

from my template. At least as I can see jquery version is different. If lightbox is also different then a mess is mostly possible.

[HM666]

I got this issue fixed. Thanks for your help Christos. :)

[HM666]

Where does the question go when someone asks a question? I cannot find the test question that I submitted anywhere and I did not get an email with it or anything like that. So how do I know when and what someone asked if I cannot get a notification of it?

[TheAdminMarket]

Where does the question go when someone asks a question? I cannot find the test question that I submitted anywhere and I did not get an email with it or anything like that. So how do I know when and what someone asked if I cannot get a notification of it?

Hello Len,

It goes to: $vbulletin->options['webmasteremail'], so to the email address that you've set as Administrator.

An advice from my own experiance. Check your junk mails folder. At least for me all the emails coming from my site goes there as the IP was blacklisted. Now that I change provider I'm receiving them ontime.

[HM666]

Hi Christos, I get the email I had forgot to add the email account to my Thunderbird after a format and reload.

[BenOwns]

Hello,

I cannot get the paypal links to work.
I always get Invalid Redirect URL When trying to check out!

[TheAdminMarket]

Hello,

I cannot get the paypal links to work.
I always get Invalid Redirect URL When trying to check out!

Have you added https://www.paypal.com to the allowed redirection domains? There is a reply for this before.
Admincp-> Settings-> Options-> Site name / URL / Contact details
Add: https://www.paypal.com
To: Redirect Domain Whitelist

[wootriffic]

I've installed it, setup all the configurations i want, however its not showing on my navigation bar.
how do i go about adding this so i can click on the shop from the homepage?

[TheAdminMarket]

I've installed it, setup all the configurations i want, however its not showing on my navigation bar.
how do i go about adding this so i can click on the shop from the homepage?

Have you set usergroup permissions? If not, nobody can see the tab menu.

[wootriffic]

Have you set usergroup permissions? If not, nobody can see the tab menu.

that worked, been ages since i've used vb. feel like a noob all over again lol.

[Johnny G]

Christos, I've messaged you on your own forum. Can you pop a reply over to me please. Thanks.

[akxt660]

Hello!

It works with (http://www.correios.com.br) Brazil Delivery System?

[SaN-DeeP]

This shall be great if you are able to add few (atleast 3 or 5 live/working demo)..
Clients shall be appreciated by a linkback from this official site.. :)

Works great on test installation great work.

[TheAdminMarket]

Hello!

It works with (http://www.correios.com.br) Brazil Delivery System?

You can add any carrier data but manually. There is no API at all.

[TheAdminMarket]

This shall be great if you are able to add few (atleast 3 or 5 live/working demo)..
Clients shall be appreciated by a linkback from this official site.. :)

Works great on test installation great work.

I don't know if I got your meaning but the demo is here:
DEMO: http://demo.teriakis.com/vb4x/cart.php

There are some products with 0 price so you can order one of them to check the client area.

[tpearl5]

believe you have a small bug in functions.php. Both instances of

"&currency_code=

should be

"&amp;currency_code=

Otherwise it turns into ¤cy_code because &curren; is the HTML code for ¤

[TheAdminMarket]

believe you have a small bug in functions.php. Both instances of

"&currency_code=

should be

"&amp;currency_code=

Otherwise it turns into ?cy_code because &curren; is the HTML code for ?

Even if I do agree that the right syntaxt (for many reasons) is to use &amp; instead of &, your report is not valid in the links. Is valid (eg) when you're trying to "echo" something, but in links works fine.

Try it at: http://www.christeris.net/cur.php and you'll see that the link in your browser should be correct. Also this function is in use since my vbDigiShop for vB3 back to 2007 and never had any problem.

[tpearl5]

Also, there is a design flaw when a coupon or discount makes an item free. There is no way to check out and record the order.

[tpearl5]

Even if I do agree that the right syntaxt (for many reasons) is to use &amp; instead of &, your report is not valid in the links. Is valid (eg) when you're trying to "echo" something, but in links works fine.

Try it at: http://www.christeris.net/cur.php and you'll see that the link in your browser should be correct. Also this function is in use since my vbDigiShop for vB3 back to 2007 and never had any problem.

Maybe it depends on a server setting? No matter what I did it would come back with a malformed URL.

[tpearl5]

oh, and one last thing. secondary groups weren't working with item discounts. In cart.php I had to change instances of

in_array($vbulletin->userinfo['usergroupid'],

to

is_member_of($vbulletin->userinfo,

[TheAdminMarket]

Maybe it depends on a server setting? No matter what I did it would come back with a malformed URL.

......hmmmmmmmmmm.......... What to say??...... There are some 100's using it (since 2007), all are accepting PayPal, and nobody had a problem to be redirecting to PayPal with the correct currency code (even me using non USD currency). But seems that all we have that "wrong" server setup.

[TheAdminMarket]

oh, and one last thing. secondary groups weren't working with item discounts. In cart.php I had to change instances of

in_array($vbulletin->userinfo['usergroupid'],

to

is_member_of($vbulletin->userinfo,

Coupons and Discount Usergroups are not parts of my code. Have added by Michael and as I've wrote in the original thread of microCART, I'm letting them there "just in case".
Actually, I don't agree even with the way that coupons are working. It useless feature as they work.

[tpearl5]

Coupons and Discount Usergroups are not parts of my code. Have added by Michael and as I've wrote in the original thread of microCART, I'm letting them there "just in case".
Actually, I don't agree even with the way that coupons are working. It useless feature as they work.

That's okay. It actually works for what I'm doing, so I'm not complaining.

Any ideas on adding a field for "State" for the user info?

[TheAdminMarket]

That's okay. It actually works for what I'm doing, so I'm not complaining.

Any ideas on adding a field for "State" for the user info?

State is "hidden" in locations. What I mean. As States can have different taxes/shipping you must add them in the Locations table (via Admincp). This way you can set different tax/shipping per state.

An example in case that you're working international:

Locations:
United States (Roor category)
--- Alabama
--- Alaska
....etc
Canada (Root category)
--- Ontario
--- Quebec
....etc

EDITED: Other than this, if you need seperate field, just rename the phrase "ecommerce_fax" from "Fax" to "State" and use that field.

[Bastien]

I have searched all the afternoon for a hack like this one !!!

Thank you for sharing, I try it asap. You save me a lot of time :up:

[sadiq6210]

Why I didn't see this mod before 6 months?! Maybe because of the new nickname
Nice to see you again and welcome back Chris

[TheAdminMarket]

Why I didn't see this mod before 6 months?! Maybe because of the new nickname
Nice to see you again and welcome back Chris

Nice to see you again Sadiq, my old friend :) How are you?

This mod was not here before 6 months. As you're old client you maybe remember that I gave microCART and microSUPPORT to another coder who finally left coding behind (at all... not just vB).

When I seen that many user where complaining for some small bugs I got it back and post a bug fix. Later on I decided to improve it by adding new features but I was unable to use the old thread I repost it with new name.

As for my old account, admins here refused to give me back my old account so I had to use a new one.

Christos

[chikuru]

How to setup the shipping fee? It doesnt appear in checkout or even in the cart, though i have selected my shipping location..

[TheAdminMarket]

How to setup the shipping fee? It doesnt appear in checkout or even in the cart, though i have selected my shipping location..

AdminCP-> eCommerce-> Shipping Zones and Rates.
Then when you add a new location you can set which shipping to use for that location. The same applies for Tax.

[chikuru]

https://vborg.vbsupport.ru/external/2015/07/41.png

Still doesnt work.. Can you check? I can provide you admin login..

[TheAdminMarket]

PM Login details and the location for which you've set in the order and does not works.

[TheAdminMarket]

** IMPORTANT **
Also check that in General Setting "Enable Shipping" is active. By default is "No" so you must change it to "Yes".

[chikuru]

** IMPORTANT **
Also check that in General Setting "Enable Shipping" is active. By default is "No" so you must change it to "Yes".

Thanks! I overlooked this one. Its working fine now.. :up:

[TheAdminMarket]

Thanks! I overlooked this one. Its working fine now.. :up:

Two(2) important things to know for ANY vbulletin addon:
1.- Check for possible usergroup permissions
2.- Check carefuly any Settings

Glad that is working now.

[Bastien]

Nick, is this your ecommerce that added this field Donations to my postbit ?

[TheAdminMarket]

Nick, is this your ecommerce that added this field Donations to my postbit ?

Which version are you using? This is on the PRO version which includes Donations. You can turn it off from AdminCP-> Products & Plugins-> Plugins Manager.

But I had and a seperate Donations mod that adds thes same details there.

[Bastien]

1.8.4 but I do not use the PRO version ...

I'll check in plugins to disable this in the postbit ! Thx

[tpearl5]

Thanks for releasing the pro version! Much appreciated!

[DaKirch]

Your website does not work!

[TheAdminMarket]

Your website does not work!

I don't have website anymore as I don't have something to sell. Everything is available for Free here.

But for the demo you're correct. I forgot to setup a demo for this. I'll do it a bit later today.

[michael24179]

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

Where can I see the Pro version. my site is not available

[TheAdminMarket]

Where can I see the Pro version. my site is not available

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.

[DistortionTony]

Is a business paypal forced? I keep getting an invalid redirect when you get to check out.

[TheAdminMarket]

Is a business paypal forced? I keep getting an invalid redirect when you get to check out.

Have you added https://www.paypal.com to the allowed redirection list?
AdminCP-> Settings-> Options-> Site Name / URL / Contact Details
"Redirect Domain Whitelist"

[DistortionTony]

Have you added https://www.paypal.com to the allowed redirection list?
AdminCP-> Settings-> Options-> Site Name / URL / Contact Details
"Redirect Domain Whitelist"

I actually found a typo when i looking at the code. i must have hit the keyboard by mistake around line 1398 in the functions.php

Funny how a simple mistake can take hours to find. :/ Thank you for responding so quickly though

But i do have a question, do we have an option to add a new field to the finalize your order page

[TheAdminMarket]

But i do have a question, do we have an option to add a new field to the finalize your order page
Sorry NO. Currently there is no support for extra fields and don't think that should be any in the near future.

[andy2295]

These warnings appear when working on the categories when adding images

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2859

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2886

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2904

Any ideas?

[TheAdminMarket]

These warnings appear when working on the categories when adding images

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2859

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2886

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2904

Any ideas?

Lot's of ideas :) Just upload the attached file at: ecommerce/includes/ I thought that I've updated the zip file.

[andy2295]

Hi,

Thats the problem sorted. Thanks for the very quick response

[OPsNaStYM0FO]

FIles not uploading to server ... get an error when trying to upload files in admincp.

[OPsNaStYM0FO]

fixed it nm

[Markos]

hi guys

i keep getting this error through email from my database anyone got any ideas

Database error in vBulletin 4.2.3:
Invalid SQL:
UPDATE ecommerce_usercoupon SET valid=0 WHERE userid=;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Request Date : Thursday, September 3rd 2015 @ 08:31:25 AM
Error Date : Thursday, September 3rd 2015 @ 08:31:25 AM
Script : http://www.vx-enthusiast.com/cart_gateway.php?method=paypal
Referrer :
IP Address : 173.0.81.1
Username :
Classname : vB_Database
MySQL Version :

[TheAdminMarket]

hi guys

i keep getting this error through email from my database anyone got any ideas

Database error in vBulletin 4.2.3:
Invalid SQL:
UPDATE ecommerce_usercoupon SET valid=0 WHERE userid=;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Request Date : Thursday, September 3rd 2015 @ 08:31:25 AM
Error Date : Thursday, September 3rd 2015 @ 08:31:25 AM
Script : http://www.vx-enthusiast.com/cart_gateway.php?method=paypal
Referrer :
IP Address : 173.0.81.1
Username :
Classname : vB_Database
MySQL Version :

Please upload this file.

[BGN64]

There isn't any check against an option being selected or not. For example, If a user needs to select a t-shirt size but doesn't it adds it to the cart anyway. Is there any plan to correct this?

[Markos]

Please upload this file.

to the root folder yes

[andy2295]

I have set up a store that has both physical and downloadable items.

The products which are physical have a shipping set up by weight so everything up to 1kg is 3.99 then an increment for every 100g above this.
Tthe download items are also taking the 3.99 shipping on checkout but i want them to have no shipping cost as they are downloads.

How do i do this?

Regards

[euronova]

Hi,
Just installed this and almost have it working, I think it will work well for my site.

1 small issues... I don't get emails when anything is purchased (paypal or bank transfer option)
Emails are enabled and I get the messages when I use the contact form.
Users also aren't receiving any emails when buying items.

Any help appreciated

kind regards

[TheAdminMarket]

Hi,
Just installed this and almost have it working, I think it will work well for my site.

1 small issues... I don't get emails when anything is purchased (paypal or bank transfer option)
Emails are enabled and I get the messages when I use the contact form.
Users also aren't receiving any emails when buying items.

Any help appreciated

kind regards

Hi

Have you set everything at: eCommerce Email Templates and Options (admincp).?

[Gizmo99]

HI Great Hack mate

Now how do you do variations ? ie tshirt S M L XL as one Product ?

Giz

[Gizmo99]

RTFM :)

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.

[vortodox]

Is it possible to filter products that are in stock?

[gundelpfanne]

Hello
I have a small question
Can I change the color of the news ticker ?
Because a white color can be seen as bad,
on a white background :D,
or can i chance the color in the background ?

Best regards
gundelpfanne

[HM666]

Anyone have any ideas how to add tags for a product where someone can search for an item using the built in vBulletin search system?

[HM666]

Hello
I have a small question
Can I change the color of the news ticker ?
Because a white color can be seen as bad,
on a white background :D,
or can i chance the color in the background ?

Best regards
gundelpfanne

1. Login to your AdminCP
2. Go to Styles & Templates > Style Manager > find the style you want to make this change in.
3. Click the drop down menu and choose "Edit Templates".
4. Scroll down in the left side box until you find CSS Templates, double click it to open, now search for the additional.css template and double click it to open.
5. Scroll to the bottom of the template and copy and paste this code into it:
table.marquee {
background:#aaaaaa;
}

Change the hex (red text in code above) info for the color to the color you desire.
6. Click the "Save" button.
7. View in a browser.

[gundelpfanne]

Hello

Thanks ..worked for me.:)

[HM666]

Glad to have been able to help :)

[knikio]

Hi
I really love this mod.
Until now this mode has worked on my server without any problem.
But now when someone click on "Renew your Subscription"
All that he is getting is A "'white screen"
I AM using vb 4.2.3
and eCommerce 2.1.2

Thanks
Knikio

[Dave]

Check the error logs of your webserver/PHP, it's very likely something is causing an internal server error.

[Dragonsys]

Hi
I really love this mod.
Until now this mode has worked on my server without any problem.
But now when someone click on "Renew your Subscription"
All that he is getting is A "'white screen"
I AM using vb 4.2.3
and eCommerce 2.1.2

Thanks
Knikio

did you find anything out on this? I'm having the same issue with all products. Cats display fine, when you select a product, the page shows for a split second, and then it refreshes to a white page. I do not have any errors in the server logs for this.

I did see this when checking with a debugger:
jquery.min.js:103 GET http://www.lonestarcamaro.com/forums/skins/skin4/top.css (anonymous function) @ jquery.min.js:103c.fn.extend.domManip @ jquery.min.js:110c.fn.extend.append @ jquery.min.js:103c.fn.(anonymous function) @ jquery.min.js:110global_loadSkinCss @ skinable_tabs.min.js:6(anonymous function) @ skinable_tabs.min.js:4c.extend.each @ jquery.min.js:30c.fn.c.each @ jquery.min.js:24__global_construct @ skinable_tabs.min.js:4TabSkinsClass @ skinable_tabs.min.js:71$.fn.skinableTabs @ skinable_tabs.min.js:2(anonymous function) @ cart.php?do=viewproduct&productid=1:641
vbulletin-core.js?v=423:11 Firing System Init

The big one being:
GET http://www.lonestarcamaro.com/forums/skins/skin4/top.css

This line is added by this product, yet the file does not exist. I found it referenced in the below templates:
ecommerce_addedit_review
ecommerce_cart
ecommerce_cpanel
ecommerce_download_aera
ecommerce_feedback
ecommerce_main
ecommerce_offline_payment
ecommerce_payment
ecommerce_pay_invoice
ecommerce_preview
ecommerce_thank_you
ecommerce_view_product
ecommerce_view_simple_product

[knikio]

Check the error logs of your webserver/PHP, it's very likely something is causing an internal server error.

Hi
I did not find any errors in my server logs files
I looked in the PHP and the Apache log files

[knikio]

Can someone please confirm to me that the "Renew your Subscription" working properly.
And if so Which version of vbulletin and php do you use.

Thanks
Knikio

[TheAdminMarket]

From today Support will be available as paid service only in my site.
Bug fixes will be still available here.

Regards
Christos

[Dragonsys]

From today Support will be available as paid service only in my site.
Bug fixes will be still available here.

Regards
Christos

Well, that is nice and all, except that your website (http://www.christos.teriakis.com/) doesn't seem to work.
Or do you mean the one in your signature (http://www.iqbulletin.com/)?

[TheAdminMarket]

Well, that is nice and all, except that your website (http://www.christos.teriakis.com/) doesn't seem to work.
Or do you mean the one in your signature (http://www.iqbulletin.com/)?

You're right. The correct is http://www.iqbulletin.com The other will be reconstruct to be my global site as Freelancer for custom work only.

[Dragonsys]

You're right. The correct is http://www.iqbulletin.com The other will be reconstruct to be my global site as Freelancer for custom work only.

Ok, thank you
You should update the Mod description.

The only problem I have is that there is a bug somewhere, mentioned by more than 1 person, and no one has made any comments in regards to it (other than check your logs). I can understand your reasons for doing this support model, but IMO you should at least address this issue, if not troubleshoot/correct it.

I wish you luck, you have made a bunch of great addons.

[watty005]

Hi Guys, has anyone got this to work with vbulletin 4.2.3? I've uploaded all files to the root, as described in the product info section. I have also chmod all files stated to 777. I have also activated the product too, within the navigation manager. What could be the problem? Thanks in advance.

[Dragonsys]

Hi Guys, has anyone got this to work with vbulletin 4.2.3? I've uploaded all files to the root, as described in the product info section. I have also chmod all files stated to 777. I have also activated the product too, within the navigation manager. What could be the problem? Thanks in advance.

I have not been able to, I keep getting white pages. I'm not sure what the difference is between 4.2.2 & 4.2.3 which might be causing it. But I haven't dug into it very deep yet.

[TheAdminMarket]

@watty005
@Dragonsys
----------------
Works fine with 4.2.3 as you can see at: http://www.teriakis.com/423/cart.php

Have you activated SEO urls in cart settings? If yes, have you added the correct code in .htaccess file?

Last reminder:
I'm not offering regular support here. Now I had time and I replied. But this is not a rule.

[Dragonsys]

@watty005
@Dragonsys
----------------
Works fine with 4.2.3 as you can see at: http://www.teriakis.com/423/cart.php

Have you activated SEO urls in cart settings? If yes, have you added the correct code in .htaccess file?

Last reminder:
I'm not offering regular support here. Now I had time and I replied. But this is not a rule.

No, SEO is disabled.
I finally got a chance to look into it more, and it seems to be an issue with my custom style. Everything works fine with the Default style.

I will check more, and see if I can figure it out, otherwise I will check your paid support.

Thanks Nick

[watty005]

@watty005
@Dragonsys
----------------
Works fine with 4.2.3 as you can see at: http://www.teriakis.com/423/cart.php

Have you activated SEO urls in cart settings? If yes, have you added the correct code in .htaccess file?

Last reminder:
I'm not offering regular support here. Now I had time and I replied. But this is not a rule.

Thanks for the quick reply Nick. I've solved my issue, I made a rookie mistake by not enabling admin positions for this mod within the usergroup manager. It's a great mod by the way. :)

[knikio]

From today Support will be available as paid service only in my site.
Bug fixes will be still available here.

Regards
Christos

Hi
I want to purchase a service, but your site is down

[knikio]

Please Help / Support :erm:

[TheAdminMarket]

Please Help / Support :erm:

To support what? Have you post any question and didn't replied? If yes, please post the link.

[knikio]

To support what? Have you post any question and didn't replied? If yes, please post the link.

when someone click on "Renew your Subscription"
All that he is getting is A "'white screen"
I AM using vb 4.2.3
and eCommerce 2.1.2

Thanks
Knikio

[TheAdminMarket]

Already replied here:
http://www.iqbulletin.com/showthread.php?1-Support-for-eCommerce

[PedroMA]

Hi!,

I have problems with the payment. When i click in "Make Payment", an advise appear that said:
"The URL redirection is not valid"

Can you help me?

[PedroMA]

Your website doesn't work :(

[PedroMA]

Finally I can solve it. Whitelist. But sandbox.paypal (test mode) doesn't work. The same for donate option.

[andro140]

Invalid Redirect URL On Paypal Payment

[andro140]

Never mind Added to the whitelist *sits in n00b corner*

[pratul11]

Hi
I am trying to install your mod but I am getting the following Database Error. Can you please help me to resolve it?

Database error in vBulletin 4.2.3:

Invalid SQL:
INSERT INTO `ecommerce_product_types` SET id='1', name='Downloadable', shipping='0', downloads='1';

MySQL Error : Duplicate entry '1' for key 'PRIMARY'
Error Number : 1062
Request Date : Friday, January 13th 2017 @ 06:39:33 AM
Error Date : Friday, January 13th 2017 @ 06:39:34 AM
Script : http://www.occultforums.net/admincp/plugin.php?do=productimport
Referrer : http://www.occultforums.net/admincp/plugin.php?do=productadd
IP Address : 103.10.197.2
Username : DarkAdverts
Classname : vB_Database
MySQL Version : 5.5.52-cll-lve

[pratul11]

Hi
I somehow managed to get past the Database error. But now showing this error while trying to add more categories.

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2792

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2832

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2859

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2886

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2904

[pratul11]

How do I access the store front page after adding products in the back end?

Whenever I am trying to access it from http://www.occultforums.net/cart.php, it says you do not have permission to access this page.

I am the super Admin of the site. What should I do?

[TheAdminMarket]

Really can't understand how some users act here. For something that is mark as "Unsupported" to post 3 messages in forums and on the same time to send them as PM. Not even to wait some hours.

[pratul11]

Hi
I have installed the eCommerce for vB4.2.2+ Mod . I have installed the product in my vBulletin version 4.2.3.
But I am facing a problem here. I have added a Category and products in that category. I am clicking on the product, it is taking me back to the forum homepage. What should I do ? I can't go to the products details page for ordering...
please check the screenshot of the shop in my forum...

https://snag.gy/gYoDNf.jpg

Please help..thanks

[pratul11]

Hello Sorry about this..I was in hurry..
I am looking for some support...i don't know how to contact you for support...so PMed u as your site is not working...
the mod is creating some problems to me during installation. So I thought of uninstalling and reinstalling it...but while uninstalling it, I got this error:

Database error in vBulletin 4.2.3:

Invalid SQL:
DROP TABLE `ecommerce_news`;

MySQL Error : Unknown table 'ecommerce_news'
Error Number : 1051
Request Date : Monday, January 16th 2017 @ 08:09:13 AM
Error Date : Monday, January 16th 2017 @ 08:09:13 AM
Script : http://www.occultforums.net/admincp/plugin.php?do=productkill
Referrer : http://www.occultforums.net/admincp/plugin.php?do=productdelete&productid=ecommerce&s=
IP Address : 103.10.197.4
Username : DarkAdverts
Classname : vB_Database
MySQL Version : 5.5.52-cll-lve

[HM666]

After a little bit of research I have found a fix for the category upload icon issue as mentioned above by pratul11 I too had the same issue so I googled it and found a fix for it. To fix this PHP Warning message:

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2792

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2832

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2859

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2886

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2904

You will need to have a HTML editor. DO NOT USE MS WORD!!! You will need to edit the code within a file to fix this, so if you are not comfy with that then perhaps you should hire someone or ask a friend that is comfy with it....whichever. ALWAYS MAKE A BACK UP OF THE FILE YOU ARE WORKING WITH. :)

Open your /ecommerce/includes/class.upload.php in your HTML editor and look for line 2792 and find:

if (preg_match("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", $this->file_src_mime)) {
$this->file_src_mime = preg_replace("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", '$1/$2', $this->file_src_mime);
$this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Replace it with:

if (preg_match("/^([\w.-]+)\/([\w.-]+)(.*)$/i", $this->file_src_mime)) {
$this->file_src_mime = preg_replace("/^([\w.-]+)\/([\w.-]+)(.*)$/i", '$1/$2', $this->file_src_mime);
$this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Then look for line 2832 and look for this:

if (preg_match("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", $this->file_src_mime)) {
$this->file_src_mime = preg_replace("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", '$1/$2', $this->file_src_mime);
$this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Then replace it with this:

if (preg_match("/^([\w.-]+)\/([\w.-]+)(.*)$/i", $this->file_src_mime)) {
$this->file_src_mime = preg_replace("/^([\w.-]+)\/([\w.-]+)(.*)$/i", '$1/$2', $this->file_src_mime);
$this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Then go to line 2859 and find:

if (preg_match("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", $this->file_src_mime)) {
$this->file_src_mime = preg_replace("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", '$1/$2', $this->file_src_mime);
$this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

And replace it with:

if (preg_match("/^([\w.-]+)\/([\w.-]+)(.*)$/i", $this->file_src_mime)) {
$this->file_src_mime = preg_replace("/^([\w.-]+)\/([\w.-]+)(.*)$/i", '$1/$2', $this->file_src_mime);
$this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Then find line 2886 and find:

if (preg_match("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", $this->file_src_mime)) {
$this->file_src_mime = preg_replace("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", '$1/$2', $this->file_src_mime);
$this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

And replace it with:

if (preg_match("/^([\w.-]+)\/([\w.-]+)(.*)$/i", $this->file_src_mime)) {
$this->file_src_mime = preg_replace("/^([\w.-]+)\/([\w.-]+)(.*)$/i", '$1/$2', $this->file_src_mime);
$this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Then find line 2904 and find:

if (preg_match("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", $this->file_src_mime)) {
$this->file_src_mime = preg_replace("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", '$1/$2', $this->file_src_mime);
$this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

And replace it with:

if (preg_match("/^([\w.-]+)\/([\w.-]+)(.*)$/i", $this->file_src_mime)) {
$this->file_src_mime = preg_replace("/^([\w.-]+)\/([\w.-]+)(.*)$/i", '$1/$2', $this->file_src_mime);
$this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Save the file and upload it overwriting the other file.

Mind you I'm not a PHP coder. I do design, HTML & CSS. So if you have intricate PHP questions I may or may not be able to answer them. But I found this fix and it worked for my site,possibly it will help others.

[pratul11]

Hi All: I have got a new issue. I have uninstalled the mod completely and then tried reinstalling it..now I get the following error:


Database error in vBulletin 4.2.3:

Invalid SQL:
INSERT INTO `ecommerce_product_types` SET id='1', name='Downloadable', shipping='0', downloads='1';

MySQL Error : Duplicate entry '1' for key 'PRIMARY'
Error Number : 1062
Request Date : Friday, January 13th 2017 @ 06:39:33 AM
Error Date : Friday, January 13th 2017 @ 06:39:34 AM
Script : http://www.occultforums.net/admincp/...=productimport
Referrer : http://www.occultforums.net/admincp/...?do=productadd
IP Address : 103.10.197.2
Username : DarkAdverts
Classname : vB_Database
MySQL Version : 5.5.52-cll-lve

Can you please help me how to solve it? Thanks

[HM666]

Hi All: I have got a new issue. I have uninstalled the mod completely and then tried reinstalling it..now I get the following error:


Database error in vBulletin 4.2.3:

Invalid SQL:
INSERT INTO `ecommerce_product_types` SET id='1', name='Downloadable', shipping='0', downloads='1';

MySQL Error : Duplicate entry '1' for key 'PRIMARY'
Error Number : 1062
Request Date : Friday, January 13th 2017 @ 06:39:33 AM
Error Date : Friday, January 13th 2017 @ 06:39:34 AM
Script : http://www.occultforums.net/admincp/...=productimport
Referrer : http://www.occultforums.net/admincp/...?do=productadd
IP Address : 103.10.197.2
Username : DarkAdverts
Classname : vB_Database
MySQL Version : 5.5.52-cll-lve

Can you please help me how to solve it? Thanks

That is because when you uninstalled it did not uninstall the database as well. So basically what that error message is saying is that there was already a value for that table in your database and therefore it cannot install until that value is removed. If you have phpMyAdmin you can go into it and remove that table or the tables associated with the ecommerce module and try to reinstall it again. Just be careful because if you remove the wrong thing it can completely and permanently screw up your forum. Your ecommerce tables will labeled as ecommerce_agreements, ecommerce_cart and so on. Every table that has ecommerce_ in it will belong to this mod. Your tables may have a prefix. It depends on what was done when vBulletin was installed. My prefix is vb4 so an eccomerce table in mine would look like vb4_eccommerce_cart.

[pratul11]

Thanks a lot HM666!

[HM666]

No problem.

[secondeye]

is it still working as DEMO link not working: ttp://www.teriakis.com/vb423/cart.php

[paradoxG(r)eek]

is it still working as DEMO link not working: ttp://www.teriakis.com/vb423/cart.php

Works fine. I'm reconstructing the progress of my work and that domain will be used for Custom work only.

You can read about my vBulletin mods in the middle of my homepage at:
https://www.paradoxbb.com/

Chris
PS: I'm using my secondary account that's why nickname does not match.

[HM666]

is it still working as DEMO link not working: ttp://www.teriakis.com/vb423/cart.php

Yes I have it installed on the latest vb myself.

[Kairete]

A very good plugin. Unfortunately i changed software for my forum but NickTheGreek makes ever good plugins

[EGNDRAGON]

i cant seem to find the actual store.... no nav tab either

[HM666]

i cant seem to find the actual store.... no nav tab either

Go to your forum URL and add cart.php on the end of it. (Example: http://www.yoursite.com/forum/cart.php) You should see the store. As for why the tab did not automatically show I have no idea as your post is pretty vague with no info. I've had no problem with the tab showing up, it should have been automatically installed when you installed the shop. The only thing I can tell you is to make sure that you installed the product properly and that you have uploaded all the files in the proper place.

[EGNDRAGON]

Get error when checking out
Invalid Redirect URL (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=joshuaj181992%40gmail.com&item_name=Shirt+1%2C+&amount=23.30&handling=0&shipping=0.00&tax=0.00&quantity=1?cy_code=USD&return=http%3A%2F%2Fegnxclan.net%2Fcart.php&item_number=EGN TwIsTiD-17Apr17-QCLV6YEHF327?ify_url=http%3A%2F%2Fegnxclan.net%2Fc art_gateway.php%3Fmethod%3Dpaypal)

[paradoxG(r)eek]

Get error when checking out
Invalid Redirect URL (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=joshuaj181992%40gmail.com&item_name=Shirt+1%2C+&amount=23.30&handling=0&shipping=0.00&tax=0.00&quantity=1?cy_code=USD&return=http%3A%2F%2Fegnxclan.net%2Fcart.php&item_number=EGN TwIsTiD-17Apr17-QCLV6YEHF327?ify_url=http%3A%2F%2Fegnxclan.net%2Fc art_gateway.php%3Fmethod%3Dpaypal)

It has been replied at least 5 times before. Is wise to read before asking.

In anycase is a vB setting. You must add PayPal in the allowed domain redirects.
admincp-> Settings-> Options-> Site Name / URL / Contact Details-> Redirect Domain Whitelist

Add: https://www.paypal.com

[EGNDRAGON]

Works thanks

[knikio]

Can anyone confirm if the "Renew your Subscription" option Works or not.
Thanks

[Trip3151]

Awesome plugin thanks for your hard work :)

[Player-63]

Will this work with vB 3.8.x?

[pewpewlizards]

Will this work with vB 3.8.x?

It's for 4.2.2+ as it says lol.