Use the following tutorial to import on hand/ available for sale QTY's to your website:
https://www.wpallimport.com/documentation/woocommerce/syncing-stock/
Here are some commands to PING CRON jobs: https://www.wpallimport.com/documentation/recurring/cron/
Scheduling Imports Using Cron Jobs
Each time the cron is run, WP All Import will download your XML or CSV file from the specified URL and update, delete, and create posts on your site according to your settings.
To set up a recurring import using cron jobs, specify the URL to your XML or CSV file on the Import Settings page.
Then, visit the Scheduling Options link on the Manage Imports page to open the Scheduling Options Popup.
You will need to choose the “Manual Scheduling” option here:
Each import has two cron URLs – a trigger URL, and a processing URL.
The trigger URL will look something like this:
http://YOUR-WEBSITE.com/wp-load.php?import_key=[YOUR_SECRET_KEY]&import_id=[YOUR_IMPORT_ID]&action=trigger
The processing URL will look something like this:
http://YOUR-WEBSITE.com/wp-load.php?import_key=[YOUR_SECRET_KEY]&import_id=[YOUR_IMPORT_ID]&action=processing
You can find your secret key on the All Import -> Settings screen, and the import ID on the Manage Imports screen.
If you want to run your import every 24 hours, you should run the trigger URL every 24 hours. If you want to run your import once per week, you should run the trigger URL every week.
The processing URL should be run every two minutes because it may not finish your import in one run. The reason is that many hosts have maximum script execution times in place, so its only possible for the processing script to finish only a small percentage of your import before it is timed out.
If this is the case and the processing script is run again after two minutes, it checks to see if your import is finished, or if there’s still work to be done. If there’s work to be done, it will import posts for as long as it can, or two minutes, whichever is longer.
Then, on the next run of the processing script, it will see if more work needs to be done on the import – and if so, it will do it. If not, it will “untrigger” the import. And now the processing script will have no effect, until the import is triggered again by the next run of the trigger script.
Setup CRON job to Automatically Process Updates
Depending on your update schedule on your website for handling inventory files, most websites will have two inventory files to process daily.
- Supplemental file that will include new products and updated items (im_store.txt)
- On Hand / Available For Sale file that will include the SKU, Onhand QTY (onhands.txt)
--- You will need two commands below for each file above ---
You will need to setup a few different commands:
- Trigger (Tells website updates are going to be processed) : Setup the trigger to start once
- Processing (Does the work to process inventory file row by row) : Command will run multiple times to confirm the entire file has been processed. Start at X hour, Every 10 Mins for 4-5 hours.
Trigger Inventory - Begin Processing Inventory Flag
wget -q -O /dev/null "https://www.bookmrkt.com/wp-load.php?import_key=YOURIMPORTKEY&import_id=IMPORTID&action=trigger"
Setup the Interval: 0 18 * * * (START AT 1800)
Process Inventory File:
wget -q -O /dev/null "https://www.bookmrkt.com/wp-load.php?import_key=YOURIMPORTKEY&import_id=IMPORTID&action=processing"
Interval: */10 18-23 * * * (START AT 1800, RUN EVERY 10 MINS FOR 5 HOURS)
The instructions for setting up cron jobs vary across hosts. Commonly, you can do it in your web hosting control panel. Click here for more details about pinging your cron jobs in the schedule task section.