Sales Analytics
      Back to home
      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 "Sales">"Manual Sales".

        Screen Shot 2022-10-13 at 16.47.42 PM
      2. Select the outlet for which you want to register the sales.
      3. Click on the "Record Manual Sales" button.

        Screen Shot 2022-10-13 at 16.26.34 PM
      4. Select "Import from file".

        Screen Shot 2022-10-13 at 16.26.55 PM
      5. This import works in a similar fashion to the other imports.
        1. Click on "Step 1" to download an empty template.

          Screen Shot 2022-10-13 at 16.27.17 PM
        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.

        Screen Shot 2022-10-13 at 16.27.25 PM
      8. In "Step 3" you get the results of the import.

        Screen Shot 2022-10-13 at 16.27.50 PM
      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.

        Screen Shot 2022-10-13 at 16.31.42 PM
      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.