Woocommerce Table Rate Shipping import/export function
I’d love to see an import/export function in “Woocommerce Table Rate Shipping”.
It is very useful for developers. Sometimes, we have to fill hundreds of shipping prices.
With an export/import function, i could easily copy my configuration from a site to another one.
Current Status
Open
Last updated: November 14, 2013
62 comments
Log in to comment on this feature request.
This is really required, we have around 10,000 Value and this could not be done manually.
oh yeah, lets eliminate manual legwork… upload a csv file and tadahhh!
This would be great to be able to do this
Yep, I would kill for this.
This is really necessary given the complexity of zoning and shipping rates. For instance if you offer three shipping methods where the shipping company or post zones are not consistent for a country you have to enter a table multiple times for each scenario. For instance in Thailand there are only three air mail zones but there are 15 Express Mail Zones. So if a country is in regular air mail zone 2 along with 50 other countries – the other countries in regular zone 2 may span 9 Express mail zones. That means the same table for regular Zoe 2 has to be entered 9 different times. Better still would bve to allow rate tables to be used across zones. A customer can only be in one zone so you are forced to make as many zones as your most complex shipping method, which is fine, but then you have to enter the easier zone rate tables under each individual zone – not efficient
Has this been added?
Yeap, totally need this! really handy feature.
Add an import/export function to replicate configuration in multiple sites
this. please!
To export and reimport, simply export and reimport those tables:
wp_woocommerce_shipping_zones
wp_woocommerce_shipping_zone_locations
wp_woocommerce_shipping_zone_shipping_methods
wp_woocommerce_shipping_table_rates
Dimitri
This would be amazing. I deal with winery clients that have complex shipping setups based on the fulfillment they use. The nice thing is there are only a couple of fulfillment options so I can copy all of the table rate shipping setup from one to the other. Import/export would save a huge amount of time.
I agree
Entering and/or changing table rates is so time consuming for my clients! An importer would be great.
i copy every comment to add this feature
‘@ Dimitri ,thanks so much, your sql guide worked like a charm and saved me hours,thanks mate!
Is there still an import function?
Or AT LEAST duplicate a zone or table. This is crazy!!!
PLEASE give us import / export! Entering all this manually is beyond ridiculous. And then to have to edit every one again when prices change? Surely there’s a solution! Especially given the cost of the plugin.
I’m keen on this too. Mostly to have as a backup as on one of my sites the settings seem to keep getting reset after an update, so it takes at least 2 hours to reconfigure the settings. Booo.
I agree, with 128 votes + so far, an import/export and duplicate feature is needed. Manually entry in some cases is not efficient or practical.
I’m inclined to agree with comments below about the price we pay for TRS. It’s premium and there should and import/export.
Yes, I can export the SQL data but my client can’t in case he needs to be able to reinstate tables.
I’ve experienced “pickled” TRS after updates which is frustrating because customers find it rather than the developer.
Now we have Shipping Zones coming in Woo 2.6 I’m somewhat nervous about my days and days of work being destroyed in one fell swoop after update!
So, yes, a bit vote up for this.
I tried the db table export and import from my staging to my production site and it didn’t fully work. In particular, when editing the table rates for a particular shipping method the Shipping Classes in the dropdown menus have all been set to Any Class instead of the specific class corresponding to each line in the table. Any ideas why this happened?
Hard to believe this had never been addressed in all the votes this has been getting over 4 years now.
Really neeeded, how can they charge top dollar for a plugin that requires so much manual work, c’mon guys.
Yes, we can export sql tables but how many “real clients” are able to do that – they work on TRS as well? It’s a useful idea and we keep multiple backups so we always have the shipping tables but a quick export/import feature would be so much better!
Any feedback on whether this is likely to happen? We are doing weekly freight costing report and would love being able to export, make any changes required and import.
Import/export feature should be basic…like wheels are for the cars.
Hi guys.
I created a simple plugin for this task – https://wordpress.org/plugins/wc-shipping-rates-importer/
You can import AND export shipping zone and table rate shipping data with this plugin.
I don’t have the premium plugin and just based the import/export logic from Dimitri’s post regarding the 4 tables needed to be imported/exported. Let me know what you guys think and and feedback is very much appreciated.
This would be great!
I would also like to see this for the Flat Rate Boxes shipping plugin. Actually for everything that you manually have to enter/configure in the Shipping tab of Woocommerce.
This is defiitely much needed. Also to be able to duplicate table rate shipping from one zone to another!
Cannot believe such a simple request is still not fulfilled.
I want this too! Please!
Export globally shipping zone settings and reimport them into an other website ? Definitely a must-have
Yes, please include it in the plugin!
Yes, please.
good idea
any progress/ response?
i m struggling from this task i have to integrate table rate shipping method in Woocommerce RestAPI is it any blog or any one can show me the way how can integrate Tablerate shipping method in rest api . So that my invoice generate correct according to the shipping tax class
Ill implement this now. so sick of this missing feature
Would be great to have the ability to export and import shipping rates to csv.
Any progress ?
Looks like the import/export shipping method links have been added, but whenever I try to export, I just get a red “error” message in the middle of the screen. Does anyone know the CSV format so I can make one manually?
I read that the import function has been added to the plugin, but I just purchased the table Rate shipping plugin and can’t find any option to import. HOW is it done?
This is stupid to have such a plugin that is dependent on data to have to manually enter and not be able export data from it. it should be in the base of the plugin to be able to import and export data
Any progress on the csv import and export of shipping rates?
Yes that would be definitly in
I second that idea!
This is such an absurdly basic requirement – I wan’t my $99 bucks back until this is added.
SOO dumb that it’s not part of the core plugin from the very beginning.
7 years on, no action. Maybe in another 7 years hey WC? Just keep taking peoples money and don’t bother after that.
Yes please
Perhaps this can help someone:
http://rynaldo.com/how-to-import-and-export-your-woocommerce-shipping-zones-methods-and-rates-from-one-site-to-another/
Still not added? this should be a basic feature
Please implement this! I’m about to spend several hours doing this very error-prone operation by hand on multiple sites!
Any update on this?? It really should be a basic feature.
This feature is available with this plugin: https://jem-products.com/how-to-import-export-shipping-rates-into-woocommerce/
This is a basic feature and it’s still not done, sigh
This has been raised since 2013 and it’s STILL not been implemented?!?
I think it might be nice if it was.
Nice post, Thanks for this information. I really appreciate the kind of topics you post here. Thanks for sharing with us great information that is actually helpful. I posted some helpful links can you check it for a second?
https://www.companycontactdetail.com/yogi-adityanath-email-id/
https://www.companycontactdetail.com/vijay-devarakonda-phone-number/
https://www.companycontactdetail.com/kiccha-sudeep-phone-number-2/
https://www.companycontactdetail.com/mukesh-ambani-email-id/
Sweta……..
It would be very helpful for clients. Thanks for sharing the information.
http://www.landscaping-santaclarita.com
It would be very helpful for clients. Thanks for sharing the information.
https://lunchtimeresult.net/
Thanks for clear the WooCommerce Table Rate Shipping import / export function deeply its helps altos for my website to activating the function
https://thailottery.today/thai-lottery-results/
https://thailottery.today/
Dimitri’s answer works – use PHP admin to export these tables from the site you want to copy the shipping tables.
Then, in PHP admin simply import them into the new website’s database. After that you need to ‘Drop’ the existing tables and change the table prefix of the imported 4 tables to match the new database.
It really is pretty easy. So why the plugin couldn’t do this I don’t know. But Woocommerce aren’t very good at taking feedback and acting on it in my experience. They get very defensive.
To export and reimport, simply export and reimport those tables:
wp_woocommerce_shipping_zones
wp_woocommerce_shipping_zone_locations
wp_woocommerce_shipping_zone_shipping_methods
wp_woocommerce_shipping_table_rates
An update on my March 11th comment:
Using this method many of the Method Titles were not imported for some reason. Instead they displayed as ‘Table Rate’. This was not a problem where labels for the front end had been specified, but where they were not ‘Table Rate’ would be seen by customers. it is also unhelpful on the back end. I manually edited the Method Titles – not ideal but not too time-consuming for this store.