Blog

Continue reading “Currencies”

Continue reading “Translations – how to do and why they are needed.”

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.

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 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”:

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:

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.

In the Main Feed in PSQQQ, you can add or update content from other suppliers feed that are in the PSQQQ.

Why is it needed — if the products in the Main Feed do not have enough content, you can add or update it from any other upload that you have. This can be downloading content from the supplier’s site, for example. Or any other content uploaded to the PM.

As a result, the function allows you to “enrich” your product cards with missing content from other sources.

In addition to content, you can update any other parameters, such as product weight, manufacturer, manufacturer’s article, etc.

To update the content, you must:

1. create a supplier’s feed in the PM and upload a file to it
2. build references between the products of the Main Feed and the supplier feed, where the content was uploaded;
3. launch the content update function, which will update the Main Feed using the created references.

To start the content update function, go to Functions — Content — Update Main Feed content from the supplier

In the window that opens, select the supplier’s feed from which we will update the Main Feed and select the field that needs to be updated. There are three update options: update always, update only if empty, and add new values (for arrays only).

In PSQQQ, you can set a scheduler that will perform a number of configured actions automatically.

When the schedule starts, the following tasks are run by default:

1. All feeds of suppliers that have an external source are loaded (by links, from mail, by API, etc.). If the suppliers feed is loaded from the computer, then such feed will not be loaded accordingly.
2. Launch of the function “Update prices and quantities at Main feed”. And also repricing taking into account the feed of competitors, if it is configured.
3. Export of the Main feed.

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

It is also possible to create an individual set of commands and settings that can be run on a schedule. You need to contact support with this question.

Almost all functions (content updating, building references, copying prices, etc.) that are available in the PSQQQ interface can be launched on a schedule.

Building references is a comparison of a product from the Main Feed and a product from the supplier’s feed, and the subsequent updating of the product from the Main Feed with a product from the supplier’s feed using the constructed reference.

Why do this?

Sometimes the same product may have a different SKU and other characteristics. The SKU created by the manufacturer may differ from the SKU at the seller, or the name of the product may be in different languages ​​in different price lists, or supplied from different places, etc. References between products help to avoid duplicates on the site and correctly make a margin, taking into account the minimum purchase price of suppliers (the minimum prices can also be seen in the Summary report, if references are configured).

There will be one product on the site (no erroneous repetition) with a margin on the supplier’s minimum price.

There are two types of references — made manually and automatically. In practice, this is, as a rule, a combination of both options, when the automatic algorithm works first, and then what is not automatically linked is completed manually.

Building references automatically

In the personal account of the user of the PSQQQ service, in the menu, click on Functions and select “Build references” from the drop-down list.

 

References between products are made according to the article (the best option), name or other data. In the settings, specify between which supplier feed to create a reference now (1), select the field for referring (2) and start the process (3).

 

After the end of the process of building references, the “Preview of references built  by process” window opens. In this window, you can save all created references to the base or delete references:

 

After building references, products with reference change the color of the plus sign — from gray, it turns green. When you click on the plus sign, a plate about the product appears, in which you can see in the feed of which supplier this product is and what the purchase price and the sales price (in this example, with a 10% markup).

 

Even if the product in the updated feed of the supplier disappears and then reappears, the reference will be restored. That is why, within any supplier’s feed, you can selectively delete or all products, but not the supplier’s feed itself (the supplier’s feed is removed from the list of feeds by clicking on Remove on the right in the feed page). If you completely delete the supplier’s feed itself, then all data from the system will disappear, and you will have to reload the supplier’s feed, set the correspondence of fields and create reference between the products of this supplier’s feed and others.

Building references manually

To set up the reference between the products of the Main Feed and the supplier’s feed:

1. Select a product in the supplier’s feed and click on “+” (1);
2. Click on “Add reference” (2);
3. In the window that opens, select the supplier’s feed with which you are making a reference (3);
4. Select the desired product from the list or search for it using the search bar on the right (4)
5. Select the desired product (5);
6. Click “Add reference” (6).