Consignment or Commissioner-Management for second hand stores / Thrift-shops

Explore

This template is made for stores that sell in consignment (also known as commission or concierge)

It was made to keep an overview of your clothing and consigners (original owners of the clothing).

​

What started as this Airtable base turned into a complete software with many more features over the last years. **You can find the complete software here: **

https://www.circle-hand.com

​

Contact me if you have any questions: lennart.wittstock@gmail.com

​

I made this Airtable for two friends who run a second-hand shop called OLA-Ware.It is currently in use at their place and works great. I made two Youtube video to explain this base:

https://youtu.be/vWngyS1tVMw

https://youtu.be/Yi8yVSQ5XUY

​

​

Perfect for:

  • Second Hand Stores, Thirftshops that sell items on a commission also called consignment basis.
  • Synchronisation, of items in the physical Store with a Shopify-Store/Ebay

The Airtable performs the following tasks:

  • Commissioners can easily register via a form. The items they have given into commission can then be linked to their record.
  • Via the mobile phone app, new items can be added and provided with photos within a very short time. Each article is provided with a barcode and scanned with the Airtable-App. This way you can always find/assign each article quickly. (Barcodes can be ordered easily and cheaply online)
  • In the "Page Designer" block a document is automatically created with all the articles given by the committer in the commission. This can then be downloaded and sent to the committer as a receipt.
  • When selling an item, the barcode of the item can be scanned with the Airtable app. The linked record can then be marked as sold. This automatically calculates the commission of the linked commissioner. In the table "Commissioners" the commissions of the respective commissioner are added up.
  • In the table "Transactions" all payouts are recorded, and thus automatically update the "amount to be paid" in the table "Commissioners". The payouts can also be documented with a receipt.

Next Level Stuff:With the software Integromat I have made this airtable even more powerful.

  • With a new sale, a mail/SMS can be sent automatically to the commissioner, which contains variables within a continuous text, such as the sum of the commissions available to him/her. (Mail = Free of charge, SMS = 0,07€ per SMS)

At OLA-Ware, the Airtable also serves as the merchandise management system for their Shopify store (https://ola-ware.com)

  • Via Integromat the products are automatically uploaded to the store. For in-store sales the respective product is automatically taken from the Shopify-Store. For sales in the Shopify-Store the Airtable is automatically updated. So that the respective article is not sold in the store by mistake.
  • A Shopify app also synchronizes the stock with an Ebay account. This creates two new sales channels in addition to the shop.

If you are interested in implementing this solution in your shop, please contact me: lennart.wittstock@gmail.comI am happy to help. Love, Lennart

Explore
Updated January 27, 2023 at 4:04 PM
Copied 82 times
Explore the base
Basic Overview
All Information
To be reduced after one month
To be reduced after one month Galllery
Items older than 2 months
Items older than 2 months Gallery
To be shipped
To be shipped Gallery
Items not picked up
All sales
Unpaid to commissioners
Already paid out to commissioners
Basic Overview
To be paid
Grid view
Reklamationen