Garden Gives Me Joy
Well-Known Member
I started my first consignment arrangement with a lady at the farmer's market on 1st March this year. Her stall specializes in candles (that she makes). I am trying to figure how to improve arrangements like this for the future, especially since there are some inherent risks with this model. Happy for your opinion on how I can improve.
I gave her 53 bars of soap and viewing access to this Google Sheets spreadsheet (below). (BTW, I quickly adjusted most of the data like prices and quickly re-typed to English. Excuse me if I missed anything).
So how our system has worked so far has been like this.
Every week (like the week that we 'ended on 20 July' because I go to the market on that day when I collect the commission), she sends me a WhatsApp message saying something like: "I sold 2 charcoal, 1 botanicals", etc. So, today, 25th July, I am about to enter her figures for what she sold last week. I plan on going on 27th July.
Inside some cells (like D7), notes give me more details, like how many bars I delivered on specific dates.
... and I enter formulas so I can keep track of all the deliveries amounts and sales.
At the bottom of the page, I show the total of all commission payments.
She seemed to have understood the spreadsheet without any guidance. In fact, she was very complimentary about it some months ago and often referred to it to see how much was due. I noticed that, before she had gotten a hang of the spreadsheet, she used a notebook with so many notes that she could barely figure where to find what she needed or what her notes said when she eventually found them. At least, we agreed on the delivery amounts and that agreement is still in WhatsApp. So every week, I have updated twice; first when she says what she has sold the week before (so we can see how much she owes) and then a second time a day or two after, ie after I go to the market when she pays me my commission. Then I alert her that I have updated the sheet.
Sales were going fine at first. Before I could ask the reason when sales got much lower, she explained that the market had become sluggish because of changes in the country's economy, etc.
... Then she started to complain about her 20-year old son being so young and irresponsible and how upset she was with him, etc, etc because he understated the sales when he did the selling. But she assured me she would pay for everything. She also suggested that I stop sending the spreadsheet to her son also.
... Then she started to complain that she is old school and has trouble understanding the spreadsheet. (Happy for any ways of improving its ease of use.) I also noticed that she would report that there were no sales for those weeks that if I could not make it to the market.
When I look at her social media posts of her table display and I physically go to the fair, I think her stock is far lower than what she has reported. I figure she is now panicking over having to pay to balance everything out. But I feel like she is paying me such small amounts that it is frustrating going to the market just for that amount . However, I also know that, if I do not go or try a cycle of 2 weeks, she will likely say that she had no sales for entire weeks. On 13th July, she claimed to have counted stock and knew the amount by which her son had understated the sales, that she had had no sales the previous and would therefore pay only what her son had understated. ... But I suspect the understatement is much much more than she says. When I was there recently, her son, likely unaware of his mother's concerns, blurted out that they were out of a soap X. I believe that he is telling the truth and that she has still not reported having sold all of that particular soap. One day, she went digging through some draws to find a soap that had gotten damaged and asked for me to deduct it from my deliveries amount. It feels so panicked and uncomfortable. Needless to say, quite some time before I had gotten a feel for the situation, I offered to bring more soaps because the spreadsheet said she was low. She refused, citing how overwhelmed she was and suggested that my system is hard, etc. At least, when I asked, she confirmed not feeling like I had somehow taken advantage of her.
... and then after a gruelling amt of time going through her weekly messages, etc, I also noticed an error that I made in forgetting to adjust one soap's formula for remaining stock for one week. So I suppose she is not actually checking the sheet as well as she should. Otherwise, she would have spotted it.
Happy for suggestions for improvements and new items to my preliminary list of things I could do to fix this situation .. and things to do differently in the future to avoid this from recurring.
Here are some things I thought of.
I gave her 53 bars of soap and viewing access to this Google Sheets spreadsheet (below). (BTW, I quickly adjusted most of the data like prices and quickly re-typed to English. Excuse me if I missed anything).
So how our system has worked so far has been like this.
Every week (like the week that we 'ended on 20 July' because I go to the market on that day when I collect the commission), she sends me a WhatsApp message saying something like: "I sold 2 charcoal, 1 botanicals", etc. So, today, 25th July, I am about to enter her figures for what she sold last week. I plan on going on 27th July.
Inside some cells (like D7), notes give me more details, like how many bars I delivered on specific dates.
... and I enter formulas so I can keep track of all the deliveries amounts and sales.
At the bottom of the page, I show the total of all commission payments.
She seemed to have understood the spreadsheet without any guidance. In fact, she was very complimentary about it some months ago and often referred to it to see how much was due. I noticed that, before she had gotten a hang of the spreadsheet, she used a notebook with so many notes that she could barely figure where to find what she needed or what her notes said when she eventually found them. At least, we agreed on the delivery amounts and that agreement is still in WhatsApp. So every week, I have updated twice; first when she says what she has sold the week before (so we can see how much she owes) and then a second time a day or two after, ie after I go to the market when she pays me my commission. Then I alert her that I have updated the sheet.
Sales were going fine at first. Before I could ask the reason when sales got much lower, she explained that the market had become sluggish because of changes in the country's economy, etc.
... Then she started to complain about her 20-year old son being so young and irresponsible and how upset she was with him, etc, etc because he understated the sales when he did the selling. But she assured me she would pay for everything. She also suggested that I stop sending the spreadsheet to her son also.
... Then she started to complain that she is old school and has trouble understanding the spreadsheet. (Happy for any ways of improving its ease of use.) I also noticed that she would report that there were no sales for those weeks that if I could not make it to the market.
When I look at her social media posts of her table display and I physically go to the fair, I think her stock is far lower than what she has reported. I figure she is now panicking over having to pay to balance everything out. But I feel like she is paying me such small amounts that it is frustrating going to the market just for that amount . However, I also know that, if I do not go or try a cycle of 2 weeks, she will likely say that she had no sales for entire weeks. On 13th July, she claimed to have counted stock and knew the amount by which her son had understated the sales, that she had had no sales the previous and would therefore pay only what her son had understated. ... But I suspect the understatement is much much more than she says. When I was there recently, her son, likely unaware of his mother's concerns, blurted out that they were out of a soap X. I believe that he is telling the truth and that she has still not reported having sold all of that particular soap. One day, she went digging through some draws to find a soap that had gotten damaged and asked for me to deduct it from my deliveries amount. It feels so panicked and uncomfortable. Needless to say, quite some time before I had gotten a feel for the situation, I offered to bring more soaps because the spreadsheet said she was low. She refused, citing how overwhelmed she was and suggested that my system is hard, etc. At least, when I asked, she confirmed not feeling like I had somehow taken advantage of her.
... and then after a gruelling amt of time going through her weekly messages, etc, I also noticed an error that I made in forgetting to adjust one soap's formula for remaining stock for one week. So I suppose she is not actually checking the sheet as well as she should. Otherwise, she would have spotted it.
Happy for suggestions for improvements and new items to my preliminary list of things I could do to fix this situation .. and things to do differently in the future to avoid this from recurring.
Here are some things I thought of.
- Start with less bars, like 2 to 3 bars of each type of soap.
- Make a screen recorded instructional video on how to use the spreadsheet so no one can say they did not understand as an excuse. Perhaps I should remind the retailer to keep their own records so she can spot discrepancies and tell me right away.
- Let a sheet run for only a short period like 3 months before starting a new sheet that carries over the final figures. Maybe this would help both parties when it is necessary to check back figures.