CRELOADED Database automate Import script/solution

  • Status Closed
  • Budget $85 - $260 USD
  • Total Bids 6

Project Description

Script needed for automate import from excel/ .xls file to creloaded online store.

1. The source file .xls is stored on a ftp server, and will be updated everyday.

2. I need you write a script to import certain column from .xls file to creloaded online store.

3. we have to test the script until it's working perfectly.

4. some clue: use easy populate?

some tips from google search, but it's for zen cart, which has been proof working ok:

You can save an excel spreadsheet in CSV format and use, the Easy Populate CSV add on, available here:

[url removed, login to view]

Ftp the file to /tempEP (the default import directory).

Let's say the file is called [url removed, login to view]

You might be able to automate the above with a batch script.

Then create a script to be called by cron every five minutes say.

The script must first authenticate itself.


[url removed, login to view]

The script then sets the filename variable to import and runs the easypopulate code.

To authenticate we need to override init_admin_auth.php.

So copy

admin/includes/init_includes/[url removed, login to view]


admin/includes/init_includes/overrides/[url removed, login to view]

and add


// to allow cron jobs set CRON_ADMIN_USER_ID


if (!isset($_SESSION['admin_id']) && defined('CRON_ADMIN_USER_ID') && CRON_ADMIN_USER_ID != '') {





to just after


if (!defined('IS_ADMIN_FLAG')) {

die('Illegal Access');



Then we write the script for cron.

Create a file /admin/[url removed, login to view]:

Then set up the cron job to call the script eg:

/usr/bin/lynx -accept_all_cookies -dump http://localhost/PathTo/admin/[url removed, login to view]

Get free quotes for a project like this
Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online