In the absence of information on prices / balances / goods and other properties of goods, you can use the download data on goods using the common formats of price lists XLS (Excel) and YML (Yandex Market Language).
Please note that the price list must have a specific format. You can download an example of a correctly compiled price list here.
To download the price list in XLS format, go to Profile Settings:
In the window that opens, go to the Download data from XLS section:
In the Download data from XLS section, you can:
As an example, consider loading a new price list from a local storage (computer).
To specify the path to the price list, click on the button
In the window that opens, specify the local path to the price list by clicking the Upload file button and then the Next button:
After that, you will go to the settings page for the downloaded file:
Import Type Parameters:
If the price list contains headers or descriptions in the first line, then it is necessary to check the box Skip the first line so that the contents of this line are not treated as a product or other object for import.
Then indicate what type of data is indicated in the columns of the Excel file. To do this, on the settings page, all columns from the file and the first three lines are displayed:
If the loaded price list has many columns, for example, with several types of prices or product properties, then you can use the horizontal page scroll:
The drop-down menu contains all possible data options that can be imported:
After filling in the parameters of the price list, check the box whose column corresponds to the product identifier. As a rule, the article of goods is marked:
After that, click the Upload file button to upload products from the price list to the portal.
You can use the additional settings if the above logic for loading the price list for one reason or another is not suitable.
On the Automatic Download tab, you can specify a URL link to the final XLS (Excel) file for automatic, periodic downloads.
For automatic download, you must specify a username and password. After specifying the URL link to the file and credentials, click on the Save button.
The tab Download by e-mail is used to receive price lists from a specific email address that does not fit. You can create a specific mailbox, when sending a price list in XLS format to which it will be automatically loaded into the system.
The setting is individual, therefore, if you need the functionality of loading goods using an email address, write to technical support: firstname.lastname@example.org and they will certainly help you implement this setting.
The Frequency of loading tab is used to specify the period of loading the price list from the URL specified in the Automatic loading section.
Specifying the URL to access the price list is a prerequisite for using the Download Frequency function.
After loading the price list, a list of previously loaded price lists, including the just loaded one, will be displayed.
To view the previously used conditions for loading price lists, click on Import Type. To reload the previously loaded price list, but with the changed parameters, click the Add button:
You can check the processing status and view errors that occur in the Data Processing section:
In case of Errors during the download process, the number of errors will be indicated in the Errors column. To view detailed error information, click on the number of errors. In our case, this is the number 6.
The downloadable YML file should contain offerings of a simplified type.
To download, also go to Portal Settings:
In the window that opens, go to the Load data from YML tab:
Select the appropriate settings and specify the local path to the price list in YML format.
Using the above parameters affects the logic of updating existing (previously downloaded) products.
After clicking the Download button, the process of downloading the price list will begin immediately without any additional settings:
After some time (up to 1 minute) the processing status will change from New to Processing:
As soon as the price list is processed, its status will change to Processed. In case of errors during processing, by analogy with the XLS price list, the number of errors will be displayed. To view detailed error information, click on the number of errors.
If you have any difficulties downloading or questions, you can always contact our technical support at: email@example.com and they will certainly help you.