Updating prices, availability, photos on the site through the E-Trade Tunnel module (adding new products to the online store)

The E-Trade HTTP Tunnel integration module is an application designed for easy and fast interaction of E-Trade Jumper with the online store database (update).

To configure and connect the module, you will need to perform the following steps:

• Transfer files with the module to the hosting account of your site, for example, using the FTP client program.
• Select your site's CMS from the list available in E-Trade Jumper.
• Enter a link to your site in E-Trade Jumper and click the "Connect" button.

Installing the E-Trade Tunnel integration module on your hosting

• Download the module from this link extract the contents of the etrade_http_tunnel2.zip archive to a temporary folder on your local PC. The archive contains directories and files
  
• Copy the contents of the unpacked archive to the root folder of the installed site (CMS of the online store), along with the etrade_http_tunnel2 folder. This can be done, for example, using the FileZilla FTP client .

After that, specify the address of your site and click the Connect button, all other parameters should be filled in automatically.


Manual configuration of the module, if it was not possible to automatically configure the module
Enter your website address

• Provide a link to the module: https://mysite.com/etrade_http_tunnel2/etrade_http_tunnel.php
  where mysite.com is the address of your site
• login: admin
• password: Wd7q6z5H4i (the password is set in the etrade_http_tunnel_login.php file, if the file contains the $new_password variable, you must take the password from this line)

Specify the parameters for accessing the database of your site. These parameters can be taken from the configuration file of your CMS (for example config.php)

Setting up the E-Trade Tunnel integration module to work with the site database of a typical CMS

To download a catalog of products from the site, open the "Download products to the catalog" window by clicking on the shortcut on the desktop

Or select a menu item

Next, select the E-Trade Tunnel data format

Then in the drop-down list "Select CMS" select your CMS to download data from the site. Paste the link to your site in the "Link to your site" field and click the "Connect" button,

If the connection is successfully established, then you will see something like this message

Then you need to open the "Download" tab.

Attention! If at this stage an error appears on the screen, be sure to contact us for help, we will set up the integration for you. There are cases when there are not enough write permissions in the folder where the E-Trade Tunnel module is installed (or other problems), thus the connection will be interrupted. Send us an email. e-mail access to the site via FTP and provide the address of the site.

Manual setting

To create a template for uploading to the site through the E-Trade Tunnel integration module, open the "Upload product catalog" window by clicking on the shortcut on the desktop

or by selecting the menu item

then click "+" and select "E-Trade Tunnel" format


After creating the upload template, you can switch to editing mode by clicking on the "Pencil" button.

If you have not previously installed the E-Trade Tunnel module on your hosting, then you need to do it according to this instruction (before the point of loading data).

Export tab

You can choose which blocks on the site you want to update, as well as set up a more detailed site update using numerous settings.

Selecting data to delete on the site

Allows you to select the items that you want to remove on the site when it is updated, if they were removed in the base product catalog

When the flag "Delete data immediately on the site" is activated, the data will be deleted without uploading data to the site, that is, without using the "Data upload" subsystem. For example, you delete a product in the base catalog grid, the product will be immediately deleted on the site.
The "Clear" button allows you to delete all previously deleted entries, in order to start using this function from the moment it is activated.

Setting up site database archiving

You can activate the mode of permanent archiving of site data when updating from E-Trade Jumper, thus you will always have the opportunity to return to the previous version of the data if the site update is not correct. A file with an archive copy is created on your hosting in the folder with the E-Trade Tunnel module.

• Create an archive copy of the site database
  After activating this flag, before updating the site, an archive copy of the site database tables will be created, tables that will be updated from E-Trade Jumper.
• Use compression
  When this flag is activated, archived copies will be packed into a zip archive to reduce the space occupied on your hosting.
• Number of days to keep copies
  The number of days to keep files with archived copies of the site database tables.
• File prefix
  Additional Latin text to add to the filename.

Product availability setting

Allows you to adjust the quantity, availability and activity status of products on the site based on the availability statuses set for the products of the base catalog.
The setting can be useful if, for example, you want to set the quantity to 1000 for all products on the site with the "In stock" status and turn off the visibility of products with the "Out of stock" status.

Description of fields

• Activity
  The activity to apply the setting for the current availability status. That is, whether this setting needs to be applied to base catalog items that have this stock status. If the activity is disabled, the quantity, activity, and stock status values are taken individually from each product of the base catalog, which are specified in each product card. This can be useful if you want to send the exact quantity of a product and its activity status to the site.
• Availability status
  The name of the presence status of the base directory.
• Quantity
  The quantity of products prescribed for products on the site that have this status of availability. For example, you can specify on the site a quantity equal to 500 for products that have the "Pre-order" status in the base catalog.
• Product activity
  The same as with the quantity, it only affects the activity of the product on the site. If you want to hide products with a certain status from the site at all, then you should remove the activity flag.
• Name on the site (on file)
  Allows you to register your own name of the availability status on the site. The operation of the function depends on the CMS of the site, it is not supported by all CMS. For CMS OpenCart, you must specify the names of the availability statuses from the admin part to link them to the E-Trade Jumper statuses, for example
  
• Parameter "If the product is not in the unloading"
  Allows you to change the number and activity of products on the site if they are not in the download from E-Trade Jumper. For example, if you upload to the site only products that have the status "In stock", while you want to register a certain amount for products on the site that were not included in the upload or change their activity, then you can set the activity flag for such products and specify amount.

Field unloading settings

Allows you to adjust the update on the site of selected fields for categories, products and manufacturers. For example, you do not need to update the "Description" field, you can uncheck this field so that E-Trade Jumper does not update it on the site.

Description of fields:

• Field type
  Specifies where this field comes from, such as Category, Manufacturer, Product.
• Field
  The name of the field updated on the site.
• Refresh flag
  Activates field update on the site.
• Formula
  Allows you to set an individual condition for updating the value on the site. For example, for the "Price" field, you can set the formula IF(etrade_temp. price_rrp>0, etrade_temp. price_rrp, etrade_temp. price) which will check the filling of the RRP field for the products of the base catalog, if it is filled, then register the value from the RRP field on the site, if it is not filled, then take the value from the Price field.
  
  The field ID for the formula can be taken from the base catalog grid setting, for example etrade_temp. product_f451
  
  Note. RRP is updated on the site automatically if this flag is set in the settings
  

Photo upload settings

You can customize the resizing of photos for display on the site. Attention! This function in E-Trade Jumper is not supported for all CMS. Moreover, many CMS already have a photo resizing function on the site, so you may not need to configure this function.

Setting up SQL queries

You can set up an individual site update based on SQL queries. This mode requires knowledge of the syntax of the SQL language, that is, it may require the involvement of a specialized specialist. Requests can be executed after the site is updated or before it is updated, it depends on your task.

Extra options

For example, you can specify the data of which languages you want to update on the site

For CMS 1C Bitrix, you need to select the infoblock, the data in which you want to update on the site

Description Generator

You can create descriptions for products in the form of a table (html) based on the attributes of the products, in order to save this table on the site in the "Full description" field.

After activating the flag "Generator is enabled" for each unloading, a table with attributes and values will be created for the goods. When the "Filter: empty description" flag is activated, the generator will create a table only for products for which the "Full description" field is not filled in the base catalog.

For the generator, attributes are used in which the flags "Activity" and "Display on the site in the product card" are active in the attribute reference book

In addition to attributes, you can insert these macro substitutions anywhere

• {{product_head.name}} - Product name
• {{product_head.mpn}} - Manufacturer's SKU
• {{product_head.ean}} - EAN barcode
• {{product_head.description_short|raw}} - Short description
• {{product_head.description_full|raw}} - Full description
• {{product_head.tag}} - Tags

Site database recovery

You can restore an archived copy of the site database, for this you need to select the desired archive and click the "Restore" button.

Schedule setting

You can set a schedule for the upload template to regularly update your site.

How to impose a restriction on uploading data

You can shorten the list of products for unloading, specify the conditions under which products should be unloaded, for example, it can be a certain category of products or the status "In stock", more details.

Monitoring the prices of competitors on the Internet