X-Cart allows setting up product cost prices for automatic margins calculation and generating profit stats reports. It becomes possible with the Cost Price add-on. See general guides on the add-on installation here.

Assign Cost Prices to Products and Product Variants

You can configure a product cost price in the Prices & Inventory section of the product details page.

Specify the value in the "Cost Price" field and click "Update product."

For product variants, use the Variants tab of the product details page.

The procedure is the same - set the value in the "Cost Price" field and click "Save changes."

You can configure the cost price for each product variant separately. However, do mind that cost prices assigned to variants will not display on the product listing. Instead, the product listing page shows the parent product cost price only.

Bulk Edit Cost Prices

It is also possible to assign cost prices and edit their values for multiple products simultaneously.

To do so, select the products you need in the product list in your store's Admin area (Catalog -> Products) and click within the "Bulk edit selected" drop-down.

Proceed to the "Bulk Edit Price and Membership" page.

Use the "Click to specify" button opposite the "Cost price" field, set the value there, and click "Save changes." This way, you assign one cost price to a group of products.

You will see a notification of a successful operation completion shortly after it.

Import Cost Prices

Neither assigning cost prices to single products and product variants via product details nor bulk editing product lists allow specifying different cost price values for multiple products. However, importing cost price values makes this task possible.

To import cost prices, use the regular product.csv file. See Importing Product to X-Cart for details.

To update the cost price values, use the "costPrice" table in the products.csv file.

Statistic Reports

A store automatically generates regular profit reports that are built based on the stock price and cost price difference. The stats data is available on the Statistics page of your store's Admin area (Orders -> Statistics).

Refer to the "Gross profit" line of the "Order Statistics" table to see your net earnings for different periods.

Related pages:

Did this answer your question?