[TheAdminMarket]

Originally Posted by 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_ga...?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]

Originally Posted by NickTheGreek

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]

Originally Posted by 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

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 ,
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]

Originally Posted by 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 ,
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:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

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