Forums / General Questions / block checkout page about error min0 unit0

block checkout page about error min0 unit0

Views: 899

Results 1 to 9 of 9
10 Mar 2014, 4:08 PM
#1
salvo72 avatar

salvo72

New Zenner

Join Date:
Feb 2013
Posts:
45
Plugin Contributions:
0

block checkout page about error min0 unit0

hello

despite I set the values ​​to the appropriate field products_quantity_mixed to "1", I always lock to an error page chekout precisely relative to this field inthe shopping cart page

from where i can edit the script and delete this control in shopping cart page?

thanks

11 Mar 2014, 3:25 AM
#2
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

Re: block checkout page about error min0 unit0

It's advisable to fix the cause of the error not remove the control. Can you provide the error?

Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
June 7.2026 - NOW AVAILABLE - Twitch Base8 - Obsidian

11 Mar 2014, 8:31 AM
#3
salvo72 avatar

salvo72

New Zenner

Join Date:
Feb 2013
Posts:
45
Plugin Contributions:
0

Re: block checkout page about error min0 unit0

twitchtoo:

It's advisable to fix the cause of the error not remove the control. Can you provide the error?

ok

I dont access to checkout page for the error in the attachment file...

I realized that using easy populate the field products_quantity_mixed was set to 0

I proceeded to change the value of the field on the db, now the value is to 1, but I always get the error ....

What is most strange if I enter the product in admin and upgrade (without changing the data) that solves the problem and the product goes into the shopping cart and then at checkout!!

in the file attachements it visible any product ok and any product whith problem (Biscotti integrali.kg1..) , if i oen the product in admin en resave the page , the problem on shopping cart is resolved!!

ps: excuse for my english im italianAttachment 13880

11 Mar 2014, 1:21 PM
#4
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

Re: block checkout page about error min0 unit0

The problem is with Easy Populate not setting all of the switches for the product. You open the product in admin and the default radio buttons/values are set then recorded when you save the product and like you said each product magically works.

I spent some time trying to catch this exact error, the fix is to set the missing switches related to the product quantity.

There are some options depending on how you've got your cart setup but the important ones are:

  • Products Quantity Box Shows = 0
  • Product Qty Minimum = 1
  • Product Qty Maximum = 0
  • Product Qty Units = 1
  • Product Qty Min/Unit Mix = 1

The value settings above fix the problem and hide the annoying min/max display.

To achieve this I set the switches with these SQL statements:

update products set products_qty_box_status = 0;

update products set products_quantity_order_min = 1;

update products set products_quantity_order_max = 0;

update products set products_quantity_order_units = 1;

update products set products_quantity_mixed = 1;

Be sure to backup your SQL before you run them.

Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
June 7.2026 - NOW AVAILABLE - Twitch Base8 - Obsidian

11 Mar 2014, 3:30 PM
#5
salvo72 avatar

salvo72

New Zenner

Join Date:
Feb 2013
Posts:
45
Plugin Contributions:
0

Re: block checkout page about error min0 unit0

ok thanks

but why

update products set products_qty_box_status = 0; ??

if i open the product in admin , i see the settings as described..... ifi simply saved the product the error in cart is resolved!!!!

but whit product_quantity_box_status = 1 !

11 Mar 2014, 3:49 PM
#6
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

Re: block checkout page about error min0 unit0

The problem is with Easy Populate not setting the switches to 1 or 0 appropriately for all records.

So if you'd like your products to show the quantity box use this:
update products set products_qty_box_status = 1;

then run these:
update products set products_quantity_order_min = 1;

update products set products_quantity_order_max = 0;

update products set products_quantity_order_units = 1;

update products set products_quantity_mixed = 1;

What's happening when you open a product is the product_info and preview php are writing the switch position to the database. The SQL code above will correct all of the records and the next time you open a product in admin everything will be correct.

Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
June 7.2026 - NOW AVAILABLE - Twitch Base8 - Obsidian

11 Mar 2014, 3:56 PM
#7
salvo72 avatar

salvo72

New Zenner

Join Date:
Feb 2013
Posts:
45
Plugin Contributions:
0

Re: block checkout page about error min0 unit0

ok it's ok

i solved!!! thanks

and a new update of product whith easy populate i can setting the field in object ?..., because i dont whant repeat this operation at any update or upgrade of products

11 Mar 2014, 4:02 PM
#8
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

Re: block checkout page about error min0 unit0

I don't know what will happen the next time you use Easy Populate, you'll have to test it and see, but now you have the code to fix it. I'm guessing the field data needs to be reported as an error/missing in the Easy Populate forum related to the version you're currently using.

Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
June 7.2026 - NOW AVAILABLE - Twitch Base8 - Obsidian

11 Mar 2014, 4:56 PM
#9
salvo72 avatar

salvo72

New Zenner

Join Date:
Feb 2013
Posts:
45
Plugin Contributions:
0

Re: block checkout page about error min0 unit0

ok tanks