Import purchase prices: the basis of meaningful profit analysis

A step-by-step guide
1 screenshotVideo tutorial ↓

Revenue shows what customers bought. To calculate product profitability, Shopstato also needs purchase prices matched to your products.

What to prepare

A UTF-8 file using semicolons and decimal commas, with columns in this order: product code or name; purchase price excluding VAT; purchase price including VAT; VAT rate.

Step by step

  1. Prepare the required columns in the specified order.
  2. Check the separator, encoding, decimal notation and VAT values against the current import form.
  3. Upload the file in Import purchase prices.
  4. Check several matched products after processing, then review the profit report.

An example from the application

Import purchase prices: the basis of meaningful profit analysis – actual Shopstato interfaceEnlarge screenshot ↗
Import purchase prices: the basis of meaningful profit analysis. From the English video tutorial; the values belong to its demonstration.

What to consider when interpreting the result

A plausible total can hide products without purchase prices. Start with high-revenue items and do not treat missing costs as zero.

Continue in the application

Application links require sign-in. Access to a report depends on your permissions and the relevant module.

Watch the steps

Explore the feature on video

English Shopstato video tutorial. Open separately ↗

Read the video transcript

Purchase price import – you upload a CSV file with product purchase prices so that profit can be calculated.

The columns are product code or name, purchase price excluding VAT, purchase price including VAT and the VAT rate, separated by semicolons.

The easiest way is to download the generated CSV file with products and just fill in the prices.

Source: Shopstato help centre . This English guide adds practical context and examples from English video tutorials.
← More articles: Guides

Application screenshot

Your next step

Good decisions start with a clear overview.

Explore your orders, products and customers in one place.

Try Shopstato for free

Which platform does your store use?

Connect WooCommerce with the plugin, or use the API for your custom store.

↑