Bonanza HW Audit Steps: • First, delete data’s in bonanza_hw_listing table • Get bonanza listing csv file data and insert into table bonanza_hw_listing • Get restricted products for Bonanza marketplace and discontinued • The prefix sku taken are NM01 • Get sku and qty from respective tables and calculate not listed, problematic and ignored sku list • Update bonanza active, inactive and count details in bonanza_hw_audit table based on sku’s • Prepare document for not listed, problematic and ignored sku list and mail the details • Finally, Prepare table and send mail with the documents and update close status in table gvs_scripts_execution_log