-------gmail ----------------------
/*
-- Query: select * from smr_smm_gmail_service where s_no = 1
-- Date: 2024-08-07 09:48
*/
INSERT INTO `smr_smm_gmail_service`
 (`s_no`,`client_id`,`client_secret`,`refresh_token`,`gmail_address`,`default_template`,
 `gmail_status`,`created_date`,`created_by`,`updated_date`,`updated_by`) VALUES
 (1,'948982844176-3tc97upso97s9touaupqcq1oirbdqgg7.apps.googleusercontent.com',
 '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',
 '1//0g-diDx2WJFIDCgYIARAAGBASNwF-L9IrZpeC1WiYyasVYdG5cxHjVDnXFVKYTMuNkHfuSFDxc30UqHZ8RGvGLPXTknxFTOvjAUk',
 'vishwalogesh.yoshops@gmail.com ','\n    <p><br></p><p><br></p><p>Kind regards<br><span style=\"font-weight: 700;\">Tina Huang</span><br><span style=\"font-weight: 700;\">Boba Tea Company</span><br>Tel: 01164030188<br>Email:&nbsp;info@bobateacompany.co.uk<br>Website:<a>&nbsp;www.bobateacompany.co.uk</a><br>Address:&nbsp;Unit 1, Cornwall Business Centre,&nbsp;Cornwall Rd, Leicester,&nbsp;LE18 4XH<br></p><img src=\"https://devstoragevcx.file.core.windows.net/bobatea/BobaTea_GmailLogo.png?sv=2023-01-03&se=2024-08-08T09%3A52%3A40Z&sr=s&sp=rl&sig=6EE6hAHCBNrACkQcNjDKGG0b%2BR%2FHNUSqpmJixRXMgZ0%3D\"><br></p><p></p><p><span style=\"font-weight: 700;\">IMPORTANT</span>: The contents of this email and any attachments are confidential. They are intended for the named recipient(s) only. If you have received this email by mistake, please notify the sender immediately and do not disclose the contents to anyone or make copies thereof. World Options and subsidiaries companies is committed to ensuring the protection of personal data, for more information please read our privacy policy on our website. If you no longer want to receive emails from us, please contact our GDPR department to register your request.</p>','G','2024-03-16 00:00:00','SUSM1709250002','2024-07-16 11:10:53','SUSM1709250001');

---------------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);