Manual Archives
PSQQQ > Blog > Manual

Bulk feeds updater

Bulk feeds updater is an alternative to “Scheduler”, suitable for prices downloaded locally. Bulk feeds updater allows in one window to configure the loading of prices for updating, to start further updating and export of the Main Feed.

All tasks are launched with the settings with which they were launched last time.

Feeds Priority

By default, none of the feeds has a preference. But it so happens that you need to select a supplier. For this, the function “Feeds Priority” is used.

So If the product has supplier related products, and if at least one of them is in the feeds’ priority, then the one with the higher priority will become the “winner”, its prices and quantities will be used in the recalculation for the item from the Main Feed.

Go to Configuration — Feeds Priority. In the window that opens, put a check mark “Use feeds priorities”, move the lines, set the required order of suppliers’ feed and click “Save”:

Working with RRP/MRP in the Suppliers Feed

Working with RRP/MRP in the Supplier’s Feed is supported in PSQQQ. In this article, we will consider the issue of working with the RRP.

What is RRP and MRP:

  • RRP — Recommended Retail Price.
  • MRP — Minimum Retail Price.

From the point of view of processing the prices of the RRP and MRP, this is the same thing.

PSQQQ uses the RRP abbreviation in all configuration dialogs and visual elements.

What is the RRP for?

The supplier, manufacturer introduces and controls the RRP in order to manage the minimum price in the market for different sellers.

In short, it is impossible to sell cheaper than the RRP. And usually the RRP is controlled, sanctions are applied to violators (products are not shipped, discounts are lost, etc.).

How to take into account the RRP in the Supplier’s Feed?

By default, if you downloaded an item from the RRP, then the RRP will be used when repricing the product. In those, the selling price will become = RRP.

It happens that the same product is available from different suppliers with different RRP. If there is such a situation, then PSQQQ takes the lower RRP as the price.

How to sell cheaper than RRP?

There are several options. Each of these methods has its own advantages and disadvantages. Which one you need, you can understand during the testing of functions:

  1. Do not upload the RRP to the Supplier’s Feed.
  2. Disable Price from RRP from recalculate. To do this, in the Supplier’s Feed, go to the Settings section and put a checkmark “Disabling price list from recalculate”, click “Save”.
  3. Create a margin (Pricing) with the “RRP disable” setting enabled.
    Go to the Margin Setup — Create new rules, set the margin and tick the “RRP disable” box, click “Save”:
  4. Disable the use of RRP for a specific Supplier’s Feed.
    In the Supplier’s Feed, go to the Setting section and put a checkmark RRP disable”, click “Save”
  5. Disable the RRP in the revaluation function globally.
    Go to “Functions — Update prices and quantities at Main Feed”, put a tick on RRP disable” and click “Update”.

How to sell above the RRP?

Usually, they still sell at the RRP. But there are cases when it is possible and necessary to sell higher than the declared value of the RRP.

For example, this is very important if you sell a product on a marketplace, price monitoring showed that there are no competitors for a specific product at a specific time. Then you can sell above the RRP.

In PSQQQ, it is possible to set the following behavior in the function “Update prices and quantities at Main Feed”:

Export Main Feed

To update information about products already on your website, use the function of the PSQQQ  — export Main Feed (from the service).

Export Main Feed to a file

Export Main Feed to a file is carried out simply: in the menu, click Functions — Export Main Feed. In the window that appears, click on Export config for Main Feed:

 

In the window “Export config for Main Feed” select the file type. Then click “Save” (3) and close the  window:

 

In the “Main Feed Export” window, click Run. When the export to file is finished, you can download the file from the Exported Files column:

 

Export Main Feed to email

To export the Main Feed to e-mail, you must:

  1. Select the file format into which the Main Feed will be uploaded.
  2. Write down the e-mail to which the Main Feed will be sent in the selected format.
  3. Next, click “Save”, close “Export config for Main Feed” window and start the export:

Upon completion of the export, a letter with the unloaded Main Feed file will be sent to your e-mail:

Categories mapping to your site’s categories

It so happened that in most cases there are no categories in the Supplier’s Feed, but the opposite situation also happens — they are.

When a supplier provides in its feed and categories, it becomes necessary to compare these categories with their categories, with the categories of the Main Feed. This is not an obligatory action if you have your own generated feed, and you only need to update prices and quantities.

When you need it

This is relevant when copying a supplier’s feed to a Main Feed in the following cases:

  • When you create your Main Feed from supplier’s feed (you do not have your own feed), and categories are needed here.
  • Adding (manual or automatic) new products from Supplier’s Feed to Main Feed (to your feed). Products need to fall into the correct categories for your feed, and this setting can help with this.

For this to work, the Supplier’s Feed must be loaded with categories. Whether there are categories in the Supplier’s Feed can be checked by going to the desired Supplier’s Feed and pressing the Categories button, there will be something like this picture:

 

If there are categories, you can make settings for the mapping of these categories to your categories — the categories of the Main Feed.

How to do it

In the PSQQQ menu, select Functions → Copy supplier feed into Main feed:

 

A dialog box will open, in which you need to select the Supplier’s Feed from which we will copy the products to the Main Feed and for which you need to configure the mapping of categories. Choose from the list of Supplier’s Feed and download the template (list of categories) for customization:

 

A template is an Excel file with a list of categories. In the second column, you need to indicate the name and nesting of your categories, where you need to transfer products from the Supplier’s Feed to the Main Feed (your feed).

If the category and products do not need to be moved, leave the cell empty:

 

After editing the file, save it and load it back into the system for the required Supplier’s Feed:

 

Example categories mapping

 

 1 Block  — the names were changed with nesting categories

 2 Block — empty cells, these categories will not be copied.

3 Block — if you need to combine several categories into one, write the same name for the destination category.