For teams that run on Abicart
Abicart stock value at purchase price
Abicart keeps the stock and the purchase price on each product, and exports products to a file. For the year-end close, stock is valued at what it cost, so shops export their products and multiply stock by purchase price in a spreadsheet.
How it goes today
- Export the products with stock and purchase price.
- Add the stock of each variant to its product.
- Multiply stock by purchase price and add it up.
- Do it again when the accountant asks for another date.
How it can go
Your stock value at purchase price, ready for the year-end close.
Each night the tool saves stock times purchase price for each product and variant, so from the start you can ask for the value on any later date as a file. Products without a purchase price are listed apart, so you can fill them in before the close.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Abicart key in the portal, never in the chat.
With Hypamoon, each night, save the stock and purchase price of every product and variant in our Abicart shop, and the total stock value at purchase price. List products without a purchase price apart. When I ask for a date, give me the file for that date with the value per product and the total, and email it to our accountant if I say so.
You create an API key yourself in your Abicart admin, under Settings, External Connections, API Keys, and copy it with your Store ID. Give this tool its own key; you can switch it off there at any time. It stays yours.
More for teams on Abicart
- Each month I export our webshop orders and turn them into a sheet for the accountant.
- I check the bank for each transfer order and mark it paid in the webshop myself.
- I put the order export next to our purchase prices to see what we earn per order.
- We keep a coloured status on orders that still wait for a product and check them by hand.
- We print a delivery note for each order and walk to the shelves for every one.
- Before I order from a supplier I go through our stock product by product.
- Each quarter I split our sales per country and VAT rate in a spreadsheet.
- Everything for Abicart