Filling in the template .xlsx sheet

[jwilkinsonart]

I downloaded the template .xlsx sheet in order to add multiple items. I will then upload the file to Squareup when I finish. My questions are about filling in the columns of the .xlsx sheet.

I see there are 17 columns across the sheet, including the Square Token column which I leave alone. As for the other 16 columns, I’m unsure of the best way to fill in the information. I’m hoping that someone here will suggest best way(s) to add my info.

I have a small art gallery and I sell art by several artists, all artworks are one-of-a-kind, with no quantity, no stock, no re-stocking. The only information that I really need to use is the artist’s name, the title of the artwork, and how the artwork was made (example: acrylic painting). I leave the “Price” field blank because I add the price manually. Sales Tax is always added. Also, I don’t use an online store and I don’t ship items, all of my sales are face-to-face in person.

Here’s an example of the only info that I need to include (words in parentheses are not included):

(ARTIST) John Doe
(TITLE) River Flood
(DESCRIPTION) Acrylic painting, unframed, by John Doe.

I'll use the (TITLE) as the "Item Name" for each artwork.

QUESTION:
On the sheet, in the Variation Name column, I’ll use the word Artwork for every item, regardless of the artist. I think I can turn off SKU. I'll add a brief Description of each artwork. For Category I’ll always use either 2D or 3D. Weight doesn’t apply. Price is blank. For columns K through P, can I leave those blank? I will disable Stock Alert Count. Sales Tax is added already.

I think that’s it, thank you for any suggestions on keeping as simple as possible.

[Candlestore]

@jwilkinsonart ;

What I would suggest you do is go to your Square Dashboard and create 1 new item with the most information.  Then download your Square Catalog.  This will give you a template with what you have filled in on the Dashboard.  Now as for an Item called XYZ with variations of "Artwork" that will give you problems because you will not be able to see which artwork is which by Variation. What I would do is create Categories based on the Artist.  Then have the Item as whatever they call their Art, and maybe Variations if they sell this Art in different sizes.  4x6, 8x10 ....etc.

As for Sales Tax being included make sure you have this enabled in your settings or on your Profits this will show as all income and no liability for Tax.  

Here is a web page stating what each column is for : https://nontechieentrepreneur.com/blog/how-to-import-products-to-square/ 

And here is more about Sales Tax settings.... hopefully this gets your sales tax calculations correct when including it in your price :

https://squareup.com/help/us/en/article/5061-create-and-manage-your-tax-settings 

You would need to Go to your Square Dashboard Business and Account settings > Business ??? > Taxes > then look for a toggle switch for taxes included in price.... I believe I am going from memory so the wording might be off but should be in the 5061 article above.