-----------------gmail--------------------------------


INSERT INTO `media`.`smr_smm_gmail_service` (`s_no`, `client_id`, `client_secret`, `refresh_token`, `gmail_address`, `gmail_status`, `created_date`, `created_by`, `updated_date`, `updated_by`) VALUES ('1', '395311020011-dobhmlkg66s06vkngmlgc5eqtm4uio1m.apps.googleusercontent.com', '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', '1//0gU803taGBZf-CgYIARAAGBASNwF-L9Ir9KLdfF7pahY6_7e20gy-u70GXwHzXQTjEOxix7mU1eXkqLOC3z1yTYXlJCeEPoDP-Wg', 'sales@medialinkconcepts.in', 'G', '2024-03-16 00:00:00', 'SUSM1709250002', '2024-07-16 11:10:53', 'SUSM1709250001');

UPDATE `adm_mst_tcompany` SET `accounts_email` = 'sales@medialinkconcepts.in' WHERE (`company_gid` = '1');

-------product group-----------------------
/*
-- Query: select * from pmr_mst_tproductgroup where productgroup_gid='PPGM2407053'
-- Date: 2024-07-29 18:08
*/
INSERT INTO `` (`productgroup_gid`,`productgroup_code`,`productgroup_name`,`display_order`,`product_type`,`location_gid`,`Group_type`,`account_gid`,`delete_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`tax1_name`,`tax2_name`,`tax3_name`,`tax1_gid`,`tax2_gid`,`tax3_gid`,`assetblock_gid`,`block_name`,`Productgroup_prefix`,`businessunit_gid`,`businessunit_name`) VALUES ('PPGM2407053','PGC003','General',0,NULL,NULL,NULL,NULL,'N','U1','2024-07-05 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);


------products---------------
/*
-- Query: select * from pmr_mst_tproduct where productgroup_gid='PPGM2407053'
-- Date: 2024-07-29 18:07
*/
INSERT INTO `pmr_mst_tproduct` (`product_gid`,`productgroup_gid`,`productuom_gid`,`productuomclass_gid`,`product_code`,`product_name`,`producttype_gid`,`status`,`bom_flag`,`qty_standardbom`,`qty_standardbyproduct`,`batch_flag`,`created_by`,`created_date`,`type_gid`,`make_gid`,`grade_gid`,`reorder_level`,`size`,`width`,`length`,`guage`,`fliptype`,`product_desc`,`serial_flag`,`branch_gid`,`department_gid`,`assigned_flag`,`custodian_flag`,`document_flag`,`stockable`,`item_no`,`count`,`product_image`,`account_gid`,`moq`,`product_price`,`cost_price`,`avg_lead_time`,`product_status`,`margin_percentage`,`margin_amount`,`name`,`content_type`,`data`,`batchtracking_flag`,`serialtracking_flag`,`warrentytracking_flag`,`expirytracking_flag`,`delete_flag`,`purchasewarrenty_flag`,`currency_code`,`hsn_number`,`gstproducttax_percentage`,`product_weight`,`updated_by`,`updated_date`,`currency`,`customerproduct_code`,`subgroup_gid`,`subgroup_name`,`productsubgroup_gid`,`producttype_name`,`ratecontract_flag`,`asset_images`,`mrp_price`,`shopify_productid`,`vendor_name`,`inventory_quantity`,`old_inventory_quantity`,`variant_id`,`price`,`compare_at_price`,`grams`,`hsn_code`,`hsn_description`,`hsn_desc`,`inventory_item_id`,`option1`,`tax_name`,`tax_name2`,`tax_name3`,`tax_gid`,`sku`,`GTIN_barcode`,`whatsappproduct_updatedby`,`whatsapp_id`,`whatsappstock_status`) VALUES ('PPTM24070510','PPGM2407053','PPMM240620134','','','General Services VAT 5%','PG005','1','',0,0,'','U1','2024-07-05 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'General Services VAT 5%','',NULL,NULL,'N',NULL,NULL,'Y',NULL,0,'../../images/no_preview.jpg',NULL,0,0.00,0.00,'',NULL,0.00,0.00,NULL,NULL,NULL,'N','N','N','','N','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'STXM20240619001',NULL,NULL,NULL,'null','Y');
INSERT INTO `pmr_mst_tproduct` (`product_gid`,`productgroup_gid`,`productuom_gid`,`productuomclass_gid`,`product_code`,`product_name`,`producttype_gid`,`status`,`bom_flag`,`qty_standardbom`,`qty_standardbyproduct`,`batch_flag`,`created_by`,`created_date`,`type_gid`,`make_gid`,`grade_gid`,`reorder_level`,`size`,`width`,`length`,`guage`,`fliptype`,`product_desc`,`serial_flag`,`branch_gid`,`department_gid`,`assigned_flag`,`custodian_flag`,`document_flag`,`stockable`,`item_no`,`count`,`product_image`,`account_gid`,`moq`,`product_price`,`cost_price`,`avg_lead_time`,`product_status`,`margin_percentage`,`margin_amount`,`name`,`content_type`,`data`,`batchtracking_flag`,`serialtracking_flag`,`warrentytracking_flag`,`expirytracking_flag`,`delete_flag`,`purchasewarrenty_flag`,`currency_code`,`hsn_number`,`gstproducttax_percentage`,`product_weight`,`updated_by`,`updated_date`,`currency`,`customerproduct_code`,`subgroup_gid`,`subgroup_name`,`productsubgroup_gid`,`producttype_name`,`ratecontract_flag`,`asset_images`,`mrp_price`,`shopify_productid`,`vendor_name`,`inventory_quantity`,`old_inventory_quantity`,`variant_id`,`price`,`compare_at_price`,`grams`,`hsn_code`,`hsn_description`,`hsn_desc`,`inventory_item_id`,`option1`,`tax_name`,`tax_name2`,`tax_name3`,`tax_gid`,`sku`,`GTIN_barcode`,`whatsappproduct_updatedby`,`whatsapp_id`,`whatsappstock_status`) VALUES ('PPTM24070511','PPGM2407053','PPMM240620134','','','General Services VAT 20%','PG005','1','',0,0,'','U1','2024-07-05 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'General Services VAT 20%','',NULL,NULL,'N',NULL,NULL,'Y',NULL,0,'../../images/no_preview.jpg',NULL,0,0.00,0.00,'',NULL,0.00,0.00,NULL,NULL,NULL,'N','N','N','','N','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'STXM20240619002',NULL,NULL,NULL,'null','Y');
INSERT INTO `pmr_mst_tproduct` (`product_gid`,`productgroup_gid`,`productuom_gid`,`productuomclass_gid`,`product_code`,`product_name`,`producttype_gid`,`status`,`bom_flag`,`qty_standardbom`,`qty_standardbyproduct`,`batch_flag`,`created_by`,`created_date`,`type_gid`,`make_gid`,`grade_gid`,`reorder_level`,`size`,`width`,`length`,`guage`,`fliptype`,`product_desc`,`serial_flag`,`branch_gid`,`department_gid`,`assigned_flag`,`custodian_flag`,`document_flag`,`stockable`,`item_no`,`count`,`product_image`,`account_gid`,`moq`,`product_price`,`cost_price`,`avg_lead_time`,`product_status`,`margin_percentage`,`margin_amount`,`name`,`content_type`,`data`,`batchtracking_flag`,`serialtracking_flag`,`warrentytracking_flag`,`expirytracking_flag`,`delete_flag`,`purchasewarrenty_flag`,`currency_code`,`hsn_number`,`gstproducttax_percentage`,`product_weight`,`updated_by`,`updated_date`,`currency`,`customerproduct_code`,`subgroup_gid`,`subgroup_name`,`productsubgroup_gid`,`producttype_name`,`ratecontract_flag`,`asset_images`,`mrp_price`,`shopify_productid`,`vendor_name`,`inventory_quantity`,`old_inventory_quantity`,`variant_id`,`price`,`compare_at_price`,`grams`,`hsn_code`,`hsn_description`,`hsn_desc`,`inventory_item_id`,`option1`,`tax_name`,`tax_name2`,`tax_name3`,`tax_gid`,`sku`,`GTIN_barcode`,`whatsappproduct_updatedby`,`whatsapp_id`,`whatsappstock_status`) VALUES ('PPTM2407059','PPGM2407053','PPMM240620134','','','General Services VAT 0%','PG005','1','',0,0,'','U1','2024-07-05 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'General Services VAT 0%','',NULL,NULL,'N',NULL,NULL,'Y',NULL,0,'../../images/no_preview.jpg',NULL,0,0.00,0.00,'',NULL,0.00,0.00,NULL,NULL,NULL,'N','N','N','','N','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'STXM20240619003',NULL,NULL,NULL,'null','Y');


------products units---------------------


/*
-- Query: select * from pmr_mst_tproductuomclass
-- Date: 2024-07-29 18:05
*/
INSERT INTO `pmr_mst_tproductuomclass` (`productuomclass_gid`,`productuomclass_code`,`productuomclass_name`,`delete_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('PUCM240604132','PUC00000','Box','N','U1','2024-06-04 00:00:00',NULL,NULL);
INSERT INTO `pmr_mst_tproductuomclass` (`productuomclass_gid`,`productuomclass_code`,`productuomclass_name`,`delete_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('PUCM240604133','PUC00002','Carton','N','U1','2024-06-04 00:00:00',NULL,NULL);
INSERT INTO `pmr_mst_tproductuomclass` (`productuomclass_gid`,`productuomclass_code`,`productuomclass_name`,`delete_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('PUCM240604134','PUC00003','Krate','N','U1','2024-06-04 00:00:00',NULL,NULL);
INSERT INTO `pmr_mst_tproductuomclass` (`productuomclass_gid`,`productuomclass_code`,`productuomclass_name`,`delete_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('PUCM240604135','PUC00004','Nos','N','U1','2024-06-20 00:00:00',NULL,NULL);