GVS Audit Steps: 1. First, Get catalog_product_entity stock details and delete data’s in gvs_listing => Tables: catalog_product_entity, cataloginventory_stock_item => Database: DATABASE_STAGREAT_MAGENTO 2. Delete onedrive file and log table data's above 30 days => Onedrive file link: Marketplace_audit_Files/GVS_website_audit => log table: script_execution 3. Get listing data based on mg_catalog_product_entity, mg_cataloginventory_stock_item. Get listings data and insert into table reports.gvs_listing 4. Get all sku details in reports.gvs_listing table and econthen_portal.4p_inventory => For count: field value based on - sku => For active sku: field value based on - sku and qty greated than 0 5. If gvs active count greater than 0 then => Compare with 4p inventory array active count and increase active count value => If not matched with 4p inventory array and count is equal to 1 then add it in a problematic array => If not matched with 4p inventory array and count is greater than 1 then add it in a ignored sku list array 6. Caluclate gvs inactive count based on below formula and update the count details in reports.gvs_audit => Ex: $count_sku_inactive = $count_catalog_active - $count_sku_active; 7. The prefix sku taken are CA10, DE01, FC01, MI01, NM01_b2b, LM01_b2b, WI01_b2b, MR01_B2B, KW01_B2B, ES01_B2B . Please do the steps 4-6 for these skus 8. Finally, prepare table and document for not listed, problematic and ignored sku list and mail the details. Also upload generated files in onedrive and delete it in local folder