<p>1. Import csv data in temporary table.<br />a. create temporary table<br />b. use mysql load data infile csv<br />c. there will be 20-30 csv files of all suppliers, make sure all csv will import properly in temporary tables.<br /><br />d. Product Update/Insert Logic:<br />d1. Update : update oc_product, we need to update only price and quantity on behalf of EAN SKU, and supplier<br />(csv ka EAN se oc_product ke EAN match and update)<br /><br />d2. Insert : cron_api mein insert ka code hai, We need to use to insert data.</p>
<p>2. Execution of CRON API: <br />Make a common database to manage this.<br />a. store list of dbs of active accounts.<br />b. execute&nbsp; one by one&nbsp;cron api <br /><br /><br />3. Make a website management panel</p>