Import “succeeds” at 34,500 products, missing 164
-
Here’s a puzzle: I have a CSV that was exported using Woocommerce’s native export functionality. It has 34,647 rows: 34,646 product rows and a header row. I changed the title of the first and last product in this CSV, cleaned it up so it only has two columns, and exported a new CSV (UTF-8 encoding). It’s 1.4 MB. I then go to Products > Import, choose the file, check “Update existing products”, and Continue. On the next page, the ID and Name are mapped appropriately. I click Run the importer, and the import runs for about 20 minutes, then says “Import complete! 34,500 products updated”. Sure enough, the first product title has been updated, but the last product title has not. What happened to the last 146 products? I tried a CSV with just the last 147 products, in case there was some hiccup with product 34,501, but this CSV updated the last product title just fine. Is there some hard cap at 34,500? I changed max_execution_time and max_input_time to 0 (unlimited), max_input_vars to 4000, and memory_limit to 1024MB on my dedicated server, running PHP7 DSO mod_ruid2. I’ve tried this many times, same result: exactly 34,500 products updated. Running the latest version of Woocommerce (3.2.6). My caching plugin (W3TC) isn’t active, though I am using Cloudflare. Ideas? Anything else I can try?
-
Update: After removing thousands of duplicate titles from the CSV, 25,185 product rows remained. When I upload this new data set (as a fresh import or to update existing products), only 25,080 of 25,185 products are imported, though again, the process says “Import complete!” I thought maybe there were some funky characters throwing things off, so I tried running the CSV through Plain Clip, which removes formatting and invisible characters and performs Unicode normalization. I even converted to ASCII and removed trailing, leading, and consecutive spaces. Still, no luck. Any suggestions of things to try would be most appreciated.
What’s interesting is that in both cases, 99.58% of products are updated:
25080/25185 = 0.99583
34500/34646 = 0.99578
- The topic ‘Import “succeeds” at 34,500 products, missing 164’ is closed to new replies.
