Klar

For all revenues that you do not capture via your Online Store system and that you don't push via the Orders API, you can now use a Google Sheet to upload those revenues.

This can be used to track your offline sales, platform sales etc.

In the Store Configurator of the respective store, add a new "Custom Revenue" sheet as a data source: ​

1. Start- &amp; End Date Here you can either define a single day or a date range for your revenue. If you select a date range we will split the revenue evenly over all dates within that range.
2. SKU Enter the SKU for the product that has been sold here. You can not use a list here, if you sold multiple products, you'll need to create multiple rows here.
3. Quantity The amount of the SKU that has been sold over that time range.
4. Gross Price per Item
 The gross price for which the item was sold.
5. Tax Line The tax rate you had to pay for that product.
6. Country Which country that product was sold to - this is important for your Logistics Costs set-up, if you e.g. have higher Logistics Costs for sales in France than in Germany.
7. Product Title The title of the product you have sold. As with the SKU you can not use a list here, if you sold multiple products, you'll need to create multiple rows here.
8. Sales Category Here you can enter the category of that sale (e.g. 'Offline Retail', 'Platform Market' etc.). This is an important field because you can use this information to allocate those revenues to your channels as well as set up Transaction and Logistic Costs based on this.
9. Sales Sub Category
 If you need to break down your category further, you can do that further.
10. Sales Channel Name
 Here you can enter the Sales Channel Name for that sale (e.g. 'Otto', 'Zalando', 'Rewe'). This is an important field because you can use this information to allocate those revenues to your channels as well as set up Transaction and Logistic Costs based on this.
11. Order ID
 If you get the Order ID from the platform, you can specify that here, to have a more accurate overview in the app. Once again here only one entry per row is possible.
12. Customer ID
 If you have customer information for your sales, you can enter those here. This makes it more precise to identify your New and Returning customers for example.

1. In the Store Configurator of the respective store, add a new "Custom Revenue" sheet as a data source: ​

2. Name your Sheet and open it.
3. Enter your revenues in the sheet
 1. Start- &amp; End Date Here you can either define a single day or a date range for your revenue. If you select a date range we will split the revenue evenly over all dates within that range.
 2. SKU Enter the SKU for the product that has been sold here. You can not use a list here, if you sold multiple products, you'll need to create multiple rows here.
 3. Quantity The amount of the SKU that has been sold over that time range.
 4. Gross Price per Item
 The gross price for which the item was sold.
 5. Tax Line The tax rate you had to pay for that product.
 6. Country Which country that product was sold to - this is important for your Logistics Costs set-up, if you e.g. have higher Logistics Costs for sales in France than in Germany.
 7. Product Title The title of the product you have sold. As with the SKU you can not use a list here, if you sold multiple products, you'll need to create multiple rows here.
 8. Sales Category Here you can enter the category of that sale (e.g. 'Offline Retail', 'Platform Market' etc.). This is an important field because you can use this information to allocate those revenues to your channels as well as set up Transaction and Logistic Costs based on this.
 9. Sales Sub Category
 If you need to break down your category further, you can do that further.
 10. Sales Channel Name
 Here you can enter the Sales Channel Name for that sale (e.g. 'Otto', 'Zalando', 'Rewe'). This is an important field because you can use this information to allocate those revenues to your channels as well as set up Transaction and Logistic Costs based on this.
 11. Order ID
 If you get the Order ID from the platform, you can specify that here, to have a more accurate overview in the app. Once again here only one entry per row is possible.
 12. Customer ID
 If you have customer information for your sales, you can enter those here. This makes it more precise to identify your New and Returning customers for example.

If you don't specify an Order ID e.g., we'll create an Order for each day and each line you've entered in the sheet.

Example: Time Range 01-01-2024 - 04-01-2024, Quantity 20, Gross Price per Item 5, Tax Line 10%

We will create 4 orders for this entry, one for each day, and each of those will carry a gross revenue of 20 with a net revenue of 18.18.

Set-Up

How the sheet works