Knowledge Base

Schedule Tasks

Updated on

To complete the automatic scheduled inventory updates to your website, you need to complete the task by adding the following scheduled tasks to your system.  Most times we install there on the box your database is install on.    


Pick one of the following setups that match your needs

Report Export

If you have a single store, use the report export function in iMerchant then use the configuration below to automate the task.  Change the DB name and the report # to fit your iMerchant setup.

Export All Reports

When emailing reports we have updated the reports to use email settings from parameters when sending export reports via File / Export.  Use the following schedule task to run all reports saved to File / Export when setup.  

Ping Cron Jobs on WordPress Website

Use the settings below to trigger and process updates on your WordPress website via WP All Import.

AWS Ping URL:

Triggerpowershell -ExecutionPolicy Bypass -Command Invoke-WebRequest 'YOURFULLURLTOTRIGGER' -UseBasicParsing

Processpowershell -ExecutionPolicy Bypass -Command Invoke-WebRequest 'YOURFULLURLTOPROCESS' -UseBasicParsing

Run Indie Commerce Export Task - LSI File

First create a new task

On the General Tab Enter a descriptive name and confirm the task will run without the user logged on.

Next switch to the Triggers Tab, Click NEW... and setup the scheduling.

Indie Commerce (ABA) accepts a new LSI file every hour max.

Switch to the Actions Tab, Click New...

Action: Start a program

Program / Script: Path to iMerchant exe called "imRunBatchProgram.exe"

Add Arguments: indiecexport INDIECOMMERCEEXPORTID DB=SAASDBName

The DB variable above is only used in our SAAS setups.

Go to the Conditions Tab, confirm the following:

Download Web Order File

Use the following action to schedule a task to automatically download a web order file.  Depending on how often you have scheduled your website to create the file, should be how often you download the file. 

Point the Detail to the following path on your server, then add the command word  indiecimport

Then the number after the command word is the number found in your Export ID - Indie Commerce Module.

Highlighted in Yellow is a NUMBER example:

Open IMERCHANT, Go to: INTERFACES  > INDIE COMMERCE 

Run Web Order Importer Automatically - Process Order File

Use the following action to schedule a task to automatically process the web order file you downloaded in the previous example above.  

Point the Detail to the following path on your server, then add the command word  processwebsiteorderfile

Then the database name to associate to a specific company on SAAS.

Also make sure to confirm your using the correct user for processing web orders.  The web order importer will use the defaults for the user set at TOOLS > SYSTEM OPTIONS - General Tab

Update the USER FOR BATCH MODE PROCESSING

Bookscan Scheduled Task

Setup the scheduled task to run every Monday morning.

Offline POS Server Task

IMImportOfflineSales.exe this one is the one that pushes the offline sales from the PC up to the server (sql or standalone)

IMImportOfflineSales I generally kick off 15 minutes before the IMUpdatePOSServer.

Ideally, import offline sales prior to the system update on the sql or standalone server so they are included automatically in the update process for the entire store data set.

Then, after the IMDbMaintenance.exe has run, then kick off (on the PC) IMUpdatePosServer to pull the latest version of the dataset from the main system onto the offline server(s)

IMUpdatePosServer.exe this one is the one that pulls the offline sales update from the server (sql or standalone) back down to the standalone PC server(s).

 

IMImportOfflineSales.......... kicks off at 02:30am on the PC; takes less than 5 minutes to complete.

IMDbMaintenance................ kicks off at 03:30am on the sql server, has been running about 15 to 18 minutes, so to be safe, and give it time to complete before the next job, allow about 25 minutes

IMUpdatePosServer............ probably kick this off at 04:00am on the pc

 

Use the XML files below to IMPORT A TASK into the task scheduler on the Offline POS Server PC. Change the user, permissions and timing as needed.

If you are seeing error messages pop up when running the tasks, confirm your VPN is running.  If it is not running and you try and run the offline update tasks you will see a message like the following pop up each time.  

Custom Products, Store Books and Wordpress Export Task

Release Update 23.12.12f DB Version 201 added a new schedule task options to automate the Custom Product and the WordPress Exports.  Custom Product export now also includes same available column options for export as WordPress export type.  The custom product export will run a new query every time of all products that match the search an export the file.  The WordPress export type will only export data from the last time a file was created, using only progressive updates in each new file.   

The new parameters now available include:

- ExportProductUpdates
- CustomProductExport
- StoreBooksExport   (IMRCHNT Release V23.12.12q DB201)

Ask your iMerchant support specialist for any help.

Previous Article Export Inventory to WordPress Website
Next Article Export Inventory to Wix / Export Orders from Wix
Still Need Help? Contact Us