I gang

XLS/CSV data to Opencart Database script

Hello,

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.

Færdigheder: Åben Kurv, PHP, SQL

Se mere: sql database business, first convenience, everything house, database small business, write task, xls, sql script , php script create table, 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, product eshop, php script setup, csv product export, write sql queries, jpg xls, table csv, update csv file products, data image product

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

Projekt-ID: #6027730

Tildelt til:

babysoftS

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 Mere

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

34 freelancere byder i gennemsnit €245 for dette job

kchg

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 Mere

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

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 Mere

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

A proposal has not yet been provided

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

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)
7.1
dinotech

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: Mere

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

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 http://www.mumyathome.com/ ht Mere

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

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)
6.7
posspooja

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 Mere

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

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 Mere

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

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 Mere

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

I am interested to ur project.Please let me know.Waiting for ur reply. Please check some of project link Here are some of the project links: http://orchidzz.com/ http://www.clubmanhattan.nl/ http:// Mere

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

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 Mere

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

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)
6.0
pixelbypixelsl

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)
5.9
VnBestSolutions

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 !! Mere

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

La propuesta todavía no ha sido proveída

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

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)
5.6
yanotcook

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 saddleonline.com newsletter automation Mere

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

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 Mere

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

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 Mere

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