I have an issue with my shipping rules
I have 7 shipping rules
1) shop delivery => no zip code and no fees
2) delivery for zip code 97410 =>
a) min zip code 97410
b) max zip code 97410
c) fees 8 euros
3) delivery for zip code 97432=>
a) min zip code 97432
b) max zip code 97432
c) fees 8 euros
4) delivery for zip code 97430 =>
a) min zip code 9730
b) max zip code 97430
c) fees 8 euros
5) delivery for zip code 97429 =>
a) min zip code 97429
b) max zip code 97429
c) fees 8 euros
6) delivery for zip code 97442 =>
a) min zip code 97442
b) max zip code 97442
c) fees 8 euros
7) delivery for zip code 97480 =>
a) min zip code 97480
b) max zip code 97480
c) fees 8 euros
The shipping rules is working fine in the basket until the client add product in the basket without logging in and log after to valid his basket. and after that the display is wrong all time ...
I put my site in debug mode and i can see the shipping rules was correctly evaluate.
For this test the client postcode is 97410 and the shipment validation is true for the 2 rights rules
<div class="alert-message"><span class="vmdebug" >12 vmdebug shipmentmethod Retrait Magasin = TRUE for variable weight = 1250 Reason: no boundary conditions set</span></div>
<div class="alert-message"><span class="vmdebug" >13 vmdebug shipmentmethod Retrait Magasin = TRUE for variable order amount = 119 Reason: no boundary conditions set</span></div>
<div class="alert-message"><span class="vmdebug" >14 vmdebug shipmentmethod Retrait Magasin = TRUE for variable zip = 97410 Reason: no boundary conditions set</span></div>
<div class="alert-message"><span class="vmdebug" >15 vmdebug shipmentmethod Retrait Magasin = TRUE for variable virtuemart_country_id = 174, Reason: Countries in rule or none set</span></div>
<div class="alert-message"><span class="vmdebug" >16 vmdebug shipmentmethod Livraison Interne Express Saint Pierre 1 = TRUE for variable weight = 1250 Reason: no boundary conditions set</span></div>
<div class="alert-message"><span class="vmdebug" >17 vmdebug shipmentmethod Livraison Interne Express Saint Pierre 1 = TRUE for variable order amount = 119 Reason: no boundary conditions set</span></div>
<div class="alert-message"><span class="vmdebug" >18 vmdebug shipmentmethod Livraison Interne Express Saint Pierre 1 = TRUE for variable zip = 97410 Reason: is within Range of the condition from 97410 to 97410</span></div>
<div class="alert-message"><span class="vmdebug" >19 vmdebug shipmentmethod Livraison Interne Express Saint Pierre 1 = TRUE for variable virtuemart_country_id = 174, Reason: Countries in rule or none set</span></div>
But the "Livraison Interne Express Saint Pierre" is not display
<tr class="sectiontableentry1" valign="top">
<td colspan="4" align="left">
<h4>Mode de livraison sélectionné</h4> <span class="vmshipment_name">Retrait Magasin</span><span class="vmshipment_description">Retrait dans notre Magasin sur Petite Ile sur Rendez-Vous en nous contactant au 06 93 55 64 94
Pour les autres modes de livraison vous devez renseigner une adresse de livraison.</span> </td>
<td align="right" class="cart-hide"><span class='priceColor2'></span> </td>
<td align="right" class="cart-hide"></td>
<td align="right">
<div class="badge inline"></div> </td>
</tr>
The entire page code is in the attached zip file.
If someone have an idea about the mistake
For information my versions are
Joomla! 3.9.11 Stable
VirtueMart 3.6.0 10113
And I already tryed the solution give in "Topic: Shipping or Payment Method Not Showing?"
I think the problem is coming with the virtuemart version 3.6 because during all my test in 3.4 all are working fine.
There is a problem with some shipping methods on VM3.6.0
please try ( on a non production site) the bug fix http://dev.virtuemart.net/attachments/download/1185/com_virtuemart.3.6.1.10152_package_or_extract.zip
Hello,
I installed the patch and I have now the following error message when I try to edit a product.
1054 Champ 'c.virtuemart_shoppergroup_id' inconnu dans field list
In the front end I have the same message when I try to add a product in the basket.
Regards
3.6.2 is released
http://dev.virtuemart.net/attachments/1187/com_virtuemart.3.6.2.10155.zip
Same issuer with
1054 Champ 'c.virtuemart_shoppergroup_id' inconnu dans field list
Perhaps I missed something during the update procedure ?
Bonjour,
I've got the same error message than Timoune974
#1054 Unknown column 'c.virtuemart_shoppergroup_id' in 'field list'
but just after upgrade to VM3.6.2.10.159 today
Thanks by advance for your help ;-)
LioneL
you need to further debug this so we can help .. find the function that is calling this
http://forum.virtuemart.net/index.php?topic=117042.0
reBonjour,
Je viens de trouver la solution ;-)
J'ai comparé les tables mysql '_virtuemart_customs'
celle de mon vm avec celle de vm3.6.2 :
dans mon vieux vm3.6.1, il y avait "custom_field_desc", qui n'existait plus dans vm3.6.2
que j'ai donc remplacé par "virtuemart_shoppergroup_id" qui m'etait manquant
(j'ai utilisé phpMyAdmin)
et Alleluia !!!! tout refonctionne :-)
Merci encore a celles et ceux qui se sont penché(e)s sur mon soucis
Amicalement,
LioneL