Mysql Sync Trigger From Another Systems Customers And Product Tables

[darman]

Hi ,

 

I am new cumunity ,  I  need someone to disign a  Trigger UPDATE  that can easly sync Prestashop from some tables that I allready have in use in another system on my  company.

 

I  have 2 tables to update data from ..      CUSTOMERS y PRODUCTS  have the data that are use in my ERP system .

 

Structures of tables from where I need UPDATE from:

 

PRODUCTS:

 

product_id   
product_name
price
stock_wharehouse_1        (stock of each products )
stock_wharehouse_2      
stock_wharehouse_3      

stock_wharehouse_4      

 

---------

 

Actual Customers Table:

 

customer_id
customer_name     (I don´t use  Name and Surname as Prestashop uses)
address
city
phone_1
phone_2
postalcode
tax_id
email
group

 

 

thank you

[im_presto]

will do it if issue still opens.

Send me Pm if needed.