Opencart v1.5 automatic products sync from database on FTP

Annullerat Publicerat 6 år sedan Betalades vid leverans
Annullerat Betalades vid leverans

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.

E-handel Open Cart PHP Shopping-carts

Projekt-id: #13663838

About the project

62 offerter Distansprojekt Aktivt 6 år sedan

62 frilansare har lagt bud på i genomsnitt €617 för det här jobbet

webbookstudio

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 Mer

€580 EUR inom 12 dagar
(344 omdömen)
8.8
ntiersolutions

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 Mer

€736 EUR inom 15 dagar
(740 omdömen)
8.4
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

€515 EUR inom 15 dagar
(470 omdömen)
8.3
sprextech

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

€700 EUR inom 12 dagar
(453 omdömen)
8.1
n2rtechnologies

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 inom 25 dagar
(285 omdömen)
7.9
gopalvora

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 Mer

€567 EUR inom 15 dagar
(537 omdömen)
8.5
kagg

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 Mer

€800 EUR inom 10 dagar
(291 omdömen)
8.1
brycep

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 inom 7 dagar
(288 omdömen)
8.1
Ginjag

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. Mer

€400 EUR inom 5 dagar
(212 omdömen)
7.3
Shopify

Hello, It's a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work on customization part if we can proceed towards more discussion. I have gone through your project de Mer

€721 EUR inom 12 dagar
(28 omdömen)
7.1
albertmobi29

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 Mer

€750 EUR inom 10 dagar
(49 omdömen)
7.3
pixelagency1

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 Mer

€1500 EUR inom 30 dagar
(47 omdömen)
7.6
prashushinde9

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore Mer

€721 EUR inom 12 dagar
(68 omdömen)
7.3
mikeblane

Warm Regards, I am pleased to inform you that your PR matches our expertise who own all the right credentials to execute this job in a very proficient way I request you to please initiate the discussion so that I can r Mer

€526 EUR inom 10 dagar
(66 omdömen)
6.9
mrphpguru

Greetings, Trust you are well. Myself Ranjeet (mrphpguru) Thank you for sharing brief details. It makes easier for the developer to understand the exact scope of work. I have read your project brief and I am will Mer

€888 EUR inom 60 dagar
(64 omdömen)
5.8
paliborek

Hello, I have made many Opencart stores in Poland and Portugal. I will be happy to help you to make this import script. I made few months ago similar script for largest store in Portugal. I always give 12 month guarant Mer

€467 EUR inom 7 dagar
(25 omdömen)
5.6
KothariNeha

I read all your requirements and I have developed many similar websites like yours. We will Provide Services Until You get 100% satisfied. We are not just looking for money OR one project, as we firmly believe in lon Mer

€266 EUR inom 10 dagar
(25 omdömen)
5.2
HelloWebStar

I'm available to discuss more on your project, I will provide 24/7 support and quick response guaranteed! So feel free to contact me at any time! If you need any further information, please feel free to contact me.

€277 EUR inom 10 dagar
(28 omdömen)
4.7
dpsmokha

A proposal has not yet been provided

€300 EUR inom 10 dagar
(5 omdömen)
3.5
Daphnistech

We are a leading IT services provider company with their primary objective on developing an online business. We have great expertise in providing web design, website development, and software development, Android appli Mer

€555 EUR inom 10 dagar
(2 omdömen)
1.5