Færdiggjort

Importing products into Magento website from custom database

Hello,

I want to have products imported from a custom database (MySQL) into my Magento-webshop.

What's available:

- database with: title, description, category-ids, sku, price and link to (external) picture.

What should be build:

Importing/updating and deleting of products.

- Importing the products where EXPORTED_TO_SHOP = NULL

Before import:

- Check if SKU doesn't exist, otherwise throw an error in an errorlog

- Check if categories exist, otherwise throw an error in an errorlog

- The picture should be taken from the vendors website and uploaded in my webshop.

After import:

- Update the EXPORTED_TO_SHOP to the current date/time

- Update the products where EXPORTED_TO_SHOP = "0000-00-00 00:00:00"

Before update:

- Check if SKU exist, if it doesn't throw an error in an errorlog

- Check if categories exist, otherwise throw an error in an errorlog

After update:

- The SKU, categories, title, price, description and image should be updated

- Update the column "EXPORTED_TO_SHOP" in table "PRODUCTEN" to the current date/time

- Delete the products where READY_TO_DELETE = "1"

After deletion:

- Put those records in the table "deleted_products" with a timestamp of deletion

- Delete those records from the table "products"

- After the insert/update/delete is completed:

- Refresh cache (Bolt and std. cache) of the webshop for those categories which were modifed/updated/added/deleted

- Report number of products inserted, updated and deleted

Other requirements:

- It should be scheduled with a cronjob

- Preferable PHP, because it should run on my own server

- Only the products which are mention should be deleted, not a "delete all" (because the webshop also contains other products which haven't been uploaded via this process)

- Should work with Magento 1.7 and 1.9

- The errors and the successes should be written to 2 errorlogs ([url removed, login to view] or [url removed, login to view]) or to an logtable/database if you prefer that

- The source code should have comments in English so I'm able to extend it later by myself (adding more fields, selecting products based on query etc.)

- I prefer to have this insert/update/delete done by an XML-file or via SOAPcalls.

- No direct updates in the Magento database via SQL, because that isn't future-proof enough.

- Instead of an update you could also build a delete and insert, that's fine by me

The first time it will be around 2.000 products, after that it will be 100 products/day

What you get:

- a sample database with products to import, update or delete (and explanation so you know how which product and why you can use it for what scenario)

- explanation of the databasefields

- everything you need to get this project finished

Please give a short description of the related projects you've done already with Magento and importing/updating products.

Thank you for your bidding!

Evner: Dataindførsel, Programmering af database, eHandel, Magento, PHP

Se mere: why you need a website 2015, how to insert picture in php code, fine products, c# database mysql, build mysql query, update magento website, magento database, build a website for custom product, build a webshop, adding products to magento, import xml file mysql database php, php project database project report, magento short description, check server log errors, webshop mysql, magento query, magento update product php, magento update xml, magento xml update, import sql database mysql

Om arbejdsgiveren:
( 2 bedømmelser ) Steenwijk, Netherlands

Projekt ID: #7561202

Tildelt til:

ranjansumit

I have done few projects of product addition and updation. https://www.freelancer.com/jobs/project-7216115/ https://www.freelancer.com/jobs/project-6934530/ In your requirement, you have missed few things 1. You m Flere

$200 USD in 5 dage
(25 bedømmelser)
5.7

21 freelancere byder i gennemsnit $269 på dette job

KESHAVINFOTECH

Hi Thanks for your valuable time. :-) Just reply with 'Yes' and We will come up with a. Detail project plan with our comments/queries. b. Best-feasible-real COST & TIMELINE Latest Projects : [login to view URL] Flere

$247 USD in 15 dage
(642 bedømmelser)
8.5
surabhirathi21

Hi, We're a team of Magento Developers based in New Delhi, India with more than 4 years of experience. We've gone through your project details and can do this task efficiently and accurately for you. Kindly check Flere

$252 USD in 8 dage
(227 bedømmelser)
7.9
crystalcloudteam

Hello, we are an experienced team in Magento, wordpress Check our profile and reviews on freelancer http://www.freelancer.com/u/crystalcloudteam.html Please reply to discuss further on the requirement to provide yo Flere

$473 USD in 10 dage
(125 bedømmelser)
7.7
CodeWolves

Hi I have review your project details and would like to be part of it. Please check Some Work so you can have an idea about Skills. Wordpress/ PSD To HTML/Custom Designs and developments: [login to view URL] Flere

$200 USD in 5 dage
(160 bedømmelser)
7.6
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 !! Flere

$333 USD in 7 dage
(232 bedømmelser)
7.0
joyzazaza

Hello I have huge experience in Magento Please give me the Chance And I will return you quality work Thanks A lot!

$315 USD in 3 dage
(48 bedømmelser)
6.9
prashushinde9

========Please Don't award this project to us without discussing this project in detail============ Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years i Flere

$309 USD in 10 dage
(66 bedømmelser)
7.1
JoomlaVogue

Hello Sir, First of all, we would like to tell you how we will initialize the project with you. We insist to follow these steps before you award the project to us: - We (technical team) will review the job and Flere

$184 USD in 3 dage
(104 bedømmelser)
7.4
forcitCample

Ah it's good to see another serious job posting on here :) I recorded  this quick video for you :  [login to view URL] Helping with your “ importing database product into magento website ” is definitely so Flere

$222 USD in 3 dage
(98 bedømmelser)
6.7
Handyman84

Hi, I don't want to bother you with those standards offers.. so I will be going straight to the point. I'm leading an efficient team ready to make a good job for this project. Here you have the link to my profile to ch Flere

$326 USD in 7 dage
(14 bedømmelser)
6.3
shreeyait

Hello Sir, Hope you are fine there. We are having good experience with Magento based projects and the reason we came across here to give the best output to your project with supreme quality. We have develo Flere

$265 USD in 10 dage
(70 bedømmelser)
7.1
massoftware

completion of milestone Hello, Reading your project description in details we would like to place our expression of interest for this exciting project.   We really look forward a chance working with you. Give u Flere

$277 USD in 7 dage
(16 bedømmelser)
6.2
techwelf

Hello Let's explore the requirement and kindly let us know if you would like us to share our skills & experiences with previous development.

$278 USD in 18 dage
(88 bedømmelser)
6.4
gogy

Hi, I have written similar auto importers for these two sites: [login to view URL] [login to view URL] I propose a MAGMI based custom importer script. It will take a customized .csv as input and auto Flere

$333 USD in 5 dage
(71 bedømmelser)
6.2
davaidwilliam

A proposal has not yet been provided

$277 USD in 4 dage
(65 bedømmelser)
6.0
saurabh121

We have a magento workshop where we fix , design and create everything under magento teams compromises of Magento Certified professionals a. A Strategist() b. Fronend developers(,). We also provide services such a Flere

$263 USD in 3 dage
(15 bedømmelser)
5.7
devi222

Hi sir, Iam expert in this. I can finish this in next 4 Days. I have done 9 projects which includes two long term and 4 short term. I have done a project on products upload into Magneto for about 2 Months. I have upl Flere

$170 USD in 4 dage
(108 bedømmelser)
6.0
coolbratan

Hi, I have much experience in uploading items to any internet-shops like amazon, wordpress based, magento based, ioffer, ebay etc. About related projects - look to my profile and you will see. Last project was to scrap Flere

$250 USD in 2 dage
(22 bedømmelser)
4.9
techinovate

I am magento certified. Kindly, share your availability here on freelancer for the discussion. I have 5 years of extensive experience in designing and developing more than 100+ stores for my clients across the globe.I Flere

$222 USD in 10 dage
(33 bedømmelser)
4.5
sathyasingh1991

Hi; I have read the project descriptions and I am confident of providing the project perfectly. If you are also interested to offer me the responsibilities of the project, You may contact me here anytime of the Flere

$250 USD in 30 dage
(10 bedømmelser)
3.5