{"id":11659,"date":"2023-05-08T10:10:27","date_gmt":"2023-05-08T17:10:27","guid":{"rendered":"https:\/\/www.coretechnologies.com\/blog\/?p=11659"},"modified":"2024-11-23T09:35:42","modified_gmt":"2024-11-23T17:35:42","slug":"daily-woocommerce-import","status":"publish","type":"post","link":"https:\/\/www.coretechnologies.com\/blog\/alwaysup\/daily-woocommerce-import\/","title":{"rendered":"Q&A: Can AlwaysUp Trigger a Daily Import into my WooCommerce Site?"},"content":{"rendered":"
\"Can<\/div>\n
\n  We’re using WP All Import<\/a> to import a CSV file into a WooCommerce<\/a> site.<\/p>\n

Can I use AlwaysUp to set up a nightly task that triggers WP All Import to perform the import, as described in this article<\/a>?<\/p>\n

Our site is running on Linux but our VPS provider doesn’t allow us to add a “cron job” to the machine and I’m hoping that AlwaysUp can help. We already use it for a couple of older Windows programs.<\/p>\n

— Patrick S.<\/p>\n<\/div>\n

Hi Patrick, thanks for reaching out. And thanks for being a customer!<\/p>\n

Yes, AlwaysUp can help definitely run your nightly task. <\/p>\n

Basically, you should create batch files that import the data and then instruct AlwaysUp to kick off the batch files at scheduled times.<\/p>\n

Let’s go through the process, step by step.<\/p>\n

1. Create the “trigger” and “processing” batch files<\/h2>\n

Follow the instructions in the article you sent<\/a> to create a couple of batch files.<\/p>\n

The first batch file imports the data. It will run nightly, at a time of your choosing. Let’s call it the “trigger batch file”.<\/p>\n

The second ensures that all data previously imported is fully processed, so we call it the “processing batch file”. It will run every couple of minutes.<\/p>\n

Both scripts work by calling a special URL on your WooCommerce site. We recommend using the free cURL<\/a> command line utility to help with that.<\/p>\n

For example, the trigger batch file should contain a single line:<\/p>\n

\nC:\\apps\\curl\\curl.exe http:\/\/YOUR-WEBSITE.com\/wp-load.php?import_key=[YOUR_SECRET_KEY]&import_id=[YOUR_IMPORT_ID]&action=trigger\n<\/div>\n

And the processing batch file will be very similar (notice the small variation in the URL parameter):<\/p>\n

\nC:\\apps\\curl\\curl.exe http:\/\/YOUR-WEBSITE.com\/wp-load.php?import_key=[YOUR_SECRET_KEY]&import_id=[YOUR_IMPORT_ID]&action=processing\n<\/div>\n

Note that the path to curl.exe will be different on your system. Be sure to specify the correct path in your files and save them to a well-known location.<\/p>\n

Our next job is to plug those files into AlwaysUp. Let’s start with the trigger batch file.<\/p>\n

2. Add the trigger batch file to AlwaysUp<\/h2>\n

To have AlwaysUp run the trigger batch file every night:<\/p>\n

    \n
  1. \n

    Start AlwaysUp<\/p>\n<\/li>\n

  2. \n

    Select Application > Add<\/b> to open the Add Application<\/b> window<\/p>\n<\/li>\n

  3. \n

    In the Application<\/b> field, enter the full path to the trigger batch file<\/p>\n<\/li>\n

  4. \n

    In the Name<\/b> field, enter a suitable name (we called ours “Trigger Import”)<\/p>\n

  5. \n

    Switch to the Logon<\/b> tab. Check the box at the top and enter your Windows username and password:<\/p>\n

  6. \n

    Switch to the Restart<\/b> tab. Here’s where you will set the batch file to run nightly.<\/p>\n<\/li>\n

  7. \n

    Specify the time to run, ensure that the first run happens at the set time and minimize logging, as pictured:<\/p>\n

  8. \n

    Click the Save<\/b> button to record your new task.<\/p>\n<\/li>\n

  9. \n

    And finally, select Application > Start<\/b> to launch the nightly process.<\/p>\n<\/li>\n<\/ol>\n

    2. Add the processing batch file to AlwaysUp<\/h2>\n

    To install the processing batch file, follow the same steps you took to setup the trigger batch file. Other than the obvious variations — such as the name and the path to the batch file — specify a two minute interval as pictured here:<\/p>\n

    \"Process<\/a><\/div>\n

    AlwaysUp will run both batch files on your WooCommerce site as specified<\/h2>\n

    With your two periodic tasks installed and managed by AlwaysUp, WP All Import will download your CSV file and update, delete, and create posts on your site according to your settings — every night.<\/p>\n

    \nBest of luck with your WooCommerce site!<\/p>\n