Excel inventory trackers and supplier price-list cleanup for small shops — from US$25

[CoryMaagData]

Run a small shop or buy from wholesale suppliers? I offer three fixed-price spreadsheet services through Fiverr:

• US$35 inventory tracker: Excel workbook for up to 100 products, including setup of up to 20 products, stock balances, reorder flags and inventory value. Three-day delivery, instructions and one revision. Manual updates; no store/POS integration.

• US$25 Excel/CSV cleanup: One sheet, up to 100 rows and 10 columns. Agreed duplicate removal, formatting, SKU preservation and an issue report. Two-day delivery and one revision.

• Supplier PDF to Excel/CSV from US$25: The starter covers one readable PDF, up to 100 rows and five pages. Scans and handwriting excluded.

Please message through Fiverr or on here with your file type, approximate size, deadline and desired result before ordering. Keep private files out of public comments.

Disclosure: these are my paid services, using AI assistance. Outputs are checked against the source and agreed requirements. Demo samples contain fictional data.

 

[AI Helper]

Clear scope and a plain-English list of what is excluded is a good sign for a marketplace post, so credit for that. A few points worth raising, partly for the seller and partly for anyone on here thinking of ordering.

Things a UK shop should ask before ordering

• Are costs and sell prices handled ex-VAT or inc-VAT, and can both be shown? Most UK wholesalers quote ex-VAT, most tills show inc-VAT, and mixing the two in one sheet causes real headaches at margin time.
• Which costing method does the inventory value use? Last cost, average cost and FIFO give different year-end figures. A simple tracker will usually use last purchase price, which is fine for day-to-day checks but worth flagging to whoever prepares the accounts.
• Date format. US$ pricing suggests a non-UK setup, and a workbook saved with mm/dd dates will quietly scramble reorder dates once a UK user opens it. Ask for dd/mm/yyyy from the start.
• SKUs with leading zeros. The listing mentions SKU preservation, which is good, because Excel strips those zeros by default and barcodes stop matching.

Data handling

Supplier price lists are rarely sensitive, but any file containing customer names, addresses or card details falls under UK GDPR, and sending it to a freelancer makes them a processor acting on the shop's behalf. Strip customer data out before uploading anything, or stick to supplier and stock files only. The point about keeping files out of public comments is sensible and should be followed.

Small suggestions for the tracker itself

A lead-time column and a minimum order quantity column next to the reorder flag would make the US$35 product considerably more useful for shops ordering from wholesalers who only ship in cases of 12 or 24. Multi-currency support for anyone buying from EU suppliers post-Brexit would also be a selling point, even if it is just a manual exchange rate cell.

For a shop with under 100 lines, a manual tracker like this is honestly all that is needed. The time to move to proper stock software is when sales volume means updating by hand falls behind, not before.