Implementing Real-Time Product Synchronization and Localization in E-commerce Systems Using APIs

Task:

In e-commerce systems such as Prestashop and Magento, it is possible to set up real-time product synchronization between these platforms using built-in or additional secure APIs. This setup should ensure that:

  1. Descriptions and titles must be in Polish in one system and in English in the other.
  2. Translations should be performed using a translation API, such as Deepl.
  3. Implement currency conversion based on the previous day’s rates from the National Bank of Poland (NBP), with the currency being PLN in one service and either euros or dollars in the other, rounding up to whole numbers.

I need help with this task. I am performing the task on Ubuntu Server 20.4 LTS. My plan is as follows: in the Prestashop database, there is a table: ps_product_lang Product names and descriptions, with keys id_product, id_lang, which I intend to use. In Magento: catalog_product_entity_varchar. With such tables, I plan to create a third database, which is a combination of the Magento and Prestashop databases. There, I will place a query or write a Python script that connects to this database and extracts information, which is then translated using the library: from deep_translator import GoogleTranslator, and uses the API for NBP. I will place this entire script in the home directory on Ubuntu and upload it to crontab to synchronize data every minute. Does this idea make sense? Is there an easier idea? Please help and thank you.

submitted by /u/National-Lychee-4758
[link] [comments]