XLS/CSV data to Opencart Database script


Some background info first FYI and then more details about the task.

I'm running a small business and currently we are creating an eShop (in-house development) based on Opencart.

In the store we are using a small ERP software called "Thesis ERP" for the invoices and the products keeping and management. It's a greek software but there is no need for someone to know how the software works in order to undertake the task.

Our aim is to avoid managing two different platforms (Thesis and Opencart) in order to manage our products (add/edit/delete). So we would like to achieve one-way synchronisation from Thesis to Opencart.

The scenario is:

Everyday we would export an .xls or .csv file from the Thesis with all data about the products (IDs, title, description, etc). The .xls is just one table with 10-15 columns.

We would like to be able to run a php script that will take all these data and put everything accordingly to the OpenCart Database. If the product id matches an existing id just update the old data with new new. If the products id doesn't exist create a new record.

The script should also take account specific columns from the xls/csv and use these data as product options, attributes. These options and attributes are static. That means that after the initial setup we will not add any more attributes. So for convenience we can provide you with all options and attributes ids, if you think that would be helpful to write/make the sql script.

In our OpenCart installation:

1. we have only one major category for the products called "Products".

2. we are using attributes at the products (5-6 attributes)

3. product options are not complicated (colours and sizes)

4. product image name can be the product id + ".jpg"

3. we are using 2 languages (English, Greek)

Please don't hesitate to ask for more info If you have any queries.

Evner: Åben Kurv, PHP, SQL

Se mere: sql database business, i need someone to write thesis, how to create database using php, how old is to, first convenience, everything but the house, database for small business, how to write task 1, xls, sql script , php script create table, i need someone to write a business description, from english to greek, database script, csv data, background thesis, database record keeping, small data table, opencart csv update, php create csv file, php table csv, csv update, task export data, opencart product title, product eshop

Om arbejdsgiveren:
( 1 bedømmelse ) Athens, Greece

Projekt ID: #6027730

Tildelt til:


Hi, I am experienced web developer with expertise in HTML5, PHP5, MySQL, Database designing, Open Cart, Magento etc. I understand the idea to export the items from Thesis ERP in csv format that needs to imported to Flere

€200 EUR in 6 dage
(49 bedømmelser)

34 freelancere byder i gennemsnit €245 på dette job


Hello, sir I'm interested with your project. I have good skill and my place is 8th in freelancer. I'll do it for you. I can do it well more than you could guess. :) If you give me t Flere

€515 EUR in 10 dage
(164 bedømmelser)

Greetings, I read your details carefully and to make a summary. Yes, that's much better if you can provide list of product & attributes so a better script can be created for products' automation in the database. As I'v Flere

€370 EUR in 7 dage
(442 bedømmelser)

A proposal has not yet been provided

€331 EUR in 4 dage
(235 bedømmelser)

Hi, We have throughly read your requirements and believe that we can deliver exceptional results. We hope you will consider using our services. Kind Regards,

€252 EUR in 6 dage
(444 bedømmelser)

Hello There Greetings of the Day! We have reviewed your requirement and understood it very well. we would like to quote down some sample of our work so that you can have an idea about working proficiency. http: Flere

€263 EUR in 8 dage
(111 bedømmelser)

Hi, We have a rich experience in opencart development and have completed many successful projects using it. Please check our some good works using the below URLs. Opencart Projects [login to view URL] ht Flere

€250 EUR in 7 dage
(53 bedømmelser)

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

€237 EUR in 12 dage
(82 bedømmelser)

Hello, I am an Certified Developer with more than 7 years of experience and shall get this done in about 5 days' time. Let me know if you have any doubts / queries about my expertise, will be more than happy to Flere

€368 EUR in 5 dage
(60 bedømmelser)

Hi,    We’ve had a good look at your project description and we’re very interested in providing a solution. Please PM me the "" API, their must be a way to call the periodic data using the API, and we can install scr Flere

€200 EUR in 7 dage
(26 bedømmelser)

Hello Sir, I have read your project detail and what I understand is you want to create new script for your website.. We can surly do that for you..kindly open message board..so I can share you detailed feature li Flere

€250 EUR in 7 dage
(44 bedømmelser)

I am interested to ur [login to view URL] let me [login to view URL] for ur reply. Please check some of project link Here are some of the project links: [login to view URL] [login to view URL] http:// Flere

€222 EUR in 5 dage
(41 bedømmelser)

Hello, I am Trinkal Juneja worked on 2K+ Opencart Projects, from custom module to designing template, RTL integration, Payment Gateway integration, Shipping, Import and Export, Customized product module, social med Flere

€210 EUR in 2 dage
(109 bedømmelser)

Ready to work. I have great experience with opencart, developing extension and import modules. Feel free to contact and hire me.

€250 EUR in 6 dage
(43 bedømmelser)

UK based developer - expert with Opencart - I can build you a custom system to plug in and update the data where required without a problem.

€526 EUR in 14 dage
(21 bedømmelser)

Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Flere

€305 EUR in 3 dage
(51 bedømmelser)

La propuesta todavía no ha sido proveída

€50 EUR in 7 dage
(86 bedømmelser)

Hello, Greetings from Shweta, Bangalore India. I propose a solution in Perl, Please let me know if you are ok with Perl. Regards, Shweta

€200 EUR in 3 dage
(50 bedømmelser)

I have completed this following with excellent which requirement is similar to your one: Custom Project http://www.freelancer.com/projects/Custom-Project-Jun.1726320.html ( for [login to view URL] newsletter automation Flere

€147 EUR in 5 dage
(48 bedømmelser)

Hi I have good level of experience in Core PHP , OpenCart , Magento, Wordpress, Drupal ,Joomla, Codeigneter and more I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work.. Aim Flere

€200 EUR in 7 dage
(51 bedømmelser)

PLEASE DON’T AWARD UNTIL WE HAVE HAD A DISCUSSION ON THE REQUIREMENTS Hello Sir , I am Ojaswa Sharma with experience of more than 7 + years in this domain serving our clients from across the globe. I am looking Flere

€144 EUR in 3 dage
(13 bedømmelser)