Does anybody have a document for the schema of the Square Library upload?

[Geezer]

I need to know more about the Square Library Upload file format.  How do we designate a record is a category or an item? How do we include the pics in the file? What other relationships can be uploaded? Is there a way to preserve the register layout when reloading/replacing the Library?

Does anybody have info such as this?

[Donnie-M]

@Geezer Here is the support article for uploading a catalog:

https://squareup.com/help/us/en/article/5153-import-items-online

The scheme is pretty straight forward.  I know with the API it is possible to pull item images from the catalog and upload item images. I have run across some of the code that looks like this; however, I am not a developer and this would be a custom application/website

let opts = {
types: "ITEM,ITEM_VARIATION,MODIFIER,MODIFIER_LIST,CATEGORY,TAX,IMAGE"
}

api.listCatalog(opts).then(...)

In the dashboard is the customer point to import a catalog as a .csv or excel file.

Hope this helps,

Donnie-M

[Geezer]

Thanks, I've studied that article. However, there is little information in it about designating whether an upload record is a category, or an item in the category, and how to link or embed product and category pics in the upload file. What is crystal clear is that all will be deleted before uploading a replacement catalog. Yet some pics from the previous catalog remain once the upload is successfully processed.

[Donnie-M]

@Geezer 

Not sure if this snapshot would help you, but the category is a specific field.  Unless you are using the api/sdk, you would have to use the web interface to upload any photos per item.  The only way to upload new photos would be using the back end developer system.

[Geezer]

Yeah, I got that far. Trying to upload from a massaged WordPress database dump to create a dumb'ed down file Square can read. Really tedious to reverse engineer Square's database when they could have made the schema available.