Daily CSV Download/Upload to Magento

We are currently building an Ecommerce website using Magento CE1.7

We need to automate a daily download or inventory / sales data and an upload of the new store inventory (we will have offline sales so need to update the system).

Our intended plan is to use a CRON job which will do the following;

1. At [time of day] have Magento create CSV files of New Customers, Orders and Product inventory (this will happen once per day, around 10:30pm), save to a folder on server (we will take care of these CSV files, nothing further with exporting required

2. At [time of day] have Magento import CSV files for customers (new from other database) and import product inventory (once per day, around 12:30am). We would save the CSV files into a folder on the server, the script we require built would then need to import the files.


Part 1: Magento Exports CSV files to folder on server

Part 2: Magento imports CSV files from another folder in server.

Export will need 3 CSV files;

1. Customers (only those who have registered on date of export)

2. Orders (should display itemised list, value, qty and customer name who purchased)

3. Products (main requirements is for SKU, Product ID and stock quantity)

Import CSV files will be

1. Customer list

2. Products (SKU, Stock quantity and other items required for a successful import)

Server details:

PHP 5.2.x, 5.3.x, 5.4.x

MySQL 5.1

Zend Optimiser

IonCube Loader



At the moment the project is on a development server, but should be moved to the new server once we have completed some other items.

Please advise what access requirements you have in order to complete this kind of project.

Skills: MySQL, PHP

See more: sales folder, import csv into mysql php script, download php 5.3, daily access, upload to server, upload magento products, sku inventory, product upload and stock update script, openssl, magento products export, magento inventory, magento import, magento import customers, job import to magento, import csv, ecommerce website on magento, download some files from, data loader, APC, magento items data project, website list magento script, update mysql using csv, update mysql csv php, product sales project php mysql, magento order date

About the Employer:
( 0 reviews ) Australia

Project ID: #4792790