2022-04-24
23038
25
8694
4 minutes.


Updating the file with the price list, setting up the receipt of the file from various sources

To manage the download of the file with the price list, open the tab "Download settings" subsection "File with the price list"
elbuz etrade jumper pricelist products show how product linked
The Downloaded File section displays the name of the last downloaded file.

I have an opportunity:

  • Download file to local PC.
  • Open it in a separate window (available for price lists up to 5mb in size, this is a limitation of online Excel).
  • Create a copy of the price list with all settings.

Setting up types of downloading a file with a price list


File

Download file from local PC. To update the file, click the "Choose File" button.
elbuz etrade jumper pricelist add

Link

Download the file with the price list from the link. The link must point to a file, that is, when you click on the link, the download of the file must begin.
elbuz etrade jumper pricelist add
Along with regular links, links to cloud storages are supported:

  • Google Spreadsheets (docs.google.com/spreadsheets)
  • Google Drive (drive. google.com)
  • Cloud Mail.ru (cloud. mail.ru)
  • Cloud Yandex. Disk (yadi. sk)

It is not possible to download a file if the link leads to a regular page on the Internet, for example, to the entrance to the closed part of the personal account, access to which requires the user to enter a login and password.

It is possible to download a file from a link that is protected by a login and password (using HTTP authentication, HTTP 1. 0/1. 1 standard protocol).

Download files from dynamic links with date
You can configure the download of the price list from the link containing the date (changes daily), to do this, specify the macro substitution {get_date(dmY)} in the link instead of the date.

For example, there is a link from a supplier
https://site.com/Price list from 04/09/2019.xlsx

To substitute a dynamic date, specify a link in the form
https://site.com/Price list from {get_date(dmY)}.xlsx

If the link contains only the date (without the year), then specify the macro substitution in this form {get_date(dm)}
If the link contains the year in short form (two numbers), then specify the macro substitution in this form {get_date(dmy)}
If the link contains a separator other than a dot, then specify a macro substitution in this form {get_date(dmY)}, in this example the separator is a hyphen.

Getting prices from a personal account closed with a login and password
The program needs to specify in which fields on the site you need to enter a login and password, to do this, specify a link to the authorization page, get a list of field names from the site and paste them into the required fields, as well as a link to send the authorization form.
elbuz etrade jumper pricelist add
If the link to the price list is in the public part (that is, no login is required) and the link changes every day, for example, a date or some other information is added, then you can set up page parsing using a CSS selector to get a dynamic link to price, setup example
elbuz etrade jumper pricelist add

Email

Uploading a file via e-mail allows you to receive files from the senders you specify.
elbuz etrade jumper pricelist add
Make a condition for filtering messages to receive a price list by e-mail. Specify a limit for receiving letters, for example, by date, in order not to process all letters from the specified sender, but to receive only new letters with up-to-date price lists. Click the Add button and select a condition.
elbuz etrade jumper pricelist add
The following conditions are available to you:

  • Sender's address
    Specify the e-mail address of the sender of the file with the price list (user@domain.com).
  • Message subject
    Specify the text in the subject line of the email.
  • Message content
    Enter the text in the body of the email.
  • Number of days (no more)
    Specify the number of days from the date the message was created by the sender, in order to process only new letters, with new prices.
  • File name
    Specify the name of the attachment file that is in the letter. Attention! It is not possible to search for letters by the field "Attachment file name", initially letters are searched by the fields "Sender's address", "Message subject", "Message content", then the found letter will be searched for the attachment file by name.

You can specify conditions based on the text search mode "Contains" (search by occurrence of words) or "Equals" (exact search).
When searching for emails, if several emails are included in the filter, taking into account the conditions you specified, then only one last email (the newest one) will be selected.

Configure access settings for your mail server
elbuz etrade jumper pricelist add
For some email services mail, you need to activate access via the IMAP protocol.

Gmail

How to enable IMAP access for GMail is described in this section .
It is also possible for GMail to allow the application to access the account .
If the steps above don't work, visit the DisplayUnlockCaptcha page and follow the instructions that appear.

To edit previously added email boxes, open the item in the system settings
elbuz etrade jumper pricelist add

FTP

Uploading a file with a price list via FTP (File Transfer Protocol) or SFTP (SSH File Transfer Protocol)
elbuz etrade jumper pricelist add

API

File upload via API
elbuz etrade jumper pricelist add
For each API provider, there are different settings that affect data loading, example settings
elbuz etrade jumper pricelist add

Site parser

This mode is available when adding a new price list and makes it possible to receive products from a third-party site. To do this, you need to configure the product parser, as described in this section.
elbuz etrade jumper pricelist add


Create a price list online .


Automation of online stores



Save a link to this article


Next