donnafaye Posted October 9, 2014 Share Posted October 9, 2014 (edited) Hi all, I have a barcode module where it also have a functionality to automatically insert draft product details in the database. tables such as: product, product_lang, product_shop, stock_available... let say the db prefix is ps Inserting the details to tables using the module is working fine. Just noticed that when updating the details of the product through Catalog > Products page, the date_add field within product table becomes 0000-00-00 00:00 As a result, the product will not be displayed in website as one of the new products (new products block). Any suggestion so that the date_add field in the product table NOT to be altered even if I updated the draft product details through the Catalog > Products page? Thanks in advance! note: prestashop version: 1.5.6.2 Edited October 9, 2014 by donnafaye (see edit history) Link to comment Share on other sites More sharing options...
donnafaye Posted October 10, 2014 Author Share Posted October 10, 2014 just found the solution by myself. I found out that there is another date_add field in product_shop table and just needed to insert the value. Link to comment Share on other sites More sharing options...
Recommended Posts