> ## Documentation Index
> Fetch the complete documentation index at: https://razorpay-881012b3.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# Bulk Submerchant Upload
> Create sub-merchants (Razorpay Partnership) in bulk using the upload feature successfully. You can format data and avoid failures using this checklist.
Available in
🇮🇳 India
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 |