Is there a way to prevent variants?

[skoontzie]

I have products with same names but each has a unique SKU. When I do an item search on the iPhone app for the sku it automatically brings up same named items  as price 1, price 2, etc. even though I didn't add variants.  No sku is shown next to the prices.  How do I know I'm selecting the correct SKU? Is there a way to turn off allowing variants?  It doesn't seem to do this on the pc.  It wouldn't bother me so much if it displayed the sku, too.

TIA

search for sku 

Results 

[Candlestore]

@skoontzie ;

I think the reason is, you have the same Name of an Item but with different SKU, so the Sku, pulls up the name of the item but finds the name multiple times.  Solution put the SKU at the end of the Item name.  This would then show the Item name and SKU.  What you can do with Excel or Googlesheets is Select Item Name column and the SKU column the use the concatenate function which would automatically merge the Item Name And SKU into one cell.  The problem is you may not want to do this to all rows (Items), so you would need to delete those rows first.  Then use the concatenate function and merge Items and SKU into a cell then copy paste that cell into the Item names field then upload those items back to Square. Make sure not to change the the Token column or it will create a new item also.   Now if it is just an item or 2 you may just want to manually enter the SKU to the end of the Item name which has Square make them 2 different Items.  Here is more on the Concatenate Function:  Export your Items Catalog, save as original catalog.

How Do You Use CONCATENATE?

CONCATENATE combines cells and lets you choose a separator, you just have to provide the cell references like in the following example:

=CONCATENATE(A2,"-",B2)

This would provide the data from A2 and B2 with a dash in between.

A2 - would equal the Item Name column and corresponding Row of 2

the "-"  put a Dash between your Item name and SKU, you could also use " " for a blank if you like.

B2 - would be the Column of your SKU and the Same row 2 where the SKU matches the Item name

So lets say you want   Widget 12345 to replace Item Widget with SKU 12345

In google sheets

Item Name is Column C and SKU is Column F

Item Widget is row 2

Type in Cell Z2 under a column header you type in as New Item Name

=concatenate(A2," ",F2)

Then you can copy this formula down the column and all items that are in the sheet would give you the results without retyping everything, and all the 2's will change to the corresponding row.

When you have the new results Copy column Z and place into the old names column as text, delete the New Item Name column.

Then save this sheet as new catalog

Then upload new catalog to Square Items.  Do a test and it should work if not upload your Original exported file from Square and your right back to where you are now.

I have changed plenty of items doing these type of calculations and formulas to save time typing.

[skoontzie]

Thank you! I’m adequate with excel so I’ll try it out. I really don’t want to try and come up with unique names for everything. 😁

[Candlestore]

You're welcome.  If you are not familiar with the Power Query feature, look it up on youtube or watch this guy:

 Kevin Microsoft Employee

He works for Microsoft and has to state that in his videos according to HR and has videos for excel and other help topics.  I watched his videos and a few others to create my Power Queries in Excel.