cancel
Showing results for 
Search instead for 
Did you mean: 

how to configure delivery method in OMS

Former Member
0 Kudos
232

I have setup b2c store and configured delivery mode,country,zone,base store to place order and order placed successfully. In delivery-modes impex file, data is inserted into ZoneDeliveryMode model.

When enable OMS in b2c module , order can not placed due to delivery method is not coming.

I observed this result.

DefaultOmsCountryZoneDeliveryModeDao

SELECT DISTINCT {zdm:pk} FROM { OmsZoneDeliveryModeValue AS val JOIN ZoneDeliveryMode AS zdm ON {val:deliveryMode}={zdm:pk} JOIN ZoneCountryRelation AS z2c ON {val:zone}={z2c:source} JOIN ZoneCountryRelation AS z2f ON {val:fromZone}={z2f:source} JOIN BaseStore2DeliveryModeRel AS s2d ON {val:deliveryMode}={s2d:target} } WHERE {val:currency}=?currency AND {z2c:target}=?deliveryCountry AND {z2f:target}=?shipFromCountry AND {s2d:source}=?store AND {zdm:net}=?net AND {zdm:active}=?active

This above flexible query return empty result.

I think that OmsZoneDeliveryModeValue should get data of parent model ZoneDeliveryMode. Flexible query should get data of ZoneDeliveryMode model. it should return result.

deployment is not defined for OmsZoneDeliveryModeValue model.so data of OmsZoneDeliveryModeValue is stored in deployment of ZoneDeliveryMode.

Any help will be appreciated.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Yashpal, ZoneDeliveryMode and ZoneDeliveryModeValue are from different hierachy (ZoneDeliveryModeModel->DeliveryModeModel->ItemModel and ZoneDeliveryModeValueModel->ItemModel) so you have to insert data in ZoneDeliveryModeValue (OmsZoneDeliveryModeValue) too, sample example from delivery-modex.impex

For UK

NSERT_UPDATE ZoneDeliveryModeValue ; deliveryMode(code)[unique=true] ; zone(code)[default='uk'][unique=true] ; currency(isocode)[unique=true] ; value ; minimum[unique=true] ; premium-gross ; ; $ukCurrency ; 10,99 ; 0,00

Please refer delivery-modex.impex

Former Member
0 Kudos

which version of oms? Is this for version before 5.7 ? i cannot find DefaultOmsCountryZoneDeliveryModeDao in 6.0

Former Member
0 Kudos

yes. hybris version is 5.5.1.1 .