To create a support ticket, start a search

CSV Customer Import: Automating your customer imports with a CRON task

CRON is a time-based job scheduler in Unix-like computer operating systems. Cron enables users to schedule jobs (commands or shell scripts) to run periodically at certain times or dates

It is indeed interesting to get the system to run recurrent and repetitive tasks automatically instead of involving a manual intervention by the user.

Here is how you can make your life easier by automating your customer imports using a CRON task, allowing you to create and/or modify your customers.


- Configure your CSV import once to check that it works when ran manually
- Download the attached file
- Unzip the file and rename it cron_import_customers_YYY.php (choose an recognisable name)
- Edit the file to configure it

The first lines allow to modify the configuration:

// Cron task name
if (!isset($_GET['name'])) {
    $_GET['name'] = 'import_custom';
}

// CSV filename, all options must be set and tested in Store Commander
if (!isset($_GET['filename'])) {
    $_GET['filename'] = 'clients.csv';
}

// Do you need to delete the working file (TODO.csv)?
if (!isset($_GET['deletetodofile'])) {
    $_GET['deletetodofile'] = 0;
}

// Do you need to force the mapping? Optional. If used, enter the mapping name below.
if (!isset($_GET['forcemapping'])) {
    $_GET['forcemapping'] = '';
}

// Update only old products? This option will skip products recently updated
// (in minutes: set this option to 120 in order to update only products updated more than 2 hours ago)
if (!isset($_GET['olderthan'])) {
    $_GET['olderthan'] = 0;
}

// internal security key to use in CRON ( you should call /modules/storecommander/XXXX/SC/cron_import_YYY.php?s_key=4hfsz65j4e68h4reh )
$local_key = '4hfsz65j4e68h4reh';


// website url for the link inluded in the email.
$websiteURL = 'http://www.yourwebsite.com';

// id employee used by cron task
$_GET['id_employee'] = "1";
$_GET['ide'] = "1";

 

** Do not modify the following lines **

** Important note: Do not use the security key above as it is used as an exemple for this article.


Then, add the file on your server in directory:

/modules/storecommander/XXX/SC/cron_import_customers_YYY.php


You will then simply call this URL with the CRON task on your server:

/modules/storecommander/XXX/SC/cron_import_customers_YYY.php?s_key=4hfsz65j4e68h4reh

 

/XXX/ corresponds to a serie of letters and digit corresponding to your installation.