thread Item/Variation Classification for Suggested Add-Ons in Orders, Menu Items, Catalog & Fulfilment

Item/Variation Classification for Suggested Add-Ons

vodhin — Sat, 20 Sep 2025 09:31:56 GMT

It would be nice to implement a way to suggest additional items when an Item is added to the cart. For the database that I built for my own website I created a cross-reference table that links other Items' Variations' to the selected Variation via a ClassID number, excluding the current Item's Category, and returns matching Variations from them.

When a Twin Mattress is selected, the cross reference table finds all other matching Twin Items including Twin Box Springs, Twin Protectors, Twin Sheets, and Twin Frames. Here is a simplified example of what I have:

Categories:

Cat_ID	Cat_Name
1	Mattresses
2	Foundations
3	Frames
4	Sheets
etcetera...

Class_ID	Class_Name
1	Twin Size
2	Full Size
3	Queen Size
4	King Size
etcetera...

Cross Reference

Class Cross ID	Class_Cat	Class_Cross_Ref
1	1	2,3,4
2	1	2,3,4
3	1	2,3,4
4	1	2,3,4
5	2	3
6	2	3
7	2	3
8	2	3
9	3	2
10	3	2
11	3	2
12	3	2
etcetera...

An Item in Category 1 (Mattress) has a Variation (Full) with a ClassID of 2, which finds additional Items and Variations with the same ClassID. So a Full Size Mattress (ClassID 2) finds and offers matching Full Size Foundations, Frames, Sheets, etc.

Square already has its Category Table and Square could use the Data from Option Sets as Class IDs, so all that needs to be added is a CrossReference Field in that Option Set Data, where you can link each Option Set's datarow to another Option Set's datarow(s).

This would only work for Item Variations created using the Option... er, option "to create variations in bulk" since that links Variations together across multiple Items. Feel free to ask for clarification, I tried to be as brief as possible without loosing specificity.

Re: Item/Variation Classification for Suggested Add-Ons

Sammie_C — Tue, 26 Aug 2025 22:00:20 GMT

Hi @vodhin, thank you for your post!

This is a great idea! I might recommend taking a look at this Square Community post and see if the Best Answer on that page may resolve your request a bit. Is a "reccomended item" what you were referring to in your post?

If not, then I would ask, are you familiar with Ideate? Ideate is a great place to post new ideas and suggestions for Square products. Feel free to add your idea as a Feature Request on there and post a link to your post back here to gain more traffic for other Sellers to see.

In the meantime though, please let me know if you have any other questions or concerns.

Re: Item/Variation Classification for Suggested Add-Ons

vodhin — Thu, 28 Aug 2025 16:33:28 GMT

Thank you for the tip. The other post regards an Online Store and it looks like this suggests other items from the same category. Similar idea, but my suggestion is to display additional items from other categories that go with the selected item, eg: Offer Twin Sheets when selecting a Twin Mattress, or a doughnut when selecting a cup of coffee... I'll go check out the Ideate (not a great name, should be simply Feature Requests or something sane) forum.