Opencart v1.5 automatic products sync from database on FTP

I need an extension for Opencart 1.5.6 to periodically (e.g. every hour) connect with the database stored on the FTP server and update products in the Opencart store. Extension should match products between databases by SKU and sync other fields based on it. Please notice that the product options also have SKUs, actually product options can be completely equivalent as the main/real products. So when I speak about a product, product options also count as standalone products. Every SKU is unique and will never be changed in the physical store. You would however need to prevent Opencart from adding multiple products under the same SKU. As in the default Opencart behaviour, this is possible, but needs to be restricted - only one product or product option per SKU is allowed.

Database is stored in .txt files, similar structure like csv (value1 | value2 | value3 | ...). To visualize better, the database from the FTP server is from a physical store. If the extension cannot match (i.e. doesn't find) a product, it should logically ignore the change, but it needs to log errors alongside a complete log, so I always have a transparent view if there's a problem.

Here is the list of what needs to be synced:

- stock

- product name

- additional short text description field, but only visible in the administration. I think you could even use any pre-existing field in the Catalog -> Products view, such as UPC, EAN etc. since I don't really use them at all. I guess that could make things a bit easier rather than creating additional field.

- price

- tax

Then we also need some extra features/fields:

Mark the product as "service" or "goods". This is defined in the database, so needs do be synced as well. If the product is marked as "goods", the behaviour is normal, so as stated before. But if the product is marked as "service", sync should be turned off and at the same time "ask for price" should be forced on. I already use "Ask for Price + Ask a Question bundle" Opencart extension, so you can use it. The only difference in that case is that the price still needs to be visible though (but you cannot buy it of course).

If the product is disabled, sync should also be turned off for that product. There should also be an option to manually override sync, so to turn it off for a specific product.

The last thing is Catalog -> Products view modification. You need to implement sorting by service/good, model and status.

VQmod is preferred, so I can update Opencart and theme in the future while retaining compatibility. Let me know your view on implementation. Please don't set placeholder bids, but realistic bids. Also let me know how many days would you need for completion.

Taidot: eCommerce, Open Cart, PHP, Ostoskärryt

Näytä lisää: build an online store online ecommerce store with mobile banking application, build an online store online e-commerce store with mobile (banking) application, database iphone sync, iphone database app sync, ftp sync, fast ftp sync tool, ruby dir ftp sync, oscommerce database script upload products, build music store online, sync products seller central webstore, ftp sync multithread, cron ftp sync directory, excel database ftp, india grocery store online denmark, list ebay store online free, ftp sync client, video game store online, cron ftp sync, ftp sync python, restored database zen cart products

Tietoa työnantajasta:
( 8 arvostelua ) Ljubljana, Slovenia

Projektin tunnus: #13663838

65 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello, Greetings, Top most Freelancer to work with and have great reviews too. I have read your project details and i am very much interested to work with you We have the best developer and designer tea Lisää

€1000 EUR 19 päivässä
(327 arvostelua)

Hi, I am Opencart expert. I can create a module to sync with the database on FTP. I will do all that you mentioned in job description. Anything else will be out of project scope. Please provide your website link and Lisää

€736 EUR 15 päivässä
(708 arvostelua)

Hello, my name is Michael. I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. We were carefully reviewing the requirements of the job description, so Lisää

€580 EUR 12 päivässä
(204 arvostelua)

Hi, I have 15+ yrs. experience of osCommerce/opencart/zencart/wordpress/woocommerce/prestashop/Cre Loaded. I have already worked on hundreds of ecommerce websites including template integration, module installation Lisää

€800 EUR 10 päivässä
(291 arvostelua)

We're a Pvt. Ltd. company based in New Delhi, India with more than 8 years of experience on eCommerce. We've gone through your project details and can do this task efficiently and accurately for you. Kindly check Lisää

€526 EUR 10 päivässä
(234 arvostelua)

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

€515 EUR 15 päivässä
(451 arvostelua)

----------------------------------------------------------Please Consider on My BID---------------------------------------------------Dear Sir/Madam, I Have read your project description. I have 8 + years experience of Lisää

€700 EUR 12 päivässä
(343 arvostelua)

Hi There, Open cart expert and have done similar job before. So you need a cron job to update database automatically. Can you show sample CSV which is stored in FTP? Thanks!

€475 EUR 7 päivässä
(288 arvostelua)

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joo Lisää

€567 EUR 15 päivässä
(512 arvostelua)

Hi Can we discuss regarding this project? I already have done such projects but for the Hourly update, I need to discuss with you.

€1000 EUR 25 päivässä
(228 arvostelua)

We requst you please response our msg. Hello, Thanks for posting your requirements. Hope you are doing well. This is vaishali from searcheverything. We are ready to help you with Opencart v1.5 automatic Lisää

€421 EUR 8 päivässä
(213 arvostelua)

Hello I have 5+ years of experience in Web Development and Designing. I am Master in making Opencart and Worked with Opencart since v1.4.x * Worked with Opencart since v1.4.x * 4+ years experience with Opencart Lisää

€515 EUR 10 päivässä
(160 arvostelua)

Dear client, We have 7+ years of experience in Responsive website development. We are ready to start the work immediately and completed in your timeline. We have a good logic and we can do customization in any tech Lisää

€750 EUR 10 päivässä
(171 arvostelua)

I completed many ecommerce websites, I can deliver in your conditions. For more details about our work, you can check our Themeforest profile with the themes we build from scratch (including for Ecommerce): https://th Lisää

€698 EUR 12 päivässä
(62 arvostelua)

Hi, I am interested in your project. I have 5-year experience on Opencart. You can check my profile to know clearly about this. I want to ask you some question about your requirement Please feel free to contact me. Lisää

€400 EUR 5 päivässä
(155 arvostelua)

Hi, I have gone through your requirement and understood but still i have few [login to view URL] per my understanding we need to sync products by SKU from another DB which is not part of the site at this [login to view URL] Queri Lisää

€388 EUR 8 päivässä
(167 arvostelua)

Hi there, I read your job post and can assist you with the synchronizing of website periodically with the database. Will also assist you with the categorization of Services and Goods. We can discuss all the re Lisää

€750 EUR 10 päivässä
(49 arvostelua)

Hello There. 1. I get that you looking for OpenCart developer. It will be great if you can share more detail with me discuss the project. 2. I have more than 9+ years experience working with Opencart and PHP . Lisää

€500 EUR 5 päivässä
(147 arvostelua)

Hi, Thanks for your valuable time. We have gone through your job description and ready to discuss with you further. We are experts in PHP, Codeigniter, CorePHP, Wordpress and Mobile Apps. We have completed many sim Lisää

€1666 EUR 30 päivässä
(81 arvostelua)

Hello! I have got acquainted with your requirements and have a proposal as well as some questions that we should discuss. The price and timeline are negotiable. We will agree on final estimation after discussio Lisää

€1500 EUR 30 päivässä
(36 arvostelua)