x

Sales Tax yes/no column in catalog export

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"

nontaxable.png

 

 

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.

 

 

249 Views
Message 1 of 6
Report
1 Best Answer
Square Champion

Best Answer

@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.

Keith
Owner
Pocono Candle

Mark as Best Answer if this Helped you solve an issue or give it a thumbs up if you like the answer.
Square Support Number 855-700-6000.
Make Sure App and OS is up to date on your Device.

View Best Answer >

229 Views
Message 2 of 6
Report
5 REPLIES 5
Square Champion

Best Answer

@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.

Keith
Owner
Pocono Candle

Mark as Best Answer if this Helped you solve an issue or give it a thumbs up if you like the answer.
Square Support Number 855-700-6000.
Make Sure App and OS is up to date on your Device.
230 Views
Message 2 of 6
Report

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

 

Reference HandleTokenItem NameVariation NameUnit and PrecisionSKUDescriptionReporting CategorySEO TitleSEO DescriptionPermalinkGTINSquare Online Item VisibilityItem TypeWeight (lb)Social Media Link TitleSocial Media Link DescriptionShipping EnabledSelf-serve Ordering EnabledDelivery EnabledPickup EnabledPriceOnline Sale PriceArchivedSellableStockableSkip Detail Screen in POSOption Name 1Option Value 1Option Name 2Option Value 2Current Quantity Twisted and ThriftedNew Quantity Twisted and ThriftedStock Alert Enabled Twisted and ThriftedStock Alert Count Twisted and Thrifted   
226 Views
Message 3 of 6
Report
Square Champion

@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:

TokenItem NameVariation NameUnit and PrecisionSKUDescriptionReporting CategorySEO TitleSEO DescriptionPermalinkGTINSquare Online Item VisibilityItem TypeWeight (lb)Social Media Link TitleSocial Media Link DescriptionShipping EnabledSelf-serve Ordering EnabledDelivery EnabledPickup EnabledPriceOnline Sale PriceArchivedSellableStockableSkip Detail Screen in POSOption Name 1Option Value 1Default Unit CostDefault Vendor NameDefault Vendor CodeCurrent Quantity Pocono CandleNew Quantity Pocono CandleStock Alert Enabled Pocono CandleStock Alert Count Pocono CandleTax - 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.

itemsdesktop.png

 

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

chooseexport.png

 

Then you should get this box for your Export Settings:

exportsettings.png

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.

Keith
Owner
Pocono Candle

Mark as Best Answer if this Helped you solve an issue or give it a thumbs up if you like the answer.
Square Support Number 855-700-6000.
Make Sure App and OS is up to date on your Device.
222 Views
Message 4 of 6
Report

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?

202 Views
Message 5 of 6
Report

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

196 Views
Message 6 of 6
Report

Type a product name