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.
34 freelancers are bidding on average €245 for this job
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,
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