---
title: "Picqer dashboard: one overview, no XLOOKUP · Hypamoon"
description: "Stitching two Picqer exports together with XLOOKUP every month? Set the overview up once and open it up to date from then on."
url: https://hypamoon.com/connect-to/picqer/dashboard
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Picqer](https://hypamoon.com/connect-to/picqer)
3.  Dashboard

For teams that run on Picqer

# Your monthly Picqer overview, without XLOOKUP.

You pull two exports from Picqer, open Excel and stitch them together. Next month you do it again. That overview can simply be there: your columns, straight from Picqer, up to date when you open it.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=picqer/dashboard)

## How it goes today

1.  Export the purchase order lines from Picqer.
2.  Export the products as well, for the HS code, the weight and the purchase price.
3.  Match the two in Excel with XLOOKUP on the product code, the way the Picqer help article shows it.
4.  Check it, save it and send it to finance.

## How it can go

One page with exactly the columns you need. The HS code shows up where you have filled it in on the product. Your colleague in finance opens it with their own login. Want it in your inbox on the first of the month? Say so when you ask.

## Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Picqer key in the portal, never in the chat.

Your request

> With Hypamoon, make an overview of the purchase order lines in Picqer for the orders placed last month. Add the purchase price from each line, and the HS code and weight of the product. Turn it into a page for my colleague in finance and email it on the first of every month.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~picqer/dashboard&say=a%20page%20for%20finance%20with%20the%20Picqer%20purchase%20order%20lines%20for%20orders%20placed%20last%20month%2C%20with%20the%20purchase%20price%20per%20line%20and%20the%20HS%20code%20and%20weight%20per%20product%2C%20emailed%20monthly.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=picqer/dashboard)

You create the Picqer key yourself under Settings, API Keys. It stays yours.

## More for teams on Picqer

-   [**I want an order to split or pause by a rule of my own, and to hear about it.**](https://hypamoon.com/connect-to/picqer/picklist-rules)
-   [**I want a screen on the floor that shows my packers which box to use.**](https://hypamoon.com/connect-to/picqer/packaging)
-   [**My fulfilment customers share one password.**](https://hypamoon.com/connect-to/picqer/fulfilment-portal)
-   [**I add product images to Picqer one by one, and my import gets stuck.**](https://hypamoon.com/connect-to/picqer/product-images)
-   [**I want my purchasing as a draft first, per supplier or per fulfilment customer.**](https://hypamoon.com/connect-to/picqer/purchasing)
-   [**I invoice my fulfilment customers with an export and a spreadsheet.**](https://hypamoon.com/connect-to/picqer/fulfilment-invoicing)
-   [**I want my customer to register a return, and to know when I refund.**](https://hypamoon.com/connect-to/picqer/returns)
-   [**I want stock and orders to match between Picqer and Exact Online.**](https://hypamoon.com/connect-to/picqer/exact-online-stock)
-   [**I want to sell on Amazon or Kaufland from Picqer.**](https://hypamoon.com/connect-to/picqer/amazon-orders)
-   [**I want to enrich my products and send them to my sales channels.**](https://hypamoon.com/connect-to/picqer/product-data)
-   [**My business customer can't change their own password or make an account.**](https://hypamoon.com/connect-to/picqer/b2b-customer-portal)
-   [**The status page for my customer doesn't have my brand.**](https://hypamoon.com/connect-to/picqer/track-and-trace)
-   [**I want to see revenue per country, or business against consumer.**](https://hypamoon.com/connect-to/picqer/revenue)
-   [**I don't know who did what in my own tool next to Picqer.**](https://hypamoon.com/connect-to/picqer/audit-log)
-   [**I want to ship subscriptions from Picqer without entering each order.**](https://hypamoon.com/connect-to/picqer/subscriptions)
-   [**Orders from my other Shopify location don't reach Picqer.**](https://hypamoon.com/connect-to/picqer/shopify-locations)
-   [**Everything for Picqer**](https://hypamoon.com/connect-to/picqer)
