News:

Support the VirtueMart project and become a member

Main Menu

Shipping methods not showing

Started by Lepsi, May 20, 2015, 10:52:49 AM

Previous topic - Next topic

Lepsi

Hi, i have a very frustrating problem.

I have 2 different shipping methods. Standard shipping and express shipping. For each one i have a few rules. E.g weight 0-0.5kg, 0.51kg - 1kg etc. Also for each method and weight rule i have countries also. e.g there is a method for standard delivery 0 - 0.5kg, European countries, standard delivery 0 - 0.5kg, Asian countries, express delivery 0 - 0.5kg, European countries, standard delivery 0 - 0.5kg, Asian countries and one of each with no countries selected for the people that don't fit in the other rules.

I have set weight to all of my products. I unchecked auto select shipping method (although it doesn't work even if checked), i have set all standard shipping methods order display to 1 and to express shipping to 2.

So, at checkout, when i click to select a shipping method nothing shows up. This is driving me crazy. I spent a lot of hours trying to figure out whats wrong but i found out nothing.

Is there anyone who could help me out to figure it? Thanks in advance.

AH

Turn on debugging in admin/configuration

then see what your shipping results show

Regards
A

Joomla 4.4.5
php 8.1

Lepsi

#2
thanks for the fast reply. turned on debugging. what am i looking for now?

AH

You are looking to see what the shipping method results show when you are in the cart

You should see what rules are being seen and why they are not being selected based on the cart data and the shipping settings
Regards
A

Joomla 4.4.5
php 8.1

Lepsi

Found the following from the database queries but doesn't seem to help.

SELECT SQL_CALC_FOUND_ROWS *
  FROM `h0vr8_virtuemart_shipmentmethods_en_gb` as l JOIN `h0vr8_virtuemart_shipmentmethods` USING (`virtuemart_shipmentmethod_id`)
  ORDER BY ordering DESC
  LIMIT 0, 20
SELECT FOUND_ROWS()
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "20"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "20"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "21"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "21"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "22"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "22"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "23"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "23"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "24"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "24"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "25"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "25"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "26"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "26"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "27"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "27"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "28"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "28"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "29"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "29"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "30"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "30"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "31"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "31"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "32"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "32"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "33"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "33"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "34"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "34"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "35"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "35"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "36"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "36"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "37"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "37"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "38"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "38"
SELECT `virtuemart_shoppergroup_id`
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE `virtuemart_shipmentmethod_id` = "39"
SELECT virtuemart_shoppergroup_id
  FROM h0vr8_virtuemart_shipmentmethod_shoppergroups
  WHERE virtuemart_shipmentmethod_id = "39"