Story 45.6. Submission submitted Email automation for FT seller

General info

This story focuses on automating the email process for first-time sellers on saclab.com when they submit a new item for consignment. The goal is to automatically send follow-up emails and track communication status without manual intervention, ensuring the admin does not need to handle sellers who do not respond. The system will send reminder emails after specified intervals and update both the email thread and Airtable to reflect the communication status.

User story

As an admin at saclab.com,
I want the seller submission follow-up email process to be automated,
So that I don’t have to manually handle sellers who do not respond to our initial and follow-up emails, which will save time and speed up the overall submission process.

Flow

SYB submission submitted May 25.jpg

Acceptance criteria

Test 27.05

01

Scenario 1: FT Seller submits a Hermès bag – we ask for the stamp

Given a seller submits a new Hermès bag for consignment

When: the Tag “First-time Seller” is attached to the deal (see here regarding First-time Seller tag)

Then: The system Automatically sends an email to this seller: “Thank you for submitting your lovely |BNAME|

We’d love to sell it for you on a consignment basis. What does this mean?…”

AND The admin should see this email thread in the inbox of sell@saclab.com

And This email thread should have tag “1st message sent”

Screenshot 2024-10-15 at 16.30.40.png

AND on AirTable SYB Submitted table, in field “Sales communication”, the value “1st message sent” should be automatically selected

Email:

Eng:

Subject: The next steps for selling your |BAG NAME|

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086446

De:

Subject: Vielen Dank für Ihre Verkaufsanfrage

Preview: Wir benötigen noch einige weitere Informationen von Ihnen.

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086449

FR:
Subject: Merci pour votre demande

Preview: Nous aurions besoin de quelques informations supplémentaires de votre part.

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086456


Screenshot 2024-10-15 at 16.28.18.png

Passed

Email template needs to be updated per stakehoder’s request

02

Scenario 2: FT Seller submits a Chanel bag – we ask for the ID card/ serial number

Given a seller submits a new Chanel bag for consignment

When: the Tag “First-time Seller” is attached to the deal (see here regarding First-time Seller tag)

Then: The system Automatically sends an email to this seller: “Thank you for submitting your lovely |BNAME|

We’d love to sell it for you on a consignment basis. What does this mean?…”

AND The admin should see this email thread in the inbox of sell@saclab.com

And This email thread should have tag “1st message sent”

Screenshot 2024-10-15 at 16.30.40.png

AND on AirTable SYB Submitted table, in field “Sales communication”, the value “1st message sent” should be automatically selected

Email:

Eng:

Subject: Thank you for your submission

Preview: We need some more information from you

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086445

De:

Subject: Vielen Dank für Ihre Verkaufsanfrage

Preview: Wir benötigen noch einige weitere Informationen von Ihnen.

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086448

FR:
Subject: Merci pour votre demande

Preview: Nous aurions besoin de quelques informations supplémentaires de votre part.

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086456

Passed

Email template needs to be updated per stakehoder’s request

03

Scenario 3: FT Seller submits a Dior/BV bag

Given a seller submits a new Bottega Veneta or Dior bag for consignment

When: the Tag “First-time Seller” is attached to the deal (see here regarding First-time Seller tag)

Then: The system Automatically sends an email to this seller: “Thank you for submitting your lovely |BNAME|

We’d love to sell it for you on a consignment basis. What does this mean?…”

AND The admin should see this email thread in the inbox of sell@saclab.com

And This email thread should have tag “1st message sent”

Screenshot 2024-10-15 at 16.30.40.png

AND on AirTable SYB Submitted table, in field “Sales communication”, the value “1st message sent” should be automatically selected

Email:

Eng:

Subject: Thank you for your submission

Preview: We need some more information from you

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086447

De:

Subject: Vielen Dank für Ihre Verkaufsanfrage

Preview: Wir benötigen noch einige weitere Informationen von Ihnen.

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086450

FR:
Subject: Merci pour votre demande

Preview: Nous aurions besoin de quelques informations supplémentaires de votre part.

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086456

04

Scenario 4: 1st follow up

Given It’s been 72hours 48hours from when the “Thank you for submitting your bag” email is sent to the seller

When the First-time seller (FT seller) still hasn’t responded

Then the system automatically sends a (1st) follow-up email to the seller

AND The admin should see this email thread in the inbox of sell@saclab.com

And this email thread have tag “Follow-up sent”

AND on AirTable SYB Submitted table, in field “Sales communication”, the value “Follow-up sent” should be automatically selected

Email:

Eng:

Subject: Here’s how to complete the listing of your |BNAME| with SACLÀB

Preview

Template: https://us12.admin.mailchimp.com/templates/editor?id=10086451

De:

Subject: So listen Sie Ihre << bag name >> zum Verkauf mit SACLÀB

Preview

Template:https://us12.admin.mailchimp.com/templates/edit?id=10086452

FR

Subject: Êtes-vous toujours intéressé(e) par la vente de votre |BNAME| ?

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086457

Passed

05

Scenario 5: 2nd follow up

Given It’s been 72h from when the 1st “Follow-up” email is sent to the seller

When the First-time seller (FT seller) still hasn’t responded

Then the system automatically sends a 2nd follow-up email to the seller

AND The admin should see this email thread in the inbox of sell@saclab.com

And this email thread have tag “2nd Follow-up sent”

AND on AirTable SYB Submitted table, in field “Sales communication”, the value “2nd Follow-up sent” should be automatically selected

Email:

Eng:

Subject: A friendly reminder to finalize the listing of your << bag name >>

Preview

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086453

De:

Subject: Erinnerung an den Verkauf Ihrer << bag name >>

Preview

Template https://us12.admin.mailchimp.com/templates/edit?id=10086454

FR:

Subject: Suivi de votre vente avec SACLÀB

Template: https://us12.admin.mailchimp.com/templates/editor?id=10086455

Passed

06

Scenario 6: 3rd follow up

Given It’s been 120hours from when the 2nd “Follow-up” email is sent to the seller

When the First-time seller (FT seller) still hasn’t responded

Then the system automatically sends a 3rd follow-up email to the seller

AND The admin should see this email thread in the inbox of sell@saclab.com

And this email thread have tag “3rd Follow-up sent”

AND on AirTable SYB Submitted table, in field “Sales communication”, the value “2nd Follow-up sent” should be automatically selected

Email:

Eng:

Subject: Are you still interested in selling your << bag Name >>?

Preview

Template: https://us12.admin.mailchimp.com/templates/editor?id=10086687

De:

Subject: Erinnerung an den Verkauf Ihrer << bag name >>

Preview

Template https://us12.admin.mailchimp.com/templates/editor?id=10086686

FR:

Subject: Suivi de votre vente avec SACLÀB

Template: https://us12.admin.mailchimp.com/templates/editor?id=10086455

Passed

07

Scenario 7: 4th follow up

Given It’s been 168hours from when the 3rd “Follow-up” email is sent to the seller

When the First-time seller (FT seller) still hasn’t responded

Then the system automatically sends a 4th follow-up email to the seller

AND The admin should see this email thread in the inbox of sell@saclab.com

And this email thread have tag “4th Follow-up sent”

AND on AirTable SYB Submitted table, in field “Sales communication”, the value “4th Follow-up sent” should be automatically selected

Email:

Eng:

Subject: The submission of your << bag Name >> will be deleted in 3 days

Preview

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086688

De:

Subject: Die Verkaufsanfrage zu Ihrer << bag Name >> wird in 3 Tagen gelöscht

Preview

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086689

FR:

Subject: Suivi de votre vente avec SACLÀB

Template: https://us12.admin.mailchimp.com/templates/editor?id=10086455

Passed

08

Scenario 8: 5th follow up

Given It’s been 48hours from when the 4th “Follow-up” email is sent to the seller

When the First-time seller (FT seller) still hasn’t responded

Then the system automatically sends a 5th follow-up email to the seller (we will decline your submission…)

AND The admin should see this email thread in the inbox of sell@saclab.com

And this email thread have tag “5th Follow-up sent”

AND on AirTable SYB Submitted table, in field “Sales communication”, the value “5th Follow-up sent” should be automatically selected

Email:

Eng:

Subject: Final reminder: The submission of your << bag Name >> will be deleted in 24 hours

Preview

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086690

De:

Subject: Letzte Erinnerung: Die Verkaufsanfrage zu Ihrer << bag Name >> wird in 24 Stunden gelöscht

Preview

Template: https://us12.admin.mailchimp.com/templates/edit?id=10086691

FR:

Subject: Suivi de votre vente avec SACLÀB

Template: https://us12.admin.mailchimp.com/templates/editor?id=10086455

Passed

09

Scenario 9: No response

Given It’s been 24hours from when the “5th Follow-up” email is sent to the seller

When the First-time seller (FT seller) still hasn’t responded

Then on airTable the field “Submission accepted” is automatically changed to “No”

AND #SYB – 4.0.3 Submission Declined is sent

AND The admin should see this email thread in the inbox of sell@saclab.com

And this email thread have tag “No response”

AND on AirTable SYB Submitted table, in field “Decline reason”, the value “No Reponse” should be automatically selected

Screenshot 2024-10-15 at 16.42.05.png

Passed

10

Scenario 10: Once the client responded

Given: The submission is not declined

When: The FT seller responded

Then: The admin should see this email thread in the inbox of sell@saclab.com

And this email thread have tag “Client responded”

AND on AirTable SYB Submitted table, in field “Sales communication”, the value “Client responded” should be automatically selected

11

Scenario 11: Client responded via another channel of communication

Given: Client responded via another channel of communication

When: Admin change the field “Sales communication” to “Client responded” (on AirTable)
NEW AND admin removes the tag from the email thread

Then the system treats this as if the client has responded to the latest email
And no further automation is triggered from this point forward.

Passed

Comments

Leave a Reply