-- ============================================
-- MERGED Import: Both companies into `customers`
-- Total: 551 unique customers/vendors
-- Generated: 2026-09-21 05:11:27
-- ============================================

SET NAMES utf8mb4;

-- ============================================
-- Part 1: Customers
-- ============================================

INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES
(1, '9 Gold Entreprise', '9930032003', '27AAOPT7558G1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(2, 'Aa', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(3, 'Aagam Enterprise', '9819785276', '27AACPJ7083N1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(4, 'A Ahmedally & Co.', '9848022758', '36AABCA4938P1Z8', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(5, 'Aarya Jewels ( Huzaifa Boxwala)', '8928113230', '27BDRPG4535R1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(6, 'A B Corporation', '9867218949', '27AAMFA4306K1ZE', 'Maharashtra', 'both', 'Abdul', 'bill', 'credit', 0, NOW(), NOW()),
(7, 'ACE Diamond Tools', '9821174934', '27ALLPM5777A1ZV', 'Maharashtra', 'both', 'Mishra', 'bill', 'credit', 0, NOW(), NOW()),
(8, 'Acme Engineering', '', '24ABFFA1280J1ZO', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(9, 'Aditi Enterprise', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(10, 'Afsana Enterprises', '9321464332', '27AYVPA1705H1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(11, 'Agarwal and Company', '9829966799', '08ADZPA2164K1Z6', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(12, 'Agkem Impex Pvt Ltd', '', '07AAECA6828P1Z5', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(13, 'Agkem Impex Pvt Ltd ( Noida)', '', '09AAECA6828P1Z1', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(14, 'A G Trading', '9892791121', '27AFWPK1895A1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(15, 'A H Tools Centre', '9820786447', '27AZVPS4307G1ZV', 'Maharashtra', 'both', 'Husain', 'bill', 'credit', 0, NOW(), NOW()),
(16, 'Ajanta Marketing', '7575808561', '24AAFPZ7637M1ZX', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(17, 'Ajay Needle Files', '', '33ARHPV7025L1ZD', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(18, 'Akar Arts', '9820435234', '27AEIPD9649C1ZF', 'Maharashtra', 'both', 'Bharat Bhai', 'bill', 'credit', 0, NOW(), NOW()),
(19, 'Akbar Travels of India Pvt Ltd', '', '27AADCA2140D1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(20, 'Akshay Tools Center ( Cash)', '9867231045', '27ABAPS2559M1Z6', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(21, 'Alamdaar Tools Corner', '9028002152', '27AAIFA8340H1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(22, 'Al Azhar Enterprise', '9819976852', '27AAQPB4872M1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(23, 'Ali Enterprises', '9820370580', '27ALKPM7016K1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(24, 'Alliance Corporation', '', '27ACWPL4322J1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(25, 'All India Tools Centre', '', '27AAAFA2471K1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(26, 'AL Nadir Enterprises', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(27, 'Alpa Tools Centre', '9869139502', '27ALFPP9955R1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(28, 'Amafhh Tools', '9029786452', '27ABLFA4613R1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(29, 'Amazon', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(30, 'Amazon.in', '', '', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(31, 'Ambe Jewels', '9867417325', '27AHYPM5663L1ZB', 'Maharashtra', 'both', 'Kamlesh Mehta', 'bill', 'credit', 0, NOW(), NOW()),
(32, 'Amit Industries', '', '24CUWPP2359B1ZD', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(33, 'Amit tools center', '9890070501', '27ABMPS1423J1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(34, 'Amrolld Marketing', '9899320071', '07AGQPS6781C1ZV', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(35, 'Amu Industries', '9820075961', '19AAEFA5228J1ZE', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(36, 'Angira Diamond & Jewellery Pvt Ltd', '9342015661', '29AAHCM4010A1Z1', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(37, 'Aniket Traders ( Jodhpur)', '8890691855', '08CDOPS1044R1ZQ', 'Rajasthan', 'both', 'Ram Gopal Soni', 'bill', 'credit', 0, NOW(), NOW()),
(38, 'Anjna Industries', '9924488096', '24AAYPV6344G1Z1', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(39, 'Ankitst Exim INC', '', '27AAJFA6712C1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(40, 'Ankitst Jewellery Tools and Machineries(Coimbatore)', '9363109757', '33AAYFA6008J1Z8', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(41, 'Ankit Trades', '9959630201', '36AAMFA8237F1ZC', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(42, 'Anupan Tools Centre', '2223820547', '27AAFPS4287E1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(43, 'A One Industrial Corporation', '9824262382', '24AAPPH6867B1ZM', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(44, 'A-Plus Jewel Tools', '9821433384', '27ABPFA8213K1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(45, 'APPARIO RETAIL PRIVATE LIMITED', '', '27AALCA0171E1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(46, 'Aqmar Trading Corp.', '9845305951', '29AAPPB0207R1ZF', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(47, 'A R C Distributors India Pvt Ltd', '2228602323', '27AAGCA9220M1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(48, 'Arham Enterprise', '', '27AHGPR1492N1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(49, 'Arihant Enterprise', '9820569739', '27AMGPS5254E1ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(50, 'Arihant International', '9820128371', '27AAAFA6537G1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW());

INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES
(51, 'Arihant Sai Traders', '9351792373', '08AAIPR1561R1ZZ', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(52, 'Arko Engineers', '9321662532', '27AAEFA7298N1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(53, 'Arpan Enterprise', '9879074051', '24ABTFA7982P1ZD', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(54, 'Arphi Electronic Pvt Ltd ( Cash)', '8879777943', '27AAACA0404D1ZK', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(55, 'Arrow Speciality Co', '', '27BAPPG0597Q1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(56, 'A R Tools Collection ( Achintu)', '9821107765', '27BAQPS0727K1Z5', 'Maharashtra', 'both', 'Achintu', 'bill', 'credit', 0, NOW(), NOW()),
(57, 'Arvind Art Jewellers', '9823040000', '27AANFM5747R1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(58, 'Arvind Kumar (URD)', '8449942925', '', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(59, 'Arwa Enterprises', '9820382841', '27ADBPV3566C1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(60, 'Asgarally Yusufally', '9820786447', '27AAAFA3616J1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(61, 'Ashirwad Enterprises', '9980548503', '29BGAPG1002P1ZL', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(62, 'Ashoke Press and Machine Tools', '', '24BCAPS7322E1ZV', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(63, 'Atash Abrasives', '7276114789', '27ABVFA0457F1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(64, 'A to Z Sales Corporation', '2223425462', '27AABFA2773R1Z0', 'Maharashtra', 'both', 'Mufaddal', 'bill', 'credit', 0, NOW(), NOW()),
(65, 'Aven Tools Centre', '9004925222', '27AAAFA0427H1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(66, 'Azarro Traders', '', '27ADBPV1381M1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(67, 'Barun Sunatan Hait ( Kutub Sami)', '', '27ABWPH0067P1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(68, 'Best Hardware Mart', '9092259335', '33AOAPK3181N1ZW', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(69, 'Best Trading Company', '9841032098', '33BEBPS0747E1ZS', 'Tamil Nadu', 'both', 'H Shabbir', 'bill', 'credit', 0, NOW(), NOW()),
(70, 'Better Services Pvt Ltd', '9930597355', '27AAGCB9410L1ZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(71, 'Bhagat and Company', '9820584010', '27AAEFB7702L1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(72, 'Bhairavi Designs', '', '27ADVPN8584C1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(73, 'Bhandare Bag House', '91400043', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(74, 'Bharati Freight Forwarders', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(75, 'Bharat Tools Manufacturing Co.', '9872823273', '03ABRPS3044C1ZU', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(76, 'Bhavin Enterprise', '2812461344', '24AMUPS9125J1ZB', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(77, 'Blue Bird Impex', '9820371210', '27AFEPR3336P1ZW', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(78, 'BNL AIR SERVICE', '', '27ABXPL7464P2ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(79, 'Bombay Jalandhar Transport', '', '03AAKFB0481A1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(80, 'Bombay Tools Center ( Vapi)', '8460882030', '26AAGFB5794C1ZG', 'Dadra & Nagar Haveli and Daman & Diu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(81, 'Bombay Tools Centre', '9782372360', '08AFPPB2296D1ZH', 'Rajasthan', 'both', 'Anil', 'bill', 'credit', 0, NOW(), NOW()),
(82, 'Bright Buff Mrg. Co', '9324316556', '27AMTPS1790A1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(83, 'Burhani Alloys and Machinery', '7977257070', '27ANSPB0599A1Z1', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(84, 'Burhani Enterprise', '9029543386', '27ADQPH0354M1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(85, 'Burhani Power Tools', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(86, 'Butma Enterprise', '28863360', '27AADPS4174Q1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(87, 'Cambridge Time Spares', '', '27AAAFC0825B1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(88, 'Cathay Pacific Airways', '', '27AABCC5644E1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(89, 'CEE AAR IMPEX (Clearing Agent)', '', '', '', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(90, 'Chamunda Corporation', '9029804060', '27ATGPG7165B1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(91, 'Chandra and Company ( Trichi)', '9944400700', '33AAMPS6885M1ZQ', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(92, 'Chandra Traders', '9428593600', '24BGKPS5550A1ZJ', 'Gujarat', 'both', 'Bhavik Shah', 'bill', 'credit', 0, NOW(), NOW()),
(93, 'Chennai Traders', '9894342837', '33AMIPT4467G1ZR', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(94, 'Classic Scientific & Surgicals', '9811275212', '07AAEPP1340A1ZD', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(95, 'COCOBLU RETAIL LIMITED', '', '29AAJCC8517E1ZH', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(96, 'Continental Commercial Co.', '23433808', '27ABTPN8666P1ZA', 'Maharashtra', 'both', 'Yusuf', 'bill', 'credit', 0, NOW(), NOW()),
(97, 'COOL Traders', '', '27AAAFC2917Q1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(98, 'Core Tools', '7058634804', '27AGOPC3253D1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(99, 'Cosmos Abrasives', '9619649080', '27AMYPS1101J1ZP', 'Maharashtra', 'both', 'Rakshit Shah', 'bill', 'credit', 0, NOW(), NOW()),
(100, 'Cosmos Jewellery Tools', '9323144258', '27AACPK2092C1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW());

INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES
(101, 'C R Gandhi & Co', '9820103412', '27AAAFC1212G1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(102, 'Crystal Polishing Meterial Industries', '9810447208', '09ADNPK9781A1Z6', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(103, 'Customer', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(104, 'Darshan Industrial Service', '9322293985', '27AAEPS3380H1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(105, 'Darshan Jewel Tools Pvt Ltd', '9004722728', '27AACCD1551G1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(106, 'Darshan Tools (Surat)', '7405109335', '24EXCPS4173K1Z3', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(107, 'Darshini Enterprises', '9820316366', '27BFAPS5479D1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(108, 'D C Creation ( Huzaifa Boxwala)', '', '27BBPPP0191Q1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(109, 'Debkumar Tools Centre', '9167821232', '27CCNPB3424N1ZE', 'Maharashtra', 'both', 'Devu', 'bill', 'credit', 0, NOW(), NOW()),
(110, 'Delhivery Limited', '', '06AAPCS9575E1ZR', 'Haryana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(111, 'Dell International Services India Pvt', '', '33AAACH1925Q2ZG', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(112, 'Dell International Services India Pvt Ltd', '', '27AAACH1925Q1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(113, 'Deora Agency', '23460138', '27AFFPD8301R1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(114, 'Devansh Enterprise', '8976262897', '27AIOPC1546K1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(115, 'Dharm Industries', '9426234471', '24AQNPP0016E1Z8', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(116, 'Dhruvil Enterprise', '9969850822', '27APZPS3565C1Z9', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(117, 'Diamond Creations ( Huzaifa Boxwala)', '', '27AAFFD7868Q1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(118, 'Dipak Metals', '9824217750', '24AEXPS2383D1Z4', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(119, 'Doshi Enterprise', '9819900380', '27AABFD9794R1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(120, 'Dwarkesh Enterprises', '23423602', '27AAAFD5544L1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(121, 'Eagle Engitech', '7016596962', '24AALFE0518L1ZH', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(122, 'Eagle Exports', '7016596962', '24AACFE5131A1ZA', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(123, 'Eagle Industries', '7016596962', '24AABFE8119R1Z2', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(124, 'Eagle Tools Centre Closed', '', '24AACFE0587A1Z0', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(125, 'Ebrahim and Company', '', '27AADFE6114G1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(126, 'Ebrahim Tools Center', '9819684355', '27AAPPK0170L1ZG', 'Maharashtra', 'both', 'Yusuf', 'bill', 'credit', 0, NOW(), NOW()),
(127, 'E-Kart Inc.', '', '07ASLPK3534C1ZY', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(128, 'Ekta Dies & Machinery', '9824293195', '24AIFPR1707A1ZU', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(129, 'Emah Jewellers Tools and Supplies', '', '27AABPG9048B1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(130, 'Empire Time Industries', '9891155989', '07AANPP6056G1ZD', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(131, 'Engro Tools Mfg. Co', '', '27AABFE0372L1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(132, 'Esskay Traders', '9821197373', '27ADFPS2861K1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(133, 'Euroshine Jewellery Works Pvt Ltd', '8850089962', '27AABCH5810P1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 1, NOW(), NOW()),
(134, 'Famous Technologies', '9820310679', '27AKWPK8047P1Z0', 'Maharashtra', 'both', 'Abdulkader Saifuddin Kagalwala', 'bill', 'credit', 0, NOW(), NOW()),
(135, 'Flamingo', '9821252957', '27ADUPS7865G1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(136, 'Freightbridge Logistics', '2267226721', '27AAACF8646G2ZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(137, 'Freya Diamond Jewellery', '91400086', '27AAGHD4215A1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(138, 'Gala Electronics', '2223854510', '27AAAFG4082C1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(139, 'Gandiva Tools India Llp', '9810067678', '07ABAFG1113H1Z0', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(140, 'Gautam Impex', '9323947784', '27ABAPS9191D1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(141, 'G .Dass Enterprises', '9810501067', '07AADFG5019Q1Z3', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(142, 'Geeta Enterprises', '7045043215', '27AJMPM3041Q1ZO', 'Maharashtra', 'both', 'Dinesh Bhai', 'bill', 'credit', 0, NOW(), NOW()),
(143, 'Gemax Industries', '', '27APTPS0922D1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(144, 'General Tools and Wheels', '9443427152', '33AATFG2537P1ZT', 'Tamil Nadu', 'both', 'Hakim / Mustafa', 'bill', 'credit', 0, NOW(), NOW()),
(145, 'Gidhandas & Sons', '23427085', '27AAAFG2766P1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(146, 'Gifts 2 Gifts', '7262863962', '27ABIPR5122K1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(147, 'Giriraj Agencies', '23401650', '27AACPS5534R1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(148, 'Giriraj Trading Corporation', '', '27AABPS8321H1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(149, 'Global Threads', '', '27AQQPB0284R1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(150, 'Globus Transitos Pvt Ltd', '', '07AADCG1329G1ZX', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW());

INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES
(151, 'Glowel', '9810100523', '07ACJPN4392F1ZE', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(152, 'Gogna Tweezer Works', '9988019022', '03AASFG4751E1ZG', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(153, 'Gold Side Production', '9428346869', '24AAPFG1880P1ZS', 'Gujarat', 'both', 'Dilip Kakkad', 'bill', 'credit', 0, NOW(), NOW()),
(154, 'Goodluck Electricals', '', '24ADKPS5101R1Z4', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(155, 'Goodwill Hardware Store', '9833155901', '27AKKPR7951B1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(156, 'Green Stars Sa Pvt. Ltd', '9781987924', '03AAECG4904C1Z9', 'Punjab', 'both', 'Amit', 'bill', 'credit', 0, NOW(), NOW()),
(157, 'Gujarat Goods Service', '', '27AAFFG8339R1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(158, 'Gupta Enterprise', '9820935343', '27ANGPG9807N1ZG', 'Maharashtra', 'both', 'Rakesh', 'bill', 'credit', 0, NOW(), NOW()),
(159, 'Gupta Tools Centre', '9820935343', '27AGBPG2506J1ZQ', 'Maharashtra', 'both', 'Rakesh', 'bill', 'credit', 0, NOW(), NOW()),
(160, 'Gurukripa Tools', '9610688825', '08AQIPB0430H1ZD', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(161, 'H.A Hardware & Power Tools', '9972188851', '29AQMPA5016A1ZC', 'Karnataka', 'both', 'Mohammed Bhai', 'bill', 'credit', 0, NOW(), NOW()),
(162, 'Hakeem Traders ( Chennai )', '9884369812', '33ABRPD6918J1ZE', 'Tamil Nadu', 'both', 'Shabbir', 'bill', 'credit', 0, NOW(), NOW()),
(163, 'Happy Every Day Premium Quality', '9326385621', '27AQPPN2497K1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(164, 'Hari Om Enterprises', '9887853052', '08ALFPA4794H1Z0', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(165, 'Hatim Enterprise', '9029266652', '27AHOPD7937N1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(166, 'Hatim Tools', '9029406651', '27AZFPM9518B1ZC', 'Maharashtra', 'both', 'Shabbir Bhai Bangali', 'bill', 'credit', 0, NOW(), NOW()),
(167, 'H B Enterprises ( Hitesh Bhai)', '9323913327', '27AQSPS2002C1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(168, 'Hemal Enterprises ( Cash )', '9821300579', '27ACEPS2664Q1ZU', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(169, 'Hemco Tools Corp', '', '27AAAFH1138G1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(170, 'Hemnav Ventures Private Limited', '9699976833', '27AAACH6616E1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(171, 'Hindustan Sales & Consultancy', '7045922250', '27APKPK8819G1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(172, 'Hi-Tech Industries', '9326817909', '27AABPB1627P1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(173, 'Hi Tech Precision Tools', '9602744282', '08ABLPD5048F1ZR', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(174, 'H M Art and Craft', '9619108635', '27ALPPA9219H2ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(175, 'H M Enterprises', '9820371210', '27GFQPR8453R1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(176, 'H M Enterprises Closed', '9820371210', '27AABPR8541G1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(177, 'Honesty Engineering Co.', '9833021251', '27AAEFH7753B1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(178, 'Horolap International', '9811856100', '07ABFPB2227C1ZG', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(179, 'HP Enterprise ( Cash)', '982134604', '27ABWPV5863H1ZN', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(180, 'Hutaib Jewellery Tools', '9769947201', '27BVAPB8366E1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(181, 'Imtex Industries', '9610447325', '08ALJPK0896N2ZD', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(182, 'Indco Tools', '', '27ADMPL5985E1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(183, 'Industrial Tools Supply Co(Bang)', '9880016261', '29AABFI0898P1ZM', 'Karnataka', 'both', 'Mufaddal', 'bill', 'credit', 0, NOW(), NOW()),
(184, 'International Traders', '9820017454', '27AAAFI0671D1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(185, 'International Watch Trading Co', '9820290177', '27AAAFI1288C1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(186, 'Ishita Trading Company', '9920098550', '27AAHPP6847P1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(187, 'Jags India Llp', '9820482480', '27AANFJ2868E1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(188, 'Jai Ambe Enterprises', '', '27AAJFJ6590R1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(189, 'Jai Ambe Gifts & Stationery', '9320482480', '27AGEPA6729Q1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(190, 'Jain Auto Industries', '9892021219', '27AAAFJ4649J1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(191, 'Jalpa Jwelery Tools', '9904083363', '24ABGPA4331F1ZD', 'Gujarat', 'both', 'Chetanbhai Arvindbhai Adeshra', 'bill', 'credit', 0, NOW(), NOW()),
(192, 'Janatha Gems Silver Jewellery', '9895124343', '32AADFJ9716B1ZQ', 'Kerala', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(193, 'Jayantilal & Company', '9831004080', '19AASFJ4550G1ZZ', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(194, 'Jayantilal & Company (Closed)', '9831004080', '19ACIPJ0422D1Z3', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(195, 'Jay Bhavani Manufactures ( DRS)', '9426970457', '24AEXPS3231E1ZD', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(196, 'Jay Durga Tools', '9413193794', '08BVYPK9026Q1ZC', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(197, 'Jay Kay Engineers', '9820451251', '27AALPM3622R1Z3', 'Maharashtra', 'both', 'Jignesh', 'bill', 'credit', 0, NOW(), NOW()),
(198, 'Jay Khodiyar Industries', '9879074051', '24AFVPM3761Q1ZJ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(199, 'JCEX Express Ind Pvt Ltd', '', '07AADCJ5337K1ZD', 'Delhi', 'both', '01-26782135', 'bill', 'credit', 0, NOW(), NOW()),
(200, 'J D Associates', '9892447510', '27ACMPV7604F1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW());

INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES
(201, 'Jewelex Int .Pvt .Ltd', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(202, 'Jewel World', '7977260770', '27AGLPS7859J1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(203, 'Jipsy Metal Industries', '9824220550', '24AAOPP1213G1ZZ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(204, 'Jitendra Hardware Mart', '9820120243', '27AAIPS7704B1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(205, 'J. M. International', '9320123115', '27AFFPD3249A1Z0', 'Maharashtra', 'both', 'Manish', 'bill', 'credit', 0, NOW(), NOW()),
(206, 'Jullandar Surgical Works', '9814062533', '03AASPM2601H1ZY', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(207, 'Kalika Tools', '8800160244', '07AOLPJ6544B1Z1', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(208, 'Kalpana Enterprises (Kutub Sami)', '8689866579', '27BUQPM4646B1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(209, 'Kamal Tools', '9391025437', '36AANPP8675R1ZC', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(210, 'Kamruddin Adamjee & Co', '0223739620', '27AAAFK7525L1Z3', 'Maharashtra', 'both', 'Kamruddin', 'bill', 'credit', 0, NOW(), NOW()),
(211, 'Karpagam Tools', '9894095917', '33AACFK3989L1ZW', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(212, 'Kashinath S Hati', '', '27ABLPH2880D1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(213, 'Kasproc Technologies', '9930729951', '27AASFK7643R1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(214, 'Keval Industries', '9624327962', '24CBSPV4538F1Z5', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(215, 'Keval Trading Corp ( Cash)', '', '27AABPJ0149C1ZB', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(216, 'Khambati Jewellery Tools', '', '27AANFK5644H1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(217, 'Khambati Tools Centre', '9821150149', '27AACPK2094E1ZX', 'Maharashtra', 'both', 'Faiyaz Khambati', 'bill', 'credit', 0, NOW(), NOW()),
(218, 'Khambati Tools Collection', '9967066884', '27AALFK1282H1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(219, 'Kheteshwar Hardware & Electrical', '9724253959', '24BXJPP4671B1ZI', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(220, 'King Tools Centre LLP', '2223449664', '27AARFK6397H1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(221, 'Krish International', '2223449109', '27AABPA0730G1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(222, 'K S B International', '9810058705', '07AAMPB1995P1Z3', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(223, 'K S B Metalex Corporation (Drs)', '9810067678', '07AGPPB4858A2ZI', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(224, 'Lago Bandu Motiwale Pvt Ltd', '9769453797', '27AAACL0079M1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(225, 'Lakhani Goldsmith Tools Machinery and Die', '9898272700', '24AAPPL0980R1ZZ', 'Gujarat', 'both', 'Imran Bhai', 'bill', 'credit', 0, NOW(), NOW()),
(226, 'Lakhani Traders', '9376670700', '24ABDPL5834H1ZR', 'Gujarat', 'both', 'Imran Bhai', 'bill', 'credit', 0, NOW(), NOW()),
(227, 'Lalji Mulji Transport Co', '', '24AAAFL2431J1ZP', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(228, 'Laxmi Arts and Craft', '7506319485', '21EQXPR1682A1ZO', 'Odisha', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(229, 'Laxmi Creation ( Huzaifa Boxwala)', '', '27BBPPP0191Q2ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(230, 'Laxmi Sales Corporation', '9969492584', '27AAFPS0023C1Z9', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(231, 'Laxmi Stores', '9007463317', '19ADRPB3177H1ZA', 'West Bengal', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(232, 'Laxmi Vijay Wood Works', '9825672132', '24ASLPS7106C1ZU', 'Gujarat', 'both', 'Dilip', 'bill', 'credit', 0, NOW(), NOW()),
(233, 'Laxmi Wooden Finish', '9426203513', '24AQCPS4975N1Z5', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(234, 'Lina Corp', '9604447395', '27AUNPP0395A1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(235, 'LIVE OAK RESORTS Pvt Ltd ( Ravine Hotel)', '', '27AAACL5085F1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(236, 'Lok Nath Tools Center', '8850461874', '27ALVPD7107K1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(237, 'Lookman & Sons', '', '27AABFL0317Q1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(238, 'Lucky Hardware', '9820133152', '27AABFL6063H1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(239, 'Lucky Surgical Works', '9530903430', '03AJXPK9169L1ZA', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(240, 'Lucky Traders', '9324438523', '27AEAPM8101J1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(241, 'Lucky Trading Co.', '9463687601', '03ASRPK0002B1ZL', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(242, 'Luxury Jewelery ( India ) Pvt. Ltd.', '8850089962', '27AAGCI6554C1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 1, NOW(), NOW()),
(243, 'Mac Forge Tools', '', '27AEZPB7884G1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(244, 'Madhu Tools Centre', '9994454947', '33AVHPB6789P1ZW', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(245, 'Mahalaksshmi', '9344808080', '34AAQFM4261P1ZN', 'Puducherry', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(246, 'Mahalaxami Steel Centre', '9833260429', '27AYJPG0067C2ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(247, 'Mahalaxmi Bottle Stores', '', '27AABFM2042B1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(248, 'Mahalaxmi Mandir Trust', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(249, 'Mahalaxmi Steel Corp.', '8080636268', '27ABSPP9423B1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(250, 'Maharashtra Jewellery Tools', '9820047830', '27ABFFM3420L1Z8', 'Maharashtra', 'both', 'Shamshuddin Bhai', 'bill', 'credit', 0, NOW(), NOW());

INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES
(251, 'Mahaveer Enterprises', '9945145656', '', 'Karnataka', 'both', 'J Mahaveer', 'bill', 'credit', 0, NOW(), NOW()),
(252, 'Mahavir Impex', '9833342018', '27AAJHR6539Q1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(253, 'Mahavir Store( Cash)', '9867760096', '27AACPJ0202F1ZI', 'Maharashtra', 'both', 'Ramesh', 'cash', 'cash', 0, NOW(), NOW()),
(254, 'Mandal Tools', '9717357960', '07AZTPM1321L1Z2', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(255, 'Manek Ojarwala', '9537783797', '24ASUPM8571A1ZG', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(256, 'Mangalmurti Sales Corporation', '8779674427', '27ABGFM2596N1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(257, 'Manibhadra', '9489610848', '33AIYPJ4171D2Z5', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(258, 'Manibhadra Corporation CLOSED)', '9489610848', '33AHPPJ6880R1ZD', 'Tamil Nadu', 'both', 'Niraj Jain', 'bill', 'credit', 0, NOW(), NOW()),
(259, 'Manmohan Tools Centre', '7874943119', '24AIPPR7971J1ZF', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(260, 'Mariya Distributors', '9870062873', '32AKZPP2560R2Z6', 'Kerala', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(261, 'Marpol Parlatici San Tic A.S', '5067411480', '', '', 'both', 'Evgin', 'bill', 'credit', 0, NOW(), NOW()),
(262, 'Marvel Enterprises', '', '27CFLPG8090Q1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(263, 'Mastas Enterprises ( CASH)', '7506317590', '27ABIFM6941P1ZH', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(264, 'Master and Sons', '9773516898', '27EUPPK4418F1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(265, 'Mauli Jewellery Tools', '9920681474', '27BAMPP9552K1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(266, 'Max Technology and Company', '2223821313', '27AHFPR9758Q1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(267, 'Mayur Enterprise', '', '27ANIPS9830M1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(268, 'MD International', '', '27AEBPD8476L1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(269, 'Meet Import & Export', '', '24AEPPD5489K1ZZ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(270, 'Mehta Brothers', '9820092052', '27AFHPM2946M1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(271, 'Metalia & Co.', '9820715517', '27AHHPG2776P1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(272, 'Metro Tools Corporation', '', '27AEYPP4023Q1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(273, 'Metro Transport Service', '9818952560', '07BABPS7195A2ZM', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(274, 'Minesh Traders', '9228105001', '24ABWPL4742R1ZQ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(275, 'Mittal Mills And Hardware Store', '9719116020', '09AASPM7868A1Z5', 'Uttar Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(276, 'M K Bearing Sundicate( Cash)', '', '27AAGPS7897H1ZU', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(277, 'M K International', '2223452816', '27CGNPS0595K1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(278, 'M K Trading', '9619019016', '27BQGPS2242M1ZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(279, 'Modern Fitting Stores', '8879529622', '27AAAPU5816G1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(280, 'Modern Jewellery Tools', '7899932151', '29AALFM5210H1Z9', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(281, 'Mohamadi Hardware and Engineering Stores', '9892030030', '27ABCFM6618F1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(282, 'Mohammed Shadabshaikh', '9321945568', '', 'Maharashtra', 'both', 'Papu', 'bill', 'credit', 0, NOW(), NOW()),
(283, 'Moiz and Brothers', '9967740456', '27ABHFM6802E1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(284, 'Moiz Traders', '9820133147', '27AABPK7330G1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(285, 'Monginis Food Pvt Ltd', '2240786786', '27AAACM5120A1Z7', 'Maharashtra', 'both', 'Sanjay', 'bill', 'credit', 0, NOW(), NOW()),
(286, 'Moon Machinery Mart', '2226756660', '27AAAFM3647B1ZN', 'Maharashtra', 'both', 'Ashish', 'bill', 'credit', 0, NOW(), NOW()),
(287, 'Moonwin Tools', '', '27AAZPS0402R1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(288, 'M. R .Tools', '9029786452', '27BOAPS2194L1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(289, 'M Sakshi International', '9820828148', '27AEFPJ1253B1Z2', 'Maharashtra', 'both', 'Bunty', 'bill', 'credit', 0, NOW(), NOW()),
(290, 'Mtech Softwares', '', '', '', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(291, 'Mukesh and Company CLOSED', '9821080566', '27AAYPS3820Q1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(292, 'Mukesh & Co', '9821080566', '27AVKPS3032K2Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(293, 'Mukesh Enterprise', '9426980906', '24AQSPS8111L1Z9', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(294, 'Mukund Overseas', '2266335300', '27AAAFM1439P1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(295, 'Mulchand R Shah', '9820094653', '27AACFM0165G1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(296, 'Mundra Traders', '9726620152', '24AATFM2970Q2ZE', 'Gujarat', 'both', 'Qusai Pocket', 'bill', 'credit', 0, NOW(), NOW()),
(297, 'Munisuvrata Enterprises ( Mandip)', '9820351910', '27AAGPS5572H1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(298, 'Mutha Venture', '', '27AAKPK6394H1ZE', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(299, 'Nakoda Electric and Hardware Store', '9004290626', '27AAPPJ2217H1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(300, 'Nakoda Traders', '9425056366', '23ADSPS8188A1Z4', 'Madhya Pradesh', 'both', 'Ravish A Jain', 'bill', 'credit', 0, NOW(), NOW());

INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES
(301, 'Nataraj File and Traders', '9381037708', '33AALPP2868A1ZS', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(302, 'National Trading Corporation', '9920439172', '27AAAPB7453N1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(303, 'Navbharat Carbon Company', '', '27AAAFN3943P1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(304, 'Navbharat Jewellery Tools', '', '27AAIFN9727F1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(305, 'Navin Enterprise', '9167094972', '27ACPPM8827J2ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(306, 'Navkar Impex', '9828568491', '08ADXPJ0489N1ZL', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(307, 'New Era Transport Pvt Ltd', '', '24AAHCN9245Q1ZQ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(308, 'New Jodhpur Tools Centre', '9887795951', '08BOGPS9633N1Z1', 'Rajasthan', 'both', 'Nitin Soni', 'bill', 'credit', 0, NOW(), NOW()),
(309, 'New Kolkata Tools ( Secunderabad )', '9966653769', '36ACFPH7816Q1Z1', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(310, 'New Rajumani Transport', '', '27AAEFN8402F1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(311, 'New Tech Manufacturing Co.', '9825021642', '24AFHPS6549A2ZF', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(312, 'New Trade Enterprise', '9869554371', '27ARUPS2631N1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(313, 'New Zenith Trading', '', '27AASFN1956E1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(314, 'New Zenith Trading (Closed)', '9223298243', '27AMRPM9501H1ZN', 'Maharashtra', 'both', 'Shabbir Dhillawala', 'bill', 'credit', 0, NOW(), NOW()),
(315, 'Next to Normal', '9820120144', '27BIMPM0654H1Z3', 'Maharashtra', 'both', 'Kishore', 'bill', 'credit', 0, NOW(), NOW()),
(316, 'N.F Enterprises', '', '27FIYPS4011L1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(317, 'Nickunj Eximp Enterprises Pvt Ltd.', '9167033040', '27AABCN0991K1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(318, 'Nilkanth Enterprise', '9924488096', '24ARUPV1822G1ZH', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(319, 'Nippo Enterprises', '9821281783', '27ACKPS7696C1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(320, 'Nisreen Sales Agency', '8097256195', '27CBZPR5094P1Z6', 'Maharashtra', 'both', 'Murtaza Rupawala', 'bill', 'credit', 0, NOW(), NOW()),
(321, 'Nitco Logistics Private Limited', '', '27AAACN6345A2ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(322, 'Nitin Industries', '', '24BSSPV7069P1ZE', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(323, 'Nitin Works', '2822220963', '24ABUPV1922B1ZN', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(324, 'NK Hearwell Solutions', '9167545222', '27AMGPS9701A1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(325, 'NSI Corporation', '1812203583', '03AADFN9728P1ZQ', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(326, 'Nurani General Store', '9724865252', '24AAIPH3467J1ZM', 'Gujarat', 'both', 'Murtja Jafarji Hajiwala', 'bill', 'credit', 0, NOW(), NOW()),
(327, 'NV Electronics', '9324248908', '27AAAPV8201A1Z3', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(328, 'Omega Tools India', '8506852595', '07BSEPG1851N1ZL', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(329, 'Optovision Optics', '9870062873', '32AKZPP2560R1Z7', 'Kerala', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(330, 'Osborn Lippert ( India) Pvt Ltd', '2402556538', '27AAACL5555G1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(331, 'Pan Products', '2266935162', '27AAEFP8103H1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(332, 'Param Enterprises', '9820112315', '27AAAPD7731P1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(333, 'Partha Dulal Adhikari ( Huzaifa Boxwala)', '', '27AAFPA4662D1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(334, 'Partho Badalchandra Maity', '9892953303', '27AREPM2082K1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(335, 'Parth Tools', '9033271727', '24AADHA5336E1ZU', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(336, 'Perfect Tablet Tools (CASH)', '9223538340', '27ATJPB7801Q1ZA', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(337, 'Perfect Tablet Tools LLP', '9223538340', '27ABCFP2493H1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(338, 'Perfect Tools Centre ( D Anwar)', '', '27CECPS0781N1ZY', 'Maharashtra', 'both', 'D Anwar', 'bill', 'credit', 0, NOW(), NOW()),
(339, 'Perfect Tools Company', '9820237731', '27ACSPS3192F1Z2', 'Maharashtra', 'both', ' Primary Mobile No.', 'bill', 'credit', 0, NOW(), NOW()),
(340, 'Pharmachine India', '', '27AACFP2824M1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(341, 'Phytness Healthcare', '9449806682', '29AATFP2433R1ZA', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(342, 'PIU Barun Hait', '', '27AFQPH3575Q1ZJ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(343, 'P J Engineering Corporation', '9892680707', '27AABPD3334P1ZP', 'Maharashtra', 'both', 'Jayesh Doshi', 'bill', 'credit', 0, NOW(), NOW()),
(344, 'P Kamdar and Co', '', '27AEPPK1413G1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(345, 'Popular Hardware Stores', '9945309452', '29AABFP8454C1Z6', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(346, 'Power Plastic Product', '', '27AKMPS7355N1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(347, 'Power Plastic Products (Closed)', '9974854342', '24AAEPS8293F1ZE', 'Gujarat', 'both', 'Ammar', 'bill', 'credit', 0, NOW(), NOW()),
(348, 'Prachi and Company', '9987646373', '27AUPPS3859L1ZL', 'Maharashtra', 'both', 'Dharmendra Solanki', 'bill', 'credit', 0, NOW(), NOW()),
(349, 'Pratima Jewellery Tools', '9869943833', '27BMKPP6143A1Z4', 'Maharashtra', 'both', 'Praveen Patil', 'bill', 'credit', 0, NOW(), NOW()),
(350, 'Pregna International Ltd', '9904332444', '26AABCP3773B1ZO', 'Dadra & Nagar Haveli and Daman & Diu', 'both', 'Viren Shah', 'bill', 'credit', 0, NOW(), NOW());

INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES
(351, 'Prime International', '1812430675', '03AANPB0297K1ZR', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(352, 'Prince Industries', '', '24ASVPM7601E1ZM', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(353, 'Prominent Surgical Co', '1814011783', '03AADFP0824A1Z4', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(354, 'P. S Arts', '', '27APLPM0185Q1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(355, 'P.Shamji & Sons', '', '27AEMPG0211R1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(356, 'Qualimate ( Amazon)', '', '24ACPPG1199R1ZV', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(357, 'Qumos Enterprises', '9820258552', '27AAYPU0913C1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(358, 'Rahul Tools', '9981666660', '22BDUPS0314P2Z3', 'Chhattisgarh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(359, 'Rainbow Creations', '', '27AAJFR4374B1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(360, 'Rajbhar Enterprises', '9930033367', '27AGPPR3902H1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(361, 'Rajendra Tools ( Closed )', '9828029112', '08ACLPJ2711J1ZM', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(362, 'Raj Enterprises', '', '27BUXPK0909C1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(363, 'Rajesh Enterprise', '9427770474', '24BOKPS3903M1ZK', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(364, 'Rajkot Ojarwala', '9825462106', '24ALJPS6005R1ZJ', 'Gujarat', 'both', 'Parasbhai Shah', 'bill', 'credit', 0, NOW(), NOW()),
(365, 'Raj Medical Distributors', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(366, 'Raj Tools( Cash)', '', '', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(367, 'Raj Trading Co', '9820089520', '27AFYPM4074P1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(368, 'Raj Yog Corporation', '9819042064', '27AAIFR3030K1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(369, 'Ramdas M Nathdwarawala', '9824031274', '24AACFR0769D1ZH', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(370, 'Ramesh and Brothers', '9821360222', '27AAAPA8409R1ZF', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(371, 'Ramesh B. Shah and Company', '3223455770', '27AAPPS1792L1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(372, 'Rameshchandra and Co', '', '27AADPS5610B1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(373, 'Ranjeet Hotel', '', '27AABPO3588N1Z2', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(374, 'Ras Creation ( CASH )', '', '27AAWFR2603L1ZP', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(375, 'Rashitriya Cargo Co', '', '03GDXPS7575A1ZY', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(376, 'Ratna Tools Enterprise', '9824290022', '24AFHPS6550B2ZK', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(377, 'Rattansons International', '9988533636', '03AAPFR6380R2ZB', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(378, 'Ravray Craft and Stationery', '9619108635', '27AAYFR3975K1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(379, 'Rekhi Jewellery Tools & Machineries', '9855142025', '03CDQPR2195Q1ZN', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(380, 'RETAILEZ PRIVATE LIMITED', '', '27AALCR3173P1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(381, 'Rian Inc Dr', '9781987924', '03ABBFR3814K1ZD', 'Punjab', 'both', 'Ashoke Khinder', 'bill', 'credit', 0, NOW(), NOW()),
(382, 'Riddhi Traders', '9819059165', '27AALPK2929D1ZQ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(383, 'RKGEMTEC', '9029031786', '27ABIPL1203H1Z1', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(384, 'Roger Motors Pvt Ltd', '9099084238', '24AAGCR3590K1Z3', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(385, 'Rohit Traders', '9969957047', '27ALMPG5363R1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(386, 'Roshan Industries', '9867155422', '27AAFFR8850C1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(387, 'Rotek Pharma Technologies Pvt Ltd', '8291210105', '27AAKCR8240A1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(388, 'Royal Engineering Solution ( Pune )', '', '27AASFR8316C1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(389, 'Royal International ( Shabbir Mukadam)', '9821134952', '27AAEFR0957M1ZS', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(390, 'Royal Time Industries', '91227687', '24AACFR5141D1ZP', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(391, 'Royal Tools', '23117549', '27AOJPS0983B1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(392, 'Royal Trade Agency', '9341241320', '29BPHPM7716J1ZC', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(393, 'R R Impex Elite India Pvt Ltd', '8976804762', '27AAMCR3632E1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(394, 'R.T. International', '8875373238', '08AFVPG9791E1ZQ', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(395, 'Rudrali Jewel Pvt Ltd ( Cash)', '', '27AAECR9689K1ZF', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(396, 'Saanvi Enterprises', '', '07CGTPP0636C1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(397, 'Safe Dispomed', '', '27ACKPG6212A1Z5', 'Maharashtra', 'both', 'Gaurav', 'bill', 'credit', 0, NOW(), NOW()),
(398, 'Safina Impex ( Tarmal)', '9619382297', '27ABNFS8420Q1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(399, 'Sagar Universal ( Dr)', '9769991774', '27ABRFS6636A1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(400, 'Saifee Travel Bureau', '', '27AAUPS1131Q1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW());

INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES
(401, 'Saif Trading', '8268636519', '27AUJPB6229M1ZC', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(402, 'Sai Krupa Express', '', '24BCVPG7407H1ZE', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(403, 'S. Akbaraly', '', '27AAPFS9968Q1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(404, 'Samaira Art', '9892661201', '27AQCPP3902E1Z4', 'Maharashtra', 'both', 'Soumen Nirmal Paramanick', 'bill', 'credit', 0, NOW(), NOW()),
(405, 'Sampurna Arts', '8828393617', '21GNRPK3565C1ZZ', 'Odisha', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(406, 'Samsan Packet & Tools', '9821147870', '27AAWPM9225D1ZA', 'Maharashtra', 'both', 'Jayesh', 'bill', 'credit', 0, NOW(), NOW()),
(407, 'Samyak Tools', '2249739899', '27BOXPS1317A1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(408, 'Sanghvi Traders', '9619706042', '27AADPS3893G1ZB', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(409, 'Sap Enterprises', '9987501474', '27AJYPS1821Q1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(410, 'Seema Enterprise', '9833014051', '27ALVPS7815D1ZI', 'Maharashtra', 'both', 'Papu', 'bill', 'credit', 0, NOW(), NOW()),
(411, 'Sethia and Co', '9833173218', '27APAPS5419L1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(412, 'Shadow Exports', '9987437786', '27AAAFS0564P1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(413, 'Shafa Tools', '9820047608', '27AAMFS3625D1Z7', 'Maharashtra', 'both', 'Altaf', 'bill', 'credit', 0, NOW(), NOW()),
(414, 'Shahaji Kashiram More', '9323047432', '', 'Maharashtra', 'both', 'Shahaji More', 'bill', 'credit', 0, NOW(), NOW()),
(415, 'Shah Files and Drills Pvt Ltd', '', '27AAACS7143P1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(416, 'Shah Industries', '', '24AFHPS6552D1ZF', 'Gujarat', 'both', 'Ajit', 'bill', 'credit', 0, NOW(), NOW()),
(417, 'Shah Jewellery Tools', '9823033522', '27ADNFS0441D1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(418, 'Shah Sales Corporation', '2223877528', '27AALFS9545H1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(419, 'Shaman Trading Co', '9650923307', '07AAOPI2470E1ZT', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(420, 'Sharp Enterprise', '7405406309', '24ACUFS7214E1ZY', 'Gujarat', 'both', 'Vijay', 'bill', 'credit', 0, NOW(), NOW()),
(421, 'Shashwat Tools', '9821149899', '27AFBPG8815M1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(422, 'Shayona Enterprise', '9869147613', '27ARWPP3297K1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(423, 'Sheela International', '9323799062', '27ADJFS0776R1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(424, 'Shiate Ali Qardan Hasana Trust Mumbai', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(425, 'Shree Ambika Enterprise', '', '27ALJPV6432H1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(426, 'Shree Electronic', '9167545222', '27AEWPD6251L1ZY', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(427, 'Shree Ganesh Tools Centre', '9594473506', '27CYCPP0669N1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(428, 'Shree Jain Traders', '9660576408', '08AJEPJ2947E1ZB', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(429, 'Shree Jay Enterprises', '9426458504', '24AJZPB8499C1ZP', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(430, 'Shreeji Trading Company', '9820454550', '27AKEPM1013F1ZP', 'Maharashtra', 'both', 'Turshar Mehta', 'bill', 'credit', 0, NOW(), NOW()),
(431, 'Shree Mahadev Bag Shop', '', '27ASNPP1185G1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(432, 'Shree Mandeo Metals', '22424333', '27AAOFS0637D1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(433, 'Shree Nath Trading Co.', '9867494646', '27ADQPS5312Q1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(434, 'Shree Radhey Govind Felts Pvt Ltd', '', '08AAKCS9897A1ZR', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(435, 'Shriji Ojarwala', '9825830764', '24AADHS7040F1ZD', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(436, 'Shripadm Trading Company', '', '27ADUFS1722Q1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(437, 'Shri Sai Enterprise', '9764660640', '27AQPPG8004K1ZK', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(438, 'Shyamlal Radhakrishna and Co', '', '27AALFS2322Q1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(439, 'Siddhi Mounting ( Pravin Patil)', '', '27AXCPK0465A1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(440, 'Siddhi Securities', '', '27ALGPM4612B1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(441, 'Sieko Brushware (India)', '8860449766', '07AACFS1123J1ZH', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(442, 'SI ENTEPRISES', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(443, 'Silver Exim', '9867862230', '27ACQFS1782H1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(444, 'Silverwing Patel Carrier', '', '08ABJFS1218G1Z9', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(445, 'Sitaram Ozarwala', '9537431113', '24CVDPP6094D1ZI', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(446, 'S K Products', '9930505562', '27ABBPL0607N1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(447, 'S K Sales Agency', '9930595596', '27ATZPB4256F1ZE', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(448, 'Slicer Grinding Wheels', '9324085585', '27AZCPS4138E1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(449, 'Smb Traders', '9833732282', '27AMUPB4668D1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(450, 'S M Enterprise', '9610447325', '08EKTPK5149D1ZR', 'Rajasthan', 'both', 'Vikas', 'bill', 'credit', 0, NOW(), NOW());

INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES
(451, 'Smit Steel', '33937820', '27AAXPG1765H1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(452, 'Smj Electronics', '2223866853', '27AATFS3368Q1Z1', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(453, 'S.M. Soni Tools & Box Stores', '8469545346', '24BLFPG9968Q1Z6', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(454, 'SNDT Womens University', '', '27AACTS2211D1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(455, 'Sonal Jewellery Tools', '9920222452', '24AEQPB8546L1Z2', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(456, 'Soni Enterprise ( Cash)', '9867178481', '27ASCPS7054C1ZQ', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(457, 'Sonisat Machine Tools Corporation', '', '27AELFS0854F1ZV', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(458, 'Soni Tools Centre ( Yunus )', '9819561852', '27AAAFS7672J1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(459, 'Soni Tools ( Navsari )', '8469620239', '24AYGPS3308B1ZT', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(460, 'Soni Tools ( Surat )', '9913032154', '24AEDPS0610P1ZH', 'Gujarat', 'both', 'Sameer Bhai', 'bill', 'credit', 0, NOW(), NOW()),
(461, 'Sony Trading Company ( Rajkot)', '9429244868', '24AGBPS7204H1ZK', 'Gujarat', 'both', 'Milan Shah', 'bill', 'credit', 0, NOW(), NOW()),
(462, 'S R Enterprises', '9829069410', '08AIGPA0616G1ZU', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(463, 'Sri Amritha Tools Centre', '9363145288', '33ADEPM5850H1ZM', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(464, 'Sri Laxmi Chemicals', '9246541371', '36ACHPP4087H1Z9', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(465, 'Sri Laxmi Tools and Chemical', '9100655094', '36AHCPP3350K1Z9', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(466, 'Sri Mahalaxmi Tools', '9849912614', '36ARVPP5165H1Z3', 'Telangana', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(467, 'Srinathji Jewellery Machinery and Tools', '9558002011', '24AEGFS1299M1ZI', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(468, 'Srinathji Jewellery Tools', '7600250010', '24AEJPS3326L1Z8', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(469, 'S.R. Industries', '8490957777', '24AMDPM0010B1Z5', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(470, 'Sri Rounak Jewellery Equipments', '', '33AFCPJ0713N1ZQ', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(471, 'Sri Vinayaka Tools', '7702770007', '37ASKPD6181F1ZO', 'Andhra Pradesh', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(472, 'S.R. Mehta & Sons', '9820135005', '27AAOFS8206J1ZP', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(473, 'S S Impex', '9314088318', '08AGNPJ7861K1ZP', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(474, 'SSK Retails Pvt Ltd', '', '27AAMCS2964C1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(475, 'Star Enterprise CLOSED', '9821334952', '27AFTPM3173Q1ZH', 'Maharashtra', 'both', 'Shabbir Mukadam', 'bill', 'credit', 0, NOW(), NOW()),
(476, 'Star Surgical Works', '9814099290', '03AACFS8058C1ZG', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(477, 'Star Tools ( Trivedum)', '9892181600', '32AARFS7048F1ZY', 'Kerala', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(478, 'Sterling Enterprises', '9821211512', '27AAAPM6811H1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(479, 'Stok International', '', '27ACTFS8937K1Z0', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(480, 'S T R Tools Centre DR', '4272396817', '33AAPFS5494M1ZD', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(481, 'St. Xaviers College', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(482, 'Subhash Jewellery Tools', '9892704382', '27AQEPM4901E1Z4', 'Maharashtra', 'both', 'Subhash', 'bill', 'credit', 0, NOW(), NOW()),
(483, 'Sun.B.International', '9999950826', '07AAIPB4716E1Z5', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(484, 'Sundaram Enterprise', '7710071402', '27DDZPP9203H1ZT', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(485, 'Sunrise Tools India Pvt Ltd', '9814007925', '03AAECS7037A1ZV', 'Punjab', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(486, 'Sunshine Polishing Industries', '9930595596', '24ADZFS9251P1ZV', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(487, 'Super Gold Tech', '9834089644', '27BFXPY4636M1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(488, 'Super Hydro Pneumatic', '9004686977', '27AACPS6050N1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(489, 'Super Shine Tools', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(490, 'Superstar Enterprises', '22005186', '27AADPM6625N1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(491, 'Super Technology and Co', '9833551992', '27ADTPY7032N1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(492, 'Super Tools Centre ( Dhanji)', '', '27ACRPN1937A1ZL', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(493, 'Supreme Diamond Tools', '', '24AHDPD3960E1ZU', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(494, 'Surya Tools Centre', '9037319035', '32AFHPR5818R1ZR', 'Kerala', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(495, 'Suspense Account', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(496, 'Taher Printer', '9820472567', '27AVZPS0715J1ZW', 'Maharashtra', 'both', 'Taher', 'bill', 'credit', 0, NOW(), NOW()),
(497, 'Tally ( India ) Private Limited', '', '29AACCT3705E1ZJ', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(498, 'Tanush', '9602744282', '08HDZPD6665K1ZI', 'Rajasthan', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(499, 'Tapan Art & Craft', '9820659072', '27AAIHJ7892P1Z6', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(500, 'Techno Tools Traders', '9840133315', '33AACFT2457N1ZY', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW());

INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES
(501, 'TEEM Enterprise ( CASH)', '', '27AKGPP3006A1ZQ', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(502, 'Tekson Enterprises', '9769116696', '27AANFT5223D1Z7', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(503, 'The Arihant Packets and Tools', '9346814870', '36AFMPJ1286Q1ZQ', 'Telangana', 'both', 'Pankaj', 'bill', 'credit', 0, NOW(), NOW()),
(504, 'Thermo Forg Company', '9909009945', '24AANFT0554D1ZD', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(505, 'The Silver Scientific Time Industries', '9825203266', '24AFNPS7255P1ZI', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(506, 'T H Tools Centre', '', '27AETPG6522L1Z0', 'Maharashtra', 'both', 'Taher', 'bill', 'credit', 0, NOW(), NOW()),
(507, 'Tiana Jewellery Exports Private Limited', '9920295116', '27AAECT1580H1ZA', 'Maharashtra', 'both', '', 'bill', 'credit', 1, NOW(), NOW()),
(508, 'T K Ramaraj', '', '33AKHPR8139C1Z5', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(509, 'Trackon Couriers Private', '', '07AABCC8298E1ZH', 'Delhi', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(510, 'Troupe Technologies Private Limited', '9833012144', '27AAGCT4765Q1ZG', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(511, 'Twinkle diamond jewellery (India) Pvt Ltd', '', '27AABCT8924G1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 1, NOW(), NOW()),
(512, 'Unique Industries', '9824580108', '24ABUPB3572F1ZP', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(513, 'Unique Tools Center', '9322230280', '27AADPK6297Q1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(514, 'Universal Enterprise', '9029939641', '27ASJPR4862L1ZZ', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(515, 'USM Enterprises', '9898690886', '24AVJPL5308E1ZT', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(516, 'Uzhou Full Jixin Import & Export Co Ltd', '', '', '', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(517, 'Vaja Traders (CASH)', '9833569772', '27AFPPV7502N1ZL', 'Maharashtra', 'both', 'Mahesh Bhikhu Vaja', 'cash', 'cash', 0, NOW(), NOW()),
(518, 'Vandana Enterprises', '9260363733', '27BNFPS9703P1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(519, 'Vapson Jewellery Equipments Pvt Ltd', '9820287720', '27AACCV0184B1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(520, 'Vardhaman Steel ( Cash)', '', '27ACEPS2549E1ZJ', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(521, 'Vardhman Enterprise ( Rajkot)', '9979023867', '24AMDPD1375J1ZB', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(522, 'Vardhman Enterprises', '9820882634', '27BDSPS9830E1ZW', 'Maharashtra', 'both', 'Ganesh', 'bill', 'credit', 0, NOW(), NOW()),
(523, 'Vardhman Jewellery Tools', '9845665556', '29ADEPS9481L1ZL', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(524, 'Variety Tools', '9819565539', '27AAEFV7967M1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(525, 'Vazirbun Trading', '9962507451', '33AAAFV0380L1Z8', 'Tamil Nadu', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(526, 'Vedant Industries', '8898287249', '27BFTPB3099F1Z5', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(527, 'Vedika Traders', '', '27AFCPM5030K1ZI', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(528, 'Veer Tools', '9819174274', '27AAHFV2272Q1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(529, 'Vegakit India Pvt Ltd', '2223823550', '27AAACV1303J1ZM', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(530, 'Vinked Cloth Pvt Ltd', '', '24AAACV3676Q1ZQ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(531, 'Vishal Sales Corporation', '2266364979', '27AAAFV3023A1ZU', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(532, 'Vishal Trading Company ( Cash)', '9869009801', '27AQUPS7736D1Z5', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(533, 'Vistara Airlines', '', '27AAECT8346F1Z4', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(534, 'V .K International', '', '27AABPA0729P1ZR', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(535, 'V Mehta and Co', '', '27AAAPM2223P1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(536, 'VRL Logistics Limited', '', '29AABCV3609C1ZJ', 'Karnataka', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(537, 'V S Gold', '', '', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(538, 'V S Products', '9321116437', '24AZOPS6858F1ZQ', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(539, 'V- Trans (India) Limited', '', '24AAACV1559Q1ZW', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(540, 'Waman Hari Peth Jewellery', '7202293416', '27AAAFW0236C1ZO', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(541, 'Western India Enterprises', '2228632073', '27BJLPS9037G1ZN', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(542, 'Whalaxy International', '9586851515', '24BXBPB8139G1ZR', 'Gujarat', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(543, 'WJT India Pvt Ltd', '9324798925', '27AADCW3581C1ZD', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(544, 'W J T Trading Co', '2232486884', '27BDDPS8984A1Z6', 'Maharashtra', 'both', 'Alam', 'bill', 'credit', 0, NOW(), NOW()),
(545, 'Wood Design Maker', '9892397357', '27AAAFW9349L1ZH', 'Maharashtra', 'both', 'Raju', 'bill', 'credit', 0, NOW(), NOW()),
(546, 'Xavier Electric', '9923158305', '27ALZPA7408E1ZX', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(547, 'Y M Trading Co ( Cash)', '9619299152', '27AAEPK4469P1Z1', 'Maharashtra', 'both', '', 'cash', 'cash', 0, NOW(), NOW()),
(548, 'Yug Enterprise', '9870928795', '27AOUPM7148D1ZH', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW()),
(549, 'Zai Jewellery Tools', '', '27ACTPB4470G1ZH', 'Maharashtra', 'both', 'Mudar Bhai', 'bill', 'credit', 0, NOW(), NOW()),
(550, 'Zan Jewellery Tools', '9653022454', '27AAAFZ9112E1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW());

INSERT IGNORE INTO `customers` (`id`, `name`, `mobile`, `gst_number`, `state`, `party_type`, `contact_person`, `mode_type`, `payment_type`, `is_sez`, `created_at`, `updated_at`) VALUES
(551, 'Zan Tools Centre', '9029097037', '27ANSPN2854L1Z8', 'Maharashtra', 'both', '', 'bill', 'credit', 0, NOW(), NOW());


-- ============================================
-- Part 2: Opening Balances
-- Company 1 balances (company_id = 1)
-- Company 2 balances (company_id = 2)
-- ============================================

INSERT IGNORE INTO `opening_balances` (`customer_id`, `company_id`, `amount`, `direction`, `as_of_date`, `fiscal_year`) VALUES
(6, 2, 188881.00, 'receive', '2025-04-01', '2024-2025'),
(18, 2, 5685.54, 'receive', '2025-04-01', '2024-2025'),
(25, 2, 2360.00, 'receive', '2025-04-01', '2024-2025'),
(41, 2, 42910.00, 'payable', '2025-04-01', '2024-2025'),
(47, 2, 268898.00, 'payable', '2025-04-01', '2024-2025'),
(57, 2, 6726.00, 'receive', '2025-04-01', '2024-2025'),
(68, 2, 3658.00, 'receive', '2025-04-01', '2024-2025'),
(91, 2, 8496.00, 'receive', '2025-04-01', '2024-2025'),
(100, 2, 11045.00, 'payable', '2025-04-01', '2024-2025'),
(108, 2, 44251.00, 'receive', '2025-04-01', '2024-2025'),
(109, 2, 12971.00, 'receive', '2025-04-01', '2024-2025'),
(119, 2, 66375.00, 'payable', '2025-04-01', '2024-2025'),
(126, 2, 1002224.72, 'payable', '2025-04-01', '2024-2025'),
(128, 2, 22960.00, 'receive', '2025-04-01', '2024-2025'),
(130, 2, 38881.00, 'payable', '2025-04-01', '2024-2025'),
(134, 2, 6286.00, 'receive', '2025-04-01', '2024-2025'),
(145, 2, 53319.00, 'payable', '2025-04-01', '2024-2025'),
(151, 2, 39274.00, 'receive', '2025-04-01', '2024-2025'),
(156, 2, 60825.49, 'receive', '2025-04-01', '2024-2025'),
(160, 2, 10266.00, 'receive', '2025-04-01', '2024-2025'),
(176, 2, 18904.00, 'receive', '2025-04-01', '2024-2025'),
(177, 2, 6036.00, 'payable', '2025-04-01', '2024-2025'),
(178, 2, 104890.80, 'receive', '2025-04-01', '2024-2025'),
(183, 2, 19116.00, 'receive', '2025-04-01', '2024-2025'),
(185, 2, 291498.00, 'receive', '2025-04-01', '2024-2025'),
(195, 2, 6726.00, 'payable', '2025-04-01', '2024-2025'),
(197, 2, 165951.00, 'receive', '2025-04-01', '2024-2025'),
(204, 2, 3068.00, 'receive', '2025-04-01', '2024-2025'),
(222, 2, 36078.00, 'receive', '2025-04-01', '2024-2025'),
(226, 2, 3428.00, 'receive', '2025-04-01', '2024-2025'),
(232, 2, 63083.00, 'payable', '2025-04-01', '2024-2025'),
(244, 2, 48326.00, 'payable', '2025-04-01', '2024-2025'),
(252, 2, 11210.00, 'receive', '2025-04-01', '2024-2025'),
(277, 2, 59531.00, 'payable', '2025-04-01', '2024-2025'),
(280, 2, 240820.00, 'receive', '2025-04-01', '2024-2025'),
(284, 2, 46020.00, 'payable', '2025-04-01', '2024-2025'),
(289, 2, 9062.00, 'payable', '2025-04-01', '2024-2025'),
(297, 2, 47145.00, 'receive', '2025-04-01', '2024-2025'),
(308, 2, 14984.00, 'receive', '2025-04-01', '2024-2025'),
(309, 2, 9794.00, 'receive', '2025-04-01', '2024-2025'),
(338, 2, 81724.00, 'receive', '2025-04-01', '2024-2025'),
(367, 2, 21666.00, 'receive', '2025-04-01', '2024-2025'),
(383, 2, 96288.00, 'payable', '2025-04-01', '2024-2025'),
(399, 2, 23405.00, 'receive', '2025-04-01', '2024-2025'),
(410, 2, 146171.00, 'receive', '2025-04-01', '2024-2025'),
(415, 2, 7762.00, 'payable', '2025-04-01', '2024-2025'),
(419, 2, 46704.00, 'payable', '2025-04-01', '2024-2025'),
(428, 2, 89325.78, 'receive', '2025-04-01', '2024-2025'),
(442, 2, 25480.00, 'receive', '2025-04-01', '2024-2025'),
(445, 2, 2360.00, 'receive', '2025-04-01', '2024-2025');

INSERT IGNORE INTO `opening_balances` (`customer_id`, `company_id`, `amount`, `direction`, `as_of_date`, `fiscal_year`) VALUES
(447, 2, 55125.98, 'receive', '2025-04-01', '2024-2025'),
(450, 2, 22774.60, 'receive', '2025-04-01', '2024-2025'),
(470, 2, 28674.00, 'receive', '2025-04-01', '2024-2025'),
(471, 2, 10620.00, 'payable', '2025-04-01', '2024-2025'),
(472, 2, 59024.00, 'receive', '2025-04-01', '2024-2025'),
(478, 2, 34457.32, 'payable', '2025-04-01', '2024-2025'),
(485, 2, 32043.00, 'receive', '2025-04-01', '2024-2025'),
(500, 2, 41536.00, 'receive', '2025-04-01', '2024-2025'),
(508, 2, 24648.00, 'payable', '2025-04-01', '2024-2025'),
(517, 2, 212.00, 'receive', '2025-04-01', '2024-2025'),
(518, 2, 133350.00, 'payable', '2025-04-01', '2024-2025'),
(548, 2, 13879.00, 'receive', '2025-04-01', '2024-2025'),
(549, 2, 205185.00, 'payable', '2025-04-01', '2024-2025');