Sales Tax yes/no column in catalog export

[AprilKiskis]

I am attempting to upload about 500 items to my store and get them updated. I searched the help posts and see that Sales Tax used to be included in the catalog export file. In my current export I do not see this column. Am I missing something?

My store has a mixed bag of items that I tax or don't tax. I'm hoping for a quick and easy way to mark these items.

Also, I do see that I can click on the ... at the right of the item listings and click "Set as non taxable"

However, when I go back and click ... shouldn't the option change to "set item as taxable"? The option still says "Set as non-taxable". You can't tell at a glance which items you actually changed without clicking on each item and checking it.

[Candlestore · Accepted solution]

@AprilKiskis;

That is not for the Catalog Export of what is included in the Export, but what is Displayed on your Computer Screen.  In my csv file it was at the end and Labeled " Sales Tax - 6% pa Sales Tax" with Y or N belowin in the rows for the items.   If you goto Square Dashboard on a Computer, Items..... then on the far right click Export then choose as CSV or Excel and you should get everything.  I think you can even export a Catalog Template now.

[AprilKiskis]

I exported my items via csv and excel and these are the only columns I have: (There is not column available for tax), 

Reference Handle

Token

Item Name

Variation Name

Unit and Precision

SKU

Description

Reporting Category

SEO Title

SEO Description

Permalink

GTIN

Square Online Item Visibility

Item Type

Weight (lb)

Social Media Link Title

Social Media Link Description

Shipping Enabled

Self-serve Ordering Enabled

Delivery Enabled

Pickup Enabled

Price

Online Sale Price

Archived

Sellable

Stockable

Skip Detail Screen in POS

Option Name 1

Option Value 1

Option Name 2

Option Value 2

Current Quantity Twisted and Thrifted

New Quantity Twisted and Thrifted

Stock Alert Enabled Twisted and Thrifted

Stock Alert Count Twisted and Thrifted

[Candlestore]

@AprilKiskis;

What Steps are you using to export your catalog?

I just exported mine and got these columns, last one to the far right is the Tax caloumn:

Token

Item Name

Variation Name

Unit and Precision

SKU

Description

Reporting Category

SEO Title

SEO Description

Permalink

GTIN

Square Online Item Visibility

Item Type

Weight (lb)

Social Media Link Title

Social Media Link Description

Shipping Enabled

Self-serve Ordering Enabled

Delivery Enabled

Pickup Enabled

Price

Online Sale Price

Archived

Sellable

Stockable

Skip Detail Screen in POS

Option Name 1

Option Value 1

Default Unit Cost

Default Vendor Name

Default Vendor Code

Current Quantity Pocono Candle

New Quantity Pocono Candle

Stock Alert Enabled Pocono Candle

Stock Alert Count Pocono Candle

Tax - Pa Sales Tax (6%)

From your Item Library on a computer:

https://app.squareup.com/dashboard/items/library 

Goto the right side of the Screen click Actions.  Make sure you have no filters.

You should get the below image and select the Export Library it should Turn blue like mine in image.

Then you should get this box for your Export Settings:

Choose CSV if you prefer.

After you do this your catalog I believe starts to download or you may have to select Download I forget.  Then you should have the Headers at the top of this reply.

Hope this helps.

[AprilKiskis]

I am using the same steps as you describe in your post. Comparing your post to my file it appears that is the only column I'm missing.

I've tried exporting as excel and CVS. Neither formats show that column.

Also to note when I exported the blank template the column didn't appear in that file either.

I wonder what would happen if I added the column then imported the file?

[AprilKiskis]

Looks like this is fixed now. I downloaded this again today and the column is there.

[ExoticSnaxx]

How did you fix this because mine has been like this for over 3 weeks now and support has no idea what to do.