News:

Support the VirtueMart project and become a member

Main Menu

All shipment rule are not display

Started by Timoune974, September 18, 2019, 15:29:14 PM

Previous topic - Next topic

Timoune974

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

Timoune974

#1
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.

GJC Web Design

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Timoune974

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

GJC Web Design

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Timoune974

Same issuer with

1054 Champ 'c.virtuemart_shoppergroup_id' inconnu dans field list

Perhaps I missed something during the update procedure ?

aLioneL

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

GJC Web Design

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

aLioneL

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