How to Manage Retail Prices

https://app.tango.us/app/workflow/How-to-Manage-Retail-Prices-in-DT-Shop-6cd90d3983f34590b7f7a57492cd16b4

1. Products and Prices page

Login to DT Shop and select Products & Prices section.

2. Pricelist visualization

Your Price List is presented in table format with various filters. You can filter it by Product ID, Destination, Operator, Service and other parameters. Alternatively you can export your pricelist to file

3. Pricelist Filters

You can filter by: Destination, Operator, Product Type, Status and under More Filters by: Service, Subservice, Product ID

4. Pricelist Table navigation

You can select columns that you want to see on the screen in by clicking on Filter Columns button

The Description of each Column is provided under More information button

If the number of columns does not fit to one screen use arrows or horizontal scroll at the bottom of the table

5. Three ways to set Retail price

There are three ways to set Retail price:

Margin. After you enter Margin %, Markup will be calculated according to the Margin. Any time the wholesale price changes, the retail price will be recalculated to preserve these Markup and Margin.
Markup from Wholesale. After you enter Markup % from Wholesale Price, Retail Margin and Retail Price will be re-calculated according to Markup. Any time the wholesale price changes, retail price will be recalculated to preserve these Markup and Margin.
Absolute value of Retail Price. After you enter absolute value of Price, Retail Margin and Markup will be re-calculated according to this value. Please note: When setting the retail price as an absolute value, margin and markup will be automatically recalculated whenever the wholesale price changes. To maintain consistent margin, we recommend setting retail prices using SET/MODIFY MARKUP or SET/MODIFY MARGIN functions.

6. Calculating Markup for specific Margin

Currently, DT Shop functions using a Markup concept. This step outlines the process if you would rather establish a specific Margin instead.

Markup is the percentage added to the cost price to determine the selling price. While Margin is the percentage of the selling price that represents profit.

Converting between the two can be done using the formula:

Margin (%) = ((Selling Price - Cost Price) / Selling Price) \* 100

To convert margin to markup, you need to use the following formula:

Markup (%) = (Margin / (100 - Margin)) \* 100

Suppose you have a product with a margin of 30%. You want to calculate the corresponding markup for a 30% Margin

First, convert the margin to a decimal: Margin Decimal = Margin / 100 = 0.30

Now, use the formula to calculate the markup:

Markup (%) = (0.30 / (1 - 0.30)) \* 100 ≈ 42.86%

So, a margin of 30% corresponds to a markup of approximately 42.86%

7. Setting Retail Price for a single product - Step 1

Search for the product you want to change using filters and click on actions button (first column in Search results)

8. Setting Retail Price for a single product - Step 2

In the pop up window enter either Maging or Markup or Absolute Value

You can also add Transaction fee. It is a fee in Source Currency that you may additionally charge to your customers (if positive) for each transaction. The value entered in Transaction fee will appear in the Retail fee column in Search Results and in Price list export CSV. Please note that the fee is not included in Retail Price.

9. Setting Retail Price for a several products - Step 1

If you have several product (upto 10) you can set retail price for them in the table. Search for the product you want to change, using filters and click on the cell with price, in the pop up window change the value (on the screenshot Markup)

10. Setting Retail Price for a several products - Step 2

Repeat for other products you want to change, all edited products will be marked with "pen" icon. Once completed click SAVE CHANGES to save all the changes

11. Setting Retail Price for a large massive of products (in bulk)

For bulk update:

Apply the required filters (for example, by country)
Tick the box to select all products on the screen.
If number of products in search result does not fit on one page, you will see a button that allow you to select all products even those that are not visible on the screen
Select the bulk action you want to proceed with

12. Products Deactivation / Activation back

Deactivated products will not appear in API Get Products response and in DT Shop user interface. To deactivate products follow the same steps as described on the step above

DT Shop Wiki