Image Field on Spreadsheet (Square Site)

[pgh415]

Is there a way to add a field to Excel Spreadsheet or CSV file that links to an image stored in Library? This will save lots of time from having to click on every image and add link on "Edit image" page.

Nothing appears on the Excel template or Exported file. It's hidden somwhere and may be related to the field "Token". Otherwise how would it know which image to use?

Thanks in advance!

[Candlestore]

@pgh415 ;

There is no way to upload an image in a csv file to Square that I am aware of.  I do know the CSV file field Token is not the Image location.  The Token Field is the field that corespondes to that Items Row, so if anything changes in that Row on a csv file, when it is uploaded to Square, Square resets the Item labeled Token 6tgcfg to the new entered data in Square.  In Excel Square uses Refrence Handle and Token fields to do this. 

I thought somewhere Square had an article defining what each Column was used for in both the CSV file and Excel files but this is all I can find now:

5153-import-items-online 

Here is another article and in the Troubleshoot Step it states that you can not Import images by CSV

6172-import-item-library-troubleshooting

Item image errors

Images cannot be uploaded via the Item Import Tool. Learn more on how to upload and manage item images.

[pgh415]

Thanks. I'm surprised an image field on spreadsheet isn't shown ot sllowed to be added for bulk imports.

[Candlestore · Accepted solution]

@pgh415 ;

At the moment the best way I have found to get images to Square has been:

1. Take a picture with a Cell or Digital camera
2. Upload the picture to your Computer to a file like Square images or Inventory Images etc
3. Rename the Images from Carmera naming to something easy to find from Square
4. On the same computer login to your Square Dashboard  : dashboard 
5. Select Items from the Left Menu bar
6. Then in your Items select Image Library Top Right select Upload, select all images that you Renamed from step 3
7. Then go back to your Items Catalog and search for your Item that needs an Image from the ones you just Uploaded
8. Edit the Image Placement holder, and get image from Library, search for the easy name of the Image you renamed in step 2
9. Save then Next Item Repeat Steps 7-9 for the remaining items.

Square for Retail possibly POS also has that you can do this inside of the Square app but currently the Uploading of images freezes after about the 3rd item your trying to assign an image to.  Square is working on this.

[Summer2024]

Thanks for providing the best answer here, @Candlestore ! Very detailed and helpful. 

[pgh415]

All images are already uploaded in Square library. I'm trying to figure out how to add its reference to the spreadsheet. It's hidden somewhere...how else would it know which image to tag. It doesn't show up on the exported excel spreadsheet with data. I think it's tied into the Token field

I don't want to lose any images and need to retag everyt time I upload

changes and replace the exisiting data.