Royal meaning in relationship.Enjoy Free 888+200 Daily Legal Bonus

Resolved

(@javibg6z)

Hi everyone!

We’re setting up our website and using Woocommerce for our services. I’m looking for a way to bulk add shipping zones to Woocommerce.

To put you in context, our service is a leisure experience with transportation service. So, we offer clients Experiences, and they can configure whether they will be picked up and left at home afterwards, only picked up, or they can go by their own.

So, for the transportation, we’ve used the shipping feature. It works perfect for our case, but we have to configure a lot shipping zones, with several options each of them (same options, but prices vary).

I haven’t been able to find a way to bulk add them. I have them all in an excel file, and it would be great to be able to do so.

Here are two screenshots:

1. Prices, zones, postal codes table
https://drive.google.com/file/d/1oNYnGNiDT8JgI8jI_aLV34GSET8o7xkw/view?usp=sharing

2. Shipping configuration for 1 zone
Shipping options per zone

Thanks in advance for your help!
Javier


### WordPress Environment ###

WordPress address (URL): https://uncover.city
Site address (URL): https://uncover.city
WC Version: 5.4.1
REST API Version: ? 5.4.1
WC Blocks Version: ? 5.1.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 2.3.1
Log Directory Writable: ?
WP Version: 5.7.2
WP Multisite: –
WP Memory Limit: 511 MB
WP Debug Mode: –
WP Cron: ?
Language: es_ES
External object cache: ?

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.20
PHP Post Max Size: 256 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.4.20-MariaDB-1:10.4.20+maria~focal-log
Max Upload Size: 256 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.4.1
WC Database Prefix: wp_
Tama?o total de la base de datos: 260.10MB
Tama?o de los datos de la base de datos: 253.21MB
Tama?o del índice de la base de datos: 6.89MB
wp_woocommerce_sessions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_woocommerce_api_keys: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_attribute_taxonomies: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_woocommerce_downloadable_product_permissions: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
wp_woocommerce_order_items: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_woocommerce_order_itemmeta: Datos: 0.05MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_tax_rates: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
wp_woocommerce_tax_rate_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_woocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_woocommerce_payment_tokens: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_woocommerce_payment_tokenmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_actionscheduler_actions: Datos: 0.08MB + índice: 0.11MB + Motor InnoDB
wp_actionscheduler_claims: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_actionscheduler_groups: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_actionscheduler_logs: Datos: 0.06MB + índice: 0.03MB + Motor InnoDB
wp_commentmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_comments: Datos: 0.05MB + índice: 0.09MB + Motor InnoDB
wp_ewwwio_images: Datos: 0.14MB + índice: 0.11MB + Motor InnoDB
wp_ewwwio_queue: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_extCCFA_fields: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_extCCFA_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_e_submissions: Datos: 0.02MB + índice: 0.27MB + Motor InnoDB
wp_e_submissions_actions_log: Datos: 0.02MB + índice: 0.11MB + Motor InnoDB
wp_e_submissions_values: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_gf_draft_submissions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_gf_entry: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_gf_entry_meta: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
wp_gf_entry_notes: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_gf_form: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_gf_form_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_gf_form_revisions: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_gf_form_view: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_gf_rest_api_keys: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_jet_apartment_bookings: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_jet_apartment_units: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_jet_appointments: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_jet_appointments_excluded: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_jet_post_types: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_jet_reviews: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_jet_review_comments: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_jet_review_guests: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_jet_review_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_jet_review_types: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_jet_taxonomies: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_links: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_litespeed_cssjs: Datos: 69.52MB + índice: 0.13MB + Motor InnoDB
wp_litespeed_img_optm: Datos: 0.11MB + índice: 0.06MB + Motor InnoDB
wp_litespeed_img_optming: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
wp_ms_snippets: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_options: Datos: 5.03MB + índice: 0.50MB + Motor InnoDB
wp_postmeta: Datos: 92.45MB + índice: 2.89MB + Motor InnoDB
wp_posts: Datos: 83.42MB + índice: 0.45MB + Motor InnoDB
wp_smush_dir_images: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_snippets: Datos: 0.03MB + índice: 0.00MB + Motor InnoDB
wp_termmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_terms: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_term_relationships: Datos: 0.03MB + índice: 0.02MB + Motor InnoDB
wp_term_taxonomy: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_usermeta: Datos: 0.11MB + índice: 0.03MB + Motor InnoDB
wp_users: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
wp_wc_admin_notes: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB
wp_wc_admin_note_actions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wc_bookings_availability: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wc_bookings_availabilitymeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_wc_booking_relationships: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_wc_category_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wc_customer_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_wc_download_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_wc_order_coupon_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_wc_order_product_lookup: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
wp_wc_order_stats: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
wp_wc_order_tax_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_wc_product_meta_lookup: Datos: 0.02MB + índice: 0.09MB + Motor InnoDB
wp_wc_reserved_stock: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wc_webhooks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wfblockediplog: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wfblocks7: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
wp_wfconfig: Datos: 0.09MB + índice: 0.00MB + Motor InnoDB
wp_wfcrawlers: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wffilechanges: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wffilemods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wfhits: Datos: 0.09MB + índice: 0.05MB + Motor InnoDB
wp_wfhoover: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wfissues: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
wp_wfknownfilelist: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wflivetraffichuman: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wflocs: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wflogins: Datos: 0.06MB + índice: 0.03MB + Motor InnoDB
wp_wfls_2fa_secrets: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wfls_settings: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wfnotifications: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wfpendingissues: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
wp_wfreversecache: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wfsnipcache: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
wp_wfstatus: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_wftrafficrates: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_woobe_history: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
wp_woobe_history_bulk: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_yoast_indexable: Datos: 0.06MB + índice: 0.08MB + Motor InnoDB
wp_yoast_indexable_hierarchy: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
wp_yoast_migrations: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_yoast_primary_term: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_yoast_seo_links: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB

### Post Type Counts ###

acf-field: 4
acf-field-group: 2
attachment: 121
bookable_resource: 4
customize_changeset: 3
elementor_library: 35
elementor_snippet: 8
jet-engine-booking: 1
jet-smart-filters: 1
jet-woo-builder: 5
nav_menu_item: 26
page: 34
post: 52
postman_sent_mail: 53
product: 18
product_variation: 10
revision: 2327
shop_coupon: 1
shop_order: 20
wc_booking: 17

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (28) ###

Query Monitor: por John Blackbourn – 3.7.1
Advanced Custom Fields PRO: por Elliot Condon – 5.9.7
Cloudflare: por Cloudflare
Inc. – 4.5.1

Code Snippets: por Code Snippets Pro – 2.14.1
Yoast Duplicate Post: por Enrico Battocchi & Team Yoast – 4.1.2
Dynamic Content for Elementor: por Dynamic.ooo – 1.15.4
Elementor Connector for WooCommerce Bookings: por WPExtend – 1.0.1
Elementor Pro: por Elementor.com – 3.3.1
Elementor: por Elementor.com – 3.2.5
Essential Addons for Elementor - Pro: por WPDeveloper – 4.3.8
Essential Addons for Elementor: por WPDeveloper – 4.7.3
Flexible Checkout Fields PRO: por WP Desk – 3.0.6
Flexible Checkout Fields: por WP Desk – 3.0.10
Imsanity: por Exactly WWW – 2.7.2
JetTabs For Elementor: por Crocoblock – 2.1.12
LiteSpeed Cache: por LiteSpeed Technologies – 3.6.4
Post SMTP: por Yehuda Hassine – 2.0.23
Advanced Editor Tools (previously TinyMCE Advanced): por Automattic – 5.6.0
BEAR - Bulk Editor and Products Manager: por realmag777 – 1.0.8.1
Shipping Method Display Style for WooCommerce: por theDotstore – 3.7.2
WooCommerce Bookings Filters: por Codup – 1.2.0.12
WooCommerce Bookings: por WooCommerce – 1.15.40
Editor de campos de pago de WooCommerce: por WooCommerce – 1.6.1
WooCommerce Email Customizer: por WooCommerce – 1.1.19
WooCommerce Stripe Gateway: por WooCommerce – 5.2.3
WooCommerce: por Automattic – 5.4.1
Wordfence Security: por Wordfence – 7.5.4
Yoast SEO: por Equipo Yoast – 16.5

### Inactive Plugins (0) ###

### Dropin Plugins (2) ###

db.php: Query Monitor Database Class
object-cache.php: object-cache.php

### Must Use Plugins (1) ###

Elementor Safe Mode: por Elementor.com – 1.0.0

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: booking (booking)
external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Base de la tienda: ? Página sin definir
Carrito: ? Página sin definir
Finalizar compra: ? La página no contiene el shortcode [woocommerce_checkout] o el bloque woocommerce/checkout.
Mi cuenta: ? Página sin definir
Términos y condiciones: ? Página sin definir

### Theme ###

Name: Hello Elementor Child
Version: 1.0.1
Author URL: https://elementor.com/
Child Theme: ?
Parent Theme Name: Hello Elementor
Parent Theme Version: 2.3.1
Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
WooCommerce Support: ?

### Templates ###

Overrides: hello-theme-child-master/woocommerce/cart/cart-shipping.php
hello-theme-child-master/woocommerce/checkout/form-checkout.php
hello-theme-child-master/woocommerce/checkout/form-shipping.php
hello-theme-child-master/woocommerce/checkout/review-order.php
hello-theme-child-master/woocommerce/emails/customer-completed-order.php
hello-theme-child-master/woocommerce/emails/email-styles.php
hello-theme-child-master/woocommerce/single-product/add-to-cart/variable.php

### Action Scheduler ###

Complete: 147
Oldest: 2021-05-27 18:16:47 +0000
Newest: 2021-06-25 11:00:48 +0000

### Status report information ###

Generated at: 2021-06-25 12:07:01 +00:00

The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)

Plugin Support con
(@conschneider)

Engineer

3 years, 9 months ago

Hi there,

I haven’t been able to find a way to bulk add them. I have them all in an excel file, and it would be great to be able to do so.

This is the best resource for this task that I know: https://rynaldo.com/how-to-import-and-export-your-woocommerce-shipping-zones-methods-and-rates-from-one-site-to-another/

Kind regards,

Thread Starter javibg6z
(@javibg6z)

3 years, 8 months ago

Hi! Thanks a lot for that resource! It has helped a lot!

There is still a piece of the puzzle missing!

Now i’m able to bulk add locations, postal codes, and i can create several shipping methods for each location, but i cannot configure those shipping methods.

The solution mentioned covers updating 3 woocommerce tables, there should be one more that defines those shipping methods’ names, prices, etc, as seen in this screenshot:

Shipping options per zone

Any further ideas??
Thanks a lot for the help so far!
Javier

Plugin Support con
(@conschneider)

Engineer

3 years, 8 months ago

Hi there,

Shipping method settings are stored in wp_options. For example:

Settings: https://d.pr/i/Nz1i5E
Database: https://d.pr/i/GjDX1C

The data will be serialized: https://wp-staging.com/serialized-data-wordpress-important/

Kind regards,

Plugin Support abwaita a11n
(@abwaita)

3 years, 8 months ago

Hi @javibg6z,

We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, the above info was helpful!

If you have further questions, please feel free to open a new topic.

Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Bulk add Woocommerce shipping zones’ is closed to new replies.

Tags