thread Re: Does anybody have a document for the schema of the Square Library upload? in Archived Discussions (Read Only)

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

Geezer — Tue, 31 Aug 2021 00:12:22 GMT

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?

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

Donnie-M — Tue, 31 Aug 2021 12:19:35 GMT

@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

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

Geezer — Tue, 31 Aug 2021 12:58:55 GMT

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.

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

Donnie-M — Tue, 31 Aug 2021 19:57:04 GMT

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

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

Geezer — Tue, 31 Aug 2021 23:26:52 GMT

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.