161 comments found.
Any intergration with Houzez theme ?
Hi Georgeach, I have done some work with integrating the houzez theme, if you can create a support ticket with what features of it your are using i might be able to help.
James
If a field equals 0 then data “blank”, what’s a command to clear the field if the import data is 0 I dont want it to put 0 I want it to clear whats in the current field, ie woocommerce sale price is not on sale any more it needs to clear the current price make it blank so it doesn’t 0 prices.
HI, it sounds like you want to use the field map option, set it to if it equals 0 then set it to return nothing. https://www.importwp.com/docs/template-fields/#mapping-fields
Yes I’m mapping but those instructions don’t help, I want it to clear the the data that WooCommerce already has in the sale field, so if the price is now not on sale if I leave the field blank it will not delete the sale price on WooCommerce it will keep the sale price as is, if I have it as 0 the product will go on sale for $0, there is no way to just clear the sale price when the import is 0 so if 0 clear sale price data to be blank
Thanks, Let me get back to you on this.
I have tested this locally, if i import a product with a price of 10 and a sale of 1, if i then import the product again with an empty sale price it clears the sale and sets it back to 10.
If this is not the case can you create a ticket https://www.importwp.com/support/ so i can get some more information about your setup such as importer config, and importer data file
ok did you do this with mapping or just a blank field CSV? I need to do it with mapping ie if equals “1” or “0” then “blank”. It can’t be a CSV with blank fields the mapping needs to authorise the blank empty field on WooCommerce.
I did this with both when i tested earlier, please create a ticket to make this easier
Hi, a pre-sale question here.
I’m working with “Directories Pro – Directory plugin for WordPress” to create Custom Post Type. This plugin uses its own field manager.
Do you know if ImportWP Pro is compatible with this tool?
Cedrik
Hi,
I am unsure as i have never used that plugin before, but if Directories pro uses the post meta table to store its fields data then it should work.
James
Hi, a pre-sale question here. Does the plugin support xprofiele fields from buddpress?
Hi, i have not compe across the plugin “xprofiele” before, but if the plugin stores data in the usermeta table then it should be able to import to it.
James
I have a WP multisite. Will this plugin allow me to assign users to a particular subsite when importing them? Will it allow me to map all custom user meta fields? Thanks.
Hi, just to update this comment, yes Import WP can import users into a WP multisite, an issue was fixed when importing users into a wp multisite, if they existed already on another site within the network it now adds them to the current network site allowing their data to be modified: https://helpdesk.importwp.com/ticket/de9b51e7-60ab-4e52-98a8-453da294c47e/
work your plugin with scf?
is scf the plugin wordpress cloned from acf? if so it should work as i think its the same codebase.
Hello, I notice your docs suggest Exporting is limited to post types, taxonomies, or users.
Is it possible to export everything, including ACF fields? I want to be able to modify/add posts and ACF repeater fields in a spreadsheet and then re-import.
Thanks
Hi bn86,
Sorry for the delay in the response, the exporter will export all data in the postmeta, usermeta, and term meta tables, which is where acf data is stored.
James
Hello. Is that possible to ask you to have a better compatibility with Directories Pro? I’ve been working with it but when importing Custom Fields of it, WP Import doesn’t properly read them. I don’t know why they appear as [object Object].
Hi Rafaelzrt,
can you create a support ticket https://www.importwp.com/support/, with all the required files and setup required to replicate your [object Object] issue and i can look into this for you.
James
What is the easiest way to bulk edit posts? Is it possible by syncing / auto update feature using Google sheets?
Hi, you cant sync with google sheets, but you can set schedule an importer to run and import your changes hourly from google sheets.
James
Hello,
Is it possible to use your plugin to export posts with custom fields created by ACF and import them to another website into posts with custom fields created by Pods?
Hello,
You can export data from acf fields, when exporting media make sure you export the url / not the id of the media file, this way it can be imported into another website.
Yes, if you install the https://www.importwp.com/integrations/pods/ addon you should be able to import the exported content.
James
Ok that sounds great!
One more question. As far as I understand from your reply that I’ll use your plugin to export from the old website and import to the new website.. Does that mean I’ll need a separate plugin license for each website or should 1 license be enough?
Note: both websites will have the same domain name, but during the staging phase the new website will be on a subdomain.
If they have the same domain, then i would presume they are the same site and automatic updates will work with the same key: https://www.importwp.com/docs/automatic-updates/ , (if you need further clarification i would recommend contacting envato / codecanyon as they handle licensing / payments).
Hello!
1) Can i add a video uploaded by Media Library with the namefile in the CVS file automatically?
2) Can i place this video after some other field in the body of the post page?
Best regards!
Hi Marcoqwerty,
1. Yes you can media from the media library by name from a csv or xml file.
2. How is the video added to the post page, is this part of the post content or a custom field, or something else? Are you importing the body content or just the video?
James
Hi;
if I have an Woocommerce shop with custom Meta boxes and custom Meta fields made in JetEngine, can I use ImportWP PRO to import products data (including custom meta boxes data) from a .CSV file?
Hi,
If you install the jet engine addon https://www.importwp.com/integrations/jet-engine/ and https://www.importwp.com/integrations/import-woocommerce-products/ you can easily import data into JetEngine fields with ImportWP PRO.
James
Can this import 80,000 product records quickly on an Enterprise level server? Any way to test this first, some others hand or fail over and over again?
Hi Ingenuitor,
Is products a custom post type or from a plugin such as WooCommerce?
James
We’re encountering a significant issue with importing WooCommerce products using WP All Import, thus looking for something else. The process is currently taking nearly a day to complete from end to end, and it’s even skipping some products despite being configured to include all of them. Ideally, we need this import to be completed in 15 minutes or less. Any suggestions or strategies to achieve this level of efficiency would be greatly appreciated.
If you are looking for the import to complete in 15 minutes to woocommerce, you would have to find an importer that imports directly into your website using SQL or write something custom, since your looking at import about 90 products a second if any of these had images then you would also need to include the processing time of images and generating image sizes.
Import WP does not offer direct SQL imports because it uses the built in woocommerce insert/update functions to increase compatability with all woocommerce plugins and themes that extend woocommerce.
For reference the https://www.importwp.com/integrations/import-woocommerce-products/ addon works with the free version of this plugin https://wordpress.org/plugins/jc-importer/ and should allow you to see the speed, but i would guess its nowhere near close to what you require.
Out of curiosity would you be able to provide the 80k csv/xml file to see what you are trying to import (if so could you create a private support ticket: https://helpdesk.importwp.com/create-ticket/).
James
Your question made me have a look into the speed of importing to woocommerce, on a fresh wordpress / woocommerce install.
Running a very basic import script outside of the plugin, including of a while loop, WC_Product_Query to find if a product exists using an sku, and if that product exists update or insert a new one, only setting the product name , sku and price.
On a fresh install with 0 products: 1k row csv import took 2 minutes @ 8.1 products per second 10k row csv import took 33 minutes @ 4.9 products per second
On a fresh install with 10k existing products: 1k row csv import took 4 minutes @ 4.1 products per second.
From this i could estimate 80k rows would take a minimum of 4.5 hours, but as you can see the more records in the database the longer the import takes, and alot longer if you were to also import images, attributes, taxonomies.
This was not on a dedicated vps, just my development machine using @wordpress/env so timings will differ.
Final update to finish this research, benchmarks have been updated to include the same data but run on parallel processes to speed up the time, all run via wp-cli (need to figure a way to run via cron and ajax to be a viable solution):
Products | Time, 5000 | 2m, 10000 | 4m, 20000 | 12m, 30000 | 22m, 40000 | 36m, 50000 | 54m
Based on the decrease in speed 80k records would take ~90 minutes , but this could change depending on the specs of your server and the number of processes that can be ran in parallel.
Overall this seems promising and if it keeps its speed when handling product attributes, taxonomies, and more product information this approach may be merged into the import plugin in the future.
Hello, these findings are very interesting, and thank you for your efforts. It seems the issue may be related to the reliance on the command line to avoid speed-related overhead, limiting the ability to run parallel processes efficiently.
A key factor in making this ecosystem effective is the ability to manage data efficiently and import/export it quickly and accurately. We know this is possible, as we’ve successfully implemented similar solutions in other software; it’s simply a matter of applying the same approach here.
To simplify the process and minimize complexity, we’re considering tools like Google Sheets. However, a significant challenge is finding an efficient way to run multiple parallel processes, especially with a direct REST API connection. We cannot afford any process to take longer than 15 minutes, regardless of the tool used.
Any delays beyond that would make the solution impractical for real-world use, particularly in environments with large sites where data changes rapidly.
We’ll also need to carefully monitor date/time updates for each row to prevent data collisions, ensuring that the most recent update is always synchronized bidirectionally.
Hi, plz help. step 4 Something went wrong
Hi Sergey_BA,
Can you create a ticket here: https://helpdesk.importwp.com/create-ticket/, can you also attach your server error log, and the version numbers of any ImportWP (latest: v2.14.0), ImportWP Pro (latest: v2.11.0), and any ImportWP Plugins installed.
Thanks James
On Wordpress it Shows there is an Update. But i can only Download here Version: 2.10.1 Not 2.10.2
Hi PermiumLizenz, I am almost ready to publish another version greater than v2.10.2 of importwp pro, which is why i am waiting to get this finalized before uploading to codecanyon, in the meantime you can update to 2.10.2 from within wordpress.
James
Hello! Is it possible in someway with your plugin to Export Posts and Import them as a Custom Post Type? I tried that but didn’t worked, when trying to Import I get a message warning that it is not the same custom post type.
When importing, if you select the new custom post type when creating the importer this should import them into the new cpt.
Oh it worked, thank you very much. I tried again and it only worked when I used .csv. It didn’t worked using .json
Is the any possible way to add Product URL to export so I can make my own feeds?
Hi YoYoMobi,
I have had a look at the ImportWP WooCommerce and there should be an option to export the product url of external products.
James
Is there a way to import lines from Google sheets as individual form submissions in formidable forms?
Hi sjbas, without a custom intigration it is not possible, i have added this to the possible feature requests list.
James
Well if this becomes a reality ill be a buyer!
Hello, I’m currently looking for an alternative to wp all import PRO and that’s when I came across your plugin. I’ve already tested it so far and would possibly buy the Pro. However, I need the following functions that I haven’t found yet.
1. Is it possible to set the product as an external product with the Woocomerce Adon? I sometimes receive affiliate products that I do not sell myself and a link to the retailer must be created directly. At Woocomerce this is hidden under the “Product data” field and then under “External product / affiliate product”. This is possible with other plugins, but I haven’t found a way to set this with yours.
2. Do I need the ability to update the data at certain intervals via cron job or automatically. For example, the data should be checked and updated every 11 p.m. Is this possible?
Hi,
Sorry for the delay, i am just back after a short vacation.
The importwp woocommerce addon allows you to import all core woocommerce product types which include the external product type, the field you are looking for is found under the “product url” field: https://www.importwp.com/docs/import-woocommerce-products-from-csv-xml/#importing-woo-commerce-external-affiliate-products-data , yes you should be able to schedule a daily import to run at 11pm, more information on scheduling imports can be found here: https://www.importwp.com/docs/how-to-schedule-an-importer/
James
I am using JetEngine and have a repeater field called Screenshots, under that I’ve Navigation, Desktop and Mobile, to upload different screenshot items. Will this cause an issue with the plugin, from reading the other comments you mention nesting might be the issue, just wanted to make sure this is ok. Thanks in advance.
Hi musuko, The Import WP Jet engine addon should allow you to import fields on a repeater field. The plugin cant handle when repeater fields are nested inside others which from your description does not sound like you have that.
