Documentation, Knowledge Base, Product Import Export Plugin for WooCommerce, WooCommerce
Importing Post ID Conflicts with an Existing Post ID : WooCommerce Product Import Export
The Best Product Import Export Plugin for WooCommerce
#1 in WordPress Official Plugin Repository With 50,000+ Active Installs
#1 in Customer Satisfaction With Most 5 Star Reviews
WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product
Buy Now!During an import, if you are updating existing product data, then do not forget to check the Update existing products tick box. Otherwise, it will generate the error of an existing ID.
Also, if the ID used in the CSV is not a product ID in the site to which it is imported to, then it can generate a conflict. For every product, WordPress creates a unique ID. It’s not just the products that are given unique IDs. They are given to tags, comments, categories, pages, and user ID as well to identify that particular item. All these are stored in WordPress in the wp_posts table. So the imported post ID can generate conflicts with these existing IDs also.
One way to avoid this type of error is to ensure that the post ID does not already exist as an Order ID, Page ID, Attachment ID etc. Another way to solve this problem is, when importing new products do not map ID column you can map with SKU and Parent_SKU columns instead. WordPress will assign a Post ID for the products that don’t have one.
The Best Product Import Export Plugin for WooCommerce
#1 in WordPress Official Plugin Repository With 50,000+ Active Installs
#1 in Customer Satisfaction With Most 5 Star Reviews
WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product
Buy Now!
I have a similiar issue when importing orders for migrating a shop. I already imported most orders before (which worked), but now I have to do it again (in the meanwhile new orders in live shop came up). This time for all the new orders there is a conflict saying “Importing order(ID) conflicts with an existing post.”
I really have no idea where there are existing posts with that ID. Any ideas what I could do? In a previous post you suggest “unmapping ID column”. How would I do that if it is the solution? Thanks a lot.
Sorry, now I know what you mean… you mean when exporting data you can unmap ID… I will try that and hope that it won’t lead to other conflicts as the correct ID then is missing…?
Hi,
You may please either export the new orders with the ID column excluded or else you may please export the orders and remove the ID data from the ID column of the new order and import it.
Please make sure that you have included the order ID in the CSV file if you are required to update the existing order. Existing orders are updated using the Order ID.
the new wordpress is empty still shows the error – “Importing product(ID) conflicts with an existing post which is not a product.”
Can ID conflicts be avoided when importing orders?
Hi,
You can overcome the ID conflict issue while importing the orders by unmapping the ID column while mapping. WordPress will automatically assign the next available ID while importing.
Would assigning post id conflicting products with an SKU before exporting them avoid problems with post id conflicts when importing associated customers and orders too? Thanks
Hi,
The issue you are facing is due to an already existing post with the same ID in the site. You may use an ID that is not already present in your site. Kindly please try using the ID that is not already stored in the wp_post tables.
Hi,
If I want to import products with cross (or up) sell ID’s, I’m forced to stick to predefined/set ID’s. I.e. if product with ID 1 has product with ID 2 as cross sell and vice versa, these exact ID’s need to be set/present in the wp_post (and wp_postmeta) tables. How would I ensure this to be imported correctly? I have made sure to start with ID’s (and corresponding cross sell ID’s) that are not yet in wp_posts (starting at 20000), but that doesn’t work, as I get the same error as described above, because each product apparently gets a unique ID in the wp_posts table. So, if I have – say – 300 post in there, the first 300 product records won’t be imported…
I’m probably missing something, so any help would be appreciated.
Thanks.