Gross profit report

When adding cost prices, enter them either including or excluding VAT following how you have configured your ShopWired account to enter product and delivery prices.

When cost prices are entered including VAT:

1. For product extras and product choices, the treatment of VAT on cost prices follows the VAT liability of the product
   • If a product is marked as zero-rated/exempt from VAT, product extra and product choice cost prices are assumed to be zero-rated/exempt
   • If a product has a custom VAT rate (or the default VAT rate), product extra and product choice cost prices are assumed to have the same VAT rate
2. For products, cost prices follow the VAT liability of the product
3. For product variations, cost prices follow the VAT liability of the product variation (which can inherit the VAT liability of the product)

Once you've installed the app, you can add cost prices. Cost prices can be added for:

• Products
• Product variations
• Product extras
• Product choices

Cost prices can be added either when creating or editing the product, or using the product import/export system.

To add cost prices for a product, when creating or editing a product navigate to the Cost price section and use the Cost price setting.

To add cost prices for variations, when creating or editing a product navigate to the Variations section and use the Cost price setting to add a cost price for each variation combination. When a variation combination does not have a cost price, it will inherit the cost price added for the product.

To add cost prices for product extras, when creating or editing a product navigate to the Product extras section and use the Cost price setting.

To add cost prices for product choices, you can enter a cost price when configuring the product choice options on the Product choices page.

The cost price added for a product choice option can be overridden when the product choice option is assigned to a product. Use the Cost price setting available for each product choice.

You can add cost prices for products, variations, product extras and product choice options using the product import system:

• Use the Cost Price column to add cost prices for products
• Use the Variant Cost Price column to add cost prices for product variations
• Use the Optional Extra Cost Price 1... column to add cost prices for product extras
• Use the Product Choice Cost Prices column to add cost prices for product choice options

The format of data for each column depends on which type you are adding cost prices for. Refer to the product import column definitions help guide for more information.

Cost prices are stored with an order at the time the order is created.

If a cost price is added or amended after an order is placed, the cost price for the items in previous orders is not affected.

It is not possible to add or edit cost prices for orders.

Once you've received orders for items in an order that have cost prices entered, you can generate a gross profit report for a period of time.

1. Navigate to Dashboard > Reports
2. Locate the Gross profit report
3. Select the period you want to generate the report for using the period from and period to filters
4. Select how many items to include in the report using the number of data points filter
5. Use the brand filter to only generate the report for products assigned to a specific brand
6. Select apply filter

The generated report can be exported to a CSV file by selecting the export report option.

The report lists the applicable products in a table. The report segments products by variations (each variation combination appears as a separate entry in the report).