1. Help Center
  2. Sales Analytics

How can I import manual sales data in bulk?

If you have sales data that is not imported via an integrated POS, you can add it to Apicbase as manual sales data. You can also enter this information using an Excel Import. Read this article to learn more.

This import is particularly useful when you have sales data in an Excel file and want to use the import to add the sales data you have using e.g. a macro in Excel.

If you just want to input the sales data manually, you can just use the interface to add the data. Read this article to learn how this works.

 To add manual sales data using the Excel import sheet, follow the steps below:

  1. Click on "Analytics">"Manual Sales".

    Apicbase manual sales import 1
  2. Select the outlet for which you want to register the sales.
  3. Click on the "Record Manual Sales" button.

    Apicbase manual sales import 2
  4. Select "Import from file".

    Apicbase manual sales import 3
  5. This import works in a similar fashion to the other imports.
    1. Click on "Step 1" to download an empty template.

      Apicbase Manual Sales import 4
    2. In the first tab you'll find an empty tab with three columns:
      1. Recipe Apicbase ID: here you can fill in the Apicbase ID for the recipes you have sold. (check next tab for a list of the Apicbase IDs)
      2. Portions sold: The number of portions you have sold for each recipe.
      3. Portion price: The price per portion you have sold.
      4. vat (%): The VAT rate for the sold item.

        Apicbase Manual sales import 6
    3. In the next tab, you find a list of all the recipes linked to this outlet with their name and Apic ID (if you can't find a recipe, it is probably not linked to this outlet. Read this article to learn how to link a recipe to an outlet.)

      Apicbase Manual Sales import 7
  6. Fill in the sales data in the first tab.

    Apicbase Manual Sales Import 8
  7. Save the file and upload it by drag and dropping or selecting it in "Step 2" of the import window.

    Apicbase Manual Sales Import 9
  8. In "Step 3" you get the results of the import.

    Apicbase Manual Sales Import 10
  9. Click on "Go back to manual sales" to be redirected to the regular manual sales registering screen. You can add other items, or still change the ones you have added.
  10. "Save" the manual sales to add the sales data to Apicbase.

    Apicbase Manual Sales Import 11
  11. You will get a popup for confirming. Click "OK" to progress.
  12. You will see the manual sales data import in the oversight and the sales data is also added to the "Sales Analytic" module.