It is necessary to integrate 3 different areas for the products for the accounting program used for the workplace and the opencart website. It can be done as a script on the main machine. And I think it can be updated with a cron job.
The product field to be updated for Opencart ;
Product name, product price, product stock number(upc field)..
I took a screenshot for the table structure. It is announced to friends who can do this customization and work with us in other works.
my note;
As far as I understand the events here are as follows;
The stock codes(upc field) of the products coming from the sql manager will update the price, name and stock quantity values of the products that match the stock code in mysql, if there is a product without stock code in mysql, a new product will be created. and by default it will also complete fields for newly added products such as description meta info etc..
img;https://im.ge/i/Fe6DwD
info@cumleyazilim.com
Cümle Software LLC
Ali A.
Edit>>
It will be a one-sided data transmission.
The update will be done in 15 minutes as much as possible.
(could be lower too)
for newly created products it should also be created in the oc table.
The product information to be transferred in MSSQL is as follows;
product barcode,
product name,
the price of the product,
category of the product,
the manufacturer of the product,
the remaining stock of the product,
These data will update the values of the product data fields in opencart.
If the product stock code from MSSQL does not exist in the opencart database, it will create a new product record.
