How to enter cost price?

Torgstat allows you to calculate net profit taking into account the cost price of products, which can be entered through the interface or uploaded via an Excel file.

Cost Price Breakdown

The cost price of a product is calculated as the sum of three values:

Cost price (purchase)

Fulfillment

Input VAT

You can enter only the purchase cost price, or break it down all the way to input VAT. The input VAT percentage is calculated from the sum of the cost price and fulfillment, and is entered in rubles.

Cost Price Priority

To ensure accurate cost price calculation in the analyzed period, you can set the cost price:

By supply (for WB only)

From a specific date

Base cost price

Base cost price is the earliest one; it is used if no cost price is set for a date or for a supply. Cost by supply has the highest priority.

We recommend always filling in the base cost price to account for cost price expenses when analyzing historical periods or comparing with them.

How to Enter Cost Price?

Go to the section: My Store — Products — Cost Price.

You can enter or change the cost price for a product manually or upload it via a file.

How to Enter Manually?

To enter or change the cost price value manually:

Double-click in a cell with a date or in the "Base Cost Price" column

Enter the cost price breakdown values in the window that opens

Click OK

To enter cost price by supply:

Go to the "Supplies" tab

Click "Open" in the "Product List" column

Double-click in a cell in the "Cost Price" column

Enter the cost price breakdown values in the window that opens

Click OK

How to Upload Cost Price via a File?

Go to the section: My Store — Products — Cost Price.

To upload cost price via a file, use the template.

To download the template, click the "Import Cost Price" button on the right above the table.

In the "Upload Cost Price" window, select the desired tab and click the "Download Template" button.

The downloaded template will be pre-filled with your product list. The "Value in System" column will be filled in if you have already uploaded cost price for the product.

Fill in the following columns in the template:

New Cost Price

Fulfillment

VAT, RUB

Application Date

Fill in the "Fulfillment" and "VAT" columns if you want to break down the cost price.

The total cost price will equal the sum of all values. All amounts are entered in rubles.

Empty fields and rows will be ignored.

Fill in the value in the "Application Date" column if you want to apply the cost price from a specific date. If no value is specified, the cost price will be saved as the base cost price, i.e., the earliest one.

To ensure the cost price import template uploads without errors, check:

The file contains only one main sheet; delete any auxiliary sheets if you used formulas for value substitution

Cells with values do not contain formulas, only numeric values

All entered values are in numeric format

Uploading Cost Price "By Orders"

The "By Orders" tab in the "Upload Cost Price" window allows you to upload cost price on the order date. This is another way to specify the cost price of a product from a specific date.

How to Find Out the Current Cost Price of a Product?

You can check the current cost price of any product from any report. To do this:

Click on the product item No.

In the pop-up menu, select "Cost Price"

What to Do If the Cost Price Has Not Been Applied?

When uploading cost price via a file, make sure the upload in the cost price import window completed successfully. If errors occurred during the upload, the system will offer to download a file with errors line by line.

Download the file with errors using the link in the "Upload Cost Price" window

Try to fix the errors yourself

If you can't — contact our support, we will help you figure it out.

If you uploaded cost price for a date but do not see the new value in the Products — Cost Price section, make sure the selected period on the right above the table includes the date for which you uploaded the new cost price. You can also check the current cost price of a product by clicking on the item No. — "Cost Price".

How to Fix Errors?

If you made a mistake when uploading cost price, you can delete the saved cost price values.

Before doing this, be sure to check:

The name of the selected store

If you want to clear the cost price for a period, make sure the correct period is selected on the right above the cost price table

Please note that other filters applied to the report, except for the period, do not affect the deletion of saved cost price values.

If you are unsure about your actions, we recommend first downloading the Cost Price report using the "Download" button on the right above the table.

Click the "MORE" button and select the desired action.

Clear for the selected period (by dates for the selected period)

Clear all by dates

Clear all base cost price

Clear all by supplies (for WB only)

Please note that only "Clear for the selected period" will apply to the period selected in the report. All other actions will result in the deletion of all cost price values of the selected type for the store.

How Quickly Will the Cost Price Be Applied?

The cost price will be applied in all reports immediately.

To update data in any report, click the "Update" button on the right above the table. There is no need to refresh the entire page.

Can Cost Price Be Updated Automatically?

Yes, you can specify a link to a file with cost price values filled in according to our template. We will download and update the product cost price from this file several times a day.

To do this, go to the section: My Store — API Connections, select the desired connection — "Edit". Go to the "Integrations" tab.

Links to Yandex.Disk and Google Drive are supported

The file must match the Template

Do You Support Batch Accounting? (FIFO)

No, but we will definitely implement it in the future.