How to update chain information with a CSV file
CSV is a text format for representing tabular data. The first row contains column names and the next rows contain data itself. The contents of the columns are separated from each other by a comma.
File data must be UTF-8 encoded.
You can download a sample CSV file.
To see the example in LibreOffice, import the text: select UTF-8 encoding, comma as a separator, and double quotes as a text qualifier.
To see the example in Excel, open it in Data → Get external data → From text. Select UTF-8 encoding, comma as a separator, and double quotes as a text qualifier.
Step 1. Prepare a CSV file
To set up automatic daily updates for branch data, create a CSV file. The data must be UTF-8 encoded.
|
Attribute |
Description |
Required field |
|
|
Name of the branch. Specified without quotation marks, case-sensitive. |
Yes |
|
|
Country. Specified in full, without abbreviations. |
Yes |
|
|
The full address for the branch, including the building number. |
Yes |
|
|
Additional address information that doesn't apply to other elements (shopping center/shopping and entertainment complex/shopping and entertainment center, floor, office, premises, boutique, entrance). For example, Roza shopping center, floor 2, office 203. Doesn't include a detailed description of the route to the address (100 meters from the metro station to the north, the blue building to the right of Pushkinsky Public Garden). Don't use brackets or quotation marks. |
No |
|
|
A phone number with the country and area code. If there are multiple phone numbers, separate them with a semicolon ;. |
Yes |
|
|
The ID of the business category this branch belongs to. If there are multiple business categories, separate them with commas. Branches can have up to three business categories, but at least one of them should match the chain category. |
Yes |
|
|
The chain's main website. Specified in lowercase, in full, including http:// or https://. |
Yes |
|
|
An additional website for the chain (for example, a link to a social media page). |
No |
|
|
Opening hours. Days off and non-working days aren't specified. |
Yes |
|
|
Geographical latitude of the branch location. Use a dot as the decimal separator. |
Yes (if the address is inaccurate) |
|
|
Geographical longitude of the branch location. Use a dot as the decimal delimiter. |
Yes (if the address is inaccurate) |
Step 2. Upload the file to the website
Upload the file to your website using an updatable link. The data should be accessible via HTTP or HTTPS.
Step 3. Add a link to the file in Yango for Business
-
On the chain page, go to Branches.
-
Under Branch management, choose File.
-
Add a link to the file, select the CSV type, and click Check. Checking the file may take several hours.
-
If the file is verified successfully, click Publish. In the window that opens, check the changes in the branches. The map can show up to 50 branches with changes. Click Yes, start the upload. The file data will be moderated and uploaded to the Yango for Business database. If the file is large, the data upload may take several days.
If errors are found when checking the file, you'll see an error message. Fix the errors and re-submit the file for review.
To view the branch changes uploaded to the Yango for Business database from the file, click Upload history. The button is available within 24 hours of the first upload.
To update the data once, save the file in CSV or XSLX format and send it using the form. Include your business's email address and phone number in the message. If we have any questions about the uploaded file, we will contact you.
The new data will appear in Yango Maps within a few days, provided the file is properly formatted.