Importing products into Magento website from custom database
$30-250 USD
Pagado a la entrega
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 ([login to view URL] or [login to view URL]) 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!
Nº del proyecto: #7561202
Sobre el proyecto
Adjudicado a:
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 Más
20 freelancers están ofertando un promedio de $272 por este trabajo
========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 Más
Hello I have huge experience in Magento Please give me the Chance And I will return you quality work Thanks A lot!
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 !! Más
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 Más
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 Más
Hello Let's explore the requirement and kindly let us know if you would like us to share our skills & experiences with previous development.
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 Más