How to import products,customers,product prices automatically in Magento?

How to import products,customers,product prices automatically in Magento?

September 5, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to import products,customers,product prices automatically in Magento?

Automatically Importing Products and Customer Data into Magento

As a senior developer, I often encounter situations where clients need to automatically import product information, customer data, and prices from their ERP systems like Oracle into their Magento stores. In this post, I’ll guide you through the process of setting up automatic imports using cron jobs.

Understanding the Approach

The key to automating the import process is to create a PHP script that retrieves data from your Oracle database and inserts it into your Magento MySQL database. This script should be scheduled as a cron job to run at regular intervals, ensuring your Magento store stays up-to-date with the latest information.

Setting Up the Cron Job

Firstly, you need to enable cron jobs in your Magento configuration:

  1. Navigate to System > Configuration > Advanced.
  2. Under the ‘Cron’ section, set the following options:
    • Enable: Yes
    • Generated Cron Schedule (every minute): 0 * * * *
  3. Save the configuration.

Next, create a PHP script with the necessary database connections and import logic. Here’s an example of how you might fetch product data from Oracle and insert it into Magento:

<?php

// Connect to Oracle DB
$conn = oci_connect('username', 'password', 'localhost/XEPDB1');

// Connect to MySQL DB (Magento)
$mysqli = new mysqli("localhost", "root", "password", "magento_db");

// Check for errors in the MySQL connection
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// Fetch products from Oracle
$stid = oci_parse($conn, 'SELECT product_id, name, price FROM products');
oci_execute($stid);

while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
    // Insert into Magento product table
    $sql = "INSERT INTO catalog_product_entity (entity_id, attribute_set_id, type_id, name, price)
            VALUES (" . $row['PRODUCT_ID'] . ", 1, 'simple', '" . $row['NAME'] . "', " . $row['PRICE'] . ")";
    if ($mysqli->query($sql) === TRUE) {
        echo "New product imported successfully.";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}

oci_free_statement($stid);
oci_close($conn);
$mysqli->close();

Scheduling the Cron Job

To schedule this script as a cron job, you can add an entry to your server’s crontab file. If using Linux:

  1. Open a terminal.
  2. Type crontab -e and press Enter.
  3. Add the following line (adjusting the path to your PHP interpreter if needed):
* * * * * /usr/bin/php /path/to/your/script.php >/dev/null 2>&1
  1. Save and close the file.

Using Magento Extensions for Import

While you can create custom scripts, there are also extensions available that provide automatic import functionality:

  • Impex - Offers a variety of features including auto-updates from CSV files.
  • AutoImport - Automatically fetches and updates products based on URL.

However, these extensions may not fully meet your requirements if you’re pulling data directly from an Oracle database. In such cases, a custom solution is often the best approach.

Conclusion

Automating the import process between your ERP system and Magento store can save significant time and reduce manual errors. By setting up cron jobs to run PHP scripts that fetch and insert data into Magento, you ensure your product information remains accurate and up-to-date.

Remember, always test your scripts thoroughly before deploying them in a live environment. If you face any challenges or need further assistance, feel free to reach out to our team at Laravel Company.

Happy coding!

Catalog Database Configuration Cron

Our network