> ## Documentation Index > Fetch the complete documentation index at: https://razorpay-60c89f9a-mintlify-audit-missing-sections-1778528421.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Bulk Submerchant Upload > With our Bulk Submerchant Upload feature, sub-merchants can be created with all details by uploading a CSV file. It is essential to provide the sub-merchant data in the correct format to upload the CSV file successfully. You will need to download a Text Editor - [Sublime Text](https://www.sublimetext.com/), to identify and fix any formatting issues in the CSV file. ## CSV File Format The table provides the data format to be followed for each sub-merchant: ## Attribute | Description ## reference1 | ## merchant\_name | Merchant Name. Example: Acme Corp ## merchant\_email | Merchant Email. Example: [gaurav.kumar@example.com](mailto:gaurav.kumar@example.com) ## contact\_name | Contact Name. Example: Acme Corp Pvt Ltd ## contact\_email | Contact email. Example: [gaurav.kumar@example.com](mailto:gaurav.kumar@example.com) ## transaction\_report\_email | Email for Transaction Reports. Example: [support@acmecorp.com](mailto:support@acmecorp.com) ## contact\_mobile | Contact phone number. Example: 9000090000 ## organization\_type | Choose **Business Type** from the list in Appendix. For example: `3`. ## business\_name | Business Name. Example: Crowdera ## billing\_label | Billing Label. Example: Crowdera Ventures Private Limited international | International Payments. Following are the options: * `1` - Enabled * `0` - Disabled. *** ## payments\_for | Payments For. Example: Non-Profit Organisation ## business\_model | Choose **Business Model** from amongst the 3 values - 'B2B', 'B2C' or 'B2B+B2C'. This field is optional if `business_category` is `others`. ## business\_category | Choose **Business Category** from the list in Appendix. Example: not\_for\_profit ## business\_sub\_category | Choose **Business Sub Category** from the list in Appendix. Example: charity ## registered\_address | Registered Address Details. Example: 78 Cuddalore Road Vriddhachalam Cuddalore District ## registered\_city | City. Example: Vriddhachalam ## registered\_state | State. Example: Tamil Nadu ## registered\_pincode | Postal Code. Example: 606001 ## operational\_address | Operational Address Details. Example: 78 Cuddalore Road Vriddhachalam Cuddalore District ## operational\_city | City. Example: Vriddhachalam ## operational\_state | State. Example: Tamil Nadu ## operational\_pincode | Postal Code. Example: 606001 ## doe | Business date of Establishment. This is an optional field. Example: 2005-10-23 ## gstin | GST Number. This is an optional field. Example: 12AAAAA0000A1Z5 ## promoter\_pan | PAN Number of Promoter. Example: ADIPI5352E ## promoter\_pan\_name | PAN Name of Promoter. Example: Saurav Kumar ## website | Business Website. Example: [https://acmecorp.com](https://acmecorp.com) ## bank\_account\_name | Bank Account Name. Example: Acme ## bank\_branch\_ifsc | IFSC Code of Bank. Example: KVBL0001210 ## bank\_account\_number | Bank Account Number. Example: 12101245623456 ## company\_cin | Corporate Identity Number or Limited Liability Partnership Identification Number (LLPIN). CIN required if `organization_type` is not Public, Private or LLP. Example: U12345DL2020PLC098765 company\_pan | PAN Number of the Business. For `proprietorship` business type, this is an optional field. Example: AARCA5484G *** company\_pan\_name | PAN Name of Business. Example: Acme ## Bulk Submerchant Onboard Data Checklist Use this checklist and avoid data format issues to upload the CSV file successfully: * Each row of the CSV file must contain one sub-merchant record. * All email fields must have unique entries. This is applicable even if partner email is used. * Correct header row must be present in the CSV file. * Date should be in YYYY-MM-DD format. * Use lower case wherever applicable. As the business category and sub-category are case-sensitive, use given values' list. For example, the value for the business category should be 'others' and not 'Others'. * Do not use commas anywhere in the data. * Business category `others` must have no entry for Business sub\_category. * All the Promoter PAN numbers must have P as the fourth letter and the Company PAN numbers must have either of these letters - C,H,F,A,T,B,L,J,G. * Remove any additional comments from the file before uploading. * Numeric fields must not be truncated or expressed in the exponential format (Pincode, Bank Account Number, and more). ## Formatting Errors Ensure that there are no formatting errors present on the CSV file. To check the file for these errors, open the file using the [Sublime Text Editor](https://www.sublimetext.com/). Given below is the checklist you must run through: * Check whether each line contains one record and no record is split across two lines **Handy Tips** You must disable the Word Wrap under View → Word Wrap to view one record in one line. * Check for unrequired new line character inside a record. * Remove blank rows. * Remove the rows with invalid or unrequired data. * Remove any default data apart from the merchant data. ## Appendix Please refer the following table for **Business Type** and **Business Category** values: ## Attribute | Values Business Type | 1 = `proprietorship`; 2 = `individual`; 3 = `partnership`;? 4 = `private_limited`; 5 = `public_limited`; 6 = `llp`; 7 = `ngo`; 8 = `educational_institutes`; 9 = `trust`; 10 = `society`; 11 = `not_yet_registered`; 12 = `other` ------------ Business Category | `financial_services`; `education`; `healthcare`; `utilities`; `government`; `logistics`; `tours_and_travel`; `transport`; `ecommerce`; `food`; `it_and_software`; `gaming`; `media_and_entertainment`; `services`; `housing`; `not_for_profit`; `social`; `others` Please refer the following table for **Business Sub Category** values: ## Attribute | Values ## FINANCIAL\_SERVICES | mutual\_fund, lending, cryptocurrency, insurance, nbfc, cooperatives, pension\_fund, forex, securities, commodities, accounting, financial\_advisor, crowdfunding, trading, betting, get\_rich\_schemes, moneysend\_funding, wire\_transfers\_and\_money\_orders, tax\_preparation\_services, tax\_payments, digital\_goods, atms ## EDUCATION | college, schools, university, professional\_courses, distance\_learning, day\_care, coaching, elearning, vocational\_and\_trade\_schools, sporting\_clubs, dance\_halls\_studios\_and\_schools, correspondence\_schools, ## HEALTHCARE | pharmacy, clinic, hospital, lab, dietician, fitness, health\_coaching, health\_products, drug\_stores, healthcare\_marketplace, osteopaths, medical\_equipment\_and\_supply\_stores, podiatrists\_and\_chiropodists, dentists\_and\_orthodontists, hardware\_stores, ophthalmologists, orthopedic\_goods\_stores, testing\_laboratories, doctors, health\_practitioners\_medical\_services, testing\_laboratories ECOMMERCE | ecommerce\_marketplace, agriculture, books, electronics\_and\_furniture, coupons, rental, fashion\_and\_lifestyle, gifting, grocery, baby\_products, office\_supplies, wholesale, religious\_products, pet\_products, sports\_products, arts\_and\_collectibles, sexual\_wellness\_products, drop\_shipping, crypto\_machinery, tobacco, weapons\_and\_ammunitions, stamps\_and\_coins\_stores, office\_equipment, automobile\_parts\_and\_equipements, garden\_supply\_stores, household\_appliance\_stores, non\_durable\_goods, pawn\_shops, electrical\_parts\_and\_equipment, wig\_and\_toupee\_shops, gift\_novelty\_and\_souvenir\_shops, duty\_free\_stores, office\_and\_commercial\_furniture, dry\_goods, books\_and\_publications, camera\_and\_photographic\_stores, record\_shops, meat\_supply\_stores, leather\_goods\_and\_luggage, snowmobile\_dealers, men\_and\_boys\_clothing\_stores, paint\_supply\_stores, automotive\_parts, jewellery\_and\_watch\_stores, auto\_store\_home\_supply\_stores, tent\_stores, shoe\_stores\_retail,petroleum\_and\_petroleum\_products, department\_stores, automotive\_tire\_stores, sport\_apparel\_stores, variety\_stores, chemicals\_and\_allied\_products, commercial\_equipments,fireplace\_parts\_and\_accessories, family\_clothing\_stores, fabric\_and\_sewing\_stores, home\_supply\_warehouse, art\_supply\_stores, camper\_recreational\_and\_utility\_trailer\_dealers, clocks\_and\_silverware\_stores, discount\_stores,school\_supplies\_and\_stationery, second\_hand\_stores, watch\_and\_jewellery\_repair\_stores, liquor\_stores, boat\_dealers, opticians\_optical\_goods\_and\_eyeglasse\_stores, wholesale\_footwear\_stores, cosmetic\_stores, home\_furnishing\_stores, antique\_stores, plumbing\_and\_heating\_equipment, telecommunication\_equipment\_stores, women\_clothing, florists, computer\_software\_stores, building\_matrial\_stores, candy\_nut\_confectionery\_shops, glass\_and\_wallpaper\_stores,commercial\_photography\_and\_graphic\_design\_services, video\_game\_supply\_stores, fuel\_dealers,drapery\_and\_window\_coverings\_stores, hearing\_aids\_stores, automotive\_paint\_shops, durable\_goods\_stores,uniforms\_and\_commercial\_clothing\_stores, fur\_shops, industrial\_supplies, bicycle\_stores, second\_hand\_stores, motorcycle\_shops\_and\_dealers, children\_and\_infants\_wear\_stores, women\_accessory\_stores, construction\_materials, books\_periodicals\_and\_newspaper, floor\_covering\_stores, crystal\_and\_glassware\_stores, accessory\_and\_apparel\_stores,hardware\_equipment\_and\_supply\_stores, computers\_peripheral\_equipment\_software, automobile\_and\_truck\_dealers, aircraft\_and\_farm\_equipment\_dealers, antique\_shops\_sales\_and\_repairs, hearing\_aids\_stores, music\_stores, furniture\_and\_home\_furnishing\_store ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SERVICES | repair\_and\_cleaning, interior\_design\_and\_architect, movers\_and\_packers, legal, event\_planning, service\_centre, consulting, ad\_and\_marketing, services\_classifieds, multi\_level\_marketing, construction\_services, architectural\_services, car\_washes, motor\_home\_rentals, stenographic\_and\_secretarial\_support\_services, chiropractors, automotive\_service\_shops, shoe\_repair\_shops, telecommunication\_service, fines, security\_agencies, tailors,type\_setting\_and\_engraving\_services, small\_appliance\_repair\_shops, photography\_labs, dry\_cleaners, massage\_parlors,electronic\_repair\_shops, cleaning\_and\_sanitation\_services, nursing\_care\_facilities, direct\_marketing, lottery,veterinary\_services, affliated\_auto\_rental, alimony\_and\_child\_support, airport\_flying\_fields, golf\_courses, tire\_retreading\_and\_repair\_shops, television\_cable\_services, recreational\_and\_sporting\_camps, barber\_and\_beauty\_shops, agricultural\_cooperatives, carpentry\_contractors, wrecking\_and\_salvaging\_services, automobile\_towing\_services, video\_tape\_rental\_stores, miscellaneous\_repair\_shops, motor\_homes\_and\_parts, horse\_or\_dog\_racing, laundry\_services,electrical\_contractors, debt\_marriage\_personal\_counseling\_service, air\_conditioning\_and\_refrigeration\_repair\_shops, credit\_reporting\_agencies, heating\_and\_plumbing\_contractors, carpet\_and\_upholstery\_cleaning\_services, swimming\_pools, roofing\_and\_metal\_work\_contractors, internet\_service\_providers, recreational\_camps, masonry\_contractors, exterminating\_and\_disinfecting\_services, ambulance\_services, funeral\_services\_and\_crematories, metal\_service\_centres, copying\_and\_blueprinting\_services, fuel\_dispensers, welding\_repair, mobile\_home\_dealers, concrete\_work\_contractors, boat\_rentals, personal\_shoppers\_and\_shopping\_clubs, door\_to\_door\_sales, travel\_related\_direct\_marketing, lottery\_and\_betting, bands\_orchestras\_and\_miscellaneous\_entertainers, furniture\_repair\_and\_refinishing, contractors, direct\_marketing\_and\_subscription\_merchants, typewriter\_stores\_sales\_service\_and\_rentals, recreation\_services, direct\_marketing\_insurance\_services, business\_services, inbound\_telemarketing\_merchants, public\_warehousing, outbound\_telemarketing\_merchants, clothing\_rental\_stores, transportation\_services, electric\_razor\_stores, service\_stations, photographic\_studio, professional\_services ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ## HOUSING | developer, facility\_management, rwa, coworking, realestate\_classifieds, space\_rental, ## NOT\_FOR\_PROFIT | charity, educational, religious, personal ## SOCIAL | matchmaking, social\_network, messaging, professional\_network, neighbourhood\_network, political\_organizations, automobile\_associations\_and\_clubs, country\_and\_athletic\_clubs, associations\_and\_membership, ## MEDIA\_AND\_ENTERTAINMENT | video\_on\_demand, music\_streaming, multiplex, content\_and\_publishing, ticketing, news, video\_game\_arcades, video\_tape\_production\_and\_distribution, bowling\_alleys, billiard\_and\_pool\_establishments, amusement\_parks\_and\_circuses, ticket\_agencies ## GAMING | game\_developer, esports, online\_casino, fantasy\_sports, gaming\_marketplace ## IT\_AND\_SOFTWARE | saas, paas, iaas, consulting\_and\_outsourcing, web\_development, technical\_support, data\_processing ## FOOD | online\_food\_ordering, restaurant, food\_court, catering, alcohol, restaurant\_search\_and\_booking, dairy\_products, bakeries ## UTILITIES | electricity, gas, telecom, water, cable, broadband, dth, internet\_provider, bill\_and\_recharge\_aggregators ## GOVERNMENT | central, state, intra\_government\_purchases, goverment\_postal\_services, ## LOGISTICS | freight, courier, warehousing, distribution, end\_to\_end\_logistics, courier\_services ## TOURS\_AND\_TRAVEL | aviation, accommodation, ota, travel\_agency, tourist\_attractions\_and\_exhibits, timeshares, aquariums\_dolphinariums\_and\_seaquariums TRANSPORT | cab\_hailing, bus, train\_and\_metro, automobile\_rentals, cruise\_lines, parking\_lots\_and\_garages, transportation, bridge\_and\_road\_tolls, freight\_transport, truck\_and\_utility\_trailer\_rentals