How to contribute data to the OAR

Follow these step-by-step instructions to contribute your facility/supplier data to the Open Apparel Registry via CSV or Excel file.

There are two ways to contribute facility lists to the Open Apparel Registry: via CSV/Excel file or by API. This guide will walk through the CSV/Excel file process. Learn more about the OAR API here.

Preparing your data

Download the OAR Contributor Template (see buttons below) and copy and paste your list into the template.

Tips for Preparing Your Data:

  • Do not change the column heading titles in the first row.
  • The OAR accepts facilities throughout the supply chain, including dye-houses, mills, laundries, cut and sew, RMG, embellishments and printing. The OAR does not accept raw material locations, such as cotton farms or cattle ranches.
  • The OAR only accepts apparel facility data. This includes facilities contributing to the production of footwear, accessories, leather goods and home textiles.
  • The OAR accepts apparel production facilities. Your list should only contain production facilities, not office addresses or headquarters.
  • All fields in your list must be in English but may include accented or other Unicode characters. Individual fields must be separated with commas.
  • Country names must be translated into English in order to be recognized by the system.
  • File size limit: 5MB
  • Save your file as an Excel file (.xls, .xlsx) or as a CSV UTF-8 (.csv)
  • Please deduplicate your list. The OAR algorithm will check whether the facilities in your list already exist in the OAR and match them accordingly. However, the algorithm will not remove duplicates within your list. Therefore, we ask that you remove duplicate facilities from your list before uploading. Read more about what is considered a duplicate in the OAR.
  • Separate your plots/units/buildings. Please only upload one plot/unit/building per line in your upload. This way, our algorithm and moderation team can easily match entries unit by unit.

Note: Want to divide up your lists? The Open Apparel Registry allows users to search by list. This means that the name of your list will be publicly displayed. This can be useful if you are looking to separate your facilities in a particular way - like by tier, program, certification, etc. If you want to have more than one list, create a separate CSV/Excel file for each list you want displayed.

Embedded Map Users: If you have signed up for an OAR Embedded Map, you will receive a custom template with any additional data points you may have requested. Please use that template and follow the accompanying instructions to prepare your data for upload.

Uploading your data

1. If you haven't already, register for an OAR account and sign in.

NOTE: There can only be one OAR account associated with a Contributor on the OAR. If you think that more than one person from your team will need to access or manage your data on the OAR, we suggest signing up with an email address accessible to multiple team members (like csr@exampleorg.com or info@exampleorg.org).

2. Go to the OAR Contribute page.

Image shows a screenshot of the Contribute button in the OAR.

3. Enter your facility list name. If you're uploading multiple lists, ensure that your list name includes what makes this list unique from the other (Tier 1, Certified Facilities, Program Name, etc). This list name will be public-facing.

4. Enter your list description. Enter a description of this facility list and include a timeframe for the list's validity. This will also be public-facing.

5. Select your CSV/Excel file. Select your prepared file to upload.

6. Select a list to replace. If you have previously uploaded a facility list through this account, you are able to replace that out-dated list and make it inactive through this feature. Simply select the list that your new list is replacing. (If this is your first upload to the OAR, you can skip this step.)

7. Hit Submit! Your list is now processing (meaning it's being run through the OAR's geolocation tools and algorithm). Learn more about what that means here. You'll receive an automated email when the processing is complete.

Finalizing your list

Once your upload has been processed, navigate to the “My Lists” section of your account to review the results of the upload. Here you will be able to see any errors in your list, as well as facilities which require you to manually confirm or reject a match with facilities already in the database.

Your list is now live, although any facilities producing errors or that require confirm/reject are not yet visible in your list.

1. Resolve Errors. In your "My Lists" Dashboard, you'll be able to see if there are any Errors in the list you uploaded. If you see any Errors, you'll want to resolve those before moving forward with the process. Check out the "Processing Data in the OAR" section of our FAQs for more information on Error types and how to resolve them (one common and easily resolved error is a typo in a country name, for instance). Once you've figured out what may have caused the errors, make those updates in your CSV or Excel file and re-upload the full list to the OAR, replacing your previous file.

2. Complete Confirm / Reject: When you upload your list, the algorithm on which the OAR is run will work to match your facilities with those already in the database. For those that are obvious duplicates, the algorithm will automatically match them. For those where the algorithm is below 80% confident it is a match, you will be asked to manually confirm or reject matches of your facilities with those already in the database. Be sure to complete this step in order for all of your facilities to display in the OAR.

Tip: Click on your list and then filter for "Potential Match" to see all of the facilities that require Confirm/Reject in a row, for easy moderating.

Image shows a screenshot of filter by item status in the OAR.

Once you complete Confirm/Reject, your full list is now live and available on the Open Apparel Registry. To learn more about how you can make the most of your data on the OAR, check out our customized stakeholder guides, available on the Getting Started page.

Have any questions as you go through the process? Check out the Processing and Uploading sections of our FAQs page. Still can't find what you need? Feel free to Contact us.