Skip to content

Instantly share code, notes, and snippets.

@paugnu
Created June 14, 2019 06:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save paugnu/1eb7045d660ebe61e51987554e3a1450 to your computer and use it in GitHub Desktop.
Save paugnu/1eb7045d660ebe61e51987554e3a1450 to your computer and use it in GitHub Desktop.
Owebia configuration for product shipping restriction
{
"envio_AD": {
"label": "Andorra",
"description": "Envío normal Andorra",
"shipto": "AD",
"conditions": "{skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:5.5100,10.0100:5.5100,15.0100:6.9200,20.0100:8.0000,25.0100:10.4500,30.0100:11.3400,35.0100:11.3400,40.0100:11.3400,45.0100:11.3800,50.0100:12.4100,60.0100:13.4400,70.0100:15.5000,80.0100:17.5700,90.0100:19.3000,100.0100:21.0200,110.0100:22.7500,120.0100:27.0700,130.0100:27.0700,140.0100:31.3900,150.0100:31.3900,160.0100:35.7100,170.0100:35.7100,180.0100:39.0800,190.0100:39.0800,10000.0000:39.0800}"
},
"envio_EU1": {
"label": "Países: AT, BG, CH, CY, CZ, DK, EE, FI, GR, HU, IE, IS, IT, LI, LT, LU, LV, MC, MT, NO, PL, RO, SK, SI, SE",
"description": "Envío normal",
"shipto": "AT, BG, CH, CY, CZ, DK, EE, FI, GR, HU, IE, IS, IT, LI, LT, LU, LV, MC, MT, NO, PL, RO, SK, SI, SE",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:26.1000,10.0100:33.5640,15.0100:39.5160,20.0100:46.9560,25.0100:54.3960,30.0100:61.8360,35.0100:78.7320,40.0100:85.8360,45.0100:92.9400,50.0100:100.0440,60.0100:114.2520,70.0100:128.4600,80.0100:142.6680,90.0100:156.8760,100.0100:171.0840,125.0100:185.2920,150.0100:199.5000,175.0100:233.5200,200.0100:267.5400,10000.01:301.5600}"
},
"envio_BE": {
"label": "Bélgica",
"description": "Envío normal",
"shipto": "BE",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:13.7520,10.0100:15.0960,15.0100:17.2800,20.0100:20.0040,25.0100:22.7280,30.0100:25.4520,35.0100:36.2520,40.0100:39.5640,45.0100:42.8760,50.0100:46.1880,60.0100:52.8120,70.0100:59.4360,80.0100:66.0600,90.0100:72.6840,100.0100:79.3080,125.0100:85.9320,150.0100:96.3000,175.0100:110.1600,200.0100:124.0200,10000.01:137.8800}"
},
"envio_EU2": {
"label": "Países BA, GE, MK, RS",
"description": "Envío normal",
"shipto": "BA, GE, MK, RS",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:54.0600,10.0100:59.9400,15.0100:72.2040,20.0100:87.5280,25.0100:102.8520,30.0100:118.1760,35.0100:145.2840,40.0100:154.3680,45.0100:163.4520,50.0100:172.5360,60.0100:190.7040,70.0100:208.8720,80.0100:227.0400,90.0100:245.2080,100.0100:263.3760,125.0100:281.5440,150.0100:313.0560,175.0100:361.0560,200.0100:409.0560,10000.01:457.0560}"
},
"envio_CA": {
"label": "Canadá",
"description": "Envío normal",
"shipto": "CA",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 0.5010:25.1460,1.0010:31.4820,1.5010:40.4030,2.0010:49.3240,2.5010:58.2450,3.0010:67.1660,3.5010:76.0870,4.0010:85.0080,4.5010:93.9290,5.0010:93.9290,5.5010:93.9290,6.0010:93.9290,6.5010:93.9290,7.0010:93.9290,7.5010:93.9290,8.0010:93.9290,8.5010:93.9290,9.0010:93.9290,9.5010:93.9290,10.0010:93.9290,15.0010:140.0410,20.0010:187.1870,25.0010:234.3330,30.0010:281.4790,35.0010:318.9890,40.0010:356.5100,45.0010:394.0310,50.0010:431.5520,55.0010:469.0730,60.0010:506.5940,65.0010:544.1150,70.0010:581.6360,75.0010:619.1570,80.0010:656.6780,85.0010:694.1990,90.0010:731.7200,95.0010:769.2410,100.0010:806.7620,105.0010:844.2830,110.0010:881.8040,115.0010:934.7470,120.0010:973.2910,125.0010:1011.8350,130.0010:1051.4130,135.0010:1090.9910,140.0010:1129.7000,145.0010:1170.1470,150.0010:1209.7250,155.0010:1249.3030,160.0010:1288.8810,165.0010:1328.4590,170.0010:1368.0370,175.0010:1407.6150,180.0010:1447.1930,185.0010:1486.7710,190.0010:1526.3490,195.0010:1565.9270,10000.01:1605.5050}"
},
"envio_DE": {
"label": "Alemania",
"description": "Envío normal",
"shipto": "DE",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:17.6520,10.0100:19.4040,15.0100:21.5880,20.0100:24.3240,25.0100:27.0600,30.0100:29.7960,35.0100:43.7040,40.0100:47.2680,45.0100:50.8320,50.0100:54.3960,60.0100:61.5240,70.0100:68.6520,80.0100:75.7800,90.0100:82.9080,100.0100:90.0360,125.0100:97.1640,150.0100:108.3840,175.0100:126.1440,200.0100:143.9040,10000.01:161.6640}"
},
"envio_EG": {
"label": "Egipto",
"description": "Envío normal",
"shipto": "EG",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:104.6900,10.0100:139.8100,15.0100:163.4400,20.0100:187.0680,25.0100:199.7100,30.0100:211.1235,35.0100:222.5475,40.0100:233.9610,45.0100:246.3930,50.0100:256.2945,60.0100:280.2810,70.0100:306.0750,80.0100:369.8750,90.0100:433.6700,100.0100:497.4700,125.0100:550.7700,150.0100:604.1000,175.0100:657.4300,200.0100:710.7600,10000.01:764.0900}"
},
"envio_ES": {
"label": "España Península",
"description": "Envío normal península",
"shipto": "ES-(07*,38*,35*,51*,52*)",
"conditions": "{cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:4.9500,10.0100:5.1100,15.0100:7.0900,20.0100:8.0900,25.0100:9.0900,30.0100:10.0900,35.0100:11.2100,40.0100:12.3200,45.0100:13.4400,50.0100:14.5600,60.0100:16.8000,70.0100:19.0300,80.0100:20.9000,90.0100:22.7800,100.0100:24.6500,110.0100:24.6500,120.0100:29.3300,130.0100:29.3300,140.0100:34.0100,150.0100:34.0100,160.0100:38.6900,170.0100:38.6900,180.0100:38.6900,190.0100:42.3400,200.0100:42.3400,10000.01:50.0000}"
},
"envio_ES_baleares": {
"label": "España - Baleares",
"description": "Envío normal Baleares",
"shipto": "ES(07*)",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 1.0100:8.0500,2.0100:8.5500,3.0100:9.0500,4.0100:9.5500,5.0100:10.0500,10.0100:13.0100,15.0100:16.9600,20.0100:20.5100,25.0100:24.0600,30.0100:30.0300,35.0100:31.8200,40.0100:37.2800,45.0100:37.2800,50.0100:37.2800,60.0100:37.2800,70.0100:37.2800,80.0100:37.2800,90.0100:37.2800,100.0100:37.2800,110.0100:39.9000,120.0100:42.5300,130.0100:45.1500,140.0100:47.7800,150.0100:50.4000,160.0100:53.0300,170.0100:55.6500,180.0100:58.2800,190.0100:60.9000,200.0100:63.5300,400.0100:98.3900,750.0100:159.3900,1000.0100:185.3300,10000.01:200.0000}"
},
"envio_ES_ceutamelilla": {
"label": "España - Ceuta y Melilla",
"description": "Envío normal Ceuta y Melilla",
"shipto": "ES(51*,52*)",
"conditions": "{skus_es_only.conditions} && {skus_es_gi_ad.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 1.0100:17.5100,2.0100:17.5100,3.0100:18.9100,4.0100:18.9100,5.0100:18.9100,10.0100:19.9400,15.0100:22.4600,20.0100:84.7000,25.0100:84.7000,30.0100:84.7000,35.0100:84.7000,40.0100:84.7000,45.0100:84.7000,50.0100:84.7000,60.0100:84.7000,70.0100:84.7000,80.0100:84.7000,90.0100:84.7000,100.0100:84.7000,110.0100:84.7000,120.0100:84.7000,130.0100:84.7000,140.0100:94.0500,150.0100:97.3900,160.0100:100.1300,170.0100:102.3400,180.0100:106.1800,190.0100:109.2200,200.0100:111.9500,400.0100:191.2100,750.0100:300.4600,1000.0100:347.9300,10000.01:347.9300}"
},
"envio_ES_canarias": {
"label": "España - Canarias",
"description": "Envío normal Islas Canarias",
"shipto": "ES(35*,38*)",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 1.0100:8.0000,4.0100:11.3700,10.0100:18.4100,15.0100:29.6900,20.0100:36.0600,50.0100:53.9000,170.0100:71.9000,180.0100:72.1400,190.0100:73.4300,200.0100:75.1500,400.0100:126.5300,750.0100:220.0800,10000.01:275.5500}"
},
"envio_FR": {
"label": "Francia",
"description": "Envío normal",
"shipto": "FR",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:16.7640,10.0100:18.5640,15.0100:20.7600,20.0100:23.4960,25.0100:26.2320,30.0100:28.9680,35.0100:42.7920,40.0100:46.3560,45.0100:49.9200,50.0100:53.4840,60.0100:60.6120,70.0100:67.7400,80.0100:74.8680,90.0100:81.9960,100.0100:89.1240,125.0100:96.2520,150.0100:102.3480,175.0100:120.1080,200.0100:137.8680,10000.01:155.6280}"
},
"envio_GB": {
"label": "Gran Bretaña",
"description": "Envío normal",
"shipto": "GB",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:18.7560,10.0100:20.5920,15.0100:22.8840,20.0100:25.7520,25.0100:28.6200,30.0100:31.4880,35.0100:45.4080,40.0100:49.4760,45.0100:53.5440,50.0100:57.6120,60.0100:65.7480,70.0100:73.8840,80.0100:82.0200,90.0100:90.1560,100.0100:98.2920,125.0100:106.4280,150.0100:119.3160,175.0100:137.1360,200.0100:154.9560,10000.01:172.7760}"
},
"envio_GI": {
"label": "Gibraltar",
"description": "Envío normal",
"shipto": "GI",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:5.5100,10.0100:5.5100,15.0100:6.9200,20.0100:8.0000,25.0100:10.4500,30.0100:11.3400,35.0100:11.3400,40.0100:11.3400,45.0100:11.3800,50.0100:12.4100,60.0100:13.4400,70.0100:15.5000,80.0100:17.5700,90.0100:19.3000,100.0100:21.0200,110.0100:22.7500,120.0100:27.0700,130.0100:27.0700,140.0100:31.3900,150.0100:31.3900,160.0100:35.7100,170.0100:35.7100,180.0100:39.0800,190.0100:39.0800,10000.01:39.0800}"
},
"envio_NL": {
"label": "Países Bajos (Holanda)",
"description": "Envío normal",
"shipto": "NL",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:16.1040,10.0100:17.7120,15.0100:19.8960,20.0100:22.6320,25.0100:25.3680,30.0100:28.1040,35.0100:38.9760,40.0100:42.4200,45.0100:45.8640,50.0100:49.3080,60.0100:56.1960,70.0100:63.0840,80.0100:69.9720,90.0100:76.8600,100.0100:83.7480,125.0100:90.6360,150.0100:101.3400,175.0100:115.2600,200.0100:129.1800,10000.01:143.1000}"
},
"envio_PT": {
"label": "Portugal",
"description": "Envío normal Portugal",
"shipto": "PT-(92*,96*)",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:4.9500,10.0100:6.9000,15.0100:11.1400,20.0100:13.1900,25.0100:17.0400,30.0100:18.6100,35.0100:20.7600,40.0100:22.9100,45.0100:25.0600,50.0100:27.2100,60.0100:31.0600,70.0100:34.9100,80.0100:38.9600,90.0100:42.8100,100.0100:46.6700,110.0100:46.6700,120.0100:46.6700,130.0100:55.8900,140.0100:65.1100,150.0100:65.1100,160.0100:74.3400,170.0100:74.3400,180.0100:83.5600,190.0100:92.7800,200.0100:102.0100,400.0100:139.0000,750.0100:227.6000,10000.01:273.4200}"
},
"envio_PT_islas": {
"label": "Portugal - Açores y Madeira",
"description": "Envío normal Portugal - Açores/Madeira",
"shipto": "PT(92*,96*)",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions} && {cart.free_shipping}!='true'",
"fees": "{table {cart.weight} in 5.0100:23.9910,10.0100:29.9760,15.0100:34.8960,20.0100:41.0400,25.0100:47.1840,30.0100:46.0400,35.0100:67.3680,40.0100:71.1960,45.0100:75.0240,50.0100:78.8520,60.0100:86.5080,70.0100:94.1640,80.0100:101.8200,90.0100:109.4760,100.0100:117.1320,125.0100:124.7880,150.0100:136.0440,175.0100:154.1040,200.0100:172.1640,400.0100:250.0000,750.0100:343.0000,10000.01:420.0000}"
},
"envio_US": {
"label": "Estados Unidos",
"description": "Envío normal USA",
"shipto": "US",
"conditions": "{skus_es_ct_ml_ad.conditions} && {skus_es_gi_ad.conditions} && {skus_es_only.conditions}",
"fees": "{table {cart.weight} in 0.5010:25.1460,1.0010:31.4820,1.5010:40.4030,2.0010:49.3240,2.5010:58.2450,3.0010:67.1660,3.5010:76.0870,4.0010:85.0080,4.5010:93.9290,5.0010:93.9290,5.5010:93.9290,6.0010:93.9290,6.5010:93.9290,7.0010:93.9290,7.5010:93.9290,8.0010:93.9290,8.5010:93.9290,9.0010:93.9290,9.5010:93.9290,10.0010:93.9290,15.0010:140.0410,20.0010:187.1870,25.0010:234.3330,30.0010:281.4790,35.0010:318.9890,40.0010:356.5100,45.0010:394.0310,50.0010:431.5520,55.0010:469.0730,60.0010:506.5940,65.0010:544.1150,70.0010:581.6360,75.0010:619.1570,80.0010:656.6780,85.0010:694.1990,90.0010:731.7200,95.0010:769.2410,100.0010:806.7620,105.0010:844.2830,110.0010:881.8040,115.0010:934.7470,120.0010:973.2910,125.0010:1011.8350,130.0010:1051.4130,135.0010:1090.9910,140.0010:1129.7000,145.0010:1170.1470,150.0010:1209.7250,155.0010:1249.3030,160.0010:1288.8810,165.0010:1328.4590,170.0010:1368.0370,175.0010:1407.6150,180.0010:1447.1930,185.0010:1486.7710,190.0010:1526.3490,195.0010:1565.9270,10000.01:1605.5050}"
},
"recoger": {
"label": "Recogida países América del Sur",
"description": "Recogida en Brildor",
"shipto": "MX,AR",
"fees": "0"
},
"skus_es_ct_ml_ad": {
"conditions": "({count items where product.attribute.sku=='036110'} < 1) && ({count items where product.attribute.sku=='036342'} < 1) && ({count items where product.attribute.sku=='034217'} < 1) && ({count items where product.attribute.sku=='034287'} < 1) && ({count items where product.attribute.sku=='034286'} < 1) && ({count items where product.attribute.sku=='034229'} < 1) && ({count items where product.attribute.sku=='035326'} < 1) && ({count items where product.attribute.sku=='034219'} < 1) && ({count items where product.attribute.sku=='036112'} < 1) && ({count items where product.attribute.sku=='034220'} < 1) && ({count items where product.attribute.sku=='034215'} < 1) && ({count items where product.attribute.sku=='034212'} < 1) && ({count items where product.attribute.sku=='034213'} < 1) && ({count items where product.attribute.sku=='034214'} < 1) && ({count items where product.attribute.sku=='034211'} < 1) && ({count items where product.attribute.sku=='034995'} < 1) && ({count items where product.attribute.sku=='035205'} < 1) && ({count items where product.attribute.sku=='035206'} < 1) && ({count items where product.attribute.sku=='035207'} < 1) && ({count items where product.attribute.sku=='035208'} < 1) && ({count items where product.attribute.sku=='035281'} < 1) && ({count items where product.attribute.sku=='034216'} < 1)"
},
"skus_es_gi_ad": {
"conditions": "({count items where product.attribute.sku=='003465'} < 1) && ({count items where product.attribute.sku=='033339'} < 1) && ({count items where product.attribute.sku=='033340'} < 1) && ({count items where product.attribute.sku=='033341'} < 1) && ({count items where product.attribute.sku=='033342'} < 1)"
},
"skus_es_only": {
"conditions": "({count items where product.attribute.sku=='036684'} < 1) && ({count items where product.attribute.sku=='034284'} < 1) && ({count items where product.attribute.sku=='034090'} < 1) && ({count items where product.attribute.sku=='034073'} < 1) && ({count items where product.attribute.sku=='034520'} < 1) && ({count items where product.attribute.sku=='035339'} < 1) && ({count items where product.attribute.sku=='000919'} < 1) && ({count items where product.attribute.sku=='000920'} < 1) && ({count items where product.attribute.sku=='000921'} < 1) && ({count items where product.attribute.sku=='000922'} < 1) && ({count items where product.attribute.sku=='000923'} < 1) && ({count items where product.attribute.sku=='003395'} < 1) && ({count items where product.attribute.sku=='035603'} < 1) && ({count items where product.attribute.sku=='003198'} < 1) && ({count items where product.attribute.sku=='032642'} < 1) && ({count items where product.attribute.sku=='003397'} < 1) && ({count items where product.attribute.sku=='028196'} < 1) && ({count items where product.attribute.sku=='028200'} < 1) && ({count items where product.attribute.sku=='028206'} < 1) && ({count items where product.attribute.sku=='028205'} < 1) && ({count items where product.attribute.sku=='028210'} < 1) && ({count items where product.attribute.sku=='028209'} < 1) && ({count items where product.attribute.sku=='028203'} < 1) && ({count items where product.attribute.sku=='028204'} < 1) && ({count items where product.attribute.sku=='028211'} < 1) && ({count items where product.attribute.sku=='028212'} < 1) && ({count items where product.attribute.sku=='028217'} < 1) && ({count items where product.attribute.sku=='028219'} < 1) && ({count items where product.attribute.sku=='028218'} < 1) && ({count items where product.attribute.sku=='028221'} < 1) && ({count items where product.attribute.sku=='028224'} < 1) && ({count items where product.attribute.sku=='028227'} < 1) && ({count items where product.attribute.sku=='028228'} < 1) && ({count items where product.attribute.sku=='028229'} < 1) && ({count items where product.attribute.sku=='028220'} < 1) && ({count items where product.attribute.sku=='028225'} < 1) && ({count items where product.attribute.sku=='028226'} < 1) && ({count items where product.attribute.sku=='032657'} < 1) && ({count items where product.attribute.sku=='028234'} < 1) && ({count items where product.attribute.sku=='028233'} < 1) && ({count items where product.attribute.sku=='028231'} < 1) && ({count items where product.attribute.sku=='028213'} < 1) && ({count items where product.attribute.sku=='003193'} < 1) && ({count items where product.attribute.sku=='003194'} < 1) && ({count items where product.attribute.sku=='003195'} < 1) && ({count items where product.attribute.sku=='003197'} < 1) && ({count items where product.attribute.sku=='003398'} < 1) && ({count items where product.attribute.sku=='003396'} < 1)"
},
"free_shiping": {
"label": "Envío gratis",
"conditions": "{cart.free_shipping}=='true'",
"fees": 0
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment