If you can’t increase your execution time, you can break your CSVs into multiple parts for import. Check with your hosting company to see if they support it. The plugin uses set_time_limit to prevent timeouts, but this is not supported by all hosting environments. Why does my import keep timing out? ↑ Back to top Contact your hosting provider, and ask them to increase the limit. If you cannot do it yourself, there may something on the server that restricts it. Your server may not have enough memory to perform the import. Why am I getting the message “Allowed memory size of xxx bytes exhausted”? Try uploading your spreadsheet to Google Spreadsheets, and save your CSV there. If you’re using Microsoft Excel, it could be an issue with formatting. Where possible, you should use LineFeed (LF) endings instead of Carriage Return (CR). This could be an issue with line endings. Why can’t I see my rows after import? ↑ Back to top
You can specify an external URL for images in the CSV, but the importer will download them and save them in your media library. WordPress does not support external images inside galleries and as featured post images. Images need to be imported to the media library. Open the exported CSV file, and delete the product ID column.ĭo I need to import images to the media library, or can they be external? ↑ Back to top.Export this product, and make sure to select the hidden fields checkbox.Create a product with all the information you want.Add all the plugins and extensions you need, and add any custom fields to your products if required.What is the best way to create a CSV? ↑ Back to top If possible, avoid Microsoft Excel due to formatting and character encoding issues. Online spreadsheet editor Google Drive / Docs.What CSV editors do you recommend? ↑ Back to top Elementor Connector for WooCommerce BookingsĬonditional Payment Methods For WooCommerceĪll Products for WooCommerce SubscriptionsĬommon issues and answers/solutions for the Product CSV Import Suite.