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:
- 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.
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.
66 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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
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!