Opencart v1.5 automatic products sync from database on FTP + products grouping
€250-750 EUR
Paid on delivery
I need an extension for Opencart 1.5.6 @ Journal theme to periodically connect with the database (generated by the software from a physical store) stored on the FTP server and update products. Extension should match products between database on the unique model and sync other fields accordingly.
Database is stored in .txt files, similar structure like csv (value1 | value2 | value3 | ...). Extension should log errors and anomalies, so I always have a transparent view if there is an issue.
Here is the list of fields that need to be synced:
- product name
- SKU
- stock
- VAT
- price (prices in the database already include VAT, so extensions has to automatically recalculate the neto price)
- product setting (this is a custom field, see below)
You should implement 4 selectable sync settings for products. Each product would therefore have a drop-down menu under "Catalog -> Products" and also in the "Product update page". Sorting/filter by this setting should also be implemented in the "Catalog -> Products" page. Assigning product to a specific setting would affect it like this:
- 1st: Normal sync as explained above.
- 2nd: Same as for the 1st group but without stock sync. Instead, sync field should be full customizable. Also if stock=0, "Ask a a question" form is forced instead of "add to cart" button, so buying is disallowed. I already have "Ask for Price + Ask a Question bundle" extension for that part, but it also hides the price at the same time. I need the price to be visible with this 2nd setting though, so you only need to modify the original extension functionality.
- 3rd: Sync turned off. Complete manual override, so in other words normal Opencart functionality with manual editing.
- 4th: Identical to built-in "enabled" & "disabled" options for the product, you can actually just make a link to switch between enabled/disabled state.
SECOND PART OF THE PROJECT: Product grouping. Please have a look at this website for a sample: [login to view URL]
So there are actually 8 separated products (dumbbells), each with different price, QTY, model etc. and they are grouped into one "container" or a "group" view. To achieve something similar in OC, one would have to create a main product and then add 8 options with custom prices etc. However, those options are still just options, so very limited and also always affected by the main product by its settings, price, discounts etc. It is also unintuitive to use options since they are not visible in "Catalog -> Products page".
There is no such thing like product options/parents/childs in the FTP DB. Each entry is a complete, unique, standalone product and comes with all the fields listed above. So in this case, there would be 8 standalone products. It's impossible to use the default Opencart's product options in this case as the parent product simply doesn't exist, so I would have to create a fictional product and make up price, SKU, model and all the remaining required information for it.
To sum it up, I would like you to create (or suggest) a similar system like in the sample website. Please notice that I would like to have each and every product also listed in the admin under Catalog -> Products. I would also like that products are grouped automatically based on the extra field which you will find in the FTP database. The idea is that each product (entry) in the database also has an extra field. Products that will have the same content in this field will be grouped together. E.g. if there will be 8 products with code XYZ123, they will get grouped together and look just like on the link posted above.
Regarding the category view, it should work like here [login to view URL] , so the price is hidden in case products have multiple options (multiple prices).
VQmod is preferred.
Project ID: #15628093
About the project
Awarded to:
We have gone through the description and will create the extension which you need. We also check the link you suggest but these are not working and showing 404 Relevant Skills and Experience Please connect chat so we More
41 freelancers are bidding on average €591 for this job
Hi, I am Open Cart expert. I can do this job to create a script to import products from text file and also the other changes you mentioned in job description. It will be for 1 website only using. Relevant Skills and E More
Hello, We specialize in custom Opencart solutions and services. PLAMP is our favourite tool to use for any website. I can do this job to create a script to import products from text file and also the other changes More
Hello, We can do Opencart v1.5 automatic products sync from database on FTP + products grouping according to your description here. Please give me one chance to show my skills. Thanks Relevant Skills and Experience We More
Hello Sir, I've reviewed your requirement and I'm ready to work with you.I have almost 11+ years of experience in web development. I will provide quality work as well full support for any query Relevant Skills and Ex More
Hello, Your job posting has caught my attention and I am keenly considering your job post. I have excellent experience in Mentioned skills. We can discuss in detail over chat Thanks Relevant Skills and Experience Ope More
Hello Sir, I checked your requirement and i can do that please contact me so that we can discuss further. Relevant Skills and Experience MySQL, Open Cart, PHP Proposed Milestones €300 EUR - milestone Feel f More
Hi AM READY TO START NOW. I have 6+ years of experience in PHP, HTML 5, CSS3 asp, asp., ajax, smarty, WordPress,Graphic Design,website designing MySQL, Open Cart , based sites etc. Magento, MVC Relevant Skills and More
hello i have read all the requirements of your project and ready to finish it i have some questions so can you plz come online in freelancer chat so we can discuss Relevant Skills and Experience hello i am More
I have gone through your Job post and I can understand your job requirement thoroughly. I have all the required skills and experience you need for the above Job. Relevant Skills and Experience I have a total of 7 year More
Hello, We loved to work on your project because we have team of experienced Opencart Developers that do this job also check my profile we done successful project on opencart inbox me for details. Relevant Skills and E More
Hi, we can work on this and done in past Relevant Skills and Experience OpenCart Proposed Milestones €833 EUR - Milestone
Hi there, I read through the job details extremely carefully and I am absolutely sure that I can do Opencart v1.5 automatic products sync from database on FTP + products grouping. Relevant Skills and Experience I hav More
Hello! I am writing in response to your Project. After carefully reviewing the experience requirements and skills required for the job, I feel that I am a suitable match for the job. I am a data scientist by professi More
