Array ( [0] => GDPR Cookie Consent [1] => CCPA [2] => Getting Started [3] => Changelog [4] => GDPR [5] => Add and Categorise Cookies [8] => Auto-block cookies with Script Blocker [13] => Create Privacy Policy Page [15] => Customize Cookie Notice [18] => Customize Settings Pop up [19] => Change Toggle button color [21] => Display Cookie List [22] => FAQ [23] => Getting Started [24] => Multilingual Support [25] => Overview [26] => Import Export Suite for WooCommerce [28] => Order / Coupon / Subscription Export Import Plugin for WooCommerce [29] => PayPal Express Checkout Payment Gateway for WooCommerce [30] => Changelog [31] => Getting Started [32] => Issue Refund [34] => Video Tutorial [35] => Print Invoice, Packing Slip, Delivery Note & Label for WooCommerce [36] => Address Label [39] => Changelog [41] => Credit Note [43] => Delivery Note [45] => Dispatch Label [47] => FAQ [48] => Invoice [49] => Adding meta data [50] => Customizations [51] => Email PDF Invoice [52] => FAQ [53] => Getting Started [54] => Invoice Number [55] => Multilingual Support [56] => Overview [57] => Packing Slip [58] => Customizations [59] => Getting Started [60] => Pick List [62] => Proforma Invoice [65] => Shipping Label [68] => Product Import Export Plugin for WooCommerce [69] => Smart Coupons for WooCommerce [70] => Abandoned Cart Discount [71] => Advanced Coupon Options [72] => Bulk Generate [73] => Changelog [76] => Getting Started [78] => Import Coupon [80] => Sales Countdown Timer [81] => SignUp Coupon [82] => Store Credit [84] => Volume/Quantity based coupon [85] => Stripe Payment Gateway for WooCommerce [86] => Alipay [87] => Apple Pay [88] => Changelog [89] => Compatibility with Subscription [90] => Getting Started [93] => SCA Ready [94] => Stripe Checkout [95] => Stripe Overview [96] => Stripe via Credit Card [97] => Troubleshoot [98] => Video Tutorial [99] => Subscriptions for WooCommerce [100] => Changelog [101] => Email Notifications [102] => FAQ [103] => Getting Started [104] => Manually Add or Modify Subscriptions [105] => Subscriptions Payment Gateway Guide [106] => URL Coupons for WooCommerce [107] => Changelog [108] => FAQ [109] => Getting Started [110] => Import URL Coupons [111] => QR Code Coupon [112] => WordPress Users & WooCommerce Customers Import Export )

Documentation/Product Import Export Plugin for WooCommerce/How to cron import WooCommerce products using multiple CSV files

How to cron import WooCommerce products using multiple CSV files

Product Import Export Plugin for WooCommerce plugin gives provision to automatically import products to your online store at the scheduled time with the specified time interval. You can even import products from multiple CSV files at once without having the need to import each file one by one at a time.

The first step in achieving this is to install and activate the plugin. Then, you can follow the steps explained below to cron import multiple CSV files all at once:

    1. Navigate to WooCommerce > Product Im-Ex > Settings
    2. Enable FTP and enter the following FTP details:
      • Enter FTP Server Host/IP.
      • Enter FTP User Name.
      • Enter FTP Password.
      • Select Use FTPS checkbox to connect securely.
      • Test FTP if working properly
      • Enable passive mode if required.
    3. Choose Enabled option to automatically Import products from FTP Server Host/IP, as shown below:

      WooCommerce FTP Product Import

      WooCommerce FTP Product Import

    4. Import from Folder: Enabling this option will import all the files in the specified folder. Upon enabling, you can specify the complete path of the root directory including the folder name where the CSV files are residing in the Import folder field as shown below. All the CSV files in the specified folder will be imported.
      WooCommerce FTP Product Import all files from folder

      WooCommerce FTP Product Import all files from folder

      Likewise if Import from folder is unchecked, then you can specify the complete path of the root directory including the name of the CSV file in the import file field to import that particular file.

      WooCommerce FTP Product Import Multiple Files

      WooCommerce FTP Product Import Multiple Files

    5. Enter the required Start time for importing the products.
    6. Enter the time interval in minutes for importing the products.
    7. Select Merge Products if exist checkbox to merge existing product with the updated details of the same product. The Merging of the product is possible only if the product ID already exists in your online store. Otherwise, the product is imported as a new product.
    8. Skip new product: If a new product SKU is encountered in the imported CSV file, it will be skipped, and only the existing products will be updated.
    9. Delete existing products: check to delete existing products that are not present in the CSV.
    10. Use SKU to link grouped products: Check this to link grouped products using product SKUs instead of product IDs
    11. Select a required mapping file from the given drop-down list.
    12. Click Save Settings to save/update settings.

You can see that products are auto-imported using multiple CSV files from the FTP server to your online store.

Refer to Setting Up Cron Job – WooCommerce Product Import Export plugin to know how to set up cron for import.

  • Was this article helpful ?
  • YesNo